Query the database using SQL/XML
使用SQL/XML查询数据库
The data Access Object got several finder methods to query the database.
数据访问对象(Data Access Object)有一些搜索方法以查询数据库。
It's very easy to query the database and to throw the results up on a web page.
它很容易就能查询数据库,并把结果在一个网页。
Query by criteria: Query the database by creating a criteria object and setting its properties.
Querybycriteria:通过创建criteria对象查询数据库。
First we query the database to get a row set of all the items that match the selected category.
首先查询数据库以获取与所选种类匹配的所有货品的行集。
The PHP code to query the database for the files associated with a particular user is shown below.
用于在数据库中查询与某个特定用户相关联的文件的PHP代码如下所示。
For example, a database connection component may choose not to query the database at design time.
例如,数据库连接组件可能不会选择在设计时查询数据库。
Using Flashback query, you can query the database as it existed this morning, yesterday, or last week.
利用回闪查询,用户可以查看数据库今天早晨,昨天甚至上星期的状态。
CEI does not provide a direct access to the event database but it does provide the APIs to query the database.
CEI没有提供直接访问数据库的事件,但它提供了API用来查询数据库。
Listing 3 contains this function, which attempts to open the database (if not already opened) and query the database.
清单3包含有这个函数,它尝试打开数据库(如果尚未打开的话)并查询数据库。
The simplest solution is to query the database for the number of outstanding requests and to serve this in a controller.
最简单的方法是查询数据库中未完成的请求数量,并将查询放到一个控制器中进行。
Users can query the database with keyword or browse the database in the way of chromosome or gene symbol or behavior trait.
在数据库查询方面,提供关键词查询方式、染色体浏览查询方式、基因列表浏览查询方式和行为特征分类浏览查询方式。
The customer ID is also extracted from the message and is used to query the database for information on the items purchased by the customer.
再次从消息中提取出客户ID,并用它在数据库中查询这位客户购买的商品的相关信息。
This way you can query the database, directly producing XML, and use XSLT to transform the returned data directly into KML that you can overlay on a map.
采用该方法,您可以查询数据库,直接生成xml,并使用XSLT将返回的数据直接转换为可以在地图上覆盖的KML。
Query by example: Query the database by creating a sample object of the type you want to retrieve and setting its properties to specify selection criteria.
Querybyexample:通过创建一个你想要遍历类型的对象,设置它的属性来指定某个criteria来查询数据库。
For example, the controller handles query-string values, and passes these values to the model, which in turn might use these values to query the database.
例如,控制器处理查询字符串值,并将这些值传递给模型,而模型可能会使用这些值来查询数据库。
A key feature of applications such as ClearQuest and ClearCase is the strong query capabilities. It is possible, for example, to query the database to determine.
像ClearQuestand ClearCase这样的程序的关键特性,是它具有很强的查询功能。
Now test that the NIS connection is active by using ypcat to query the database directly. For example, to get a dump of the NIS passwd file ordered by name, you would use.
现在通过使用ypcat直接查询数据库,以确定NIS连接为活动状态。
For example: Portlet will query the database for the current program and display a list of names, geographical locations, and point scores for the top 10 highest point values.
例如:Portlet将查询当前程序的数据库,并显示名称、地理位置列表,以及分值最高的前十位的得分。
If the practitioner enters a message containing the pattern, the client is triggered to query the database for HL7 CDA XML documents for the particular patient (3 in Figure 3).
如果从业人员输入一条包含此模式的消息,就会触发客户机在数据库中查询特定患者的HL7CDAXML文档(图3中的3)。
The second way you use location is when the web page makes a request to the browser to get the location of the user and then uses that information to query the database using Ajax.
使用定位的第二种方法是当Web页面向浏览器发送请求以获得用户的位置时,使用该信息用 Ajax查询数据库。
Although the query looks simpler than the XQuery, we must query the database for each item in the cart, resulting in increased database traffic and slightly more loop-oriented application code.
虽然查询看起来比XQuery简单,但我们必须为购物车中的每个货品查询数据库,导致数据库流量增加,应用程序代码有些更面向循环。
Here, we make one query to the database to get all the rows.
这里,我们对数据库进行一次查询,以获得所有的行。
Establishes a connection with the support database and provides access methods to query and update the database.
建立一个到支持数据库的连接,提供一些访问方法来查询和更新数据库。
The initial idea was to develop custom code that would query the Browse database directly for a random author name.
最初的想法是开发能够由随机作者名称直接查询浏览数据库的定制代码。
The implementation of advanced query statistics is based on the query log database technology.
高级查询统计的实现是基于查询日志数据库技术。
This activity sends a query to the database and returns none, one or more account datasets depending on the query.
该活动会向数据库发送一条查询,该查询会返回零个、一个或多个账户数据集合。
Each time the query is made, the database must do the same work — parse the query, determine how to execute it, load information from disk, and return it to the client.
每次执行查询时,数据库都必须要执行相同的工作——对查询进行分析,确定如何执行查询,从磁盘中加载信息,然后将结果返回给客户机。
When you use query over collection, your query can be executed against existing result sets without the need to re-evaluate the query in the database and re-fetch all the data into your application.
当在集合上使用查询时,可直接在已有的结果集上执行查询,而不必重新在数据库中执行查询,然后重新将所有数据取出到应用程序中。
When the query is prepared, the database will analyze, compile and optimize it's plan for executing the query.
当查询准备好后,数据库将分析、编译和优化执行该查询的计划。
应用推荐