Note: This step is similar to creating a parameterized query in SQL.
注意:这一步类似于用SQL创建参数化查询。
A parameterized query binds the value of the parameter before the query execution.
参数化查询在查询执行之前绑定参数的值。
A parameterized query also takes a variable number of arguments as its binding parameters.
一个带参数的查询也可以将一组数量不定的参数作为它的绑定参数。
All of these can be condensed into a single parameterized query (also known as a prepared statement), as shown in Listing 2.
所有这些查询可以简化为一个参数化查询(也称为一个预准备语句),如清单2所示。
A typical parameterized query USES these parameters instead of literal values, so that WHERE clause conditions can be changed at run time.
典型的参数化查询使用这些参数来代替文字值,因此where子句条件可以在运行时更改。
Select a new or existing parameterized query.
选取新的或现有的参数型查询。
Instead, use a parameterized query and assign user input to parameter objects.
相反,使用参数化查询并将用户输入分配给参数对象。
A parameterized query returns data that meets the conditions of a WHERE clause within the query.
参数化查询将返回满足查询内的where子句条件的数据。
Data Driven Queries must specify the text of the parameterized query and identify any columns (in the associated columns collection) needed to fill in the parameters.
数据驱动的查询必须指定参数化查询的文本并识别任何需要填写参数的列(在相关的列集合中)。
Data Driven Queries must specify the text of the parameterized query and identify any columns (in the associated columns collection) needed to fill in the parameters.
数据驱动的查询必须指定参数化查询的文本并识别任何需要填写参数的列(在相关的列集合中)。
应用推荐