引入mybatis-plus

1.引入的依赖

<!--spring整合mybatis-plus -->
         <dependency>
             <groupId>com.baomidou</groupId>
             <artifactId>mybatis-plus-boot-starter</artifactId>
             <version>3.4.3</version>
         </dependency>
 <!--spring整合mybatis-plus -->
         <dependency>
             <groupId>com.baomidou</groupId>
             <artifactId>mybatis-plus-boot-starter</artifactId>
             <version>3.2.0</version>
         </dependency>

2.编辑Mapper接口

public interface UserMapper extends BaseMapper<User>

3.编写service

public interface UserService extends IService<User>

4.编写ServiceImpl

public class UserServiceImpl extends ServiceImpl<UserMapper , User> implements UserService{
}

5.查询方法

QueryWrapper<User> wrapper = new QueryWrapper<>();
        //等于 
        wrapper.eq("user_id",userId);
        //模糊查询
        wrapper.like("username","%张%");

 mysql中模糊查询时可用concat

select userName from user where userName LIKE CONCAT(’%’, ‘张’, ‘%’)