注意:需要将ngdbc.jar加入项目构建路径
/**
* HANA数据库查询
*/
private ResultSet executeSqlByHana(String sql) {
Connection connection = null;
String DRIVER = "com.sap.db.jdbc.Driver";
// 数据库IP地址
String URL = "jdbc:sap://IP:30015/?autocommit=false";
// 帐号
String user = "user";
// 密码
String pwd = "password";
try {
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
connection = DriverManager.getConnection(URL, user, pwd);
} catch (SQLException e) {
System.err.println("Connection Failed. User/Passwd Error?");
return null;
}
if (connection != null) {
try {
System.out.println("Connection to HANA successful!");
Statement stmt = connection.createStatement();
ResultSet resultSet = stmt.executeQuery(sql);
return resultSet;
} catch (SQLException e) {
System.err.println("Query failed!");
return null;
}
}
return null;
}