MyBatisPlus条件构造器带条件排序方法orderBy、orderByDesc、orderByAsc使用

最新推荐文章于 2025-10-28 08:28:12 发布

转载最新推荐文章于 2025-10-28 08:28:12 发布 · 5.1w 阅读

10 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/BADAO_LIUMANG_QIZHI/article/details/89526925

文章标签：

#mybaits-plus

mybaits-plus 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍如何使用MyBatis Plus的EntityWrapper进行条件构造器排序操作，包括默认升序、降序及升序排列的方法，并提供代码示例。

实现
排序前数据库

orderBy()方法
默认升序。

/***
  *条件构造器 排序操作
  */
 @Test
 public void testEntitymapperOrderBy() {
  
  List<Employee> employeeList=employeeMapper.selectList(new EntityWrapper<Employee>()
    .eq("gender",1)
    .like("name", "霸")
    .orderBy("age")
    );
  System.out.println("*******************"+employeeList);
  for (Employee employee : employeeList) {
   System.out.println(employee.getAge());
  }
 }

运行效果

SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ?) ORDER BY age

orderDesc()方法
注意其参数是一个column的集合。

代码修改为：

@Test
 public void testEntitymapperOrderBy() {
  
  List<Employee> employeeList=employeeMapper.selectList(new EntityWrapper<Employee>()
    .eq("gender",1)
    .like("name", "霸")
    //.orderBy("age")
    .orderDesc(Arrays.asList(new String[] {"age"}))
    );
  System.out.println("*******************"+employeeList);
  for (Employee employee : employeeList) {
   System.out.println(employee.getAge());
  }
 }

运行效果

SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ?) ORDER BY age DESC

orderByAsc()方法
注意其参数是一个column的集合。

升序排列。

代码测试：

@Test
 public void testEntitymapperOrderBy() {
  
  List<Employee> employeeList=employeeMapper.selectList(new EntityWrapper<Employee>()
    .eq("gender",1)
    .like("name", "霸")
    //.orderBy("age")
    //.last("desc")
    //.orderDesc(Arrays.asList(new String[] {"age"}))
    .orderAsc(Arrays.asList(new String[] {"age"}))
    );
  System.out.println("*******************"+employeeList);
  for (Employee employee : employeeList) {
   System.out.println(employee.getAge());
  }
 }

运行结果

SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ?) ORDER BY age ASC

源码下载
https://download.youkuaiyun.com/download/badao_liumang_qizhi/11142313