java连接hana数据库

要在Java中连接到SAP HANA数据库，需要使用SAP提供的HANA JDBC驱动程序。以下是连接到HANA数据库的示例Java代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class HanaConnectionExample {
   public static void main(String[] args) {
      String url = "jdbc:sap://<hostname>:3<instance number>/";

      String user = "<username>";
      String password = "<password>";
      String driverClass = "com.sap.db.jdbc.Driver";

      Connection connection = null;
      Statement statement = null;
      ResultSet resultSet = null;

      try {
         Class.forName(driverClass);
         connection = DriverManager.getConnection(url, user, password);
         statement = connection.createStatement();
         resultSet = statement.executeQuery("SELECT * FROM <table name>");

         while (resultSet.next()) {
            System.out.println(resultSet.getString(1));
         }
      } catch (ClassNotFoundException e) {
         e.printStackTrace();
      } catch (SQLException e) {
         e.printStackTrace();
      } finally {
         try {
            if (resultSet != null) {
               resultSet.close();
            }
            if (statement != null) {
               statement.close();
            }
            if (connection != null) {
               connection.close();
            }
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
   }
}

在此示例代码中，您将需要替换`<hostname>`，`<instance number>`，`<username>`，`<password>`和`<table name>`与您的HANA数据库实例的相关值。请确保安装并使用正确版本的HANA JDBC驱动程序，并在代码中指定正确的驱动程序类名称。