java连接达梦数据库的简单代码

时间:2019-10-30 16:40:28   收藏:0   阅读:861

1. 引用DmJdbcDriver.jar包

2. 编写代码:

String driver= "dm.jdbc.driver.DmDriver";
String url= "jdbc:dm://192.168.1.100:12345/TEST";
String username="DEVELOPER";
String password="123456";

Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from OaUser");
int newID = 1;
if (rs.next()) {

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

}else{
    out.println("no data");
}
rs.close();
conn.close();

 

原文:https://www.cnblogs.com/ziwuxian/p/11765661.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!