一、新建空的maven工程
二、在项目中导入依赖
<dependencies>
<dependency>
<groupId>org.apache.kylin</groupId>
<artifactId>kylin-jdbc</artifactId>
<version>3.0.2</version>
</dependency>
</dependencies>
三、编写class
public class TestKylin {
public static void main(String[] args) throws Exception {
String KYLIN_DRIVER = "org.apache.kylin.jdbc.Driver";
String KYLIN_URL = "jdbc:kylin://120.55.103.238:7070/project1";
String KYLIN_USER = "ADMIN";
String KYLIN_PASSWD = "KYLIN";
Class.forName(KYLIN_DRIVER);
Connection connection = DriverManager.getConnection(KYLIN_URL, KYLIN_USER, KYLIN_PASSWD);
PreparedStatement ps = connection.prepareStatement("SELECT * FROM KYLIN_SALES limit 10");
ResultSet resultSet = ps.executeQuery();
while (resultSet.next()) {
System.out.print(resultSet.getInt(1)+"\t");
System.out.print(resultSet.getDate(2)+"\t");
System.out.println(resultSet.getString(3));
}
}
}