jdbc调用postgreSQL数据库内置函数

编程技术  /  houtizong 发布于 2年前   73

1. current_timestamp

  返回的是当前的时间戳

table intense.miracle
id integer DEFAULT 0
name character varying (20)
timestamp timestamp without time zone

Class.forName("org.postgresql.Driver");Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/test", "postgres", "postgres");String sql = "INSERT INTO intense.miracle(id, name, timestamp) VALUES(?,?,current_timestamp)";PreparedStatement ps = conn.prepareStatement(sql);ps.setInt(1, 1);ps.setString(2, "charming");ps.executeUpdate();

当然，这里也可以使用Statement:

...Statement st = conn.createStatement();String sql = "INSERT INTO intense.miracle(id, name, timestamp) VALUES(2,'significant',current_timestamp)";st.executeUpdate(sql);...

2. current_date

  返回的是当前日期

2. current_time

  返回的是当前时间

4. nextval('schema_name.sequence_name')

  也可以写成nextval('"schema_name"."sequence_name"')

  返回的是序列的下一个值

...String sql = "INSERT INTO intense.miracle(id, name, timestamp) VALUES(nextval('intense.seq_oid'),'oscillation',current_date)";...