業(yè)務(wù)場景需求:
12個月使用12張不同的表,操作表時,希望只使用單條sql操作多張表
引入字符:$
使用方法和#一致,使用時,直接將表名作為參數(shù)傳入。
舉個例子:

使用$操作多張表.png

使用$操作多張表2.png
另外附上萬能模板,包含排序:
<update id="updateByLowerChangeHigh" parameterType="map" statementType="STATEMENT">
update ${tableName} set ${sqlName} = ${sqlName} -1 where 1 = 1
<if test="startNo != null and endNo!=null">
and ${sqlName} between ${startNo} and ${endNo}
</if>
<if test="sqlName2!=null">
and ${sqlName2}
</if>
and school_num = ${schoolNum}
</update>
<update id="updateByHighChangeLower" parameterType="map" statementType="STATEMENT">
update ${tableName} set ${sqlName} = ${sqlName} +1 where 1 = 1
<if test="startNo != null and endNo!=null">
and ${sqlName} between ${startNo} and ${endNo}
</if>
<if test="sqlName2!=null">
and ${sqlName2}
</if>
and school_num = ${schoolNum}
</update>