一、HQL查询:通过HQL语句进行查询,HQL语句中没有与数据库相关的任何东西。
1.根据HQL取对象的集合,使用Query的list();方法
public void getList(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String hql = "from Customer";
Query query = session.createQuery(hql);
List<Customer> list = query.list();
for (Customer customer : list) {
System.out.println(customer);
}
transaction.commit();
session.close();
}
2.根据HQL取单个对象,使用Query的uniqueResult();
public void getOne(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String Hql = "from Customer where cust_id = 1";
Query query = session.createQuery(Hql);
Customer customer = (Customer) query.uniqueResult();
System.out.println(customer);
transaction.commit();
session.close();
}
3. “?”占位符来选择查询条件,查询的条件为对象中的字段,通过Query的setParmeter(int position,Object val);进行对条件的赋值
public void getSth(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String Hql = "from Customer where cust_id = ?";
Query query = session.createQuery(Hql);
//query.setLong(0, 1L);
query.setParameter(0, 2l);//不知道类型的时候使用
Customer customer = (Customer) query.uniqueResult();
System.out.println(customer);
transaction.commit();
session.close();
}
4.命名占位符,“:+对象属性名”,冒号加对象属性名表示查询对象的字段命名,然后通过Query的setParmeter(String name,Object val);方法进行赋值
ublic void getSthByName(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String Hql = "from Customer where cust_id = :this_is_cust_id";
Query query = session.createQuery(Hql);
query.setParameter("this_is_cust_id", 2l);//直接定义占位符名称,不需要数这个第几个位置
Customer customer = (Customer) query.uniqueResult();
System.out.println(customer);
transaction.commit();
session.close();
}
5.设置分页,类似于mysql 的limit,通过Query的setFirstResult(int start);方法设置起始位置,setMaxResult(int eachTotal);方法设置每页的数据个数
public void getAllByEach(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String Hql = "from Customer";
Query query = session.createQuery(Hql);
query.setFirstResult(1);
query.setMaxResults(1);
List<Customer> list = query.list();
System.out.println(list);
transaction.commit();
session.close();
}
二、Criteria查询
1.通过session的createCriteria(Class class);方法获取的Criteria,之后方法与Query一致
public void getAll(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
List<Customer> list = criteria.list();
System.out.println(list);
transaction.commit();
session.close();
}
2.根据条件查询单条,通过Criteria的add(条件)来添加查询条件,Restrictions类提供了多种查询条件
public void getOne(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.add(Restrictions.eq("cust_id", 1L));
Customer customer = (Customer) criteria.uniqueResult();
System.out.println(customer);
transaction.commit();
session.close();
}
3.聚合函数,通过Criteria的setProjection(条件);方法设置聚合函数的内容,例如求Customer的总条数
public void getAllCount(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.setProjection(Projections.rowCount());
Long count = (Long) criteria.uniqueResult();
System.out.println(count);
transaction.commit();
session.close();
}
三、原生SQL查询
1.通过SQLQuery来进行对数据库的SQL语句方式的查询,此方式得到的是一个包含多个数组的list,一条记录为一个数组
public void getAll(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String sql = "select * from cst_customer";
SQLQuery query = session.createSQLQuery(sql);
List<Object[]> list = query.list();//得到的一个包含多个数组的list,一条记录为一个数组
for (Object[] objects : list) {
System.out.println(Arrays.toString(objects));
}
transaction.commit();
session.close();
}
2.通过对SQLQuery的addEntity(Class class);方法,可以得到所需类型的list
public void getAllByEntity(){
Session session = HibernateUtils.getCurrentSession();
Transaction transaction = session.beginTransaction();
String sql = "select * from cst_customer";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(Customer.class);
List<Customer> list = query.list();//得到的一个包含多个数组的list,一条记录为一个数组
System.out.println(list);
transaction.commit();
session.close();
}
3.带"?"的占位符的使用方式和前面的HQL的方式一样