📄 jr - 精品文章 - hibernatehql-qbc查询语言比较的用法（1）.mht
字号:
href=3D"http://www.javaresearch.org/index.jsp">=CA=D7=D2=B3</A> » =
<A=20
=
href=3D"http://www.javaresearch.org/article/index.jsp">=D1=D0=BE=BF=CE=C4=
=BC=AF</A>=20
» <A=20
=
href=3D"http://www.javaresearch.org/article/column.jsp?column=3D108">=CA=FD=
=BE=DD=BF=E2=CF=E0=B9=D8</A>=20
</B></TD>
<TD align=3Dright width=3D"70%"><A=20
=
href=3D"http://www.javaresearch.org/search?inurl=3Darticle%2Fshowarticle.=
jsp&noencode=3Dtrue&searchType=3Dcustom&num=3D30&queryWor=
ds=3Dhibernate+%E8%AF%AD%E8%A8%80+%E6%AF%94%E8%BE%83+"=20
target=3D_blank><IMG height=3D17 =
alt=3D=CB=D1=CB=F7=B1=EA=CC=E2=CF=E0=B9=D8=CE=C4=D5=C2=20
src=3D"http://www.javaresearch.org/images/search.gif" =
width=3D17=20
border=3D0> </A><A=20
=
href=3D"http://www.javaresearch.org/search?inurl=3Darticle%2Fshowarticle.=
jsp&noencode=3Dtrue&searchType=3Dcustom&num=3D30&queryWor=
ds=3Dhibernate+%E8%AF%AD%E8%A8%80+%E6%AF%94%E8%BE%83+"=20
=
target=3D_blank>=CB=D1=CB=F7=B1=EA=CC=E2=CF=E0=B9=D8=CE=C4=D5=C2</A> =
; <A=20
=
href=3D"http://www.javaresearch.org/article/postarticle.jsp?column=3D108&=
amp;thread=3D43505&reply=3Dtrue"><IMG=20
height=3D17 alt=3D=C6=C0=C2=DB=B4=CB=CE=C4=D5=C2=20
src=3D"http://www.javaresearch.org/images/reply.gif" =
width=3D17=20
border=3D0></A> <A class=3Dtitle=20
title=3D"Click to reply to this topic"=20
=
href=3D"http://www.javaresearch.org/article/postarticle.jsp?column=3D108&=
amp;thread=3D43505&reply=3Dtrue">=B7=A2=B1=ED=C6=C0=C2=DB</A>=20
<!--
<a href=3D"/search.jsp?column=3D108"><img =
src=3D"/images/search.gif" width=3D"17" height=3D"17" =
alt=3D"=CB=D1=CB=F7=C0=B8=C4=BF" border=3D"0"></a> <a =
href=3D"/search.jsp?column=3D108" class=3D"title" =
title=3D"=CB=D1=CB=F7=C0=B8=C4=BF">=CB=D1=CB=F7=CE=C4=D5=C2</a> =
--></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%" =
border=3D0>
<TBODY>
<TR>
<TD><!-- start of article title -->
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"=20
bgColor=3D#ffffff border=3D0>
<TBODY>
<TR>
<TD class=3Dtitle1 align=3Dmiddle width=3D"100%" =
bgColor=3D#eeeeee=20
colSpan=3D3=20
=
height=3D40><B>Hibernate:HQL/QBC=B2=E9=D1=AF=D3=EF=D1=D4=B1=C8=BD=CF=B5=C4=
=D3=C3=B7=A8=A3=A81=A3=A9</B></TD></TR>
<TR>
<TD align=3Dmiddle width=3D"100%" =
bgColor=3D#eeeeee><A=20
=
href=3D"http://www.javaresearch.org/profile.jsp?user=3D100789">cucumalo</=
A>=20
=D4=AD=B4=B4 =
(=B2=CE=D3=EB=B7=D6=A3=BA4687=A3=AC=D7=A8=BC=D2=B7=D6=A3=BA490) &nbs=
p; =B7=A2=B1=ED=A3=BA2005-12-16=20
14:52 =B0=E6=B1=BE=A3=BA1.0 =
=D4=C4=B6=C1=A3=BA<B>456</B>=B4=CE=20
</TD></TR></TBODY></TABLE></TD></TR><!-- end of =
article title -->
<TR>
<TD vAlign=3Dtop align=3Dmiddle width=3D"100%"><!--start =
of article content -->
<TABLE width=3D"98%" border=3D0>
<TBODY>
<TR>
<TD class=3Dtext align=3Dleft=20
=
width=3D"100%"><BR><B>Hib=B5=C4=BC=EC=CB=F7=B7=BD=CA=BD</B><BR>1'=B5=BC=BA=
=BD=B6=D4=CF=F3=CD=BC=BC=EC=CB=F7=B7=BD=CA=BD=A1=A3=CD=A8=B9=FD=D2=D1=BE=AD=
=BC=D3=D4=D8=B5=C4=B6=D4=CF=F3=A3=AC=B5=F7=D3=C3.iterator()=B7=BD=B7=A8=BF=
=C9=D2=D4=B5=C3=B5=BDorder=B6=D4=CF=F3<BR>=C8=E7=B9=FB=CA=C7=CA=D7=B4=CE=D6=
=B4=D0=D0=B4=CB=B7=BD=B7=A8=A3=ACHib=BB=E1=B4=D3=CA=FD=BE=DD=BF=E2=BC=D3=D4=
=D8=B9=D8=C1=AA=B5=C4order=B6=D4=CF=F3=A3=AC=B7=F1=D4=F2=BE=CD=B4=D3=BB=BA=
=B4=E6=D6=D0=B5=C3=B5=BD=A1=A3<BR>2'OID=BC=EC=CB=F7=B7=BD=CA=BD=A1=A3=CD=A8=
=B9=FDsession=B5=C4get=A3=ACload=B7=BD=B7=A8=D6=AA=B5=C0=C1=CBOID=B5=C4=C7=
=E9=BF=F6=CF=C2=BF=C9=D2=D4=CA=B9=D3=C3<BR>3'HQL=BC=EC=CB=F7=B7=BD=CA=BD=A1=
=A3=CA=B9=D3=C3=C3=E6=CF=F2=B6=D4=CF=F3=B5=C4HQL=B2=E9=D1=AF=D3=EF=BE=E4s=
ession=B5=C4find=B7=BD=B7=A8=C0=FB=D3=C3HQL=C0=B4=B2=E9=D1=AF<BR>4'QBC=BC=
=EC=CB=F7=B7=BD=CA=BD=A1=A3=C0=FB=D3=C3QBCAPI=C0=B4=BC=EC=CB=F7=CB=FC=CA=C7=
=B7=E2=D7=B0=C1=CB=BB=F9=D3=DA=D7=D6=B7=FB=B4=AE=B5=C4=B2=E9=D1=AF=D3=EF=BE=
=E4<BR>5'=B1=BE=B5=D8=B5=C4SQL=BC=EC=CB=F7=B7=BD=CA=BD=A1=A3=CA=B9=D3=C3=B1=
=BE=B5=D8=CA=FD=BE=DD=BF=E2=B5=C4SQL=B2=E9=D1=AF=D3=EF=BE=E4Hib=BB=E1=B8=BA=
=D4=F0=B0=D1=BC=EC=CB=F7=B5=BD=B5=C4JDBC=BD=E1=B9=FB=BC=AF=D3=B3=C9=E4=CE=
=AA=B3=D6=BE=C3=BB=AF=B6=D4=CF=F3=CD=BC=A1=A3<BR><BR>=CE=E5=D6=D6=BC=EC=CB=
=F7=B7=BD=CA=BD=B5=C4=CA=B9=D3=C3=B3=A1=BA=CF=BA=CD=CC=D8=B5=E3=A3=BA<BR>=
<BR>HQL =A3=BA =CA=C7=C3=E6=CF=F2=B6=D4=CF=F3=B5=C4=B2=E9=D1=AF=
=D3=EF=D1=D4=A3=AC=CD=ACSQL=D3=D0=D0=A9=CF=E0=CB=C6=CA=C7Hib=D6=D0=D7=EE=B3=
=A3=D3=C3=B5=C4=B7=BD=CA=BD=A1=A3<BR> =
=B2=E9=D1=AF=C9=E8=B6=A8=B8=F7=D6=D6=B2=E9=D1=AF=CC=F5=BC=FE=A1=A3<=
BR> =D6=A7=B3=D6=CD=B6=D3=B0=B2=E9=
=D1=AF=A3=AC=BC=EC=CB=F7=B3=F6=B6=D4=CF=F3=B5=C4=B2=BF=B7=D6=CA=F4=D0=D4=A1=
=A3<BR> =D6=A7=B3=D6=B7=D6=D2=B3=
=B2=E9=D1=AF=A3=AC=D4=CA=D0=ED=CA=B9=D3=C3having=BA=CDgroup by<BR>&n=
bsp; =CC=E1=B9=A9=C4=DA=D6=C6=B5=C4=BE=
=DB=BC=AF=BA=AF=CA=FD=A3=ACsum()=A3=ACmin()=A3=ACmax()<BR> &nb=
sp; =C4=DC=B5=F7=D3=C3=D3=C3=BB=A7=B5=C4=D7=D4=B6=A8=
=D2=E5SQL<BR> =D6=A7=B3=D6=D7=D3=
=B2=E9=D1=AF=A3=AC=C7=B6=C8=EB=CA=BD=B2=E9=D1=AF<BR> &nb=
sp; =D6=A7=B3=D6=B6=AF=CC=AC=B0=F3=B6=A8=B2=CE=CA=FD<BR>=
=BD=A8=D2=E9=CA=B9=D3=C3Query=BD=D3=BF=DA=CC=E6=BB=BBsession=B5=C4find=B7=
=BD=B7=A8=A1=A3<BR> Query Q =3D session.c=
reateQuery("from customer as c where c.name =
;=3D :customerName" + "and c.age =3D :custo=
merAge");<BR> query.setString ("customerName" =
, "tom");<BR> query.setInteger("customerAge" ,=
"21");<BR> list result =3D query.li=
st();<BR>QBC : QBCAPI=CC=E1=B9=A9=C1=CB=C1=ED=D2=BB=D6=D6=
=B7=BD=CA=BD=A3=AC=D6=F7=D2=AA=CA=C7Criteria=BD=D3=BF=DA=A1=A2Criterion=BD=
=D3=BF=DA=BA=CDExpression=C0=E0<BR> Criteria criter=
ia =3D session.createCriteria(customer.class);<BR> &=
nbsp;Criterion criterion1 =3D Expression.like("name","t%")=
;<BR> Criterion criterion2 =3D Expression=
.eq("age",new Integer(21));<BR> Critera =3D&nb=
sp;criteria.add(criterion1) ;<BR> Critera =3D&=
nbsp;criteria.add(criterion2) ;<BR> list resul=
t =3D criteria.list(); <BR> =BB=F2=CA=C7=A3=
=BA list result =3D session.createCriteria(Customer.c=
lass).add(Expression.eq("this.name","tom")).list(); <BR>SQL :&n=
bsp; =B2=C9=D3=C3HQL=BA=CDQBC=BC=EC=CB=F7=CA=B1=A3=ACHib=C9=FA=B3=C9=
SQL=D3=EF=BE=E4=CA=CA=D3=C3=CB=F9=D3=D0=CA=FD=BE=DD=BF=E2=A1=A3<BR> =
Query query =3D session.createSQLQuery("=
select {c.*} from customers c where c.name&=
nbsp;like : customername " + "and c.age&nbs=
p;=3D :customerage","c",customer.calss);<BR> query.=
setString("customername","tom");<BR> query.setInteger("c=
ustomerage","21");<BR> list result =3D qu=
ery.list();<BR>/////////////=B6=E0=CC=AC=B2=E9=D1=AF<BR>  =
;HQL =A3=BAsession.createQuery("from employee");<BR>  =
; QBC =A3=BAsession.createCriteria(employee.class);<BR> &n=
bsp; HQL : session.createQuery("from hourlyEmployee")=
;<BR> QBC : session.createCriteria(hourlyEmplo=
yee.class);<BR> =CF=C2=C3=E6=B5=C4HQL=B2=E9=D1=AF=D3=EF=BE=
=E4=BD=AB=BC=EC=CB=F7=B3=F6=CB=F9=D3=D0=B5=C4=B3=D6=BE=C3=BB=AF=B6=D4=CF=F3=
=A3=BA<BR> from java.lang.Object ;<BR> &n=
bsp; from java.io.serializable ;<BR>////////////=B2=E9=D1=AF=
=B5=C4=C5=C5=D0=F2<BR> 1'=B2=E9=D1=AF=BD=E1=B9=FB=B0=B4=D5=
=D5=BF=CD=BB=A7=D0=D5=C3=FB=C9=FD=D0=F2=C5=C5=C1=D0=A3=BA<BR> =
HQL =A3=BA<BR> =
Query query =3D session.createQuery ("from custo=
mer c order by c.name");<BR> QBC&nbs=
p;=A3=BA<BR> Criteria =
;criteria =3D session.createCriteria(customer.class);<BR> =
criteria.addOrder(order.asc("na=
me"));<BR> HQL :<BR> &=
nbsp; Query query =3D session.createQuery =
("from customer c order by c.name asc =
, c.age desc");<BR> QBC :<BR> =
Criteria criteria =3D =
session.createCriteria(customer.class);<BR> =
criteria.addOrder(order.asc ("name"));<BR> &n=
bsp; criteria.addOrder(order.desc("age=
")); <BR><BR> import&=
nbsp;net.sf.hibernate.pression.Order<BR> &nb=
sp; import mypack.Order<BR> =
...........<BR> &nbs=
p; Criteria criteria =3D session.createCritria (=
mypack.Order.class);<BR> c=
riteria.addOrder(net.sf.hibernate.Order.asc("name"));<BR>///////////HQL=D3=
=EF=BE=E4=B5=C4=B2=CE=CA=FD=B0=F3=B6=A8Query=BD=D3=BF=DA=CC=E1=B9=A9=C1=CB=
=B0=F3=B6=A8=B8=F7=D6=D6Hib=D3=B3=C9=E4=C0=E0=D0=CD=B5=C4=B7=BD=B7=A8=A1=A3=
<BR> setBinary()<BR> =
setString()<BR> &nbs=
p; setBoolean()<BR> &=
nbsp; setByte()<BR> &=
nbsp; setCalendar()<BR> &nb=
sp;setCharacter()<BR> setD=
ate()<BR> setDouble()<BR>&=
nbsp; setText()<BR> &=
nbsp; setTime()<BR> &=
nbsp; setTimestamp()<BR> &n=
bsp; setEntity()//=B0=D1=B2=CE=CA=FD=D3=EB=D2=BB=B8=F6=B3=D6=BE=
=C3=BB=AF=C0=E0=B5=C4=CA=C2=C0=FD=B0=F3=B6=A8lsit result =3D&nb=
sp;session.createQuery("from order o where o.customer=
=3D &nbs=
p; :customer").setEntity("customer" , customer).list =
;<BR> setParameter()//=B0=F3=
=B6=A8=C8=CE=D2=E2=C0=E0=D0=CD=B5=C4=B2=CE=CA=FD<BR> &nb=
sp; setProperties()//=B0=D1=C3=FC=C3=FB=B2=CE=CA=FD=
=D3=EB=D2=BB=B8=F6=B6=D4=CF=F3=B5=C4=CA=F4=D0=D4=D6=B5=B0=F3=B6=A8 Q=
uery query =3D session.createQuery("from customer&nbs=
p;c where c.name =3D: name&nb=
sp;" + "and c.age =3D:age" );<BR> &nb=
sp; Query.setProperties(customer); =20
<BR><BR>
<SCRIPT type=3Dtext/javascript><!--
google_ad_client =3D "pub-7390275636631344";
google_ad_width =3D 728;
google_ad_height =3D 90;
google_ad_format =3D "728x90_as";
google_ad_type =3D "text_image";
google_ad_channel =3D"5095444487";
google_color_border =3D "336699";
google_color_bg =3D "FFFFFF";
google_color_link =3D "0000FF";
google_color_url =3D "008000";
google_color_text =3D "000000";
//--></SCRIPT>
<SCRIPT=20
=
src=3D"http://pagead2.googlesyndication.com/pagead/show_ads.js"=20
type=3Dtext/javascript>
</SCRIPT>
<TABLE width=3D"100%">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -