解决ResultSet.getDate()时分秒为0的问题
rs应该用getTimestamp()而不用getDate()
即:
字段类型为date 时用 getDate(i)
字段类型为datetime 时用 getTimestamp(i)
解决PreparedStatement.setDate()时分秒为0的问题
pstmt应该用setTimestamp()而不用setDate()
如:
pstmt.setTiemstamp(8, new Timestamp(System.currentTimeMillis()));
pstmt.setTimestamp(8, new Timestamp(new java.util.Date().getTime()));