SpringBoot 集成达梦数据库 maven依赖本地jar包

淩亂°似流年 2022-03-01 00:10 1193阅读 0赞

最近做ZF项目，需要使用国产数据库，考虑到人气较高的达梦数据库，这里是版本7。达梦数据库是参考Oracle，和MySQL有一点点的区别，这里介绍下spring boot/cloud项目里如何集成达梦数据库。

**1.下载Dm7JdbcDriver17.jar，下载地址：**[https://download.csdn.net/download/las723/11046200][https_download.csdn.net_download_las723_11046200]

**2.在src下建lib文件夹，将Dm7JdbcDriver17.jar复制进去：**

![20190321111658157.png][]

**3.pom文件里添加依赖**

<dependency>
                <groupId>com.dm</groupId>
                <artifactId>Dm7JdbcDriver</artifactId>
                <version>1.7</version>
                <scope>system</scope>
                <systemPath>${project.basedir}/src/lib/Dm7JdbcDriver17.jar</systemPath>
            </dependency>

**考虑到打包时将jar包打进项目里，需要在maven插件上加上此类依赖**

<plugin>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-maven-plugin</artifactId>
    	<configuration>
    		<includeSystemScope>true</includeSystemScope>
    	</configuration>
    </plugin>

**4.application.yml里添加达梦数据库的配置**

#spring
    spring:
      datasource:
        driver-class-name: dm.jdbc.driver.DmDriver
        url: jdbc:dm://127.0.0.1:5236/DMSERVER?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
        username: SYSDBA
        password: SYSDBA

** 5.集成mybatis，pom添加依赖**

<dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.6</version>
            </dependency>

**6.添加逆向工程，这里注意Dm7JdbcDriver17.jar使用本地绝对路径**

<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<version>1.3.6</version>
    				<dependencies>
    					<dependency>
    						<groupId>com.dm</groupId>
    						<artifactId>Dm7JdbcDriver</artifactId>
    						<version>1.7</version>
    						<scope>system</scope>
    						<systemPath>D:/fengding/xxxxx/common/src/lib/Dm7JdbcDriver17.jar</systemPath>
    					</dependency>
    				</dependencies>
    				<configuration>
    					<configurationFile>src/main/resources/mybatis/generatorConfig.xml</configurationFile>
    					<overwrite>true</overwrite>
    				</configuration>
    			</plugin>

**逆向工程文件 generatorConfig.xml**

![20190322090933467.png][]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    
        
        <context id="sqlserverTables">
            
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
    
            
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
                
            </commentGenerator>
    
            
            <jdbcConnection driverClass="dm.jdbc.driver.DmDriver"
                            connectionURL="jdbc:dm://127.0.0.1:5236/DMSERVER?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8"
                            userId="SYSDBA"
                            password="SYSDBA">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.ww.model"
                                targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper"
                             targetProject="src/main/resources">
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.ww.dao" targetProject="src/main/java">
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
    
            
            
            <table tableName="t_ww_key_person_bank_tran_info" domainObjectName="WwKeyPersonBankTranInfo">
                <property name="useActualColumnNames" value="true"/>
            </table>
    
        </context>
    
    </generatorConfiguration>

好了，接下来就可以自动生成代码了，其他操作和Oracle数据库一样的，又可以开心玩耍了！

[https_download.csdn.net_download_las723_11046200]: https://download.csdn.net/download/las723/11046200
[20190321111658157.png]: /images/20220301/44969da779b74c07bbd043cb39c41e7e.png
[20190322090933467.png]: /images/20220301/d2ca5542a4c044b1aaa66b850a544233.png