原本的代码是:
public void addUser(UserVO user) throws Exception {
Connection conn = DBUtil.connectDB();
String sql = "INSERT INTO tbl_user_info(user_name, age, sex, create_dt) "
+ " VALUES(?, ?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, user.getUserName());
pstmt.setInt(2, user.getAge());
pstmt.setInt(3, user.getSex());
pstmt.setDate(4, new Date(new java.util.Date().getTime())); //1
pstmt.execute();
}
系统提示出错
解决办法:
把标记1那里的 pstmt.setDate(4, new Date(new java.util.Date().getTime()));
改成:pstmt.setDate(4, new java.sql.Date(new java.util.Date().getTime()));