存储过程可以返回结果集吗? [英] Can stored procedures return a result set?
问题描述
我有一张名为employee的表,其中包含他的ID,姓名,电话号码。我使用MySQL作为我的数据库。我正在使用Java Swing。我正在使用Java搜索员工表名称(我在Java页面中使用了,如
子句)。
I have a table named employee, which has his id, name, phone number. I am using MySQL as my database. I am using Java Swing for that. I am searching the employee table with name now using Java (I have used like
clause in my Java page).
现在我需要在存储过程中实现该功能。可能吗?如果可能的话,我们如何在Java代码中获取结果集?
Now I need to implement that function in stored procedures. Is it possible? And how can we take that resultset in Java code, if it is possible??
现在我已经编写了我的存储过程如下
Now I have written my stored procedure as follows
BEGIN
SELECT * FROM employee where empName like '%su%'
END
示例代码将受到赞赏..
谢谢
Sample code will be appreciated.. Thanks
推荐答案
首先,您应该编写msql程序,为 LIKE
发送参数,
First thing is you should write msql procedure that sends parameter for LIKE
,
CREATE PROCEDURE simpleproc (param1 CHAR(20))
BEGIN
SELECT * FROM employee where empName like param1;
END
然后从java程序中你可以使用这段代码来使用程序,
Then from java program you can use this code to use procedure,
CallableStatement cstmt = con.prepareCall("{call simpleproc(?)}");
cstmt.setString(1, "%su%");
ResultSet rs = cstmt.executeQuery();
这篇关于存储过程可以返回结果集吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!