【Mybatis-plus学习03】SpringBoot + Mybatis + MP

引言

使用SpringBoot将进一步的简化MP的整合，需要注意的是，由于使用SpringBoot需要继承parent，所以需要重新创建工程，并不是创建子Module。

1. SpringBoot + Mybatis + MP整合

1.1 创建工程并导入依赖坐标

pom.xml

 <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.4.RELEASE</version>
  </parent>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
    <exclusions>
    <exclusion>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-logging</artifactId>
    </exclusion>
    </exclusions>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>
    <!--简化代码的工具包-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <optional>true</optional>
    </dependency>
    <!--mybatis-plus的springboot支持-->
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.1.1</version>
    </dependency>
    <!--mysql驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
    </dependency>

  </dependencies>
  <build>
    <plugins>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
        <!-- <configuration>
           <port>80</port>
           <path>/</path>
         </configuration>-->
      </plugin>

      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>

1.2 编写日志文件及springboot核心配置文件

log4j.properties

log4j.rootLogger=DEBUG,A1

log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%t] [%c]-[%p] %m%n

application.properties

spring.application.name = preSpringBoot
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mp?
useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456

#配置全局id自增策略
mybatis-plus.global-config.db-config.id-type=auto
#表名前缀，全局配置后可省略@TableName()配置。但要注意每张表都是统一tb_开头
mybatis-plus.global-config.db-config.table-prefix=tb_

1.3 编写实体类User以及UserMapper接口

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;//带全参的构造方法
import lombok.Data;//getter和setter方法及tostring
import lombok.NoArgsConstructor;//无参构造
@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("tb_user")
public class User {
    @TableId(type = IdType.AUTO)//设置id自增长
    private Long id;
    private String userName;
    @TableField(select = false)//设置密码在查询时候不显示出来
    private String password;
    private String name;
    private Integer age;
    //通过@TableField注解可以指定字段的一些属性，常常解决的问题有2个：
    //1、对象中的属性名和字段名不一致的问题（非驼峰）
    //2、对象中的属性字段在表中不存在的问题
    //像属性中的userName，字段中是user_name,TableField自动帮我们解决驼峰映射问题
    @TableField(value = "email")
    private String mail;
    @TableField(exist = false)//表明该字段在数据库表中不存在
    private String address;
}

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import springboot.pojo.User;

public interface UserMapper extends BaseMapper<User> {
}

1.4 创建启动类并添加测试

启动类：

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("springboot.mapper") //设置mapper接口的扫描包
@SpringBootApplication
public class MyApplication {
    public static void main(String[] args) {
        SpringApplication.run(MyApplication.class, args);
    }
}

测试：

@RunWith(SpringRunner.class)
@SpringBootTest(classes = MyApplication.class)
public class UserMapperTest {

    @Resource
    private UserMapper userMapper;

    @Test
    public void testSelect() {
        List<User> userList = userMapper.selectList(null);
        for (User user : userList) {
            System.out.println(user);
        }
    }
}

ok，接下来我们看一下运行结果

这里的password=null以及address=null为什么为空，在下一篇blog我们会进行解释，现在你也可以自己去探索一下…