hibernate查询问题

Question

session = HibernateSessionFactory.getSession();
            tx = session.beginTransaction();
            
            String sql = " from sysdao.Sysuser b where b.adminName =:tt";
            Query query = session.createQuery(sql);
            query.setString("tt", username);             
           user = query.list();            
public String login(){
        String username=loginName;
        SysuserImp sysuserImp=new SysuserImp();        
        user =sysuserImp.QuerySysuser(username);
                //到这里不会写了
         String name="";
         if(user.size()>0)
            {
             Sysuser u = (Sysuser )user.get(0);//得到这个Sysuser 对像
               name=user.getName();//取它的属性
            }
        return this.SUCCESS;
    }

Answer 1

这样写会好一点:
     public String login(){
                    Sysuser rtn=null;
                   org.hibernate.Session session = null;
try {
session = HibernateSessionFactory.getSession();
Sysuser =(Sysuser)session.get(Sysuser.class, id);
} catch (HibernateException ex) {
log.error(ex);
ex.printStackTrace();
} finally {
if (session != null) {
session.close();
session = null;
}
}
                  if(rtn!=null){
                    return rtn.getName();
                  }
                 else{   
                  return null;
                   }
         }