使用JDBC测试连接人大金仓、达梦

需要jar包：kingbase8-8.2.0.jar（人大金仓官网下载）

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class KingLinkTest {
    public static void main(String[] args) {
        test("SELECT * FROM \"PUBLIC\".\"T\" limit 10");
    }

    public static Connection conn = null;
    public static PreparedStatement pst = null;
    public static final String url = "jdbc:kingbase8://127.0.0.1:54321/TEST";
    public static final String name = "com.kingbase8.Driver";
    public static final String user = "system";
    public static final String password = "12345"; //这里的用户名和密码设置为自己的

    public static void test(String sql) {
        try {
            Class.forName(name);
//            DriverManager.registerDriver(new com.kingbase8.Driver());
            conn = DriverManager.getConnection(url, user, password);//获取连接
            pst = conn.prepareStatement(sql);//准备执行语句
            ResultSet resultSet = pst.executeQuery();
            int i = 0;
            while (resultSet.next()) {
                i++;
            }
            System.out.println(i);
            System.out.print("yes");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

达梦

8开发版

driver：dm.jdbc.driver.DmDriver

url：jdbc:dm://127.0.0.1:5236/DAMENG