private CallableStatement cstm = null;

最新推荐文章于 2024-10-29 14:51:36 发布

转载最新推荐文章于 2024-10-29 14:51:36 发布 · 481 阅读

本文探讨了用于执行SQL存储过程的接口及其在不同RDBMS中的通用语法，包括参数类型、设置值的方法以及返回结果的方式。重点介绍了如何通过JDBC API调用存储过程，并在执行前后处理结果集和更新计数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

The interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.

   {?= call <procedure-name>[<arg1>,<arg2>, ...]}
   {call <procedure-name>[<arg1>,<arg2>, ...]}

IN parameter values are set using the set methods inherited from PreparedStatement. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get methods provided here.

A CallableStatement can return one ResultSet object or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from Statement.

For maximum portability, a call's ResultSet objects and update counts should be processed prior to getting the values of output parameters.