发布时间:2025-12-09 13:55:47 浏览次数:5
数据库中根据你的查询条件只会返回唯一结果,就可以用uniqueResult这个方法!否则就用list();其返回类型为Object
uniqueResult()方法通常是在业务方法查询语句中用到的,比如(UsersRoles)getSession().createQuery(“select ur from UsersRoles ur where ur.role.id = ? and ur.user.id = ?”) .setParameter(0, roleId) .setParameter(1, userId) .uniqueResult();这时通表示只(从数据库中只返回一条记录)返回一个对象。当不确定时用List()方法
如果查询返回多个值用list()方法
1.publicvoidtestQuery(){
2.Configurationconfig=newConfiguration().configure();
3.SessionFactoryfactory=config.buildSessionFactory();//创建SessionFactory
4.Sessionsession=factory.openSession();//创建Session
5.session.beginTransaction();//开始事务
6.
7.Queryquery=session.createQuery(“fromStudent”);
8.Listlist=query.list();//用list方法返回多个值
9.//Listlist=session.createQuery(“fromStudent”).list();
10.for(inti=0;i<list.size();i++){
11.Studentstudent=(Student)list.get(i);
12.System.out.print(student.getId()+”“);
13.System.out.print(student.getName()+”“);
14.System.out.print(student.getSex()+”“);
15.System.out.print(student.getBirthday());
16.System.out.println();
17.}
18.
19.session.getTransaction().commit();//提交事务
20.session.close();//关闭Session
21.}
当确定返回的实例只有一个或者null时 用uniqueResult()方法
1.publicvoidtestQuery(){
2.Configurationconfig=newConfiguration().configure();
3.SessionFactoryfactory=config.buildSessionFactory();//创建SessionFactory
4.Sessionsession=factory.openSession();//创建Session
5.session.beginTransaction();//开始事务
6.
7.Queryquery=session.createQuery(“fromStudent”);
8.Listlist=query.list();//用list方法返回多个值
9.//Listlist=session.createQuery(“fromStudent”).list();
10.for(inti=0;i<list.size();i++){
11.Studentstudent=(Student)list.get(i);
12.System.out.print(student.getId()+”“);
13.System.out.print(student.getName()+”“);
14.System.out.print(student.getSex()+”“);
15.System.out.print(student.getBirthday());
16.System.out.println();
17.}
18.
19.session.getTransaction().commit();//提交事务
20.session.close();//关闭Session
21.}
当确定返回的实例只有一个或者null时 用uniqueResult()方法
publicvoidtestGet(){
Configurationconfig=newConfiguration().configure();
SessionFactoryfactory=config.buildSessionFactory();
Sessionsession=factory.openSession();
session.beginTransaction();
Queryquery=session.createQuery(“fromStudentswheres.id=?”);
query.setString(0,“2”);
Studentstudent=(Student)query.uniqueResult();//当确定返回的实例只有一个或者null时用uniqueResult()方法
//Studentstudent=(Student)session.createQuery(“fromStudentswheres.id=?”).setString(0,”5″).uniqueResult();
System.out.println(student.getName());
System.out.println(student.getBirthday());
session.getTransaction().commit();
session.close();
}