今天发现一个问题,使用标签进行查询语句的拼接时,逗号和引号老处理不好,所以在此记录下,供以后参考
@Select("<script>" +
" select * from tb_crowd_fund_person_record a,tb_crowd_fund_info b where b.id=a.crowd_fund_info_id " +
" <if test='activeStatus != null and activeStatus != \"\"'> "+
" and b.active_status=#{activeStatus} " +
" </if> " +
" <if test='createUser != null and createUser != \"\"'> "+
" and a.create_user=#{createUser} " +
" </if> " +
"</script>")
List<String> findByType(Map<String,String> map);