lwf006164的博客

添加useGeneratedKeys=“true” keyProperty=“id” //示例 <insert id="addErrorLogAsync" useGeneratedKeys="true" keyProperty="id"> insert into error_log ( id, server_name, class_na...

数组 //判断数组是否为空且长度是否为0 <if test="id != null and id.length > 0"> <foreach collection="id" open="(" close=")" item="item" separator=","> ${item} </foreach> </if> 集合 //判断集合是...

$ select * from a where id = ${recId} 最后生成的SQL为： 1select * from a where id = 1 即：直接将参数值替换到了原来${recId}的位置，相当于硬拼SQL # select * from a where id = #{recid} 最后生成的SQL为： select * from a where id = ? 即：#{......