前端输入时间字符串，数据库存储Date类型数据

1. 首先创建JavaBean

public class Employees implements Serializable{
@DateTimeFormat(pattern = "yyyy-MM-dd")
 private Date hireDate;//注解定义时间格式
 public String getHireDate() {
 //定义为String类型用于获取前端时间字符串
  SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");//注意月份是M
  if(hireDate==null) {
   return null;
  }
  return simpleDateFormat.format(hireDate);
 }
 public void setHireDate(String hireDate) {
 //将获取到的String类型数据，转换为Date格式数据
  SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");//注意月份是MM
  if(hireDate==null||hireDate=="") {
   return;
  }
  try {
   this.hireDate = simpleDateFormat.parse(hireDate);
  } catch (ParseException e) {
   e.printStackTrace();
  }
 }
}

2. 前端页面

<form name="f" action="toEmployeesLogin" method="post">
<div >
 HireDate:&nbsp&nbsp&nbsp&nbsp<input type="text" name="hireDate" id="hireDate" />
</div>
<input class="btn btn-primary" type="submit"  value="查询"/>
<button class="btn btn-primary" type="button" name="emeadd" id="emeadd"  value="添加">添加</button>
</form>

<script type="text/javascript">
 $(function(){
 //定义添加时间按钮
   $("#emeadd").click(function(){
   var hireDate = $("#hireDate").val();
   $.ajax({
      url:"/toEmployeeAdd",
      data:{"hireDate":hireDate},
      datatype:"json",
      type:"post",
      success:function(data){
       console.log("数据传回成功！");
       alert("添加成功！");
       window.location.href="toEmployeesLogin";
      },
      error:function(){
       console.log("数据传回失败！");
      }
     })
    })
 })
</script>

3. 基于springboot框架后端接收前端表单信息
Controller

@Controller
public class employeeController {
 employeesService employeesService = new employeesService();
 @RequestMapping("/toEmployeesLogin")
 public String emp(Employees eme,Model model) {
  employeesService.employees(eme, model);
  System.out.println(eme.getPhoneNumber());
  return "employeesLogin";
 }
 
 @RequestMapping("/toEmployeeAdd")
 public String emeadd(Employees eme,Model model) {
  employeesService.emeadd(eme, model);
  return "employeesLogin";
 }
}

Service

public void employees(Employees eme, Model model) {
  EmployeesDao employeedao = Factory.getInstanceThree();
  list = employeedao.SelectBySelective(eme);
  model.addAttribute("emplist", list);
 }
 
 public void emeadd(Employees eme,Model model) {
  EmployeesDao employeesdao = Factory.getInstanceThree();
  int count = employeesdao.insert(eme);
 }

dao

@Override
 public int insert(Employees eme) {
  String sql = "INSERT INTO employees(employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id)";
  sql += " VALUES(?,?,?,?,?,"+"to_date('"+eme.getHireDate()+"','yyyy-mm-dd')"+",?,?,?,?,?)";
  int count = 0 ;
  try(PreparedStatement pstmt = conn.prepareStatement(sql)){
   pstmt.setInt(1, eme.getEmployeeId());  
   pstmt.setString(2, eme.getFirstName());   
   pstmt.setString(3, eme.getLastName());
   pstmt.setString(4, eme.getEmail());   
   pstmt.setString(5, eme.getPhoneNumber());   
   pstmt.setString(6, eme.getJobId());   
   pstmt.setObject(7, eme.getSalary());   
   pstmt.setObject(8, eme.getCommissionPct()); 
   pstmt.setObject(9, eme.getManagerId());   
   pstmt.setObject(10, eme.getDepartmentId());
   count = pstmt.executeUpdate();
  } catch (SQLException e) {
   System.out.println("这是插入员工表错误！");
   e.printStackTrace();
  }
  return count;
 }