mybatis 动态排序
2022/9/5 23:22:54
本文主要是介绍mybatis 动态排序,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
public class Pagination { // 当前页 private Integer page = 1; // 一页显示条数 private Integer limit = 10; // 排序字段 private String field; // 排序类型(desc(降序)、asc(升序)、null(空对象,默认排序)) private String order; }
Map<String, Object> map = new HashMap<String, Object>(); Integer page = pagination.getPage(); Integer limit = pagination.getLimit(); map.put("start", (page-1)*limit); map.put("pageNo", limit); map.put("field", pagination.getField()); map.put("order", pagination.getOrder());
<select id="queryMarkVoluntarilyList" parameterType="map" resultType="MarkVoluntarilyDto"> select a.*, FROM_UNIXTIME(a.createTime,'%Y-%m-%d %H:%i:%s') AS createTimeStr from web_ei_voluntarily a <where> <if test="websiteName !=null and websiteName !=''"> a.websiteName like concat(#{websiteName},'%') </if> <if test="websiteUrl !=null and websiteUrl !=''"> and a.websiteUrl like concat(concat('%',#{websiteUrl}),'%') </if> <if test="companyName !=null and companyName !=''"> and a.companyName like concat(concat('%',#{companyName}),'%') </if> <if test="deptCode !=null and deptCode !=''"> <if test="containSub == '1'.toString()"> and a.deptCode like concat(#{deptCode},'%') </if> <if test="containSub == '0'.toString()"> and a.deptCode = #{deptCode} </if> </if> <if test="registrationCode !=null and registrationCode !=''"> and a.registrationCode = #{registrationCode} </if> <if test="creditCode !=null and creditCode !=''"> and a.creditCode like concat(#{creditCode},'%') </if> </where> <choose> <when test="field !=null and field !=''"> ORDER BY ${field} ${order} </when> <otherwise> ORDER BY a.createTime desc </otherwise> </choose> limit #{start}, #{pageNo} </select>
这篇关于mybatis 动态排序的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-04-26敏捷开发:想要快速交付就必须舍弃产品质量?
- 2024-04-26静态代码分析的这些好处,我竟然都不知道?
- 2024-04-26你在测试金字塔的哪一层?(下)
- 2024-04-26快刀斩乱麻,DevOps让代码评审也自动起来
- 2024-04-262024年最好用的10款ER图神器!
- 2024-04-2203-为啥大模型LLM还没能完全替代你?
- 2024-04-2101-大语言模型发展
- 2024-04-17基于SpringWeb MultipartFile文件上传、下载功能
- 2024-04-14个人开发者,Spring Boot 项目如何部署
- 2024-04-14RAG应用开发实战02-相似性检索的关键 - Embedding