Mybatis_plus和springboot集成

一.创建项目

二.添加依赖

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.8.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.sxt</groupId>
	<artifactId>02_mp_springboot</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>02_mp_springboot</name>
	<description>springboot集成mp</description>

	<properties>
		<java.version>1.8</java.version>
		<maven-jar-plugin.version>3.1.1</maven-jar-plugin.version>
		<mybatisplus.version>3.2.0</mybatisplus.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-configuration-processor</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>${mybatisplus.version}</version>
    </dependency>
	</dependencies>
	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

三.创建mapper和domain

我的项目的目录结构：

User:

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@TableName(value = "user") //建立User.class和user表的关系
public class User implements Serializable {
    /**
     *
     */
    private static final long serialVersionUID = 1L;
    @TableId(value = "id") //代表是主键
    private Integer id;
    @TableField(value = "name")
    private String name;
    private String address;
    private Date birth;
}

UserMapper .java:

public interface UserMapper extends BaseMapper<User> {
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.mp_springboot.mapper.UserMapper" >
  
</mapper>

配置文件application.yml

#数据源
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC
    username: root
    password: root
    type: org.springframework.jdbc.datasource.DriverManagerDataSource
#配置mybatisplus
mybatis-plus:
  mapper-locations:
  - classpath:mapper/*Mapper.xml
  global-config:
    db-config:
      id-type: auto
    banner: true

启动类加入@MapperScan注解

@SpringBootApplication
@MapperScan(basePackages = {"com.example.mp_springboot.mapper"})
public class MpSpringbootApplication {

    public static void main(String[] args) {
        SpringApplication.run(MpSpringbootApplication.class, args);
    }

}

四.创建分页配置类

/**
 * mybatisplus的分页配置类
 */
@Configuration
@ConditionalOnClass(value = {PaginationInterceptor.class})
public class MybatisPlusConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor(){
        return new PaginationInterceptor();
    }
}

测试

@RunWith(SpringRunner.class)
@SpringBootTest
class MpSpringbootApplicationTests {

    @Autowired
    private UserMapper userMapper;

    @Test
    void contextLoads() {
        System.out.println(userMapper);
    }

    @Test
    public void addUser(){
        userMapper.insert(new User(null,"aA","BB",new Date()));
    }

    //测试分页
    @Test
    public void queryForPage(){
        IPage<User> page = new Page<>(1,5);
        userMapper.selectPage(page,null);
        List<User> list = page.getRecords();
        for (User user:list) {
            System.out.println(user);
        }
        System.out.println("总条数:"+page.getTotal());
    }

}

五.【熟悉】MP-AR模式开发

修改User 使它继承Model 并添加@EqualsAndHashCode(callSuper = false)注解
代码：

@Data
@EqualsAndHashCode(callSuper = false)
@AllArgsConstructor
@NoArgsConstructor
@ToString
@TableName(value = "user") //建立User.class和user表的关系
public class User extends Model<User> implements Serializable {
    /**
     *
     */
    private static final long serialVersionUID = 1L;
    @TableId(value = "id") //代表是主键
    private Integer id;
    @TableField(value = "name")
    private String name;
    private String address;
    private Date birth;
}

测试ApplicationTests2：

@RunWith(SpringRunner.class)
@SpringBootTest
class ApplicationTests2 {

    @Autowired
    private UserMapper userMapper;

    @Test
    void contextLoads() {
        System.out.println(userMapper);
    }

    @Test
    public void deleteUser(){
        User user = new User();
        user.setId(7);
        user.deleteById(3);
    }

    //测试分页
    @Test
    public void queryAll(){
        User user = new User();
        List<User> list = user.selectAll();

        for (User user2 :list) {
            System.out.println(user2);
        }

    }

    @Test
    public void insert(){
        User user = new User();
        user.setId(3);
        user.setName("羡慕");
        user.insert();

    }


}

注意：当实体字段在数据库表中没有时,要加@TableField(exist = false)注解

 @TableField(exist = false) //实体字段在数据库表中没有时
    private String sex;

六.条件构造器的使用

@Test
    public void testwrapper(){
        //条件构造器的使用
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.eq(true,"id",1);
        wrapper.eq("id",2);
        wrapper.between(true,"id",10,20);
        wrapper.lt("id",20);
        wrapper.le("id",21);
        wrapper.gt("id",10);
        wrapper.ge("id",10);
        wrapper.orderByAsc("id");
        wrapper.orderByDesc("id");
        System.out.println(wrapper.getSqlSegment());
    }

结果:打印的是sql的拼接语句

(id = #{ew.paramNameValuePairs.MPGENVAL1} AND id = #{ew.paramNameValuePairs.MPGENVAL2} AND id BETWEEN #{ew.paramNameValuePairs.MPGENVAL3} AND #{ew.paramNameValuePairs.MPGENVAL4} AND id < #{ew.paramNameValuePairs.MPGENVAL5} AND id <= #{ew.paramNameValuePairs.MPGENVAL6} AND id > #{ew.paramNameValuePairs.MPGENVAL7} AND id >= #{ew.paramNameValuePairs.MPGENVAL8})