mybatis xml 对mysql批量模糊搜索

最新推荐文章于 2024-01-31 16:45:07 发布

bug退退退！

最新推荐文章于 2024-01-31 16:45:07 发布

阅读量835

点赞数

分类专栏： SQL数据库合集文章标签：数据库开发 java

本文链接：https://blog.csdn.net/bawojiyu12/article/details/124034512

版权

SQL数据库合集专栏收录该内容

1 篇文章 0 订阅

订阅专栏

mybatis xml文件

    <select id="searchBid" resultType="com.zk.company.entity.mysql.dao.BidWinNotice">
        SELECT bwn.*,bwa.type as type,bwa.name as name,bwa.company_name as companyName FROM bid_win_notice AS bwn LEFT JOIN bid_win_analysis AS bwa ON bwn.id =bwa.id
        WHERE bwa.is_check=1
        <if test="names !=null">
            <foreach collection="names" item="item" separator="OR" open="and (" close=")">
                bwa.name LIKE concat('%',#{item},'%')
            </foreach>
        </if>
        <if test="page !=null">
            limit #{page.startRow},#{page.limit}
        </if>
    </select>

mapper文件，输入集合对象就可以