Java对于jdbc对数据库的封装,封装方法参考:
1、Java(32):Java对于jdbc对数据库的封装(Bean)https://blog.csdn.net/fen_fen/article/details/120518266
2、Java(31):Java对于jdbc对数据库的封装[2]https://blog.csdn.net/fen_fen/article/details/120469074
3、Java(23):Java对于jdbc对数据库的封装[1]
https://blog.csdn.net/fen_fen/article/details/120379997
一、达梦数据库支持的数据类型
参考:达梦数据库支持的数据类型https://blog.csdn.net/weixin_41986044/article/details/105733985
二、Java访问DM数据库示例(连接调试用)
1、Maven引用(或直接导入jar包)
<!-- dm依赖-->
<dependency>
<groupId>dm</groupId>
<artifactId>DmJdbcDriver</artifactId>
<version>1.8.0</version>
<scope>provided</scope>
</dependency>
2、连接dm数据库(配置)
DM_DRIVER=dm.jdbc.driver.DmDriver
DM_URL=jdbc:dm://10.1.1.112:5236/DAMENG
DM_USER=hmf
DM_SECRET=lianshi2021static final String JDBC_DRIVER="dm.jdbc.driver.DmDriver";
static final String DB_URL="jdbc:dm://10.1.1.112:5236/DAMENG";
static final String USER = "hmf";
static final String PASSWORD = "lianshi2021";
3、连接达梦数据库示例
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class test05 {
static final String JDBC_DRIVER="dm.jdbc.driver.DmDriver";
static final String DB_URL="jdbc:dm://10.1.1.112:5236/DAMENG";
static final String USER = "hmf";
static final String PASSWORD = "lianshi2021";
public static void main(String[] args){
Connection conn = null;
Statement stmt = null;
try{
//注册 JDBC 驱动
Class.forName(JDBC_DRIVER);
//打开链接
System.out.println("Connect DB...");
conn= DriverManager.getConnection(DB_URL,USER,PASSWORD);
//执行查询
System.out.println("实例化Statement对象...");
stmt = conn.createStatement();
String sql;
sql = "SELECT * FROM aoedata";
ResultSet rs = stmt.executeQuery(sql);
//展开结果集数据库
System.out.println("aoeId"+"\t"+"aoeAes"+"\t"+"aoeSm4");
while (rs.next()){
System.out.print(rs.getInt(1) + "\t");
System.out.print(rs.getString(2) + "\t");
System.out.print(rs.getString(3) + "\t");
System.out.println();
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}