<select id="searchByName" parameterType="com.mpn.model.TUser" resultMap="BaseResultMapRolename">
Select u.*,r.RoleName
From t_user u
Left Join t_role r On u.UserRold = r.RoleId
Where u.UserIsEnabled = 1
<if test="userName != null">
and u.username like '%#{userName,jdbcType=VARCHAR}%'
</if>
</select>
查找资料发现因为%%导致出错把它提到外面直接传参带%%
//like搜索条件加入
String likestring="%"+tUser.getUserName()+"%";
tUser.setUserName(likestring);