⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 query_hql.po

📁 hibernate 开源框架的代码 jar包希望大家能喜欢
💻 PO
📖 第 1 页 / 共 5 页
字号:
msgstr """<literal>cast(... as ...)</literal>, onde o segundo argumento é o nome do ""tipo hibernate, e<literal>extract(... from ...)</literal> se ANSI ""<literal>cast()</literal> e <literal>extract()</literal> é suportado pele ""banco de dados usado"#. Tag: para#: query_hql.xml:599#, no-c-formatmsgid """the HQL <literal>index()</literal> function, that applies to aliases of a ""joined indexed collection"msgstr """A função HQL <literal>index()</literal> , que se aplicam a referencias de ""coleçôes associadas e indexadas"#. Tag: para#: query_hql.xml:605#, no-c-formatmsgid """HQL functions that take collection-valued path expressions: <literal>size(), ""minelement(), maxelement(), minindex(), maxindex()</literal>, along with the ""special <literal>elements()</literal> and <literal>indices</literal> ""functions which may be quantified using <literal>some, all, exists, any, in</""literal>."msgstr """As funções hql que retornam expressões de coleções de valores: <literal>size""(), minelement(), maxelement(), minindex(), maxindex()</literal>, ""<literal>junto</literal> com o elemento especial, <literal>elements()</""literal>, e funções de <literal>índice</literal> que podem ser quantificadas ""usando <literal>some, all, exists, any, in</literal>."#. Tag: para#: query_hql.xml:613#, no-c-formatmsgid """Any database-supported SQL scalar function like <literal>sign()</literal>, ""<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</""literal>"msgstr """Qualquer funçâo escalar pelo bando de dados como <literal>sign()</literal>, ""<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</""literal>"#. Tag: para#: query_hql.xml:619#, no-c-formatmsgid "JDBC-style positional parameters <literal>?</literal>"msgstr "Parametros posicionais ao estilo JDBC <literal>?</literal>"#. Tag: para#: query_hql.xml:624#, no-c-formatmsgid """named parameters <literal>:name</literal>, <literal>:start_date</literal>, ""<literal>:x1</literal>"msgstr """Parametros nomeados <literal>:name</literal>, <literal>:start_date</""literal>, <literal>:x1</literal>"#. Tag: para#: query_hql.xml:629#, no-c-formatmsgid """SQL literals <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E""+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"msgstr """Literais 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:635#, no-c-formatmsgid """Java <literal>public static final</literal> constants <literal>eg.Color.""TABBY</literal>"msgstr """Constantes Java <literal>public static final</literal><literal>ex: Color.""TABBY</literal>"#. Tag: para#: query_hql.xml:641#, no-c-formatmsgid """<literal>in</literal> and <literal>between</literal> may be used as follows:"msgstr """<literal>in</literal> e <literal>between</literal> podem ser usadas da ""seguinte maneira:"#. Tag: programlisting#: query_hql.xml:645#, no-c-formatmsgid "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"msgstr ""#. Tag: programlisting#: query_hql.xml:647#, no-c-formatmsgid """<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"msgstr ""#. Tag: para#: query_hql.xml:649#, no-c-formatmsgid "and the negated forms may be written"msgstr "e as formas negativas podem ser escritas"#. Tag: programlisting#: query_hql.xml:653#, no-c-formatmsgid "<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"msgstr ""#. Tag: programlisting#: query_hql.xml:655#, no-c-formatmsgid """<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"">"msgstr ""#. Tag: para#: query_hql.xml:657#, no-c-formatmsgid """Likewise, <literal>is null</literal> and <literal>is not null</literal> may ""be used to test for null values."msgstr """Likewise, <literal>is null</literal> and <literal>is not null</literal> may ""be used to test for null values. Assim mesmo, , <literal>is null</literal> e ""<literal>is not null</literal> podem ser usados para testar valores nulos."#. Tag: para#: query_hql.xml:662#, no-c-formatmsgid """Booleans may be easily used in expressions by declaring HQL query ""substitutions in Hibernate configuration:"msgstr """Booleanos podem ser facilmente usados em expressões, declarando as ""substituições da HQL query, na configuração do Hibernate"#. Tag: programlisting#: query_hql.xml:667#, no-c-formatmsgid """<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</""property>]]>"msgstr ""#. Tag: para#: query_hql.xml:669#, no-c-formatmsgid """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 """Isso irá substituir as palavras chave <literal>true</literal> e ""<literal>false</literal><literal>pelos</literal> literais <literal>1</""literal> e <literal>0</literal> na tradução do HQL para SQL."#. Tag: programlisting#: query_hql.xml:674#, no-c-formatmsgid "<![CDATA[from Cat cat where cat.alive = true]]>"msgstr ""#. Tag: para#: query_hql.xml:676#, no-c-formatmsgid """You may test the size of a collection with the special property ""<literal>size</literal>, or the special <literal>size()</literal> function."msgstr """Pode-se testar o tamanho de uma coleção <literal>com</literal> a propriedade ""especial <literal>size</literal>, ou a função especial <literal>size()</""literal>."#. Tag: programlisting#: query_hql.xml:681#, no-c-formatmsgid "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:683#, no-c-formatmsgid "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"msgstr ""#. Tag: para#: query_hql.xml:685#, no-c-formatmsgid """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 """Para coleções indexadas, você pode se referir aos índices máximo e mínimo, ""usando as funções <literal>minindex</literal> e <literal>maxindex</literal>. ""Similarmente, pode-se referir aos elementos máximo e mínimo de uma coleção ""de tipos básicos usando as funções <literal>minelement</literal> e ""<literal>maxelement</literal>."#. Tag: programlisting#: query_hql.xml:693#, no-c-formatmsgid """<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:695#, no-c-formatmsgid "<![CDATA[from Order order where maxindex(order.items) > 100]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:697#, no-c-formatmsgid "<![CDATA[from Order order where minelement(order.items) > 10000]]>"msgstr ""#. Tag: para#: query_hql.xml:699#, no-c-formatmsgid """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 """As funções SQL <literal>any, some, all, exists, in</literal> são suportadas ""quando passado o elemento ou o conjunto de índices de uma coleção ""(<literal>elements</literal> e <literal>indices</literal> de funções), ou o ""resultado de uma subquery (veja abaixo)."#. Tag: programlisting#: query_hql.xml:705#, no-c-formatmsgid """<![CDATA[select mother from Cat as mother, Cat as kit\n""where kit in elements(foo.kittens)]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:707#, no-c-formatmsgid """<![CDATA[select p from NameList list, Person p\n""where p.name = some elements(list.names)]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:709#, no-c-formatmsgid "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:711#, no-c-formatmsgid "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:713#, no-c-formatmsgid "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"msgstr ""#. Tag: para#: query_hql.xml:715#, no-c-formatmsgid """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 """Note que essas construções - <literal>size</literal>, <literal>elements</""literal>, <literal>indices</literal>, <literal>minindex</literal>, ""<literal>maxindex</literal>, <literal>minelement</literal>, ""<literal>maxelement</literal>– só podem ser usados na clausula where do ""Hibernate3."#. Tag: para#: query_hql.xml:722#, no-c-formatmsgid """Elements of indexed collections (arrays, lists, maps) may be referred to by ""index (in a where clause only):"msgstr """Elementos de coleções com índice (arrays, lists, maps), podem ser ""referenciadas pelo índice (apenas na clausula where):"#. Tag: programlisting#: query_hql.xml:727#, no-c-formatmsgid "<![CDATA[from Order order where order.items[0].id = 1234]]>"msgstr ""#. Tag: programlisting#: query_hql.xml:729#, no-c-formatmsgid """<![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:731#, no-c-formatmsgid """<![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:733#, no-c-formatmsgid """<![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:735#, no-c-formatmsgid """The expression inside <literal>[]</literal> may even be an arithmetic ""expression."msgstr """A expressão entre colchetes <literal>[]</literal>, pode ser até uma ""expressão aritimética."#. Tag: programlisting#: query_hql.xml:739#, no-c-formatmsgid """<![CDATA[select item from Item item, Order order\n""where order.items[ size(order.items) - 1 ] = item]]>"msgstr ""#. Tag: para#: query_hql.xml:741#, no-c-formatmsgid """HQL also provides the built-in <literal>index()</literal> function, for ""elements of a one-to-many association or collection of values."msgstr """O HQL também provê a função interna <literal>index()</literal>, para ""elementos de associação um-pra-muitos ou coleção de valores."#. Tag: programlisting#: query_hql.xml:746#, no-c-formatmsgid """<![CDATA[select item, index(item) from Order order\n""    join order.items item\n""where index(item) < 5]]>"msgstr ""#. Tag: para#: query_hql.xml:748#, no-c-formatmsgid "Scalar SQL functions supported by the underlying database may be used"msgstr "Funções escalares SQL, suportadas pelo banco de dados subjacente."#. Tag: programlisting#: query_hql.xml:752#, no-c-formatmsgid "<![CDATA[from DomesticCat cat where upper(cat.name) like 'FRI%']]>"msgstr ""#. Tag: para#: query_hql.xml:754#, no-c-formatmsgid """If you are not yet convinced by all this, think how much longer and less ""readable the following query would be in SQL:"msgstr """Se ainda ainda não está totalmente convencido, pense o quão maior e menos ""legível poderia ser a query a seguir, em SQL:"#. Tag: programlisting#: query_hql.xml:759#, no-c-formatmsgid """<![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:761#, no-c-formatmsgid "<emphasis>Hint:</emphasis> something like"msgstr "<emphasis>Hint:</emphasis> something like"#. Tag: programlisting#: query_hql.xml:765#, no-c-formatmsgid """<![CDATA[SELECT cust.name, cust.address, cust.phone, cust.id, cust."

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -