Hibernate7:原生SQL查询

1. 基本查询

1.1 返回数组List

public class Sql1 { public static void main(String[] args) { Session session = HibernateUtils.openSession(); Transaction tx = session.beginTransaction(); String sql = "select * from cst_customer"; SQLQuery query = session.createSQLQuery(sql); //执行查询，把返回的每行结果封装到数组中 List<Object[]> list = query.list(); for (Object[] obj : list) { System.out.println(Arrays.toString(obj)); } tx.commit(); session.close(); } }

1.2 返回对象List

public class Sql2 { public static void main(String[] args) { Session session = HibernateUtils.openSession(); Transaction tx = session.beginTransaction(); String sql = "select * from cst_customer"; SQLQuery query = session.createSQLQuery(sql); //把返回的结果集封装到对象中 query.addEntity(Customer.class); List<Customer> list = query.list(); System.out.println(list); tx.commit(); session.close(); } }

 

2. 条件查询

public class Sql3 { public static void main(String[] args) { Session session = HibernateUtils.openSession(); Transaction tx = session.beginTransaction(); String sql = "select * from cst_customer where cust_id = ?"; SQLQuery query = session.createSQLQuery(sql); //设置参数 query.setParameter(0, 2l); query.addEntity(Customer.class); Customer result = (Customer) query.uniqueResult(); System.out.println(result); tx.commit(); session.close(); } }

3. 分页查询

public class Sql4 { public static void main(String[] args) { Session session = HibernateUtils.openSession(); Transaction tx = session.beginTransaction(); String sql = "select * from cst_customer limit ?,?"; SQLQuery query = session.createSQLQuery(sql); //设置参数 query.setParameter(0, 2); query.setParameter(1, 2); query.addEntity(Customer.class); List<Customer> list = query.list(); System.out.println(list); tx.commit(); session.close(); } }