I'm new to using jdbc to execute mysql stored procedures. My question is that is it possible to call an stored procedure which returns a table in jdbc? I searched a lot and I know I can return a certain number of parameters using registerOutParameter using procedures, but how about a whole table with several rows?!
我是新手使用jdbc来执行mysql存储过程。我的问题是,是否可以调用一个在jdbc中返回表的存储过程?我搜索了很多,我知道我可以使用registerOutParameter使用程序返回一定数量的参数,但是有几行的整个表怎么样?!
I hope it's not a redundant post.
我希望这不是一个多余的帖子。
1 个解决方案
#1
1
Yes. It's possible to call a MySQL stored procedure to return a resultset using JDBC.
是。可以使用JDBC调用MySQL存储过程来返回结果集。
Examples provided here:
这里提供的示例:
https://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#calling_javadb_mysql
#1
1
Yes. It's possible to call a MySQL stored procedure to return a resultset using JDBC.
是。可以使用JDBC调用MySQL存储过程来返回结果集。
Examples provided here:
这里提供的示例:
https://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#calling_javadb_mysql