在mysql中,我们执行like(模糊查询)时,是这样写的
select * from table1 where userName like '%张%';
但是在mybatis的xml中,like必须写成这样:(${name}不带‘’传值)
<!-- 1.1.5根据群名称搜索群 -->
<select id="searchGroupByName" parameterType="map" resultType="map">
SELECT info.id, info.number AS groupNumber, info.name AS groupName, info.introduce AS groupIntroduce, info.picPath,
info.memberNumber AS nowNumber, info.longitude, info.latitude, guser.status AS inGroup
FROM profile_group_infodetail info
LEFT JOIN profile_group_userandgroup guser ON info.id = guser.groupId AND guser.userId=#{userId}
WHERE info.name LIKE '%${name}%' AND info.status=1 AND info.isPublic=1
ORDER BY info.isort,(ABS(info.longitude-#{longitude}) + ABS(info.latitude-#{latitude}))
</select>
如果将like写成(${name}带‘’传值)
<!-- 1.1.5根据群名称搜索群 -->
<select id="searchGroupByName" parameterType="map" resultType="map">
SELECT info.id, info.number AS groupNumber, info.name AS groupName, info.introduce AS groupIntroduce, info.picPath,
info.memberNumber AS nowNumber, info.longitude, info.latitude, guser.status AS inGroup
FROM profile_group_infodetail info
LEFT JOIN profile_group_userandgroup guser ON info.id = guser.groupId AND guser.userId=#{userId}
WHERE info.name LIKE '%#{name}%' AND info.status=1 AND info.isPublic=1
ORDER BY info.isort,(ABS(info.longitude-#{longitude}) + ABS(info.latitude-#{latitude}))
</select>
就会报Parameter index out of range (4 > number of parameters, which is 3)类型的错误