@Select({"<script>",
"SELECT * FROM person_data p1",
"INNER JOIN person_credit p2 ON p1.`id` = p2.`person_id`",
"WHERE 1=1",
"<when test='ssn!=null'>",
" and ssn = #{ssn}",
"</when>",
"<when test='name!=null'>",
" and name=#{name}",
"</when>",
"</script>"})
当使用多个<when> 时需要加上</script>,否则会报错;
使用Ipage进行分页时,形参为实体对象时,在@select中需要使用(对象.属性);
不适用Ipage进行分页,则可以直接写属性名称;
注意:when条件里用到的判断属性也同样遵循上述原则
< 转义大写
> 转义小写