jdbc 日期处理问题

1、从结果集中取得日期部分

  resultSet.getDate();  --2013-01-07

2、从结果集中取得时间部分

 resultSet.getTime()   --22：08：09

3、从结果集中同时得到日期和时间

 

resultSet.getTimestamp(); --2013-01-07 23：08：09

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

@Override     public List<User> findAll() {         List<User> list = new ArrayList<User>();                   Connection con = null;         PreparedStatement stmt = null;         ResultSet rs = null;                   try {             con = JdbcUtil.getConnection();             String sql = "select * from [user]";                           stmt = con.prepareStatement(sql);                           rs = stmt.executeQuery();                           while(rs.next())             {                 //精确到秒  yyyy-MM-dd HH:mm:ss                 User u = new User(rs.getInt("id"), rs.getString("username"),rs.getString("password"),rs.getTimestamp("createtime"));                 //精确到秒  yyyy-MM-dd                 //User u = new User(rs.getInt("id"), rs.getString("username"),rs.getString("password"),rs.getDate("createtime"));                 list.add(u);                               }             return list;                       } catch (Exception e) {                           e.printStackTrace();         }         finally         {                 JdbcUtil.close(rs, stmt, con);                       }                   return null;        }       @Override     public void add(User user) {         Connection con = null;         PreparedStatement stmt = null;         ResultSet rs = null;                   try {             con = JdbcUtil.getConnection();             String sql = "insert into [user](username,password,createtime) values(?,?,?)";             stmt= con.prepareStatement(sql);             stmt.setString(1, user.getUsername());             stmt.setString(2,user.getPassword());             //精确到秒  yyyy-MM-dd HH:mm:ss             //stmt.setTimestamp(3,  new java.sql.Timestamp((new Date()).getTime()));             //下面精确到 日  yyyy-MM-dd             stmt.setDate(3, new java.sql.Date(new Date().getTime()));             stmt.execute();                       } catch (Exception e) {                           e.printStackTrace();         }finally         {             JdbcUtil.close(rs, stmt, con);         }               }