Question

SELECT * FROM ［user］ WHERE u_name LIKE ‘%三%’ AND u_name LIKE ‘%猫%’ 请问这个用ibatis 怎么写

Answer 1

select *
from user
where u_name like concat('%', #param1#, '%')
and u_name like concat('%', #param2#, '%')
不知道是不是你要的结果，有问题我们可以继续讨论

Answer 2

请参考

<!-- 查询学生list，like姓名、=性别，参数entity类型 -->
<select id="searchUser" parameterType="UserSearchEntity" resultMap="UserResultMap">
SELECT * from user

WHERE u_name LIKE CONCAT(CONCAT('%', #{userName}),'%')
</select>

UserSearchEntity entity = new UserSearchEntity();
entity.setUserName("李");
List<User> userList = userMapper.searchUser(entity);
for (User user: userList) {
System.out.println(user);
}

Answer 3

<select id="com.searcheUser" parameterClass="hashMap" resultClass="entrance">
select * from user

<dynamic prepend="WHERE">
<isNotEmpty property="uname" prepend="AND">
u_name like '%'||#uname#||'%' escape '\'
</isNotEmpty>
<isNotEmpty property="uname" prepend="AND">
u_name like '%'||#uname#||'%' escape '\'
</isNotEmpty>
</dynamic>

</select>

大概就这么写的啦 uname是从hashMap取出来的。