JDBC连接hana JAVA API

JDBC连接hana JAVA API

work中需要将kafka topic中的数据sync到hana表中，事先做了一个了解hana语法和代码的demo，后续介绍kafka connector的使用 和 hana语法的简单使用

package com.xxx;

import java.sql.*;

public class JDBCDemoHANA {

    private static final String DRIVER = "com.sap.db.jdbc.Driver";
    private static final String URL = "jdbc:sap://10.xx.2.1xx:30515?currentschema=xxx";

    public JDBCDemoHANA() {
    }

    public static void main(String[] args) {
        JDBCDemoHANA demo = new JDBCDemoHANA();
        try {
            demo.select();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void select() throws Exception {

        Connection con = this.getConnection(DRIVER, URL, "username","password");

        //返回当前会话的用户名。
        PreparedStatement pstmt1 = con.prepareStatement("SELECT CURRENT_USER FROM DUMMY;");
        this.closeStatement(pstmt1);

        Prepa