常用sql查询语句

MyBatis-plus BaseMapper自定义

最新推荐文章于 2025-01-15 13:30:00 发布

原创最新推荐文章于 2025-01-15 13:30:00 发布 · 183 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #数据库

spring boot 同时被 2 个专栏收录

10 篇文章

订阅专栏

mysql

1 篇文章

订阅专栏

博客围绕MyBatis-plus BaseMapper进行自定义相关内容阐述，涉及信息技术领域中数据库操作与框架使用，能为开发者在数据库开发方面提供一定参考。

//连表查询
select *,job.user_id as createId from complaint as com left join job on job.id = com.job_id where job.city='Beijing' and job.industry like '%p%' and job.type=1 and com.user_id=7 and com.opt_status>=1 order by com.createdAt desc;

对应的myBatis-plus BaseMapper中自定义

@Select("<script>select *,job.user_id as create_id from complaint as com left join job on job.id = com.job_id where 1=1"+"<if test='certifiedJD != 0'>" + " and job.authentication=#{certifiedJD}" + "</if>"+"<if test='optStatus == 0'>" + " and com.opt_status=#{optStatus}" + "</if>"+"<if test='optStatus == 1'>" + " and com.opt_status>=1" + "</if>"+"<if test='segmentation != null'>" + " and job.industry like '%#{segmentation}%'" + "</if>"+"<if test='nature != 0'>" + " and job.type=#{nature}" + "</if>"+"<if test='userid != null'>" + " and com.user_id=#{userid}" + "</if>"+"<if test='location != null'>" + " and job.city=#{location}" + "</if>"+"<if test='sortBy=1'>"+" order by com.createdAt desc"+"</if>"+"</script>")
List<JobInfo> selectCompliantList(@Param("certifiedJD") Integer var1,@Param("segmentation") String var2,@Param("nature") Integer var3,@Param("location") String var4,@Param("sortBy") Integer var5,@Param("userid") Integer var6,@Param("optStatus") Integer var7);