1.模糊查询like的使用:e.name like "%"#{employee.name}"%"或 e.age like CONCAT(#{employee.age},'%')
2.字符串进行比较单引号在外,双引号在内<if test='employee.getSex() != null and employee.getSex() !="无"'>
3.多条sql语句一起执行加上allowMultiQueries=true<property name="url" value="jdbc:mysql://localhost:3306/company?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true" />
,然后多条sql语句之间用;间隔就可以