配置postgreSQL+mybatis-plus

最新推荐文章于 2024-06-16 19:59:55 发布

影（瘾）

最新推荐文章于 2024-06-16 19:59:55 发布

阅读量2.4k

点赞数

分类专栏：项目学习文章标签： postgresql mybatis 数据库 java

本文链接：https://blog.csdn.net/klxtstet/article/details/131514249

版权

项目学习专栏收录该内容

13 篇文章 0 订阅

订阅专栏

配置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>

admin导入数据库

        <!-- PostgreSql -->
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
        </dependency>

创建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>

在这里插入图片描述

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;

    }
}

进行测试

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();
    }

}

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> {
}

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;
}