结合使用准备好的语句和游标。
参数的当前值在[3]中绑定到准备好的语句。
The current value of the parameter is bound to the prepared statement at [3].
您可以创建并执行准备好的语句，或创建并运行外部脚本。
You can create and execute prepared statements or create and run external scripts.
通常您不会联系到命令行的另外一项任务就是使用准备好的语句。
Another task you don't normally associate with the command line is the use of prepared statements.
您甚至可以创建与多个数据集一起使用的准备好的语句(参见清单8)。
You can even create prepared statements that can be used with multiple sets of data (see Listing 8).
或许最有用的准备好的语句不仅可以获取输入值，而且还可以对游标的当前行进行操作。
Perhaps the most useful prepared statements are those that not only take input values, but also operate on the current row of a cursor.
准备好的语句可重新编译，从而获得更好的性能，在您反复执行同一操作时，它非常方便。
Prepared statements are recompiled for better performance and are convenient when you need to do the same thing over and over again.
与JDBC应用程序中的准备好的语句一样，值可以按在语句中出现的顺序被各占位符取代。
As with prepared statements in a JDBC application, the values get substituted for each placeholder in order of appearance in the statement.
关键是准备好的语句中的sql语句会引用游标的当前位置，所以您可以多次执行它，并更新不同的行。
The key is that the SQL statement in the prepared statement references the current position of the cursor, so you can execute it multiple times and update different rows.
就是说如果sql语句要执行多次，开发人员应该只准备该语句一次，在以后的执行中重用准备好的语句。
It means that when an SQL statement is going to be executed more than once, the developer should prepare the statement just once and then reuse the prepared statements for consecutive executions.
ij使您能够执行许多您原本认为只有使用完备的JDBC应用程序才能完成的任务，如操纵游标和创建并执行准备好的语句。
Ij enables you to do many of the same tasks you might think you can only accomplish using a full-fledged JDBC application, such as manipulating cursors and creating and executing prepared statements.
如果您的JDBC程序使用已经准备好的语句和参数标志，并且如果在数据库语句缓存中找到了它们的话，查询过程将处理地更快。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
您可以通过使用 odbc_prepare()在单独的步骤中准备这条语句，并通过多次调用 odbc_execute()执行准备好的语句，从而提高应用程序的性能。
You can improve the performance of your application by preparing the statement in a separate step with odbc_prepare() and executing that prepared statement by calling odbc_execute() multiple times.
insert语句像平常一样准备好了，它的四个参数标志符也设置好了。
The INSERT statement is prepared as usual, and its four parameter markers are set.
insert语句像平常一样准备好了，它的四个参数标志符也设置好了。
The INSERT statement is prepared as usual, and its four parameter markers are set.
应用推荐