mybatisplus

1.导入pom

     <!-- mybatiasplus依赖 -->
 <dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus-boot-starter</artifactId>
     <version>3.2.0</version>
 </dependency>
     <!-- mysql连接依赖 -->
 <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>5.1.47</version>
 </dependency>
       <!-- alibaba驱动 -->
 <dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>druid</artifactId>
     <version>1.0.11</version>
 </dependency>

2.配置文件

2.1 application.propweties

 spring.application.name=mp
 ​
 spring.datasource.driver-class-name=com.mysql.jdbc.Driver
 spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMultiQueries=true&useSSL=false
 spring.datasource.username=root
 spring.datasource.password=root
     
 //连接oracle的配置  
 #spring:
   #datasource:
     #type: com.alibaba.druid.pool.DruidDataSource
     #driver-class-name: oracle.jdbc.driver.OracleDriver
     #druid:
       #url: jdbc:oracle:thin:@127.0.0.1:1521/orcl
       #username: snaker
       #password: snakerweb

 

2.2 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

 

3.实体类注解

 @Data
 @AllArgsConstructor
 @NoArgsConstructor
 @Accessors(chain = true)
 @TableName("tb_user")
 public class User {
 ​
     @TableId(type=IdType.AUTO)
     private Long id;
     @TableField(value = "user_name")  //当数据库和字段不匹配时使用
     private String userName;
     @TableField(select = false)     //查询时不返回该字段的值
     private String password;
     private String name;
     private Integer age;
     @TableField(exist = false)          //数据库不存在该字段是使用
     private String email;
 ​
 }

4.查询条件设置

  QueryWrapper<User> wrapper = new QueryWrapper<>();
  //wrapper.gt("age",20);   //查询年龄大于20岁的
  wrapper.le("age",20);   //查询年龄小于20岁

5.分页查询

 //新增配置
 @Configuration
 @MapperScan("com.yulei.mapper") //设置mapper接口的扫描包
 public class MybatisPlusPaginationConfig {
 ​
     @Bean
     public PaginationInterceptor paginationInterceptor(){
         return new PaginationInterceptor();
     }
 }