Task Submission And Execution Of JDBC API Documents

Enter the ujes/jdbc directory in the Linkis project and enter the command in the terminal to package mvn assembly:assembly -Dmaven.test.skip=true The packaging instruction skips the running of the unit test and the compilation of the test code, and packages the dependencies required by the JDBC module into the Jar package.
After the packaging is complete, two Jar packages will be generated in the target directory of JDBC. The one with dependencies in the Jar package name is the Jar package we need.

2. Create A Test Category

 public static void main(String[] args) throws SQLException, ClassNotFoundException {
        //1. Load driver class：org.apache.linkis.ujes.jdbc.UJESSQLDriver
        Class.forName("org.apache.linkis.ujes.jdbc.UJESSQLDriver");
        //2. Get connection：jdbc:linkis://gatewayIP:gatewayPort
        Connection connection =  DriverManager.getConnection("jdbc:linkis://127.0.0.1:9001","username","password");
        //3. Create statement and execute query
        Statement st= connection.createStatement();
        ResultSet rs=st.executeQuery("show tables");
        //4. Processing the returned results of the database (using the ResultSet class)
        while (rs.next()) {
                System.out.print(metaData.getColumnName(i) + ":" +metaData.getColumnTypeName(i)+": "+ rs.getObject(i) + "    ");
            }
            System.out.println();
        }
        // close resourse
        rs.close();
        st.close();
        connection.close();
    }