SpringBoot结合及mybatis-plus实现增删改查

最新推荐文章于 2024-07-23 15:49:38 发布

Fei9537

最新推荐文章于 2024-07-23 15:49:38 发布

阅读量156

点赞数

文章标签： spring boot mybatis

本文链接：https://blog.csdn.net/Fei9537/article/details/118096299

版权

本文介绍了如何在Spring Boot项目中集成MyBatis-Plus进行数据库操作，包括添加依赖、创建实体类和Mapper接口、配置MetaObjectHandler以及编写测试用例，展示了完整的CRUD操作流程。

摘要由CSDN通过智能技术生成

1.引入依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.1</version>
 </dependency>

2 .根据数据库表创建一个实体类，一个mapper接口，在主启动类上添加mapper的包扫描

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = "emp")
public class Emp{
//    @TableId(type = IdType.AUTO)
    private Long empId;
//    @TableField(value = "emp_name")
    private String empName;
//    @TableField(value = "emp_age")
    private Integer empAge;

    @TableLogic
    private Integer deleted=0;

    @TableField(fill = FieldFill.INSERT)
    private Date createTime;

    public Emp( String name, Integer age) {
        this.empName = name;
        this.empAge = age;
        
    }

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;

}

3.调用mapper的接口

@Configuration
public class MyConfig implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        this.strictInsertFill(metaObject, "createTime", Date.class, new Date());
        this.strictUpdateFill(metaObject, "updateTime", Date.class, new Date());
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        this.strictUpdateFill(metaObject, "updateTime", Date.class, new Date());
    }
}

4.测试

@SpringBootTest
class DemoApplicationTests {
    @Resource
    EmpMapper empMapper;
    @Test
    void contextLoads() {
        Emp emp=empMapper.selectById(2);
        System.out.println(emp);
    }
    @Test
   void testInsert(){
        Emp emp=new Emp("分隔符",25);
        int row=empMapper.insert(emp);
        System.out.println(row);
    }

    @Test
    void testDelete(){
        int i=empMapper.deleteById(2);
        System.out.println(i);
    }
    @Test
    void testSelect(){
        List<Emp> list= empMapper.selectList(null);
        System.out.println(list);
    }

    @Test
    void testUpdate(){
        Emp emp=new Emp("tt",3);
        int i=empMapper.updateById(emp);
        System.out.println(i);
    }
}