birthday属性如何处理

# 具体遇到的问题
不知道birthday怎么处理，刚开始设置成String类型，但是在修改用户信息的时候保存不进去，报错，后来改成Date类型，也是写不进去，我增加了一个edit_add.jsp，页面，这个页面就是点击修改后跳转到的保存页面

# 报错信息的截图

# 相关课程内容截图

# 尝试过的解决思路和结果

# 粘贴全部相关代码，切记添加代码注释（请勿截图）

在这里输入代码，可通过选择【代码语言】突出显示
package com.imooc.domain;

import java.util.Date;

public class User {

private Integer id;//用户id
private String username;//用户名
private String password;//用户密码
private String real_name;//用户真实姓名
private Date birthday;//用户生日
private String phone;//用户电话
private String address;//用户地址

//无参构造方法
public User() {
super();
}

public User(Integer id, String username, String password, String real_name, Date birthday, String phone,
String address) {
super();
this.id = id;
this.username = username;
this.password = password;
this.real_name = real_name;
this.birthday = birthday;
this.phone = phone;
this.address = address;
}

//带参方法

@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password=" + password + ", real_name=" + real_name
+ ", birthday=" + birthday + ", phone=" + phone + ", address=" + address + "]";
}

public Integer getId() {
return id;
}

public void setId(Integer id) {
this.id = id;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String getReal_name() {
return real_name;
}

public void setReal_name(String real_name) {
this.real_name = real_name;
}

public Date getBirthday() {
return birthday;
}

public void setBirthday(Date string) {
this.birthday = string;
}

public String getPhone() {
return phone;
}

public void setPhone(String phone) {
this.phone = phone;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

}
package com.imooc.dao.impl;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.imooc.dao.UserDao;

import com.imooc.domain.User;
import com.imooc.utils.JDBCUtils;

public class UserDaoImpl implements UserDao {

@Override
public User login(User user) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
// 获得连接
conn = JDBCUtils.getConnection();
// 编写SQL
String sql = "select * from user where username=? and password=?";
// 预编译SQL
pstmt = conn.prepareStatement(sql);
// 设置参数
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
// 执行
rs = pstmt.executeQuery();
if (rs.next()) {
User existUser = new User();
existUser.setId(rs.getInt("id"));
existUser.setUsername(rs.getString("username"));
existUser.setPassword(rs.getString("password"));
existUser.setReal_name(rs.getString("real_name"));
existUser.setBirthday(rs.getDate("birthday"));
existUser.setPhone(rs.getString("phone"));
existUser.setAddress(rs.getString("address"));

return existUser;
}

} catch (Exception e) {
e.printStackTrace();
} finally {
// 释放资源
JDBCUtils.release(rs, pstmt, conn);

}
return null;
}

@Override
public User regist(User user) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
//获得连接
conn=JDBCUtils.getConnection();
//编写SQL
String sql="insert into user (id,username,password) values (null,?,?)";
//预编译SQL
pstmt=conn.prepareStatement(sql);
//设置参数
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
//执行sql
int result=pstmt.executeUpdate();
if(result>0) {
System.out.println("注册新用户成功");
}
} catch (Exception e) {
// TODO: handle exception
}finally {
//释放资源
JDBCUtils.release(pstmt, conn);
}

return null;
}

@Override
public User findOne(String username) {
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
//
try {
// 获得数据库连接
conn = JDBCUtils.getConnection();
// 编写SQL
String sql = "select * from user where username=? ";
// 预编译SQL
pstm = conn.prepareStatement(sql);
// 设置参数
pstm.setString(1, username);
// 执行SQL
rs = pstm.executeQuery();
// 处理结果
if (rs.next()) {
User user=new User();
user.setId(rs.getInt("id"));
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
user.setReal_name(rs.getString("real_name"));
user.setBirthday(rs.getDate("birthday"));
user.setPhone(rs.getString("phone"));
user.setAddress(rs.getString("address"));

return user;

}

} catch (Exception e) {
e.printStackTrace();
} finally {
// 释放资源
JDBCUtils.release(rs, pstm, conn);
}

return null;
}

/**
*
*/
@Override
public void save(User user) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 1、获取连接
conn = JDBCUtils.getConnection();
// 2、编写SQL
String sql = "insert into user values (null,?,?,?,?,?,?)";

// 3、预编译SQL
pstmt = conn.prepareStatement(sql);
// 4、设置参数
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
pstmt.setString(3, user.getReal_name());
// pstmt.setString(4, user.getBirthday());
pstmt.setDate(4, (Date) user.getBirthday());

pstmt.setString(5, user.getPhone());
pstmt.setString(6, user.getAddress());
// 5、执行SQL
int result=pstmt.executeUpdate();
if(result>0) {
System.out.println("用户信息修改成功");
}
// 6、结果处理

} catch (Exception e) {
e.printStackTrace();
} finally {
// 7、数据释放
JDBCUtils.release(pstmt, conn);
}

}
}
package com.imooc.service.impl;

import com.imooc.dao.UserDao;
import com.imooc.dao.impl.UserDaoImpl;
import com.imooc.domain.User;
import com.imooc.service.UserService;

public class UserServiceImpl implements UserService {

@Override
public User login(User user) {
// 调用Dao查询用户是否存在
UserDao userDao = new UserDaoImpl();

return userDao.login(user);
}

@Override
public User regist(User user) {
//注册新用户
UserDao userDao=new UserDaoImpl();
return userDao.regist(user);
}

@Override
public User findOne(String userName) {
// 根据用户名查询用户信息
UserDao userDao=new UserDaoImpl();
return userDao.findOne(userName);

}

@Override
public void save(User user) {
// 保存修改后的用户信息至数据库
UserDao userDao=new UserDaoImpl();
userDao.save(user);

}

}
package com.imooc.web.action;

import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.imooc.domain.User;
import com.imooc.service.UserService;
import com.imooc.service.impl.UserServiceImpl;

@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String methodName = request.getParameter("method");
if ("edit".equals(methodName)) {
// 根据已登录用户信息，将用户全部信息传递到edit_user.jsp页面
edit(request, response);
} else if ("saveUI".equals(methodName)) {
// 在编辑页面点击修改后，进入edit_add.jsp页面
saveUI(request, response);
}else if("save".equals(methodName)) {
//在edit_add.jsp点击保存后，将修改后的用户信息保存至数据库
try {
save(request,response);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doGet(request, response);
}

/**
* 在edit_add.jsp页面中修改用户信息，然后点击保存，保存至数据库中，然后执行跳转至
* 执行MessageServlet?method=findAll，返回留言面板
* @param request
* @param response
* @throws ParseException
*/
private void save(HttpServletRequest request, HttpServletResponse response) throws ParseException {
// 接收页面提交数据
String username=request.getParameter("username");
String password=request.getParameter("password");
String real_name=request.getParameter("real_name");
//将接收到的字符型数据生日转换为日期型
String newbirthday=request.getParameter("birthday");
//截取并拼接字符串
String birthday1=newbirthday.substring(0, 4)+"-"+newbirthday.substring(4, 6)+"-"+newbirthday.substring(6, 8);
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-mm-dd HH:mm:ss");
Date birthday=sdf.parse(birthday1);

String phone=request.getParameter("phone");
String address=request.getParameter("address");
//封装数据
User user=new User();
user.setUsername(username);
user.setPassword(password);
user.setReal_name(real_name);
user.setBirthday(birthday);
user.setPhone(phone);
user.setAddress(address);
//调用业务层处理数据，将新修改的用户信息存入数据库
UserService userService=new UserServiceImpl();
userService.save(user);
//修改成功后跳转至留言板页面

}

/**
* 在edit_user.jsp中点击修改后进入保存页面，页面比edit_user.jsp中多一个密码显示框，只是显示数据，未做修改
*
* @param request
* @param response
* @throws IOException
* @throws ServletException
*/

private void saveUI(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 从登录用户中获取用户名
User existUser = (User) request.getSession().getAttribute("existUser");
String userName = existUser.getUsername();
// System.out.println("需要编辑的用户名为：" + userName);
// 调用业务层根据用户名查询该用户的所有信息
UserService userService = new UserServiceImpl();
User user = userService.findOne(userName);
System.out.println("查询到的用户为" + user);
// 保存查询到的用户信息，并跳转至edit_user.jsp
request.setAttribute("user", user);
request.getRequestDispatcher("/edit_add.jsp").forward(request, response);

}

/**
* 根据用户登录的信息，将所有用户信息查询出来并跳转至edit_jsp页面,修改前用户信息
*
* @param request
* @param response
* @throws IOException
* @throws ServletException
*/
private void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 从登录用户中获取用户名
User existUser = (User) request.getSession().getAttribute("existUser");
String userName = existUser.getUsername();
// System.out.println("需要编辑的用户名为：" + userName);
// 调用业务层根据用户名查询该用户的所有信息
UserService userService = new UserServiceImpl();
User user = userService.findOne(userName);
// System.out.println("查询到的用户为" + user);
// 保存查询到的用户信息，并跳转至edit_user.jsp
request.setAttribute("user", user);
request.getRequestDispatcher("/edit_user.jsp").forward(request, response);
}

}
package com.imooc.web.action;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.imooc.domain.User;
import com.imooc.service.UserService;
import com.imooc.service.impl.UserServiceImpl;

@WebServlet("/RegistServlet")
public class RegistServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

// 完成验证码的校验:
// 获得session中保存的验证码的信息
String code1 = (String) request.getSession()
.getAttribute(com.google.code.kaptcha.Constants.KAPTCHA_SESSION_KEY);
// 接收前台表单提交的验证码的信息
String code2 = request.getParameter("checkCode");
if (code2 == null || !code2.equalsIgnoreCase(code1)) {
request.setAttribute("msg", "验证码输入不正确!");
request.getRequestDispatcher("/reg.jsp").forward(request, response);
return;
}

// 接收页面提交过来的用户名和密码
String username = request.getParameter("username");
String password = request.getParameter("password");
// 输出接收到的用户名和密码
System.out.println(username + " " + password);
// 数据封装
User user = new User();
user.setUsername(username);
user.setPassword(password);
// 处理数据
UserService userService = new UserServiceImpl();
userService.regist(user);
//页面跳转，重定向至登录页面
request.setAttribute("msg", "注册成功请登录!");
request.getRequestDispatcher("/login.jsp").forward(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doGet(request, response);
}

}
package com.imooc.web.action;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.imooc.domain.User;
import com.imooc.service.UserService;
import com.imooc.service.impl.UserServiceImpl;

@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

public LoginServlet() {
super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//接收参数
String methodName=request.getParameter("method");
//判断
if("login".equals(methodName)) {
login(request,response);
}else if("logout".equals(methodName)) {
logout(request,response);
}

}

private void logout(HttpServletRequest request, HttpServletResponse response) throws IOException {
//1、销毁session
request.getSession().invalidate();
//2、跳转到登录页面
response.sendRedirect(request.getContextPath()+"/login.jsp");

}

private void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 完成验证码的校验:
// 获得session中保存的验证码的信息
String code1 = (String) request.getSession()
.getAttribute(com.google.code.kaptcha.Constants.KAPTCHA_SESSION_KEY);
// 接收前台表单提交的验证码的信息
String code2 = request.getParameter("checkCode");
if (code2 == null || !code2.equalsIgnoreCase(code1)) {
request.setAttribute("msg", "验证码输入不正确!");
request.getRequestDispatcher("/login.jsp").forward(request, response);
return;
}

//接收页面提交过来的用户名和密码
String username=request.getParameter("username");
String password=request.getParameter("password");
//输出接收到的用户名和密码
System.out.println(username+" "+password);
//数据封装
User user=new User();
user.setUsername(username);
user.setPassword(password);
//处理数据
UserService userService=new UserServiceImpl();
User existUser=userService.login(user);
//根据处理结果，完成页面跳转
if(existUser==null) {
//登录失败，返回到登录页面
request.setAttribute("msg", "用户名或密码错误");
request.getRequestDispatcher("/login.jsp").forward(request, response);
}else {
//登录成功,保存用户信息
request.getSession().setAttribute("existUser", existUser);
response.sendRedirect(request.getContextPath()+"/MessageServlet");
// response.sendRedirect(request.getContextPath()+"/message_list.jsp");
}
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doGet(request, response);
}

}
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登录</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/login.css">

<script type="text/javascript">
function changeImg() {
var img = document.getElementById("codeimg");
img.src = "${pageContext.request.contextPath }/KaptchaServlet?time=" + new Date().getTime();
}

</script>
</head>
<body>
<div class="login">
<div class="header">
<h1>
<a href="${pageContext.request.contextPath}/Login.jsp">登录</a>
<a href="${pageContext.request.contextPath}/reg.jsp">注册</a>
</h1>
<button></button>
</div>
<font color="red">${msg}</font>
<form action="${pageContext.request.contextPath}/LoginServlet" method="post">
<input type="hidden" name="method" value="login">

<div class="name">
<input type="text" id="name" name="username" placeholder="请输入登录用户名">
<p></p>
</div>
<div class="pwd">
<input type="password" id="pwd" name="password" placeholder="6-16位密码，区分大小写，不能用空格">
<p></p>
</div>
<div class="idcode">
<input type="text" id="verificationCode" name="checkCode" placeholder="请输入验证码">
<a href='#' onclick="changeImg()">    换一张</a>
<span >
<img id="codeimg"
src="${pageContext.request.contextPath }/KaptchaServlet">
</span>
<div class="clear"></div>
</div>
<div class="autoLogin">
<label for="">
<input type="checkbox" checked="checked">
下次自动登录
</label>
<a href="">忘记密码</a>
</div>
<div class="btn-red">
<input type="submit" value="登录" id="login-btn">
</div>
</form>
</div>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<meta charset="UTF-8">
<title>注册</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/reg.css">

<script type="text/javascript">
function changeImg() {
var img = document.getElementById("codeimg");
img.src = "${pageContext.request.contextPath }/KaptchaServlet?time=" + new Date().getTime();
}



function validate_form(){
//获取用户名
var username=document.getElementById("username").value;
if(username==null||username==""){
alert("用户名不能为空");
return false;
}

//获取密码
var password=document.getElementById("password").value;
if(password==null||password==""){
alert("密码不能为空");
return false;
}

//获取确认密码
var repassword=document.getElementById("repassword").value;
if(password !=repassword){
alert("两次密码输入不一致");
return false;
}
return true;
}







</script>
</head>
<body>
<div class="reg">
<div class="header">
<h1>
<a href="${pageContext.request.contextPath}/login.jsp">登录</a>
<a href="${pageContext.request.contextPath}/reg.jsp">注册</a>
</h1>
<button></button>
</div>
<form action="${pageContext.request.contextPath }/RegistServlet" method="post" onsubmit="return validate_form()">
<div class="name">
<input type="text" id="username" name="username" placeholder="请输入用户名">
<p></p>
</div>
<div class="pwd">
<input type="password" id="password" name="password" placeholder="6-16位密码，区分大小写，不能用空格">
<p></p>
</div>
<div class="confirm-pwd">
<input type="password" id="repassword" placeholder="确认密码">
<p></p>
</div>
<div class="idcode">
<input type="text" id="verificationCode" name="checkCode" placeholder="请输入验证码">
<a href='#' onclick="changeImg()">    换一张</a>
<span><img id="codeimg"
src="${pageContext.request.contextPath }/KaptchaServlet">
</span>
<div class="clear"></div>
</div>
<div class="btn-red">
<input type="submit" value="注册" id="reg-btn">
</div>
</form>
</div>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<meta charset="UTF-8">
<title>我的信息</title>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/add.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="/message/list.do">
返回留言板
</a>
</div>
</div>
</nav>
<div class="container">
<div class="jumbotron">
<h1>Hello, ${user.name}!</h1>
<p>信息都在这里了 ^_^</p>
</div>
<div class="page-header">
<h3><small>个人信息</small></h3>
</div>
<form class="form-horizontal" action="" method="post">

<div class="form-group">
<label for="name" class="col-sm-2 control-label">用户：</label>
<div class="col-sm-6">
<input name="name" class="form-control" id="name" value="" readonly>
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">密码：</label>
<div class="col-sm-6">
<input name="password" class="form-control" id="password" value="">
</div>
</div>


<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary">保存</button>   
</div>
</div>
</form>
</div>
<footer class="text-center" >
copy@imooc
</footer>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<meta charset="UTF-8">
<title>修改个人信息</title>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/add.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="#">
慕课网留言板个人信息
</a>
</div>
</div>
</nav>
<div class="container">
<div class="jumbotron">
<h1>Hello, ${user.username}!</h1>
<p>请斟酌后修改 ^_^</p>
</div>
<div class="page-header">
<h3><small>个人信息</small></h3>
</div>
<form class="form-horizontal" action="${pageContext.request.contextPath }/UserServlet?method=saveUI" method="post">

<div class="form-group">
<label for="name" class="col-sm-2 control-label">用户：</label>
<div class="col-sm-6">
<input name="username" class="form-control" id="username" value="${user.username}" readonly>
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">姓名：</label>
<div class="col-sm-6">
<input name="real_name" class="form-control" id="real_name" value="${user.real_name}">
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">生日：</label>
<div class="col-sm-6">
<input name="birthday" class="form-control" id="birthday" value="${user.birthday}">
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">电话：</label>
<div class="col-sm-6">
<input name="phone" class="form-control" id="phone" value="${user.phone}">
</div>
</div>

<div class="form-group">
<label for="password" class="col-sm-2 control-label">地址：</label>
<div class="col-sm-6">
<input name="address" class="form-control" id="address" value="${user.address}">
</div>
</div>

<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary">修改</button>   
</div>
</div>
</form>
</div>
<footer class="text-center" >
copy@imooc
</footer>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<html>
<head>
<meta charset="UTF-8">
<title>修改个人信息</title>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/add.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="#"> 慕课网留言板个人信息 </a>
</div>
</div>
</nav>
<div class="container">
<div class="jumbotron">
<h1>Hello, ${user.username}!</h1>
<p>请斟酌后修改 ^_^</p>
</div>
<div class="page-header">
<h3>
<small>个人信息</small>
</h3>
</div>
<form class="form-horizontal"
action="${pageContext.request.contextPath }/UserServlet?method=save"
method="post">

<div class="form-group">
<label for="name" class="col-sm-2 control-label">用户：</label>
<div class="col-sm-6">
<input name="username" class="form-control" id="username"
value="${user.username}" readonly>
</div>
</div>
<div class="form-group">
<label for="name" class="col-sm-2 control-label">密码：</label>
<div class="col-sm-6">
<input name="password" class="form-control" id="password"
value="${user.password}">
</div>
</div>

<div class="form-group">
<label for="password" class="col-sm-2 control-label">姓名：</label>
<div class="col-sm-6">
<input name="real_name" class="form-control" id="real_name"
value="${user.real_name}">
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">生日：</label>
<div class="col-sm-6">
<input name="birthday" class="form-control" id="birthday"
value="${user.birthday}">
</div>
</div>
<div class="form-group">
<label for="password" class="col-sm-2 control-label">电话：</label>
<div class="col-sm-6">
<input name="phone" class="form-control" id="phone"
value="${user.phone}">
</div>
</div>

<div class="form-group">
<label for="password" class="col-sm-2 control-label">地址：</label>
<div class="col-sm-6">
<input name="address" class="form-control" id="address"
value="${user.address}">
</div>
</div>

<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary">保存</button>
   
</div>
</div>
</form>
</div>
<footer class="text-center"> copy@imooc </footer>
</body>
</html>