springboot项目搭建0050-整合通用mapper

一时失言乱红尘 2022-03-31 12:15 216阅读 0赞

项目地址：[https://github.com/wenrongyao/springboot-demo.git][https_github.com_wenrongyao_springboot-demo.git]

摘要：mybatis是优秀的持久化框架，但是引入mybatis后还要频繁的写增删改查，很不方便，所以这边引入刘增辉老师的通用mapper，通用mapper封装了单表基本上所有的操作。

1、加入依赖

mybatis及mapper的版本参数

<mybatis.version>1.3.2</mybatis.version>
            <mapper.version>2.0.3-beta1</mapper.version>
            <pagehelper.version>1.2.10</pagehelper.version>

<dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
            
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>${mapper.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>${pagehelper.version}</version>
            </dependency>

2、com.honor.config包下配置自己的mapper接口，以后自己写的mapper继承这个接口就可以了

import tk.mybatis.mapper.common.MySqlMapper;
    
    /**
     * 继承自己的MyMapper
     *
     * @author liuzh
     * @since 2015-09-06 21:53
     */
    public interface Mapper2<T> extends tk.mybatis.mapper.common.Mapper<T>, MySqlMapper<T> {
    }

3、资源文件配置通用mapper

#通用mapper
    mapper.mappers=com.honor.config.Mapper2
    mapper.notEmpty=true
    #pagehelper
    restart.include.mapper=/mapper-[\\w-\\.]+jar
    restart.include.pagehelper=/pagehelper-[\\w-\\.]+jar
    #mybatis
    mybatis.mapper-locations=classpath:mapper/*.xml,classpath:mapper/*/*.xml
    #配置驼峰转下划线
    mybatis.configuration.map-underscore-to-camel-case=true

4、com.honor.mapper包下建立自己的mapper-SysUserMapper

import com.honor.config.Mapper2;
    import com.honor.model.SysUser;
    
    /**
     * Created by rongyaowen
     * on 2019/1/3.
     */
    public interface SysUserMapper extends Mapper2<SysUser> {
    }

5、SpringbootDemoApplication启动配置mapper扫描

import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import tk.mybatis.spring.annotation.MapperScan;
    
    /**
     * Created by rongyaowen
     * on 2019/1/3.
     */
    @SpringBootApplication
    @MapperScan(basePackages = {"com.honor.mapper"})
    public class SpringbootDemoApplication {
        public static void main(String[] args) {
            SpringApplication.run(SpringbootDemoApplication.class);
        }
    }

一定注意，这里的MapperScan是tk包下的，不是spring的。

6、测试

import com.honor.mapper.SysUserMapper;
    import com.honor.model.SysUser;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    import org.springframework.test.context.web.WebAppConfiguration;
    
    import java.util.List;
    
    /**
     * Created by rongyaowen
     * on 2019/1/3.
     */
    @RunWith(SpringRunner.class)
    @SpringBootTest
    @WebAppConfiguration
    public class Mapper2Test {
        @Autowired
        private SysUserMapper sysUserMapper;
    
        @Test
        public void selectTest() {
            List<SysUser> sysUsers = sysUserMapper.selectAll();
            for (SysUser sysUser : sysUsers) {
                System.out.println(sysUser);
            }
        }
    
    }

7、结果

![20190103144844467.png][]

8、配置日志级别打印出sql详细信息

如果是logback日志，直接在资源文件中配置，设置mapper包为trace

logging.level.com.honor.mapper=trace

如果是log4j，在log4j.properties设置

log4j.logger.com.honor.mapper = trace

结果

![20190103145438497.png][]

[https_github.com_wenrongyao_springboot-demo.git]: https://github.com/wenrongyao/springboot-demo.git
[20190103144844467.png]: /images/20220331/0e63c46bbd0c499faf6d5de38e373b22.png
[20190103145438497.png]: /images/20220331/fec606892acf473885dd164550fc3859.png