向数据库中添加datetime型数据:
例如: 2007-09-05 11:08:53
public boolean addSraimsUserTime(int sraimsuser_id, java.util.Date entertime) {
java.sql.Timestamp tt = new java.sql.Timestamp(entertime.getTime());
String sql = "insert into sraimsusertime(sraimsuser_id,entertime) values(?,?)";
try {
conn = DatabaseBean.getConnection();
stmt = conn.prepareStatement(sql);
stmt.setInt(1, sraimsuser_id);
stmt.setTimestamp(2, tt);
if (stmt.executeUpdate() == 1)
return true;
else
return false;
} catch (Exception e) {
e.getMessage();
return false;
} finally {
DatabaseBean.close(conn, stmt, rs);
}
}
取出数据:
public ArrayList<SraimsUserTime> getAllSraimsUserTime(int sraimsuser_id) {
String sql = "select * from sraimsusertime where sraimsuser_id=? ";
ArrayList<SraimsUserTime> list = new ArrayList<SraimsUserTime>();
SraimsUserTime sraimsUserTime = null;
try {
conn = DatabaseBean.getConnection();
stmt = conn.prepareStatement(sql);
stmt.setInt(1, sraimsuser_id);
rs = stmt.executeQuery();
while (rs.next()) {
sraimsUserTime = new SraimsUserTime();
sraimsUserTime.setId(rs.getInt("id"));
sraimsUserTime.setSraimsUser_id(rs.getInt("sraimsuser_id"));
sraimsUserTime.setEntertime(rs.getTimestamp("entertime"));
list.add(sraimsUserTime);
}
return list;
} catch (Exception e) {
e.getMessage();
return null;
} finally {
DatabaseBean.close(conn, stmt, rs);
}
}
在sraimsUserTime.getEnterTime()中这样写:
public String getEntertime() {
SimpleDateFormat fmt=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
return fmt.format(entertime);
}