方式1 常用插入方式
Timestamp currentTime= new Timestamp(System.currentTimeMillis());
String sql = "INSERT INTO message(date_create) VALUES (" + "'" + currentTime + "'" + ");";
方式2 使用 占位符
Timestamp currentTime= new Timestamp(System.currentTimeMillis());
String sql = "INSERT INTO message( date_create) VALUES (?);";
PreparedStatement pst = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
pst.setTimestamp(1, currentTime);
pst.executeUpdate();
pst.close();
方式3 使用postgreSQL自带函数
String sql = "INSERT INTO message(date_create) VALUES (LOCALTIMESTAMP);";