MyBatis-Plus配置（个人学习记录）

1.创建SpringBoot项目 

2.pom.xml引入 

<!--mybatis-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>3.0.2</version>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter-test</artifactId>
    <version>3.0.2</version>
    <scope>test</scope>
</dependency>


<!--mybatisPlus-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.3.1</version>
</dependency>

3.application.xml配置文件配置数据源 

server:
  port: 8090
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/analyse?serverTimezone=GMT%2b8
    username: (用户名称)
    password: (用户密码)

    logging:
      level:
        com.analyse.backend:debug
mybatis:
  mapper-locations: classpath:mapper/*.xml #扫描所有mybatis的xml文件

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句(可不加)
  mapper-locations: classpath:mapper/*.xml

4.创建与表对应的实体类

/**
 * @TableName user
 */
@TableName(value = "user")//指定数据库的名称
@Data//提供类的get、set、equals、hashCode、canEqual、toString方法
@AllArgsConstructor//全参构造
@NoArgsConstructor//无参构造
public class User implements Serializable {
//    private static final long serialVersionUID = 1L;

    @TableId(type = IdType.AUTO)//指定id
    private Integer uid;

    private String username;

    private String email;

    @JsonIgnore//忽略掉不给前端展示
    private String password;

    private Integer permission;

    @TableField(value = "create_time")//指定数据库字段名称
    private Date createTime;

    @TableField(value = "update_time")//指定数据库字段名称
    private Date updateTime;

    @TableLogic//逻辑删除
    private String deleted;//是否展示

    @Version//乐观锁
    private Integer version;//版本号

}

5.创建mapper接口

//@Mapper//将mapper实例化不建议在这实例化
public interface UserMapper extends BaseMapper <User>{
}

6.创建service

@Service
public class UserService extends ServiceImpl<UserMapper, User> {
    public boolean saveUser(User user){
        return saveOrUpdate(user);

    }
}

7.配置启动类

@SpringBootApplication
@MapperScan("com.analyse.backend.generator.mapper")//扫描mapper所在的包
public class BackendApplication {

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