Kylin

public class KylinDemoApp {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // kylin Driver
        String KYLIN_DRIVER = "org.apache.kylin.jdbc.Driver";

        // kylin URL
        String KYLIN_URL = "jdbc:kylin://192.168.1.200:7070/FirstProject";

        // kylin USERNAME
        String KYLIN_USER = "ADMIN";

        //kYLIN PASSWORD
        String KYLIN_PASSWORD = "KYLIN";

        // 1.加载驱动
        Class.forName(KYLIN_DRIVER);

        // 2.获取数据库连接
        Connection connection = DriverManager.getConnection(KYLIN_URL,KYLIN_USER,KYLIN_PASSWORD);


        // 3.获取Statement 对象
        PreparedStatement ps = connection.prepareStatement("select * from dept");


        // 4. 执行SQL,返回结果集
        ResultSet resultSet =ps.executeQuery();

        // 5.循环解析结果集
        while (resultSet.next()){
            System.out.println(resultSet.getString(1));
            System.out.println(resultSet.getString(2));
        }

        // 关闭连接
        resultSet.close();
        ps.close();
        connection.close();
    }
}