HQL的增删改查操作
你猜
阅读:182
2022-04-08 10:44:24
评论:0
实体更新
Transaction trans
=session.beginTransaction();
String hql =” update User user set user.age = 20 where user.age = 18”;
Query queryupdate =session.createQuery(hql);
int ret =queryupdate.executeUpdate();
trans. commit();
String hql =” update User user set user.age = 20 where user.age = 18”;
Query queryupdate =session.createQuery(hql);
int ret =queryupdate.executeUpdate();
trans. commit();
实体删除
Transaction trans
=session.beginTransaction();
String hql =” delete from User user where user.age = 18”;
Query queryupdate =session.createQuery(hql);
int ret =queryupdate.executeUpdate();
trans. commit();
String hql =” delete from User user where user.age = 18”;
Query queryupdate =session.createQuery(hql);
int ret =queryupdate.executeUpdate();
trans. commit();
属性查询
List list
=session.createQuery(“
select
user.name
from
User
user ”).list();
for( int i = 0){
for( int i = 0){
System.out.println(list.get(i));
}
一次检索多个属性,如下面程序:
List list
=session.createQuery(“
select
user.name,
user.age
from
User
user ”).list();
for(
int i
=
0;i
<list.length();i
++){
Object [] obj =(Object [])list.get(i);
Object [] obj =(Object [])list.get(i);
System.out.println(obj
[
0
]);
System.out.println(obj
[
1
]);
}
声明
1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。