存储过程可以返回结果集吗？ [英] 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屋！