import org.apache.ibatis.type.StringTypeHandler; //导入依赖的package包/类
@Test
public void testAndExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria()
                .andCondition("countryname like 'C%' and id < 100")
                .andCondition("length(countryname) = ", 5)
                .andCondition("countrycode =", "CN", StringTypeHandler.class);
        List<Country> countries = mapper.selectByExample(example);
        //查询总数
        Assert.assertEquals(1, countries.size());
    } finally {
        sqlSession.close();
    }
}
 

import org.apache.ibatis.type.StringTypeHandler; //导入依赖的package包/类
@Test
public void shouldGetTypeAndTypeHandlerForNullStringType() {
  assertEquals(JdbcType.VARCHAR, Null.STRING.getJdbcType());
  assertTrue(Null.STRING.getTypeHandler() instanceof StringTypeHandler);
}