文档

插入数据

更新时间:
一键部署

写入point点数据。支持标准的点线面,多点、多线等OGC标准。

public class InsertJDBC {
    public static void main(String args[]) {
        Connection conn = null;
        Statement stmt = null;
        try{
            Class.forName("org.postgresql.Driver");
            //用户请使用自己的账号和密码
            conn = DriverManager.getConnection("jdbc:postgresql://139.224.XX.XX:5432/doc","citybrain", "Tsdb2gaia");
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            String sql = "INSERT INTO tsdb_test VALUES (1001, '2019-03-11 16:34:15', 1002.2, ST_MakePoint(10.3,20.1) )" ;
            stmt.executeUpdate(sql);

            sql = "INSERT INTO tsdb_test VALUES (1002, '2019-03-12 16:34:15', 2002.2, ST_MakePoint(1.3,2.1) )";
            stmt.executeUpdate(sql);

            sql = "INSERT INTO tsdb_test VALUES (1003, '2019-03-13 16:34:15', 3002.2, ST_MakePoint(30.3,40.1) )";
            stmt.executeUpdate(sql);


            stmt.close();
            conn.commit();
            conn.close();

        } catch (Exception e) {
            System.err.println(e.getClass().getName() + " : " + e.getMessage());
            System.exit(0);
        }
        System.out.println("select successfully");
    }
}
  • 本页导读 (1)
文档反馈