目录
基本概念
代码与实例
基本概念
Jdbc有4种方式访问数据库,下面给出达梦访问数据库的方式。
安装好达梦库后,就会有驱动,在此不再说明怎么去安装!
本次使用Java7的环境,所以使用的Jar包为:Dm7JdbcDriver17.jar。
其实安装好后官方有提供驱动的使用,但没有提供Spring Boot和Jdbc接口调用,所以在此本人记录下用Jdbc访问。
逻辑如下:
Jdbc调用达梦提供的驱动文件,Java应用再去调用JDBC接口。
代码与实例
首先来看下数据:
程序运行截图如下:
程序结构如下:
关键源码如下:
请求:
@GetMapping("/")public String test(){System.out.println("DM Test");List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from SYS.POLICY_GROUPS");System.out.println(list);System.out.println("The size is: " + list.size());return "over";}
maven读取本地jar文件:
<!--导入三方jar--><dependency><groupId>dm.jdbc.driver.DmDriver</groupId><artifactId>jdbc</artifactId><scope>system</scope><systemPath>${project.basedir}/src/main/resources/lib/Dm7JdbcDriver17.jar</systemPath></dependency>
打包时和其他库一起:
<plugin><artifactId>maven-compiler-plugin</artifactId><configuration><source>1.7</source><target>1.7</target><encoding>UTF-8</encoding><compilerArguments><extdirs>${project.basedir}/src/main/resources/lib</extdirs></compilerArguments></configuration></plugin></plugins>
完整源码
DMTest.java
package dmjbdc0919.demo.dmTest;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.RestController;import java.util.List;import java.util.Map;@RestControllerpublic class DMTest {@AutowiredJdbcTemplate jdbcTemplate;@GetMapping("/")public String test(){System.out.println("DM Test");List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from SYS.POLICY_GROUPS");System.out.println(list);System.out.println("The size is: " + list.size());return "over";}}
porm.xml
<?xml version="1.0" encoding="UTF-8"?><project xmlns="/POM/4.0.0" xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/POM/4.0.0 /xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>1.5.21.RELEASE</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>YWHAfterEnd</groupId><artifactId>demo</artifactId><version>0.0.1-SNAPSHOT</version><name>demo</name><description>Demo project for Spring Boot</description><properties><java.version>1.7</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><!--导入三方jar--><dependency><groupId>dm.jdbc.driver.DmDriver</groupId><artifactId>jdbc</artifactId><scope>system</scope><systemPath>${project.basedir}/src/main/resources/lib/Dm7JdbcDriver17.jar</systemPath></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin><plugin><artifactId>maven-compiler-plugin</artifactId><configuration><source>1.7</source><target>1.7</target><encoding>UTF-8</encoding><compilerArguments><extdirs>${project.basedir}/src/main/resources/lib</extdirs></compilerArguments></configuration></plugin></plugins></build></project>
application.properties
spring.datasource.driver-class-name=dm.jdbc.driver.DmDriverspring.datasource.url=jdbc:dm://127.0.0.1:5236spring.datasource.username=SYSDBAspring.datasource.password=SYSDBA