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();