查询语句不会检查输入是否有效。
清单10展示了初始查询语句及其优化版本。
Listing 10 shows shows the original query statement and its optimized version.
在您测试编排之前,需要修改数据库查询语句。
Before you can test the orchestration, you have to adjust the database query.
SQL查询最重要的元素是查询语句。
The most important element of the SQL query is the Select statement. The rules for Select statements are as follows.
在这种情况下,使用自己指定的查询语句并填充才是明智之举。
In this particular situation, it makes sense for you to use the same table and fill it with a more specific query.
攻击者将其恶意输入注入到sql语句中,以修改查询语句的逻辑。
The attacker injects his malicious inputs to the SQL statement to change the query's logic.
要根据前面创建的XML的关系视图创建报告,输入下面的查询语句。
To create a report based on the relational view of the XML created previously, enter the following query statement.
通常,需要从一组已有的数据库查询语句(SQL)实现应用程序构建。
It is often the case that the process of building an application originates from having a set of database query statements (i.e. SQL).
上面的查询语句返回与tax1120view视图所含内容相同的信息。
The query statement above returns the same information as contained in the TAX1120VIEW view.
就像你看到的,上面的代码用三段字串组成了一个完整的SQL查询语句。
As you can see, the above code combines three tokens to generate a complete SQL query.
最后,配置连接器,编写一个SQL查询语句来将客房预订信息提交给数据库。
Finally, configure a connector and write an SQL query to submit the room-booking information to the database.
如下例所示,在此情况下,查询语句获得用户的名称和电子邮件地址。
In this scenario a query gets the name and e-email address from a user, as in the following example.
如您所见,黑客将恶意代码作为其userid输入,修改了查询语句的逻辑。
As you can see, the hacker changes the query's logic by entering the malicious code as his userid.
where和其他表达查询的操作数并不会真正引起查询语句被执行。
Where and other operands that express the query do not actually cause the query to execute.
任何熟悉sql的人都不会反对这很简单。剩下的就是这些代码了。先看看查询语句。
For the rest of us, here's the code that does the trick. First, the query.
可以全限定每个对象引用的名称,这能完全避免你的查询语句中存在的二义性。
Fully qualify Name; this will fully qualify each object reference, this disambiguates the your query statements completely.
当出现提示时,您可以直接键入查询语句或者使用向导帮助您创建一个查询语句。
When prompted, you can type in your query statement directly or use the wizards to help you create one.
“如果我单独分析每个查询语句,我将需要数百次分析和调优过程,而不是一次,”他说。
“If we analyzed each query statement individually, it would require hundreds of analysis and tuning procedures, versus one,” he says.
CommandEditor提供了体验各种查询语句并且可以立刻查看结果的简单方法。
The Command Editor provides a simple way to experiment with various query statements and see the results right away.
下一部分将介绍weblogic-ql元素到 ejb-ql 元素的查询语句映射。
The next sections show the mapping of query statements from weblogic-ql element to ejb-ql element.
这通过在 WHERE 语句中使用一个 cmp 字段来输入有效的EJBQL查询语句。
This will enter a valid EJBQL query with one cmp-field used in the WHERE predicate.
这是Coldfusion中使用的标签,用于将查询语句或sql语句传递给数据源。
This is the tag used in Coldfusion to pass queries or SQL statements to the data source.
在本例中,我们使用XRT表示法,它是将查询语句与XSL转换捆绑在一起的XSL的松散扩充。
In our example, we use the XRT notation, which is a loose extension of XSL that ties together query statements with an XSL transformation.
“数据表查询向导”对话框可以帮助你构造你自己的查询语句,之后数据表会被新数据更新。
The "DbTable query Wizard" dialog opens to help you construct your query, after which the table is updated with the new data.
这时就需要基于已有的查询语句生成对象层次,这些查询语句又可用于构建底层的应用程序。
This is when object hierarchies need to be created based on existing query statements, which in turn can be used to build the underlying application.
查询工具是数据库管理器的一个辅助工具,它作用就是定义一条符合SQL标准的查询语句。
The query tool is an assistant tool of the database manager, and it can define a query sentence accord with SQL standard.
如果该选择没被选中,那么JPQL查询语句将在JPAManagerBean代码中直接使用。
If this option is unchecked, the JPQL query statements will be used directly inside of the JPA Manager Bean code.
在多个查询语句的执行过程中需要保持数据库连接,否则会抛出一个延迟加载异常,这将导致数据出现问题。
Database connection needs to be maintained for the duration of the multiple query cycle else a lazy loading exception is thrown, resulting in inadequate use of resources.
其它的最佳实践还包括检查生成的SQL,这会使我们更深入了解orm工具生成的SQL查询语句。
Other best practices include evaluating generated SQL which gives a good insight into the SQL queries generated by the ORM tool.
其它的最佳实践还包括检查生成的SQL,这会使我们更深入了解orm工具生成的SQL查询语句。
Other best practices include evaluating generated SQL which gives a good insight into the SQL queries generated by the ORM tool.
应用推荐