Hibernate常用查询语句

Hibernate ò ѯ��� � ���

Hib ļ ʽ1' ͼ ʽ Ѿ� ��� �������� ���� �� ���� ���� صĶ 󣬵 .iterator() õ order������ ������Ե � ����

������״�ִ�д˷ Hib����� �����ع���ݿ����order 󣬵 ʹӻ еõ������� ��� ���

2'OID ʽ session get load���� �� ��� � �� ���� �����֪ OID ¿ ʹ������ ��� ��

3'HQL ʽ ʹ HQL ѯ session find HQL ѯ���� �� ���������� �� ��� �� �������� ���

4'QBC ʽ QBCAPI Ƿ���� ������ �������� �װ�˻����ַ�IJ ѯ� ���

5'���ص�SQL ʽ ʹ ñ���� �� � �����ݿ��SQL ѯ Hib Ḻ Ѽ JDBC ӳ Ϊ�� ��� � �� ���� ��� �� �־û ͼ����� ��

���ּ���ʽ ʹ ó Ϻ�� � �� ��ص㣺

֧���Ӳ ѯ Ƕ ʽ ѯ� �� �� ��

֧ 󣬵󣬵 󣬵 󣬵�ֶ�����

ʹ Query ӿ���� �� � ��滻 session find�� ������

Query Q = session.createQuery("from customer as c where c.name

= :customerName" + "and c.age = :customerAge");

query.setString ("customerName" , "tom");

query.setInteger("customerAge" , "21");

list result = query.list();

QBC : QBCAPI ṩ һ� ���� �ַ�ʽ Ҫ Criteria ӿ���� �� � ڡ�Criterion ӿ� ں�Expression��

Criteria criteria = session.createCriteria(customer.class);

session.createCriteria(Customer.class).add(Expression.eq("this.name","tom")).lis

t();

SQL : HQL QBC ʱ Hib SQL���� �� ���� �� ��� �������������ݿ⡣

Query query = session.createSQLQuery("select {c.*} from customers c where

c.name like : customername " + "and c.age = :customerage","c",customer.calss);

query.setString("customername","tom");

query.setInteger("customerage","21");

list result = query.list();

///////////// ѯ����

HQL session.createQuery("from employee");��

//////////// ѯ�� ������

1' ѯ ͻ У�� ����տ ������������ �

HQL ��

Query query = session.createQuery ("from customer c order by c.name");

QBC ��

Criteria criteria = session.createCriteria(customer.class);

criteria.addOrder(order.asc("name"));

HQL :

Query query = session.createQuery ("from customer c order by c.name

asc , c.age desc");