插入数据
写入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.168.86: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");
}
}
版权声明
本文仅代表作者观点,不代表本站立场。
本文系作者授权发表,未经许可,不得转载。
评论