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

📄 query_hql.po

📁 hibernate 开源框架的代码 jar包希望大家能喜欢
💻 PO
📖 第 1 页 / 共 5 页
字号:
"can't call these queries using <literal>Query.scroll()</literal>.)"msgstr """Nota que estas dos &#x00fa;ltimas consultas requerir&#x00e1;n m&#x00e1;s de ""un <literal>SELECT</literal> SQL. Esto significa que la cl&#x00e1;usula ""<literal>order by</literal> no ordenar&#x00e1; correctamente todo el ""conjunto resultado. (Significa adem&#x00e1;s que no puedes llamar estas ""consulta usando <literal>Query.scroll()</literal>.)"#: index.docbook:400msgid "The where clause"msgstr "La cl&#x00e1;usula where"#: index.docbook:402msgid """The <literal>where</literal> clause allows you to narrow the list of ""instances returned. If no alias exists, you may refer to properties by name:"msgstr """La cl&#x00e1;usula where te permite estrechar la lista de instancias ""devueltas. Si no existe ning&#x00fa;n alias. puedes referirte a las ""propiedades por nombre:"#: index.docbook:407msgid "<![CDATA[from Cat where name='Fritz']]>"msgstr "<![CDATA[from Cat where name='Fritz']]>"#: index.docbook:409msgid "If there is an alias, use a qualified property name:"msgstr "Si existe un alias, usan un nombre cualificado de propiedad:"#: index.docbook:413msgid "<![CDATA[from Cat as cat where cat.name='Fritz']]>"msgstr "<![CDATA[from Cat as cat where cat.name='Fritz']]>"#: index.docbook:415msgid "returns instances of <literal>Cat</literal> named 'Fritz'."msgstr "devuelve las instancias de <literal>Cat</literal> llamadas 'Fritz'."#: index.docbook:419msgid """<![CDATA[select foo\n""from Foo foo, Bar bar\n""where foo.startDate = bar.date]]>"msgstr """<![CDATA[select foo \n""from Foo foo, Bar bar\n""where foo.startDate = bar.date]]>"#: index.docbook:421msgid """will return all instances of <literal>Foo</literal> for which there exists ""an instance of <literal>bar</literal> with a <literal>date</literal> ""property equal to the <literal>startDate</literal> property of the ""<literal>Foo</literal>. Compound path expressions make the <literal>where</""literal> clause extremely powerful. Consider:"msgstr """devolver&#x00e1; todas las instancias de <literal>Foo</literal> para las ""cuales exista una instancia de <literal>bar</literal> con una propiedad ""<literal>date</literal> igual a la propiedad <literal>startDate</literal> ""del <literal>Foo</literal>. Las expresiones de ruta compuestas hacen la ""cl&#x00e1;usula <literal>where</literal> extremadamente potente. Considera:"#: index.docbook:430msgid "<![CDATA[from Cat cat where cat.mate.name is not null]]>"msgstr "<![CDATA[from Cat cat where cat.mate.name is not null]]>"#: index.docbook:432msgid """This query translates to an SQL query with a table (inner) join. If you were ""to write something like"msgstr """Esta consulta se traduce en una consulta SQL con una uni&#x00f3;n de tabla ""(interna). Si fueses a escribir algo como"#: index.docbook:437msgid """<![CDATA[from Foo foo\n""where foo.bar.baz.customer.address.city is not null]]>"msgstr """<![CDATA[from Foo foo  \n""where foo.bar.baz.customer.address.city is not null]]>"#: index.docbook:439msgid """you would end up with a query that would require four table joins in SQL."msgstr """terminar&#x00ed;as con una consulta que requerir&#x00ed;a cuatro uniones de ""tablas en SQL."#: index.docbook:443msgid """The <literal>=</literal> operator may be used to compare not only ""properties, but also instances:"msgstr """El operador <literal>=</literal> puede ser usado para comparar no s&#x00f3;""lo propiedades, sino tambi&#x00e9;n instancias:"#: index.docbook:448msgid "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"msgstr "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"#: index.docbook:450msgid """<![CDATA[select cat, mate\n""from Cat cat, Cat mate\n""where cat.mate = mate]]>"msgstr """<![CDATA[select cat, mate \n""from Cat cat, Cat mate\n""where cat.mate = mate]]>"#: index.docbook:452msgid """The special property (lowercase) <literal>id</literal> may be used to ""reference the unique identifier of an object. See <xref linkend=\"queryhql-""identifier-property\"/> for more information."msgstr """La propiedad especial (en min&#x00fa;sculas) <literal>id</literal> puede ser ""usada para referenciar el identificador &#x00fa;nico de un objeto. ""(Tambi&#x00e9;n puedes usar su nombre de propiedad.)"#: index.docbook:458msgid """<![CDATA[from Cat as cat where cat.id = 123\n""\n""from Cat as cat where cat.mate.id = 69]]>"msgstr """<![CDATA[from Cat as cat where cat.id = 123\n""\n""from Cat as cat where cat.mate.id = 69]]>"#: index.docbook:460msgid "The second query is efficient. No table join is required!"msgstr """La segunda consulta es eficiente. &#x00a1;No se requiere ninguna uni&#x00f3;""n de tablas!"#: index.docbook:464msgid """Properties of composite identifiers may also be used. Suppose ""<literal>Person</literal> has a composite identifier consisting of ""<literal>country</literal> and <literal>medicareNumber</literal>. Again, see ""<xref linkend=\"queryhql-identifier-property\"/> for more information ""regarding referencing identifier properties."msgstr """Tambi&#x00e9;n pueden ser usadas las propiedades de identificadores ""compuestos. Sup&#x00f3;n que <literal>Person</literal> tiene un ""identificador compuesto consistente en <literal>country</literal> y ""<literal>medicareNumber</literal>."#: index.docbook:471msgid """<![CDATA[from bank.Person person\n""where person.id.country = 'AU'\n""    and person.id.medicareNumber = 123456]]>"msgstr """<![CDATA[from bank.Person person\n""where person.id.country = 'AU' \n""    and person.id.medicareNumber = 123456]]>"#: index.docbook:473msgid """<![CDATA[from bank.Account account\n""where account.owner.id.country = 'AU'\n""    and account.owner.id.medicareNumber = 123456]]>"msgstr """<![CDATA[from bank.Account account\n""where account.owner.id.country = 'AU' \n""    and account.owner.id.medicareNumber = 123456]]>"#: index.docbook:475msgid "Once again, the second query requires no table join."msgstr """Una vez m&#x00e1;s, la segunda consulta no requiere ninguna uni&#x00f3;n de ""tablas."#: index.docbook:479msgid """Likewise, the special property <literal>class</literal> accesses the ""discriminator value of an instance in the case of polymorphic persistence. A ""Java class name embedded in the where clause will be translated to its ""discriminator value."msgstr """Asimismo, la propiedad especial <literal>class</literal> acccede al valor ""discriminador de una instancia en el caso de persistencia polim&#x00f3;""rfica. Un nombre de clase Java embebido en la cl&#x00e1;usula where ""ser&#x00e1; traducido a su valor discriminador."#: index.docbook:485msgid "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"msgstr "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"#: index.docbook:487msgid """You may also use components or composite user types, or properties of said ""component types. See <xref linkend=\"queryhql-components\"/> for more ""details."msgstr """You may also use components or composite user types, or properties of said ""component types. See <xref linkend=\"queryhql-components\"/> for more ""details."#: index.docbook:492msgid """An \"any\" type has the special properties <literal>id</literal> and ""<literal>class</literal>, allowing us to express a join in the following way ""(where <literal>AuditLog.item</literal> is a property mapped with ""<literal>&lt;any&gt;</literal>)."msgstr """Un tipo \"any\" tiene las propiedades especiales <literal>id</literal> y ""<literal>class</literal>, permit&#x00e9;ndonos expresar un join en la ""siguiente forma (donde <literal>AuditLog.item</literal> es una propiedad ""mapeada con <literal>&lt;any&gt;</literal>)."#: index.docbook:498msgid """<![CDATA[from AuditLog log, Payment payment\n""where log.item.class = 'Payment' and log.item.id = payment.id]]>"msgstr """<![CDATA[from AuditLog log, Payment payment \n""where log.item.class = 'Payment' and log.item.id = payment.id]]>"#: index.docbook:500msgid """Notice that <literal>log.item.class</literal> and <literal>payment.class</""literal> would refer to the values of completely different database columns ""in the above query."msgstr """Nota que <literal>log.item.class</literal> y <literal>payment.class</""literal> har&#x00ed;an referencia a los valores de columnas de base de datos ""completamente diferentes en la consulta anterior."#: index.docbook:508msgid "Expressions"msgstr "Expresiones"#: index.docbook:510msgid """Expressions allowed in the <literal>where</literal> clause include most of ""the kind of things you could write in SQL:"msgstr """Las expresiones permitidas en la cl&#x00e1;usula <literal>where</literal> ""incluyen la mayor&#x00ed;a del tipo de cosas que podr&#x00ed;as escribir en ""SQL:"#: index.docbook:517msgid "mathematical operators <literal>+, -, *, /</literal>"msgstr "operadores matem&#x00e1;ticos <literal>+, -, *, /</literal>"#: index.docbook:522msgid """binary comparison operators <literal>=, &gt;=, &lt;=, &lt;&gt;, !=, like</""literal>"msgstr """operadores de comparaci&#x00f3;n binarios <literal>=, &gt;=, &lt;=, &lt;""&gt;, !=, like</literal>"#: index.docbook:527msgid "logical operations <literal>and, or, not</literal>"msgstr "operadores l&#x00f3;gicos <literal>and, or, not</literal>"#: index.docbook:532msgid "Parentheses <literal>( )</literal>, indicating grouping"msgstr "Par&#x00e9;ntesis <literal>( )</literal>, indicando agrupaci&#x00f3;n"#: index.docbook:537msgid """<literal>in</literal>, <literal>not in</literal>, <literal>between</""literal>, <literal>is null</literal>, <literal>is not null</literal>, ""<literal>is empty</literal>, <literal>is not empty</literal>, ""<literal>member of</literal> and <literal>not member of</literal>"msgstr """<literal>in</literal>, <literal>not in</literal>, <literal>between</""literal>, <literal>is null</literal>, <literal>is not null</literal>, ""<literal>is empty</literal>, <literal>is not empty</literal>, ""<literal>member of</literal> y <literal>not member of</literal>"#: index.docbook:550msgid """\"Simple\" case, <literal>case ... when ... then ... else ... end</literal>, ""and \"searched\" case, <literal>case when ... then ... else ... end</literal>"msgstr """Caso \"simple\", <literal>case ... when ... then ... else ... end</literal>, ""y caso \"buscado\", <literal>case when ... then ... else ... end</literal>"#: index.docbook:556msgid """string concatenation <literal>...||...</literal> or <literal>concat(...,...)""</literal>"msgstr """concatenaci&#x00f3;n de cadenas <literal>...||...</literal> o <literal>concat""(...,...)</literal>"#: index.docbook:561msgid """<literal>current_date()</literal>, <literal>current_time()</literal>, ""<literal>current_timestamp()</literal>"msgstr """<literal>current_date()</literal>, <literal>current_time()</literal>, ""<literal>current_timestamp()</literal>"#: index.docbook:567msgid """<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour""(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, ""<literal>year(...)</literal>,"msgstr """<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour""(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, ""<literal>year(...)</literal>,"#: index.docbook:574msgid """Any function or operator defined by EJB-QL 3.0: <literal>substring(), trim""(), lower(), upper(), length(), locate(), abs(), sqrt(), bit_length(), mod()""</literal>"msgstr """Cualquier funci&#x00f3;n u operador definido por EJB-QL 3.0: ""<literal>substring(), trim(), lower(), upper(), length(), locate(), abs(), ""sqrt(), bit_length(), mod()</literal>"#: index.docbook:580msgid "<literal>coalesce()</literal> and <literal>nullif()</literal>"msgstr "<literal>coalesce()</literal> y <literal>nullif()</literal>"#: index.docbook:585msgid """<literal>str()</literal> for converting numeric or temporal values to a ""readable string"msgstr """<literal>str()</literal> para convertir valores num&#x00e9;ricos o ""temporales a una cadena legible."#: index.docbook:591msgid """<literal>cast(... as ...)</literal>, where the second argument is the name ""of a Hibernate type, and <literal>extract(... from ...)</literal> if ANSI ""<literal>cast()</literal> and <literal>extract()</literal> is supported by ""the underlying database"msgstr """<literal>cast(... as ...)</literal>, donde el segundo argumento es el nombre ""de un tipo Hibernate , y <literal>extract(... from ...)</literal> si ""<literal>cast()</literal> y <literal>extract()</literal> fuesen soportados ""por la base de datos subyacente."#: index.docbook:599msgid """the HQL <literal>index()</literal> function, that applies to aliases of a ""joined indexed collection"msgstr """la funci&#x00f3;n <literal>index()</literal> de HQL, que se aplica a alias ""de una colecci&#x00f3;n indexada unida."#: index.docbook:605msgid """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> "

⌨️ 快捷键说明

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