排序的列中有中文, 需要使用gbk转码再排序, 否则排序无效果
mybatis-plus 排序查询 (java语句)
@Test
void sort() {
QueryWrapper qw = new QueryWrapper();
//按name升序排序
qw.orderByAsc("CONVERT(name using gbk)");
List list = employeeMapper.selectList(qw);
System.out.println(list);
}
sql语句
SELECT id,name,password,email,age,admin,dept_id
FROM employee
ORDER BY CONVERT(name using gbk) ASC