CDATA[ ${value 如果value是sql语句,那这里就是个动态的sql语句了,最终会执行这条sql语句,select from student where id = #{id} 如果你这个id也传入个sql语句,这里就会把它当成一个查询值了<update id = "excute" parameterType="java.lang.String"><![CDATA[ ${value}]]></update>select * from studen...
[CDATA[ and (DATE_FORMAT(a.start_date, '%Y-%m-%d') BETWEEN DATE_FORMAT(#{chooseStartDate}, '%Y-%m-%d') AND DATE_FORMAT(#{chooseEndDate}, '%Y-%m-%d') OR DATE_FORMAT(a.end_date, '%Y-%m-%d') BETWEEN DATE_FORMAT(#{chooseStartDate}, '%Y-%m-%d') AND DATE_FORMAT(#{chooseEnd...