Mybatis逆向生成的xxxxExample.java如何使用

MessageExample example = new MessageExample();
MessageExample.Criteria criteria = example.createCriteria();
criteria.andUserIdEqualTo(id);
List<Message> list = messageMapper.selectByExampleWithBLOBs(example);

模糊查询user表，返回一个list<user> ,其中有一个属性是从别的表中关联查询的，resultMap怎么写：
<resultMap id="SelectUserByFuzzySearchMap" type="com.pojo.User" extends="BaseResultMap">
<association property="picture" javaType="com.pojo.PictureWithBLOBs">
<id property="picId" column="pic_id" />
<result property="picDir" column="pic_dir"/>
</association>
</resultMap>
注:记得在user表中添加那个没有的属性

数据库查询语句为：
SELECT
u.user_id,
u.loginname,
u.phone,
u.email,
u.sex,
u.nickname,
u.pic_id,
u.qq,
u.intro,
u.address,
p.pic_dir
FROM user u LEFT JOIN picture p on u.pic_id = p.pic_id WHERE CONCAT(loginname,nickname,realname) LIKE '%${value}%'