Hibernat查询
Hibernate的查询方式参考：Hibernate ORM 最佳实践
通过对象表示符查询
Company c = (Company)session.get(Company.class,new Long(1));
面向对象查询--HQL
Query q = session.createQuery("From Company AS c WHERE c.name = :cname");q.setString("cname","JNotNull");List result = q.list();
按条件查询方式--QBC
Criteria criteria = session.createCriteria(Company.class);criteria.add(Expression.like("name","JNotNull"));List result = criteria.list();
按样例查询方式--QBE
Company exCompany = new Company();exCompany.setName("JNotNull");Criteria criteria = session.createCriteria(Company.class);criteria.add(Example.create(exCompany));List result = criteria.list();
传统的查询方式--Native SQL
List result = session.createSQLQuery("select {c.*} from Company c").addEntity("c",Company.class).setMaxResults(50).list();
页:
[1]