mybatis对text类型进行了特别处理，在selectByExampleWithBLOBs里面，criteria里面没有。但可以自己在exampler里面自己写，他会自动映射成sql语句进行查询
查询代码
List<OperatorLogDto> operatorLogDtos = new ArrayList<>(); OperatorLogExample example = new OperatorLogExample(); example.setOrderByClause("gmt_modify desc"); example.createCriteria().andStatusEqualTo(2).andUserIdEqualTo(userId).andContentNotLike("%版本2.1%"); List<OperatorLog> operatorLogs = operatorLogMapper.selectByExampleWithBLOBs(example);
生成的XXXExample类添加方法
public Criteria andContentLike(String value){ addCriterion("content like", value, "content"); return (Criteria) this; } public Criteria andContentNotLike(String value){ addCriterion("content not like", value, "content"); return (Criteria) this; }
XML
<resultMap id="BaseResultMap" type="com.beihui.domain.model.OperatorLog"> <id column="id" jdbcType="VARCHAR" property="id" /> <result column="user_id" jdbcType="VARCHAR" property="userId" /> <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate" /> <result column="gmt_modify" jdbcType="TIMESTAMP" property="gmtModify" /> <result column="ip" jdbcType="VARCHAR" property="ip" /> <result column="STATUS" jdbcType="INTEGER" property="status" /> <result column="methodName" jdbcType="VARCHAR" property="methodname" /> </resultMap> <resultMap extends="BaseResultMap" id="ResultMapWithBLOBs" type="com.beihui.domain.model.OperatorLog"> <result column="content" jdbcType="LONGVARCHAR" property="content" /> </resultMap>
mysql中字段为text类型使用mybatis的Criteria查询无法进行封装
原文：http://www.cnblogs.com/xczln/p/7640462.html