发表于: 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;
}
}
明天计划的事情:
把模糊查询的结果也改为年月日的显示方式,试试分页查询
遇到的问题:
一开始显示年月日还好,第二部将已有的时间转换为时间戳遇到问题
收获:
单步调试
评论