query_hql.po

hibernate-distribution-3.3.1.GA-dist.zip源码

"Any database-supported SQL scalar function like <literal>sign()</literal>, "
"<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</"
"literal>"
msgstr ""
"任何数据库支持的SQL标量函数，比如<literal>sign()</literal>, <literal>trunc()"
"</literal>, <literal>rtrim()</literal>, <literal>sin()</literal>"

#. Tag: para
#: query_hql.xml:643
#, no-c-format
msgid "JDBC-style positional parameters <literal>?</literal>"
msgstr "JDBC风格的参数传入 <literal>?</literal>"

#. Tag: para
#: query_hql.xml:648
#, no-c-format
msgid ""
"named parameters <literal>:name</literal>, <literal>:start_date</literal>, "
"<literal>:x1</literal>"
msgstr ""
"命名参数<literal>:name</literal>, <literal>:start_date</literal>, <literal>:"
"x1</literal>"

#. Tag: para
#: query_hql.xml:653
#, no-c-format
msgid ""
"SQL literals <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"
msgstr ""
"SQL 直接常量 <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"

#. Tag: para
#: query_hql.xml:659
#, no-c-format
msgid ""
"Java <literal>public static final</literal> constants <literal>eg.Color."
"TABBY</literal>"
msgstr ""
"Java <literal>public static final</literal> 类型的常量 <literal>eg.Color."
"TABBY</literal>"

#. Tag: para
#: query_hql.xml:665
#, no-c-format
msgid ""
"<literal>in</literal> and <literal>between</literal> may be used as follows:"
msgstr ""
"关键字<literal>in</literal>与<literal>between</literal>可按如下方法使用:"

#. Tag: programlisting
#: query_hql.xml:669
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:671
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:673
#, no-c-format
msgid "and the negated forms may be written"
msgstr "而且否定的格式也可以如下书写："

#. Tag: programlisting
#: query_hql.xml:677
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:679
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"
">"
msgstr ""

#. Tag: para
#: query_hql.xml:681
#, no-c-format
msgid ""
"Likewise, <literal>is null</literal> and <literal>is not null</literal> may "
"be used to test for null values."
msgstr ""
"同样, 子句<literal>is null</literal>与<literal>is not null</literal>可以被用"
"来测试空值(null)."

#. Tag: para
#: query_hql.xml:686
#, no-c-format
msgid ""
"Booleans may be easily used in expressions by declaring HQL query "
"substitutions in Hibernate configuration:"
msgstr ""
"在Hibernate配置文件中声明HQL“查询替代（query substitutions）”之后， 布尔表达"
"式（Booleans）可以在其他表达式中轻松的使用:"

#. Tag: programlisting
#: query_hql.xml:691
#, no-c-format
msgid ""
"<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</"
"property>]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:693
#, no-c-format
msgid ""
"This will replace the keywords <literal>true</literal> and <literal>false</"
"literal> with the literals <literal>1</literal> and <literal>0</literal> in "
"the translated SQL from this HQL:"
msgstr ""
"系统将该HQL转换为SQL语句时，该设置表明将用字符 <literal>1</literal> 和 "
"<literal>0</literal> 来 取代关键字<literal>true</literal> 和 <literal>false</"
"literal>:"

#. Tag: programlisting
#: query_hql.xml:698
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.alive = true]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:700
#, no-c-format
msgid ""
"You may test the size of a collection with the special property "
"<literal>size</literal>, or the special <literal>size()</literal> function."
msgstr ""
"你可以用特殊属性<literal>size</literal>, 或是特殊函数<literal>size()</"
"literal>测试一个集合的大小。"

#. Tag: programlisting
#: query_hql.xml:705
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:707
#, no-c-format
msgid "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:709
#, no-c-format
msgid ""
"For indexed collections, you may refer to the minimum and maximum indices "
"using <literal>minindex</literal> and <literal>maxindex</literal> functions. "
"Similarly, you may refer to the minimum and maximum elements of a collection "
"of basic type using the <literal>minelement</literal> and "
"<literal>maxelement</literal> functions."
msgstr ""
"对于索引了（有序）的集合，你可以使用<literal>minindex</literal> 与 "
"<literal>maxindex</literal>函数来引用到最小与最大的索引序数。 同理，你可以使"
"用<literal>minelement</literal> 与 <literal>maxelement</literal>函数来 引用到"
"一个基本数据类型的集合中最小与最大的元素。"

#. Tag: programlisting
#: query_hql.xml:717
#, no-c-format
msgid ""
"<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:719
#, no-c-format
msgid "<![CDATA[from Order order where maxindex(order.items) > 100]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:721
#, no-c-format
msgid "<![CDATA[from Order order where minelement(order.items) > 10000]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:723
#, no-c-format
msgid ""
"The SQL functions <literal>any, some, all, exists, in</literal> are "
"supported when passed the element or index set of a collection "
"(<literal>elements</literal> and <literal>indices</literal> functions) or "
"the result of a subquery (see below)."
msgstr ""
"在传递一个集合的索引集或者是元素集(<literal>elements</literal>与"
"<literal>indices</literal> 函数) 或者传递一个子查询的结果的时候，可以使用SQL"
"函数<literal>any, some, all, exists, in</literal>"

#. Tag: programlisting
#: query_hql.xml:729
#, no-c-format
msgid ""
"<![CDATA[select mother from Cat as mother, Cat as kit\n"
"where kit in elements(foo.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:731
#, no-c-format
msgid ""
"<![CDATA[select p from NameList list, Person p\n"
"where p.name = some elements(list.names)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:733
#, no-c-format
msgid "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:735
#, no-c-format
msgid "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:737
#, no-c-format
msgid "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:739
#, no-c-format
msgid ""
"Note that these constructs - <literal>size</literal>, <literal>elements</"
"literal>, <literal>indices</literal>, <literal>minindex</literal>, "
"<literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - may only be used in the where clause in "
"Hibernate3."
msgstr ""
"注意，在Hibernate3种，这些结构变量- <literal>size</literal>, "
"<literal>elements</literal>, <literal>indices</literal>, <literal>minindex</"
"literal>, <literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - 只能在where子句中使用。"

#. Tag: para
#: query_hql.xml:746
#, no-c-format
msgid ""
"Elements of indexed collections (arrays, lists, maps) may be referred to by "
"index (in a where clause only):"
msgstr ""
"一个被索引过的（有序的）集合的元素(arrays, lists, maps)可以在其他索引中被引用"
"（只能在where子句中）："

#. Tag: programlisting
#: query_hql.xml:751
#, no-c-format
msgid "<![CDATA[from Order order where order.items[0].id = 1234]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:753
#, no-c-format
msgid ""
"<![CDATA[select person from Person person, Calendar calendar\n"
"where calendar.holidays['national day'] = person.birthDay\n"
"    and person.nationality.calendar = calendar]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:755
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ order.deliveredItemIndices[0] ] = item and order.id = 11]]"
">"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:757
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ maxindex(order.items) ] = item and order.id = 11]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:759
#, no-c-format
msgid ""
"The expression inside <literal>[]</literal> may even be an arithmetic "
"expression."
msgstr "在<literal>[]</literal>中的表达式甚至可以是一个算数表达式。"

#. Tag: programlisting
#: query_hql.xml:763
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ size(order.items) - 1 ] = item]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:765
#, no-c-format
msgid ""
"HQL also provides the built-in <literal>index()</literal> function, for "
"elements of a one-to-many association or collection of values."
msgstr ""
"对于一个一对多的关联（one-to-many association）或是值的集合中的元素， HQL也提"
"供内建的<literal>index()</literal>函数，"

#. Tag: programlisting
#: query_hql.xml:770
#, no-c-format
msgid ""
"<![CDATA[select item, index(item) from Order order\n"
"    join order.items item\n"
"where index(item) < 5]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:772
#, no-c-format
msgid "Scalar SQL functions supported by the underlying database may be used"
msgstr "如果底层数据库支持标量的SQL函数，它们也可以被使用"

#. Tag: programlisting
#: query_hql.xml:776
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where upper(cat.name) like 'FRI%']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:778
#, no-c-format
msgid ""
"If you are not yet convinced by all this, think how much longer and less "
"readable the following query would be in SQL:"
msgstr ""
"如果你还不能对所有的这些深信不疑，想想下面的查询。如果使用SQL，语句长度会增长"
"多少，可读性会下降多少："

#. Tag: programlisting
#: query_hql.xml:783
#, no-c-format
msgid ""
"<![CDATA[select cust\n"
"from Product prod,\n"
"    Store store\n"
"    inner join store.customers cust\n"
"where prod.name = 'widget'\n"
"    and store.location.name in ( 'Melbourne', 'Sydney' )\n"
"    and prod = all elements(cust.currentOrder.lineItems)]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:785
#, no-c-format
msgid "<emphasis>Hint:</emphasis> something like"
msgstr "<emphasis>提示:</emphasis> 会像如下的语句"

#. Tag: programlisting
#: query_hql.xml:789
#, no-c-format
msgid ""
"<![CDATA[SELECT cust.name, cust.address, cust.phone, cust.id, cust."
"current_order\n"
"FROM customers cust,\n"
"    stores store,\n"
"    locations loc,\n"
"    store_customers sc,\n"
"    product prod\n"
"WHERE prod.name = 'widget'\n"
"    AND store.loc_id = loc.id\n"
"    AND loc.name IN ( 'Melbourne', 'Sydney' )\n"
"    AND sc.store_id = store.id\n"
"    AND sc.cust_id = cust.id\n"
"    AND prod.id = ALL(\n"
"        SELECT item.prod_id\n"
"        FROM line_items item, orders o\n"
"        WHERE item.order_id = o.id\n"
"            AND cust.current_order = o.id\n"
"    )]]>"
msgstr ""

#. Tag: title
#: query_hql.xml:794
#, no-c-format
msgid "The order by clause"
msgstr "order by子句"

#. Tag: para
#: query_hql.xml:796
#, no-c-format
msgid ""
"The list returned by a query may be ordered by any property of a returned "
"class or components:"
msgstr ""
"查询返回的列表(list)可以按照一个返回的类或组件（components)中的任何属性"
"（property）进行排序："

#. Tag: programlisting