配置postgreSQL+mybatis-plus_mybatis-plus使用pg的指定模式

配置PostgreSQL+Mybatis-Plus

父工程导入

            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>${spring-boot.mybatis}</version>
            </dependency>

            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
1
2
3
4
5
6
7
8
9
10
11

admin导入数据库

        <!-- PostgreSql -->
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
        </dependency>
1
2
3
4
5

创建pure-common-mybatis

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <groupId>com.xie</groupId>
        <artifactId>pure-common</artifactId>
        <version>${revision}</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>pure-common-mybatis</artifactId>



    <description>
        pure-common-mybatis 数据库服务
    </description>


    <dependencies>
        <dependency>
            <groupId>com.xie</groupId>
            <artifactId>pure-common-core</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
    </dependencies>
</project>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

package com.xie.common.mybatis.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import com.baomidou.mybatisplus.extension.toolkit.Db;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.autoconfigure.AutoConfiguration;
import org.springframework.context.annotation.Bean;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * @作者：xie
 * @时间：2023/7/2 19:30
 */
@EnableTransactionManagement(proxyTargetClass = true)
@AutoConfiguration
@MapperScan("${mybatis-plus.mapperPackage}")
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.POSTGRE_SQL));
        return interceptor;

    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

进行测试

package com.xie.controller;

import com.xie.common.core.domain.R;
import com.xie.mapper.MybatisTestMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @作者：xie
 * @时间：2023/7/2 19:59
 */
@RestController
@RequestMapping("/demo/mybatis")
public class MybatisTestController {

    @Autowired
    MybatisTestMapper mybatisTestMapper;
    /**
     * 查询测试
     */
    @GetMapping("/select")
    public R<Void> sendSimpleMessage() {
        mybatisTestMapper.selectById(1L);
        return R.ok();
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

package com.xie.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xie.domain.MybatisTest;
import com.xie.domain.vo.MybatisTestVo;
import org.apache.ibatis.annotations.Mapper;

/**
 * @作者：xie
 * @时间：2023/7/2 19:46
 */

public interface MybatisTestMapper extends BaseMapper<MybatisTest> {
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

package com.xie.domain;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * @作者：xie
 * @时间：2023/7/2 19:55
 */
@Data
@TableName("test_demo")
public class MybatisTest {
    private Long userId;
    private Long id;
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

参考RuoYi-Vue-Plus
代码仓库地址