MySql的时间类型有 Java中与之对应的时间类型
date java.sql.Date
Datetime java.sql.Timestamp
Timestamp java.sql.Timestamp
Time java.sql.Time
Year java.sql.Date
String sql="INSERT INTO server_time(servername,classname,responsetime,currenttime)"
+ "VALUES(?,?,?,?)";
Connection con=getConn();
try{
PreparedStatement preStmt =(PreparedStatement) con.prepareStatement(sql);
preStmt.setString(1, servername);
preStmt.setString(2, classname);
preStmt.setLong(3, responsetime);
//获得当前时间,插入到数据库,数据库中的数据类型为datatime,对应于java.sql.Timestamp
//时间格式为yyyy-MM-ddHH:mm:ss
preStmt.setTimestamp(4, new java.sql.Timestamp(new java.util.Date().getTime()));
}
//如果数据库数据类型date:
preStmt.setDate(4, new java.sql.Date(new java.util.Date().getTime()));
//如果数据库数据类型为time:
preStmt.setTime(4, new java.sql.Time(new java.util.Date().getTime()));