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

喜欢ヅ旅行 2023-10-18 17:41 148阅读 0赞

## 场景 ##

项目搭建专栏：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/column/info/37194][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]

基础搭建：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89407994][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]

条件构造器介绍使用：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89482201][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89482201]

## 实现 ##

排序前数据库

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

### 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

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

### orderDesc()方法 ###

注意其参数是一个column的集合。

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

代码修改为：

@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

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3][]

### 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

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4][]

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11142313][https_download.csdn.net_download_badao_liumang_qizhi_11142313]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/column/info/37194
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89407994
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89482201]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89482201
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190425214253584.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190425214320243.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/201904252143300.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190425214924254.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190425214944896.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[https_download.csdn.net_download_badao_liumang_qizhi_11142313]: https://download.csdn.net/download/badao_liumang_qizhi/11142313