数据库中datetime型数据的操作

向数据库中添加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);
  
 }