mybatis动态sql模糊查询之Example
背景
根据姓名和工号查询某学校某班级学生
sql
select * from user_info where school=#{school} and class=#{class} and (name=#{name} or work_id=#{workId})
使用Example
Example example = new Example(UserInfo.class); example.createCriteria().andEqualTo("school",school).andEqualTo("class",class); if (StringUtils.isNotEmpty(nameOrId)) { example.and(example.createCriteria().andLike("name","%" + nameOrId + "%").orLike("workId","%" + nameOrId + "%")); } userInfoMapper.selectByExample(example);