mybatis的sql 执行报错:Parameter index out of range (4 > number of parameters, which is 3)
来源:互联网 发布:c语言第五版 编辑:程序博客网 时间:2024/06/02 04:58
在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)类型的错误
- mybatis的sql 执行报错:Parameter index out of range (4 > number of parameters, which is 3)
- mybatis中#{}报错 Parameter index out of range (1 > number of parameters, which is 0)问题
- MySQL 报错:Parameter index out of range (2> number of parameters, which is 1)
- 执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)?
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- 使用mybatis执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)?
- 使用mybatis执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)?
- 使用mybatis执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)?
- Parameter index out of range (4 > number of parameters, which is 3)
- mybatis Parameter index out of range (1 > number of parameters, which is 0)
- mybatis错误Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- java.sql.SQLException Parameter index out of range (9 > number of parameters, which is 8)
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- 兔子--Parameter index out of range (3 > number of parameters, which is 2).
- Parameter index out of range (3 > number of parameters, which is 2).
- grunt-ts编译成es5报错
- [java]使用httpclient4.5.3设置fiddler代理方法
- cksum与md5sum实现文件校验
- 利用PHPMailer发送邮件
- SharedPreferences保存文件工具类
- mybatis的sql 执行报错:Parameter index out of range (4 > number of parameters, which is 3)
- Hibernate(2)Hibernate核心类和接口
- yum install error – GPG key retrieval failed
- grails 记录
- 大数据工程师需要的东西
- angular.js 错误:Error: [$injector:modulerr] 原因
- C#使用UdpClient发送和接收UDP数据示例
- 二叉排序和二叉查找
- log4j.properties配置详解