Mybatis-Plus —— 简化传统CRUD(使用IService)

问题

传统的增删改查，代码繁多，如何进行简化呢？

解决

1、引入mybatis-plus

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-annotation</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

也可直接引入 

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

2、Service层

import com.baomidou.mybatisplus.extension.service.IService;

public interface xxxService extends IService<表格对应的实体类> {
}

 3、DAO层

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

@Repository
public interface xxxDao extends BaseMapper<表格对应的实体> {
}

4、Impl层

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

@Service
public class xxxImpl extends ServiceImpl<xxxDao, 表格对应的实体类>
        implements xxxService {
}

5、Controller

public class OrgInfoController {

    private final XxxService xxxService;

    public boolean add() {
        return xxxService.save(要新增的实体);
    }

}

6、 查询语句

        xxxService.list(Wrappers.<表格对应的实体A>lambdaQuery()
                .ge(A::getTime, startTime)
                .lt(A::getTime, endTime)
                .select(A::getId,
                        A::getTitle,
                        A::getStatus
                ));

扩展

IService 的方法

条件构造器