MyBatis Plus
国产的开源框架,基于mybatis
核心功能就是简化mybatis开发,提高效率
属性是null,默认是不更新和插入
mybatis-plus快速上手
1.创建maven工程
2.添加pom依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1.tmp</version>
</dependency>
3.创建实体类
package com.example.mybatisplus.entity;
import lombok.Data;
@Data
public class User {
private Integer id;
private String name;
private Integer age;
}
4.创建Mapper接口
package com.example.mybatisplus.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mybatisplus.entity.User;
public interface UserMapper extends BaseMapper<User> {
}
5.application.yml
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8
username: root
password: 1qaz@WSX
#想在运行时打印sql日志
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
6.启动类添加@MapperScan(“mapper所在包”)注解
package com.example.mybatisplus;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.example.mybatisplus.mapper")
public class MybatisplusApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisplusApplication.class, args);
}
}
7.测试
package com.example.mybatisplus.mapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
@SpringBootTest
class UserMapperTest {
@Autowired
private UserMapper userMapper;
@Test
void test(){
userMapper.selectList(null).forEach(System.out::println);
}
}
常用注解
注:默认通过entity名字与数据表名匹配,如果名字匹配不上需要添加注解映射
@TableName
映射数据库表名
@Data
@TableName(value = "user")
public class UserEntity {
private Integer id;
private String name;
private Integer age;
}
@TableId
设置主键映射,value属性是数据库主键字段名
type属性设置主键类型,主键的生成策略
AUTO