Because listprice has a default value, it can be omitted from the CallableStatement.
由于listprice有个默认值,因此在CallableStatement中可以忽略。
After calling the SEARCH stored procedure, we can retrieve the result set from the CallableStatement.
调用SEARCH存储过程后,就可以从CallableStatement读取结果集了。
The CallableStatement interface has been updated so that you can now specify parameters by their names.
CallableStatement接口已经被更新了,现在您可以用名称来指定参数。
It then described the named parameter feature and discussed how that can be used in a CallableStatement.
然后描述了命名参数特性,并讨论了如何在CallableStatement中使用命名参数。
Listing 16 shows the code for this processing result section, in which we simply get the output parameter from the CallableStatement.
清单16显示了处理结果部分的代码,在这里我们只需要从CallableStatement中获得输出参数。
Parameters for the CallableStatement must be specified by either name or by the ordinal format within a single invocation of a routine.
在调用例程时,必须以名称或顺序格式指定CallableStatement的参数。
In this code, we get the account ID from the entity bean BankAccount, and then set the appropriate parameters on the CallableStatement.
在这些代码中,我们从实体bean BankAccount中获取帐户ID然后为CallableStatement设置适当的参数。
If the stored procedure includes any OUT parameters, it needs to be invoked from a client application using the CallableStatement interface.
如果存储过程包含OUT参数,那么就需要通过CallableStatement接口,从客户机应用程序调用该参数。
Table 1 lists the CMP EJB methods, their corresponding stored procedures, and the SQL statement to use when preparing the CallableStatement.
表1列出了CMPEJB方法、对应的存储过程以及准备CallableStatement时要用到的sql语句。
If the number of parameters in CallableStatement is less than the number of arguments in the stored procedure, the remaining arguments must have default values.
如果CallableStatement中的参数数量少于存储过程中的参数数量,那么剩下的参数必须有默认值。
As mentioned above, if a stored procedure includes OUT parameters, a client application executes the stored procedure using the CallableStatement method, as shown in Listing 9.
正如上面所提及的,如果存储过程包含OUT参数,那么客户机应用程序就会使用CallableStatement方法来执行该存储过程,如清单9所示。
For example, if a stored procedure has 10 arguments of which four have non-default values and six have default values, you must have at least four question marks in the CallableStatement.
例如,如果一个存储过程有10个参数,其中4个参数没有默认值,6个参数有默认值,那么在CallableStatement中必须至少有4个问号。
For example, if a stored procedure has 10 arguments of which four have non-default values and six have default values, you must have at least four question marks in the CallableStatement.
例如,如果一个存储过程有10个参数,其中4个参数没有默认值,6个参数有默认值,那么在CallableStatement中必须至少有4个问号。
应用推荐