Spring boot集成mybaitsPlus

pom配置

        <!--MyBaitsPlus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
        </dependency>
        <!--Mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

application.properties配置

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/testallowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

 

SpringBoot启动类添加Mapper扫描

@MapperScan("com.cc.mapper")
@SpringBootApplication
public class Application{
    public static void main(String[] args){
        SpringApplication.run(Application.class,args);
    }
}

Mapper继承mybatisplus内置BaseMapper

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

public interface UserMapper extends BaseMapper<User>{

}

编写测试类

@RunWith(SpringRunner.class)
@SpringBootTest
public class Test{

    @Autowired
    private UserMapper userMapper;

    @Test
    public void select(){
        List<User> list = userMapper.selectList(null);
        list.forEach(System.out::println);
    }
}

指定表名与实体类对应关系,假设数据库表名为T_USER而实体类为User,这时候就需要实体类上指明对应的表名.

@TableName("T_USER")
public class User{
    //指定主键ID
    @TableId 
    private Long id;
    //指定对应数据库字段名
    @TableField("name")
    private String userName;
    private String email;
}