mybatis总结

mybatis总结

 

https://blog.csdn.net/qq_47540091/article/details/123446973

Mybatis in 逗号分隔字符串

 

<update id="softDel" parameterType="String">
SELECT *
FROM study

WHERE id in
<foreach item="item" index="index" collection="ids.split(',')"  open="(" separator="," close=")">
  #{item}
</foreach>
</update>

String ids = “1,2,3”,如ids作为参数。

mybatis常见转义符

 

Mybatis转义字符表

&lt;	<	小于
&gt;	>	大于
&amp;	&	与
&apos;	'	单引号
&quot;	"	双引号

 

mybais拼接% 模糊查询

 

<select id="queryWaitSignPageList" parameterType="com.bill.intemag.entity.BusBillWaitsign" resultType="com.bill.intemag.entity.BusBillWaitsign">
        SELECT
            A.*
        FROM
            BUS_BILL_WAITSIGN A
        JOIN (
            SELECT
                COMPNAME,
                FLAG,
                MAX(POIDATE) AS POIDATE
            FROM
                BUS_BILL_WARN
            GROUP BY
                COMPNAME,
                FLAG
        ) B ON A.ACPTRACCT_NAME = B.COMPNAME
        WHERE
            a.RECORDFLAG = 'A'
        AND a.CHECKFLAG IN ('0', '2')
        AND a.WARNFLAG = '1'
        AND a.DATAFLAG = '0'
        AND a.DATAOPERFLAG = '0'
        <if test="bw.billcode != null and bw.billcode !=''">
            AND a.billcode like '%${bw.billcode}%'
        </if>
    </select>