SQL in查询方式、与传参、模糊查询

weixin_45587504

已于 2023-02-01 15:47:38 修改

阅读量1.1k

点赞数 3

分类专栏： sql 文章标签： java sql

于 2022-12-13 17:09:01 首次发布

本文链接：https://blog.csdn.net/weixin_45587504/article/details/128304843

版权

sql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

用parameterType="java.util.ArrayList"接收dao传递类型

String[] files= {"1","50265","50271","50309","50310","50311","50312"};

Service

public List<LimsFileManagement> findInList(String[] files) {

       return limsFileManagementDao.findInList(files);

   }

DAO

List<Office> findZhiDingList(@Param("files")String[] files);

<foreach>循环数组

<select id="findInList" resultType="LimsFileManagement" parameterType="java.util.ArrayList">
       SELECT
       <include refid="limsFileManagementColumns" />
       FROM lims_file_management a
       <include refid="limsFileManagementJoins" />
       WHERE a.del_flag='0'

               AND a.id IN
               <foreach collection="files" item="file" open="(" close=")" separator=",">
           #{file}
           </foreach>
       <choose>
           <otherwise>
               ORDER BY a.sort
           </otherwise>
       </choose>
   </select>

模糊查询

<if test="sampleTitle != null and sampleTitle != ''">
               AND a.sampleTitle LIKE
                   <if test="dbName == 'oracle'">'%'||#{sampleTitle}||'%'</if>
                   <if test="dbName == 'mssql'">'%'+#{sampleTitle}+'%'</if>
                   <if test="dbName == 'mysql'">concat('%',#{sampleTitle},'%')</if>
  </if>