常用sql查询语句

最新推荐文章于 2024-07-25 16:49:43 发布

攻城狮狮

最新推荐文章于 2024-07-25 16:49:43 发布

阅读量104

点赞数

分类专栏： spring boot mysql 文章标签： sql 数据库

本文链接：https://blog.csdn.net/wodebokecsdn/article/details/127517198

版权

spring boot 同时被 2 个专栏收录

10 篇文章 1 订阅

订阅专栏

mysql

1 篇文章 0 订阅

订阅专栏

//连表查询
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);