Hibernate合集(第三章) SQL使用

Hibernate合集

第一章 Hibernate 三种状态
[第二章 HQL使用](https://blog.csdn.net/a8590455/article/details/115715569)
第三章 SQL使用

---

---

一、查询

单表查询

持久态

// return User
select * from t_user user where user.age=20;
select * from t_user user where user.age between 20 and 30;
select * from t_user user where user.id in(20,30);
select * from t_user user where user.age=20 and
(user.name is null or user.name like '%zx%');

session.createSQLQuery(sql).addEntity("user", User.class).list();

属性查询

Detached 游离态

select user.name from t_user user;// list<String>
select user.name,user.age from t_user user;// List<Object[]>

group

select count(user) as count,user.age as age
from t_user user group by user.age having count(user)>10

二、条件

属性

Query query=session.createSQLQuery("select * from t_user user
where user.name=:customerName");
query.setString("customerName",name);

实体

Customer customer=new Customer();
customer.setName("pansl");
customer.setAge(80);
Query query=session.createQuery("select * from t_customer c
where c.name=:name and c.age=:age");
query.setProperties(customer);

三、单表更新/删除

update t_user set age=20 where age=18;

delete from t_user user where user.age=18;

四、关联查询

String sql = "select {order.*},{c.*} from t_order order inner join t_customer c on order.customer_id=c.id
where c.id=:customerId";
Query query1=session.createSQLQuery(sql).addEntity("order", Order.class).addJoin("c", Customer.class);
List<Object[]> list1 = query1.list();
Query query2=session.createSQLQuery(sql).addEntity("order", Order.class).addEntity("c", "order.customer");
List<Object[]> list1 = query2.list();

---

总结