SpringBoot 集成DM达梦数据库并使用Pagination分页

目录

1、引入jar包，在达梦安装目录下

 2、引入pom依赖

 3、引入yml配置文件

 4、MybatisPlusConfig使用Pagination分页配置类

5、关于找不到表错误信息--需要在实体中指定模式

 1、引入jar包，在达梦安装目录下

 2、引入pom依赖

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

//把第三方引入的jar包一起打包
<build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <includeSystemScope>true</includeSystemScope>
                </configuration>
            </plugin>
        </plugins>
</build>

 3、引入yml配置文件

spring:
  datasource:
      url: jdbc:dm://192.168.0.104:5236/Test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true
      username: SYSDBA
      password: '123456789'
      driver-class-name: dm.jdbc.driver.DmDriver

 4、MybatisPlusConfig使用Pagination分页配置类

package com.test.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import java.util.Properties;

/*
 * @Description MybatisPlusConfig
 * @author wuqs
 * @Date 2020-08-19 18:55
 **/
@Configuration
@MapperScan("com.test.mapper")
@EnableTransactionManagement
public class MybatisPlusConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor page = new PaginationInterceptor();
        page.setDbType(DbType.DM);
        return page;
    }

}

5、关于找不到表错误信息--需要在实体中指定模式