springboot2+mybatisplus自定义查询语句的写法

1. mapper 代码:

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tivattravel.demo.bean.User;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

@Mapper
public interface UserMapper extends BaseMapper<User> {
    @Select("select * from user ${ew.customSqlSegment}")
    List<User> selectAll(@Param(Constants.WRAPPER) Wrapper<User> queryWrapper);

}

2.测试代码:

 @Test
    void testUserMapper(){
        LambdaQueryWrapper<User> query = new LambdaQueryWrapper<>();
        String a = "18";
        query.eq(User::getAge, a);
        List<User> list = userMapper.selectAll(query);

在mapper函数中的
“select * from user ${ew.customSqlSegment}” *号为输出数据的全部内容,可以改为你自己想输出的查询内容,在测试函数中可以根据不同属性的查询条件进行查询,只需更改getAge参数,get想要以查询为主的函数即可.