java mybatis分页查询语句_4.MybatisPlus 自定义sql及分页查询

1.自定义sql

版本需要大于3.0.7

1.1.使用注解式

1.1.1.在UserMapper.java中添加自定义方法

package com.mp.dao;

import com.baomidou.mybatisplus.core.conditions.Wrapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.baomidou.mybatisplus.core.toolkit.Constants;

import com.mp.entity.User;

import org.apache.ibatis.annotations.Param;

import org.apache.ibatis.annotations.Select;

import java.util.List;

/**

* @Description 数据访问层

* @Author LL

* @Date 2020-03-22 12:31

*/

public interface UserMapper extends BaseMapper {

//注解式

@Select("select * from user ${ew.customSqlSegment}")

List selectAll(@Param(Constants.WRAPPER)Wrapper wrapper);

}

1.1.2.测试

package com.mp;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;

import com.baomidou.mybatisplus.core.toolkit.Wrappers;

import com.mp.dao.UserMapper;

import com.mp.entity.User;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

/**

* @Description 测试类，自定义sql

* @Author LL

* @Date 2020-03-22 18:35

*/

@SpringBootTest

@RunWith(SpringRunner.class)

public class CustomSqlTest {

@Autowired

private UserMapper userMapper;

/**

* 自定义sql，注解式

*/

@Test

public void myTest(){

LambdaQueryWrapper lambdaQuery = Wrappers.lambdaQuery();//方式三

lambdaQuery.like(User::getName, "雨")

.lt(User::getAge, 40);

List users = userMapper.selectAll(lambdaQuery);

users.forEach(System.out::println);

}

}

1.2.使用xml方式

1.2.1.在配置文件中指定xml文件所在位置

# mapper.xml文件位置

mybatis-plus:

mapper-locations: classpath:mapper/*.xml

1.2.2.在UserMapper.java文件中添加自定义