mybaties复杂代码查询
@ContextConfiguration(locations = {"classpath:spring-mybatis.xml"})
public class TUser2MapperTest extends AbstractTestNGSpringContextTests{
@Autowired
TUser2Mapper usermapper;
@Test
public void countByExampleTest() {
TUser2Example example =new TUser2Example();
Criteria cri = example.createCriteria();
cri.andAgeBetween(1, 100);
cri.andAgeLessThan(1000);
Criteria cri2= example.createCriteria();
cri2.andUserNameNotLike("zhangsan%");
example.or(cri2);
PageHelper.startPage(2, 2);
List<TUser2> list = usermapper.selectByExample(example);
PageInfo<TUser2> pageInfo=new PageInfo<>(list);
System.out.println(pageInfo.getPageNum());
}
}