mybatis 调用 mysql 存储过程返回结果集

已采纳

存储过程：

create procedure sp_uList(uname varchar(11))

begin

  select * from  t_user where username like concat('%',uname,'%')

end;

userMapper.xml:

<select id = "uList" statementType="CALLABLE">

   {

      call sp_uList(

          #{uname,mode=IN,javaType=java.lang.String,jdbcType=VARCHAR},

          #{users,mode=OUT,javaType=ResultSet,jdbcType=CURSOR,resultMap=UserMap}

      )

}

</select>

执行时报错： java.sql.sqlexception: parameter index of 2 is out of range(1,1)
意思大概就是参数越界，我也能想到是mysql中的存储过程的写法有问题，但查了很多资料，都解决不了。
有没有人能提供 mybatis 调用mysql 中存储过程返回结果集的例子？谢谢！

点赞
写回答
关注问题
收藏
复制链接分享
邀请回答

3条回答

采纳
码龄粉丝数

被点赞

被采纳

采纳率

私信
iteye_878 9年前
procedure 写的不对，应该加一个参数，

create procedure sp_uList(uname varchar(11)， o_result out sys_refcursor)

begin
open o_result for
select * from t_user where username like concat('%',uname,'%')

end;

点赞评论复制链接分享
采纳
码龄粉丝数

被点赞

被采纳

采纳率

私信
zfu3382548 9年前
如果是sqlserver。 select 标签配置 requltMap

去掉 #{users,mode=OUT,javaType=ResultSet,jdbcType=CURSOR,resultMap=UserMap}

调用selectList也行

点赞评论复制链接分享
采纳
码龄粉丝数

被点赞

被采纳

采纳率

私信
liuyinhuan0409 9年前
你的procedure都没有out参数的：
[code="sql"]
create procedure sp_uList(uname varchar(11), out_result out sys_refcursor) as
begin
open out_result for
select * from t_user where username like concat('%', uname, '%');

end;
[/code]

点赞评论复制链接分享

提交

相关推荐

mybatis 调用 mysql 存储过程返回结果集
9年前

回答 3 已采纳存储过程： create procedure sp_uList(uname varchar(11)) begin select * from t_user where username like concat('%',uname,'%') end; userMapper.xml: <select id = "uList" statementType="CALLABLE"> { call sp_uList( #{uname,mode=IN,javaType=java.lang.String,jdbcType=VARCHAR}, #{users,mode=OUT,javaType=ResultSet,jdbcType=CURSOR,resultMap=UserMap} ) } </select> 执行时报错：  java.sql.sqlexception: parameter index of 2 is out of range(1,1) 意思大概就是参数越界，我也能想到是mysql中的存储过程的写法有问题，但查了很多资料，都解决不了。有没有人能提供 mybatis 调用mysql 中存储过程返回结果集的例子？谢谢！
mybatis调用mysql存储过程时报错 java java-ee mysql
2年前

回答 4 已采纳 {CALL pro_getChildList( #{pId,jdbcType=VARCHAR,mode=IN}, #{colName,jdbcType=VARCHAR,mode=IN}, #{colPname,jdbcType=VARCHAR,mode=IN}, #{tName,jdbcType=VARCHAR,mode=IN}, #{outColName,jdbcType=VARCHAR,mode=IN}, #{retVal,jdbcType=VARCHAR,mode=OUT}, #{userCount,jdbcType=INTEGER,mode=OUT} )} 在本机跟测试mysql 5.6.36中可以正常运行，但放到生产环境中，mysql版本为5.6.44时会抛出错误 std [0523 14:45:27 ERROR: druid.sql.Statement - {conn-10020, cstmt-20014} execute error. {CALL pro_getChildList( ?, ?, ?, ?, ?, ?, ? )} com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362) at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:908) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493) at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy224.query(Unknown Source) at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy224.query(Unknown Source) at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:60) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434) at com.sun.proxy.$Proxy38.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) at com.sun.proxy.$Proxy74.getChildDeptAndCountByParentId(Unknown Source) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl.queryChildDeptAndCountByParentId(DepartmentServiceImpl.java:846) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl$$FastClassBySpringCGLIB$$5153dd20.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:652) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl$$EnhancerBySpringCGLIB$$adbc1137.queryChildDeptAndCountByParentId() at com.alibaba.dubbo.common.bytecode.Wrapper77.invokeMethod(Wrapper77.java) at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.concom.yunzq.dubbo.BaseFilter.invoke(BaseFilter.java:85) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:70) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:132) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:113) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) std [0523 14:45:27 ERROR: com.alibaba.dubbo.rpc.filter.ExceptionFilter - [DUBBO] Got unchecked and undeclared exception which called by 172.21.4.80. service: com.concom.yunzq.service.user.IDepartmentService, method: queryChildDeptAndCountByParentId, exception: org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 ### The error may exist in file [D:\ouyang\tomcat\branch\apache-tomcat-8.5.39\webapps\METRO_YUNZQ_SERVICE_IMPL\WEB-INF\classes\config\mybatis\mappers\user\Department_mapper.xml] ### The error may involve com.concom.yunzq.impl.dao.user.DepartmentDao.callMap ### The error occurred while setting parameters ### SQL: {CALL pro_getChildList( ?, ?, ?, ?, ?, ?, ? )} ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1, dubbo version: 2.8.4, current host: 172.21.4.80 org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 ### The error may exist in file [D:\ouyang\tomcat\branch\apache-tomcat-8.5.39\webapps\METRO_YUNZQ_SERVICE_IMPL\WEB-INF\classes\config\mybatis\mappers\user\Department_mapper.xml] ### The error may involve com.concom.yunzq.impl.dao.user.DepartmentDao.callMap ### The error occurred while setting parameters ### SQL: {CALL pro_getChildList( ?, ?, ?, ?, ?, ?, ? )} ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) at com.sun.proxy.$Proxy38.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) at com.sun.proxy.$Proxy74.getChildDeptAndCountByParentId(Unknown Source) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl.queryChildDeptAndCountByParentId(DepartmentServiceImpl.java:846) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl$$FastClassBySpringCGLIB$$5153dd20.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:652) at com.concom.yunzq.impl.service.user.DepartmentServiceImpl$$EnhancerBySpringCGLIB$$adbc1137.queryChildDeptAndCountByParentId() at com.alibaba.dubbo.common.bytecode.Wrapper77.invokeMethod(Wrapper77.java) at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.concom.yunzq.dubbo.BaseFilter.invoke(BaseFilter.java:85) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:70) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:132) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:113) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362) at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:908) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493) at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy224.query(Unknown Source) at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy224.query(Unknown Source) at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:60) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434) ... 40 more
如何通过MyBatis获取mysql存储过程返回的不确定个数的多个结果集？ mysql
5年前

回答 5 已采纳（网上搜到的案例，都是固定个数的多个结果集的场景，比如这种：http://www.iteye.com/problems/78259 。**请注意，我的问题与此不同**。）我需要返回不确定个数个结果集。MySQL存储过程形如： ``` while(i > queryTop20(@Param("n") Integer n); ``` 通过如下的配置不能如愿： ``` ``` 如下配置虽然能得到想要的结果，但是这也太烂了，而且会限定n的上限： ``` ``` 请问，怎样才是通过MyBatis获取MySQL存储过程的不确定个数个结果集的正确方式？
mybatis调用mysql存储过程，得到null，求帮助 mysql
4年前

回答 2 已采纳 Dao层 ``` int instertUserWeight(@Param("_uid") Integer uid,@Param("_gid") Integer gid,@Param("_count") Long count,@Param("_result") Integer result); ``` Mapping层 ``` {CALL proc_BetWeightSave( #{_uid,mode=IN,jdbcType=INTEGER}, #{_gid,mode=IN,jdbcType=INTEGER}, #{_count,mode=IN,jdbcType=BIGINT}, #{_result,mode=OUT,jdbcType=INTEGER} )} ``` 存储过程 ![图片说明](https://img-ask.csdn.net/upload/201710/27/1509095431_190744.png) 运行结果是2 可是我用mybatis调用的时候拿到的是null attempted to return null from a method with a primitive return type (int). ** 求帮助**
Mybatis向存储过程传递参数 oracle
3年前

回答 1 已采纳存储过程需要根据部门名称相关数据修改。用varray的话估计要申请很大的空间。可不可以直接传递一个String，然后在存储过程里拆分称department\_name in('A','B','C')这样的参数
java中使用mybatis调用存储过程（存储过程返回数据集）我只想取其中的一个字段，怎么写？ maven spring jar
2年前

回答 1 已采纳 java中使用mybatis调用存储过程（存储过程返回数据集）我只想取其中的一个字段，怎么写？我的返回字段有mg_dept，energy_name，s_energy_name，target_date，sum_use_value，total_price。但我只想要sum_use_value如个地字段的值。，求各位大神指导，谢谢！如下是我的代码： {call source_select( #{mg_dept,mode=IN,jdbcType=VARCHAR}, #{energy_name,mode=IN,jdbcType=VARCHAR}, #{s_energy_name,mode=IN,jdbcType=VARCHAR}, #{target_date,mode=IN,jdbcType=VARCHAR} ) }
mybatis执行存储过程报错
6年前

回答 3 已采纳我用mybatis调用存储过程，数据已经插入数据库，但是eclipse报错:提示大概是设置参数时出错，还报空指针异常，求解![图片说明](https://img-ask.csdn.net/upload/201508/06/1438821961_112141.png) ![图片说明](https://img-ask.csdn.net/upload/201508/06/1438821968_865787.png)
mysql+mybatis sql语句返回乱码 sql sql mysql
5年前

回答 5 已采纳请教一个问题：mysql+mybatis sql 语句中用了CONCAT 方法来拼接两个时间类型的字段： ![图片说明](https://img-ask.csdn.net/upload/201611/22/1479804094_180032.jpg) ![图片说明](https://img-ask.csdn.net/upload/201611/22/1479804563_586839.jpg) 运行sql语句后效果显示正常： ![图片说明](https://img-ask.csdn.net/upload/201611/22/1479804172_816193.jpg) 但是在程序中返回的数据格式是错误的： ![图片说明](https://img-ask.csdn.net/upload/201611/22/1479804453_871112.jpg) 按说返回String类型的字段后应该没有问题的，不知为何错误
mybatis查询结果和mysql的查询结果不一样
4年前

回答 2 已采纳我只想查询userName和userAge,结果user类的所有属性都跑出来了....![![图片说明](https://img-ask.csdn.net/upload/201710/11/1507707452_948210.png)图片说明](https://img-ask.csdn.net/upload/201710/11/1507707444_946196.png)
mybatis调用过程中的SqlSessionFactory
2年前

回答 1 已采纳初学框架，请教各位大佬，SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); 创建SqlSessionFactory实例中，SqlSesssionFactoryBuilder().build(inputStream)看了下源码，返回值是new DefaultSqlSessionFactory(config)吧，此处不是已经new出了该类对象吗，然后创建实例中又new该值，不就是 (new new DefaultSqlSessionFactory(config))这样，可以new一个已经创建了的对象吗
mybatis调用mysql存储过程返回结果集
6年前

赶路人儿的博客存储过程中经常需要返回结果集。Mysql中直接用select即可返回结果集。而oracle则需要使用游标来返回结果集。这一点Mysql相对比较方便，如下代码即可实现输出结果集：存储过程定义： DELIMITER $$ DROP procedure IF EXISTS pro_sql_data1 $$ CREATE procedure pro_sql_data1(...
mybatis mysql存储过程返回值_mybatis调用mysql存储过程返回结果集
4月前

邝烁的博客存储过程中常常须要返回结果集。Mysql中直接用select就可以返回结果集。而oracle则须要使用游标来返回结果集。这一点Mysql相对照较方便。例如以下代码就可以实现输出结果集：存储过程定义：DELIMITER $$DROP procedure IF EXISTS pro_sql_data1 $$CREATE procedure pro_sql_data1(in sear_name var...
mybatis mysql存储过程返回值_MyBatis调用MySQL存储过程返回结果集
4月前

Mr pretty的博客存储过程中经常需要返回结果集。 MySQL 中直接用 select 即可返回结果集。而 Oracle 则需要使用游标来返回结果集。这一点 MySQL 相对比较方便，如下代码即可实现输出结果集：存储过程定义：DELIMITER $$DROP procedure IF EXISTS pro_sql_data1 $$CREATE procedure pro_sql_data1(in sear_name...
Mybatis调用MySQL存储过程（返回参数，单结果集，多结果集）
1年前

样young的博客一、接收一个返回值使用Map接收返回参数，output参数放在传入的param中创建表： DROP TABLE IF EXISTS `demo`; CREATE TABLE `demo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8; -...
mybatis调用mysql存储过程（返回参数，单结果集，多结果集）
3年前

阿瑟与非的博客一、接收一个返回值使用Map接收返回参数，output参数放在传入的param中创建表 DROP TABLE IF EXISTS `demo`; CREATE TABLE `demo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ...
mybatis 调用mysql存储过程_mybatis调用mysql存储过程
4月前

美界柯南的博客返回类似 select *from 的做法过程：create procedure selectAll()BEGINselect * from user;endxml配置：{call selectAll()}java配置：//service层调用List> ss = accountMapper.selectall();//DAO调用public List> selectall();Sql...
mysql执行存储过程结果集_mybatis调用mysql存储过程返回多结果集（完整）
4月前

陈昆廷的博客最近，有个开发提了个需求，希望中间件支持调用mysql存储过程时支持多结果集返回，因为某些原因我们使用了不少的存储过程，很多复杂的逻辑目前来看交互非常的多，所以从当前的现状来说，这个需求还是蛮合理的。中午抽空特地搜了下，整合完整示例如下：1、创建测试存储过程delimiter $$CREATE PROCEDURE sp_multi_resultset(IN p_operator_company_n...
mybatis调用mysql存储过程返回多个结果集_mybatis调用存储过程返回多个结果集
3月前

weixin_39809793的博客首先在resources文件下的的mapper文件下下加CarMapper.xml，代码如下：/p>PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">代码文件夹下面的IUserMapper文件下面代码如下：String ADD_USER_OWNCAR = " ...
mybatis调用mysql存储过程
4年前

mybatis调用mysql中的存储过程方法详解
mybatis 调用mysql 存储过程返回多个结果集
6年前

weixin_33739523的博客 2019独角兽企业重金招聘Python工程师标准>>> ...

bronzestar

mybatis 调用 mysql 存储过程 返回结果集

3条回答

相关推荐

mybatis 调用 mysql 存储过程返回结果集