Mybatis中的like模糊查询功能

param.setUsername("%CD%");

 param.setPassword("%11%");

select id,sex,age,username,password from person wheretrue

AND username LIKE #{username}

AND password LIKE #{password}

 

 select id,sex,age,username,password

 from person

 where username LIKE #{pattern}