【TRINO】jdbc链接取值（trino的前身就是presto）

mvn

其中trino的jar包一定要找对应trino版本的jar，我的trino安装版本是400，那我jar的版本就是400

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.3</version>
</dependency>
<dependency>
    <groupId>io.trino</groupId>
    <artifactId>trino-jdbc</artifactId>
    <version>400</version>
</dependency>

代码

public static void getConnection() throws SQLException, ClassNotFoundException {

        Class.forName("io.trino.jdbc.TrinoDriver");
        TimeZone.setDefault(TimeZone.getTimeZone("+08:00"));
        String url = "jdbc:trino://192.168.1.136:8989/";
        Properties properties = new Properties();
        properties.setProperty("user", "trino");
        properties.setProperty("password", "");
//        properties.setProperty("SSL", "true");
        Connection connection = DriverManager.getConnection(url, properties);
        Statement statement = connection.createStatement();
//        String sql = "SELECT id, name, remark FROM mysql.test.abc ";
//        String sql = "show tables";
        String sql = "select * from mysql.test.student offset 0 limit 200";
//        String sql = "select id,name from iceberg.default.table_a";

//        String sql = "select * from default.student2";
        ResultSet rs = statement.executeQuery(sql);
        int rowNum = 0;
        if(rs.next()){
            while (rs.next()) {
                System.out.println("id==========="+rs.getString("id"));
                System.out.println("name==========="+rs.getString("name"));
            }
            rowNum ++;
        }
    }