查询:
select p from Person p where p.name=?0
删除:
delete from Person p where p.id=?0
更新语句:
update Person p set p.name=?0,p.sex=?1 where p.id=?2
补充hql参数绑定:
***setParameter(属性名,真实值,类型)
String hql="select p from Person p where p.name=:name" ;
Query query=getSessionFactory().getCurrentSession().createQuery(hql);
query.setParameter("name","天天向上",Hibernate.STRING);
***setXXXX(属性值,真实值)
query.setString("name",userName);
query.setInteger("id",userId);
***setString(问号位置,真实值);或者是setParameter(问号位置,真实值)
getSessionFactory().getCurrentSession()
.createQuery("delete from " + entityClass.getSimpleName() + " en where en.id=?0").setParameter("0", id)
.executeUpdate();
***setProperties(对象);
String hql="update User u set u.userName=:userName where u.userId=:userId";
Query query = getSession.createQuery(hql);
User user = new User();
user.serUserName("张三");
user.setUserId(1);
query.setProperties(user);
query.executeUpdate();