将这个SQLXML对象设置为语句参数。
pureQuery遵从参数占位符语法规则来决定如何从带注释的方法的参数列表中声明的参数映射sql语句参数。
PureQuery follows the rules for parameter marker syntax to determine how SQL statement parameters are mapped from the declared parameters in the annotated method's parameter list.
现在,对于由于使用字面值而具有独特性的多个语句,会使用参数把它们整合为单一语句,从而提高应用程序性能。
Now, multiple statements that had each been unique due to the use of literals will be consolidated into a single statement using parameters to improve application performance.
sql语句中的参数占位符与带注释的方法中声明的参数之间可能存在一对一的映射,但是也不一定如此。
There can be, but there is not necessarily, a one-to-one mapping of parameter markers in the SQL statement to declared parameters in the annotated method.
语句可以有多个参数标记(' ? ')。
如上节所述,sql语句中的参数标记使用可促进访问计划重用。
As the previous section described, parameter marker usage in SQL statements fosters access plan reuse.
提供给预处理语句的参数不需要用引号括起来,驱动程序会处理这些。
The parameters to prepared statements don't need to be quoted; the driver handles it for you.
控制器为导入语句定义了两个参数。
The controller defines two parameters along with the import statements.
这种LDSVSAM数据集的最大尺寸将间接取决于您创建的表空间的类型和您在create语句上指定的参数。
The maximum size of such LDS VSAM datasets would depend indirectly upon the type of table space you create and the parameters you specify on the create statement.
sql语句可能包含参数标记。
利用这些函数的PASSING 子句将参数从SQL语句传递给这些函数。
The parameter is passed to these functions from the SQL statement using the PASSING clause of these functions.
清单9显示了如何定义连接参数,以便sql语句嵌套运行。
Listing 9 shows how to define the connection parameters so that the SQL statements run in-line.
但是许多打包的应用程序使用具有参数标记的动态sql语句,因此,这些参数标记的值是未知的。
However, many packaged applications use dynamic SQL statements with parameter markers and therefore the values of these parameter markers are not known.
如果您的JDBC程序使用已经准备好的语句和参数标志,并且如果在数据库语句缓存中找到了它们的话,查询过程将处理地更快。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
用户可以使用CREATETYPEMAPPING语句覆盖过程参数的默认类型映射。
The user can use the CREATE TYPE MAPPING statement to override the default type mapping for procedure parameters.
为了获得最佳性能,在load语句中指定SORTKEYS参数也很重要。
It is also important to specify the SORTKEYS parameter in the LOAD statements for maximum performance.
在构造sql语句之后,剩下的步骤就与其他具有参数标记的动态语句完全相同了。
After we compose our SQL statement, all the other steps are the same as for any dynamic statement with parameter markers.
insert语句将需要额外的参数。
Additional parameters to the INSERT statement would be needed.
验证数据:通过语句钩子可以在执行语句之前验证参数数据,从而为应用程序级的约束检查和数据验证提供机会。
Validate data: statement hooks let you validate parameter data before statement execution, providing the opportunity to do constraint check and data validation at the application level.
对于批量更新,需要使用一个集合参数多次执行一条sql语句,每次执行时使用不同的参数值。
For batch updates, a collection parameter is used vertically to execute an SQL statement more than once, with different parameter values each time.
语句集中器寻找除参数值之外完全相同的sql语句。
The statement concentrator looks for SQL statements that look exactly the same except for their parameter values.
此外,只要sql语句没有任何输入参数,jdbc批处理仅支持添加不同的sql语句到批处理中。
In addition, JDBC batching only supports adding different SQL statements to the batch as long as the SQL statements do not have any input parameters.
这种形式的批处理仅限于单个表以及同一sql语句的多个执行,前提是该语句有输入参数。
This form of batching is restricted to single tables and to multiple executions of the same SQL statement as long as the statement has input parameters.
将应用程序变量绑定到预备语句中的参数标记。
Bind application variables to parameter markers used in a prepared statement.
语句之间或函数参数之间的分隔符。
Commas, for example, can separate statements or function parameters.
使用参数标记发出sql语句。
这不包括那些被用在对象定义,数组定义,var语句,和参数列表中的逗号分隔符。
This does not apply to the comma separator, which is used in object literals, array literals, var statements, and parameter lists.
JDBC可调用语句中的命名参数。
具有参数标记的sql语句。
Data接口提供执行查询、执行SQLcall语句和返回输出参数的方法。
The data interface provides methods to execute queries, to execute SQL CALL statements, and to return their output parameters.
应用推荐