Figure 2 shows the BaseDao interface, which has been extended to support query-by-example functionality.
图2给出扩展的BaseDao接口,它支持按示例查询功能。
Another useful facility in a dynamic query API is that it can support query-by-example with relative ease.
动态查询API中的另一个有用特性就是它能够轻松地支持根据例子进行查询。
The idea of query-by-example is that instead of specifying the exact predicates for a query, a template instance is presented.
根据例子进行查询的理念使用模板实例,而不是为查询指定精确的谓词。
Query-by-example - a familiar pattern popularized by the object-database community.
根据例子进行查询—数据库社区熟悉的模式。
To see an example, create a query that returns a list department Numbers and names, filtered by their locations.
为了查看一个范例,创建一个返回部门号以及部门名,由部门所在地过滤结果的查询。
In the above example, performance of the federated query could be improved by executing all three remote legs of the UNION at the same time.
在上面的例子中,可以通过同时执行union的所有三条分支来提高联邦查询的性能。
For example, a view based on a very complex query that returns only five rows (for example, a GROUP BY query) is costly to evaluate at the remote source.
例如,基于一个非常复杂的、只返回5行的查询(例如一个GROUPBY查询)的视图在远程数据源上计算起来代价较高。
An example of such a query might be "Find all the red things", represented in the XPath language by the expression //*[@color = "Red"].
这种查询比如可以是“Findalltheredthings”,在XPath语言中可用表达式 //*[@color = "Red"] 来表示。
The lists returned can be filtered according to a Notes Formula language query, a query by example, or a view.
返回的列表可以根据Notesformula语言查询、示例查询或视图进行过滤。
The plug-in can even change the query result type by returning, for example, a group name instead of the original set of users.
该插件甚至可以通过返回组名称(而不是原始用户集)来更改查询结果类型。
If you have a long-running database query for example that's triggered by a button press, you can simply increase the time paused after the button event has been issued.
如果你有一个运行时间很长的数据库查询(比如由按钮点击所触发),那么在按钮事件产生后你可以增加延迟时间。
A few of these (smart query rewriting, for example) are available to tools that aren't backed by a database.
其中少数(如智能查询改写)可用于没有数据库支持的工具。
The client can request (query) different views by interacting with the Web page (for example, by navigating to a new page).
客户机可以通过与网页交互(例如,通过导航到新页面)请求(查询)不同的视图。
For example, some business requirements are generated by analyzing existing report query workflows and interpreting current business data analytic structures.
例如,某些业务需求是通过分析现有报表查询工作流和解释当前业务数据分析结构而生成的。
Start by generating the query using the first aggregation function (SUM in the example) in the measure's list of aggregations to aggregate the template expression.
先使用度量的聚合列表中的第一个聚合函数(在这个示例中是SUM)对表达式模板进行聚合,产生一个查询。
Our next example, shown in Figure 2, is a query with an ORDER BY clause using the code below.
我们的下一个例子,如图2所示,是一个含有ORDERBY子句的查询,它使用了下面的代码。
For example, you can minimize the rows read by having predicates in the query that can determine the needed rows from just the index alone.
例如,您可以通过把可以仅从索引就确定需要的行的谓词放到查询中来将行读取降到最低。
However, every time the user asked for a system refresh by sorting her tasks by due date, for example, the portal application had to issue a new query to WPS to repopulate the task list.
不过,每次用户要求系统刷新(例如,按照结束日期对任务进行排序)时,门户应用程序必须向WPS 发送新查询,以重新填充任务列表。
For example, when you apply one of the standard templates to administer your change management processes, all team members can by default query all records in the database.
举例来说,当你应用其中一个标准模板来管理你的变更管理过程时,所有的团队成员缺省可以查询数据库中的所有记录。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
例如,只需在列出监控表函数返回的应用程序数据的查询中添加where子句,就可以搜索CPU消耗量最大的应用程序。
For example, if you build an application to sell video tapes, you might expect a user to query for all the videos that have a certain keyword in the title and that were directed by a given person.
例如,如果构建一个用于销售录像带的应用程序,您可能预期用户会查询标题中包含某个关键字并且由某个导演执导的所有视频。
One example is Google's search engine, which is partly guided by the number of clicks on an item to help determine its relevance to a search query.
其中一个例子是谷歌的搜索引擎,该引擎部分根据一个对象被点击的次数来帮助决定该对象对搜寻的相关度。
For example, if you group only by publisher, you cannot also display individual titles in the query.
例如,如果仅按出版商分组,则也无法在查询中显示单个书名。
This means you need to first process a query result completely before reusing a JDBC Statement — for example, by reissuing a database query — or you will lose any results from the previous query.
这意味着您必须先处理完查询结果,然后再重用JDBCStatement——例如,重新发出数据库查询——否则将丢失上一次查询到的所有结果。
Consider an example where a DBA knows the problem is a poor-performing query, but that query was generated by a framework, using an object-relational mapping technology.
考虑这样一个示例:DBA知道问题根源是查询的性能较差,但此查询是由框架生成的,使用了对象关系映射技术。
Provides an example of how to order the results of a query by using LINQ.
提供有关如何使用LINQ 对查询结果进行排序的示例。
For example, Figure 10 shows the query result of "Employee by position-department" by using the "Test Sample" button when no filter was set for this query Subject.
例如,图10显示没有对这个Query Subject设置过滤器时,使用“TestSample”按钮进行的“Employee byposition - department”查询的结果。
For example, the following query returns a result by limiting search to the document part identified by name "description" in the document model of Figure 5.
例如,以下查询将搜索限制到图5的文档模型中名称“description”所标识的文档部分,从而返回一个结果。
For example the context will be built using who the query was executed by, which cube was queried, which particular year was used for filtering, etc.
例如,使用执行查询的主体、查询了哪个多维数据集、特别使用了哪一年进行过滤等来构建上下文。
For example, you can get a count out of the database for the number of respondents who have stated that their favorite color (question 2) is red by using the following query shown in Listing 10.
例如,使用下面的清单10中的查询,您可以从数据库中查询最喜欢的颜色是红色(问题2)的回答者的数目。
应用推荐