发表于: 2018-04-02 20:57:48

1 547


今天完成的事情:

把查询结果和修改结果里面的毕业时间用年月日展示出来,传入数据库的时候又变回时间戳

package com.controller;


import com.DAO.StudentMapper;
import com.POJO.ChangeType;
import com.POJO.DateTypeChange1;
import com.POJO.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import java.io.IOException;
import java.util.List;

@Controller
@RequestMapping("/user")
public class mvcController {
Student student;
   @Autowired
   StudentMapper studentMapper;
   
   @RequestMapping("/searchbyid")
public String jumptosearchid( ) throws IOException {
return "searchbyid";
   }
/*
    * 根据ID查询信息
    *
    * */
   @RequestMapping(value = "/list",method = RequestMethod.GET)
public String select( Integer ID, Model model) throws Exception {
student = studentMapper.findUserById(ID);
       DateTypeChange1 newstu = ChangeType.dateTypeChange1(student);
       model.addAttribute("student", newstu);
       return "list";
   }
/**
    * 新增用户
    */
   @RequestMapping("/new")
public String turntoinsert( ) throws IOException {
return "insert";
   }
@RequestMapping(value = "/add")
public String insert(Student newStudent,Model model) throws Exception {
studentMapper.insertUser(newStudent);
       Integer a = newStudent.getID();
       model.addAttribute("message2",a);
       return "addcomplate";
   }
/**
    * 删除用户
    */
   @RequestMapping(value = "/deletebyid/{ID}")
public String delect(@PathVariable("ID") int ID, Model model) throws Exception {
int a = studentMapper.deleteUser(ID);
       String message;
       if (a == 1) {
message = "数据删除成功";
       } else {
message = "数据删除失败";
       }
model.addAttribute("message", message);
       return "deletebyid";
   }
/**
    * 修改用户
    */
   @RequestMapping(value = "/list/{ID}",method = RequestMethod.GET)
public String jumptoupdate(@PathVariable("ID") Integer ID, Model model) throws Exception {
student = studentMapper.findUserById(ID);
       DateTypeChange1 newstu = ChangeType.dateTypeChange1(student);
       model.addAttribute("student", newstu);
       return "updatebyid";
   }
@RequestMapping(value = "/updatecomplate")
public String update(DateTypeChange1 updatestudent,Model model) throws Exception {
System.out.println(updatestudent);
       Student newstu1 = ChangeType.LongTypeChange(updatestudent);
       System.out.println(newstu1);
       int s = studentMapper.updateUser(newstu1);
       String message;
       if (s == 1) {
message = "数据修改成功";
       } else {
message = "数据修改失败";
       }
model.addAttribute("message", message);
       return "updatecomplate";
   }
/**
    * 根据姓名模糊查询
    */
   @RequestMapping(value = "/searchbyname")
public String jumptosearchbyname() throws Exception {
return "searchbyname";
   }
@RequestMapping(value = "/listbyname",method = RequestMethod.GET)
public String selectByName(String name, Model model) throws Exception {
List<Student> studentlist = studentMapper.findUserByName(name);
       System.out.println(studentlist);
       model.addAttribute("lists",studentlist);
       return "listbyname";
   }
}

 

package com.POJO;

import java.text.ParseException;
import java.text.SimpleDateFormat;
public class ChangeType {
public static DateTypeChange1 dateTypeChange1(Student s) {
DateTypeChange1 dtc=new DateTypeChange1();
           dtc.setID(s.getID());
           dtc.setName(s.getName());
           dtc.setQQ(s.getQQ());
           dtc.setOnlineNumber(s.getOnlineNumber());
           dtc.setProfessionType(s.getProfessionType());
           dtc.setDailyLink(s.getDailyLink());
           dtc.setPromise(s.getPromise());
           dtc.setBrotherName(s.getBrotherName());
           dtc.setPhone(s.getPhone());
           dtc.setMail(s.getMail());
           //毕业时间类型转换转换Long转换到Date
           SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
           String timechange1=sdf.format(s.getEnrollmentTime());
           dtc.setEnrollmentTime(timechange1);
           return dtc;
       }
public static Student LongTypeChange(DateTypeChange1 s) throws ParseException {
Student dtc = new Student();
           dtc.setID(s.getID());
           dtc.setName(s.getName());
           dtc.setQQ(s.getQQ());
           dtc.setOnlineNumber(s.getOnlineNumber());
           dtc.setProfessionType(s.getProfessionType());
           dtc.setDailyLink(s.getDailyLink());
           dtc.setPromise(s.getPromise());
           dtc.setBrotherName(s.getBrotherName());
           dtc.setPhone(s.getPhone());
           dtc.setMail(s.getMail());
           //毕业时间类型转换Date转换到Long
           SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
           Long timechange1=sdf1.parse(s.getEnrollmentTime()).getTime();
           dtc.setEnrollmentTime(timechange1);
           return dtc;
       }
}


明天计划的事情:

把模糊查询的结果也改为年月日的显示方式,试试分页查询 
遇到的问题:

一开始显示年月日还好,第二部将已有的时间转换为时间戳遇到问题

收获:

单步调试


返回列表 返回列表
评论

    分享到