查询数据

某时间段上，BBOX范围查询。其它空间范围查询SQL参考：空间对象关系函数

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class PostgreSQLJDBC {
    public static void main(String args[]) {
        Connection conn = null;
        Statement stmt = null;
        try{
            Class.forName("org.postgresql.Driver");
            conn = DriverManager.getConnection("jdbc:postgresql://ts-uf6sx115kjk117156.tsdbgaia.rds.aliyuncs.com:3242/postgres","singo", "Tsdb2gaia");
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery( "SELECT uid,time,ST_AsText(position) AS pos FROM tsdb_test " +
                    "WHERE time > '2019-03-10 18:30:15' AND time < '2019-03-15 18:30:15' AND " +
                    "ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(10, 20),ST_Point(35,41)),4326),position)" );
            while ( rs.next() ) {
                long id = rs.getLong("uid");
                String  time = rs.getString("time");
                String position  = rs.getString("pos");
                System.out.println( "uid = " + id + ", time = " + time + ", position = " + position );
                System.out.println();
            }
            rs.close();
            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");
    }
}