java.sql.date是java.util.date的子类
birthday=rs.getDate("birthday");
birthday=new Date(rs.getDate("birthday"));
输出不一样,后者做了格式化工作
static void create(String name,String pwd,Date birthday) throws SQLException{
Connection conn = null;
PreparedStatement ps=null;
ResultSet rs = null;
try {
conn = JdbcUtils.getConnection();
String sql="insert into user(username,passwd,birthday) values(?,?,?)";
ps=conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pwd);
ps.setDate(3, new java.sql.Date(birthday.getTime()));
int i=ps.executeUpdate();
System.out.println(i);
} catch (Exception ex) {
ex.printStackTrace();
} finally {
JdbcUtils.free(rs, ps, conn);
}
}
create("hello","pwd",new Date());