为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。 【DM版本】: 【操作系统】: 【CPU】: 【问题描述】*:再麻烦问一下,jdbc连接达梦怎么连
详情可以看https://eco.dameng.com/document/dm/zh-cn/app-dev/java-jdbc.html
package java_jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class jdbc_conn { static Connection con = null; static String cname = "dm.jdbc.driver.DmDriver"; static String url = "jdbc:dm://localhost:5236"; static String userid = "SYSDBA"; static String pwd = "*****"; public static void main(String[] args) { try { Class.forName(cname); con = DriverManager.getConnection(url, userid, pwd); con.setAutoCommit(true); System.out.println("[SUCCESS]conn database"); } catch (Exception e) { System.out.println("[FAIL]conn database:" + e.getMessage()); } } public void disConn(Connection con) throws SQLException { if (con != null) { con.close(); } } }
可参考上述文档,如有demo,可执行:java -jar jdbc_test.jar ip 端口号连接。
可以参考下这篇文章https://blog.csdn.net/aa0597/article/details/118091573
详情可以看https://eco.dameng.com/document/dm/zh-cn/app-dev/java-jdbc.html
package java_jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class jdbc_conn {
static Connection con = null;
static String cname = "dm.jdbc.driver.DmDriver";
static String url = "jdbc:dm://localhost:5236";
static String userid = "SYSDBA";
static String pwd = "*****";
public static void main(String[] args) {
try {
Class.forName(cname);
con = DriverManager.getConnection(url, userid, pwd);
con.setAutoCommit(true);
System.out.println("[SUCCESS]conn database");
} catch (Exception e) {
System.out.println("[FAIL]conn database:" + e.getMessage());
}
}
public void disConn(Connection con) throws SQLException {
if (con != null) {
con.close();
}
}
}