jdbc连接达梦数据库，单机版指定schema

package com.audaque.web.action;

/**
 * @Auther: 
 * @Date: 2021/4/19 15:02
 * @Description:
 */
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

class Connect{
    static Connection conn=null;
    static String name="dm.jdbc.driver.DmDriver";
//目前发现还是不能指定schema
    static String url="jdbc:dm://xxxx:5236/xx";
//集群环境
// static String url="jdbc:dm://dmconn?dmconn=(192.168.10.211:5236,192.168.10.211:5236,192.168.10.211:5236)&LOGIN_MODE=(1)";
    static String user="dqms_user";
    static String password="Huaao1234";
    public static void main(String[] args) {
        try{
            Class.forName(name);
            conn= DriverManager.getConnection(url,user,password);
            conn.setAutoCommit(true);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from TEST1");
            int newID = 1;
            if (rs.next()) {

                String userName = rs.getString("name");
                System.out.println("name:" +userName);

            }else{
                System.out.println("no data");
            }
            rs.close();
            conn.close();
            System.out.println("数据库连接成功"+url);
        }catch(Exception e){
            System.out.println("error");
        }
    }
}