需求:特殊符号标识(大于,小于,等于,不等于)
& &
< <
> >
" "
' '
小于等于 a<=b a <= b a <![CDATA[<= ]]>b
大于等于 a>=b a >= b a <![CDATA[>= ]]>b
不等于 a!=ba <![CDATA[ <> ]]>b a <![CDATA[!= ]]>b
需求:#{} ${}区别
链接:这份博客讲的很清楚
<select id="findUserById"parameterType="int"resultType="user">
select * from user where id =#{id}
</select>
<select id="selectUserByName"parameterType="string"resultType="user">
select * from user whereusername like '%${value}%'
</select>
ORDER BY ${columnName}
-$ ORDER BY columnName
-# ORDER BY "columnName"
语句:foreach
<insert id="setVorticityList" parameterType="Vorticity">
insert into vorticity (sitename,year,filename,filepath)
values
<foreach collection="list" item="item" index="index" open=" " separator="," close=" ">
(#{item.sitename},#{item.year},#{item.filename},#{item.filepath})
</foreach>
</insert>