hibernate SQLQuery & Query

来源：互联网发布：能回看的电视软件编辑：程序博客网时间：2024/05/29 21:33

sessions=sessionFactory.openSession();
  transAction=sessions.beginTransaction();
  SQLQuery query=sessions.createSQLQuery(sql);//SQL search
  query.addScalar("au_id",Hibernate.STRING);
  query.addScalar("au_lname",Hibernate.STRING);
  query.addScalar("au_fname",Hibernate.STRING);
  query.addScalar("phone",Hibernate.STRING);
  query.addScalar("address",Hibernate.STRING);
  query.addScalar("city",Hibernate.STRING);
  query.addScalar("state",Hibernate.STRING);
  query.addScalar("zip",Hibernate.STRING);
  query.addScalar("contract",Hibernate.BOOLEAN);
  list=query.list();
  /*Query qu=sessions.createQuery("from AuthorFormBean");//HQL search
  list=qu.list();*/

  try{
   Iterator it=list.iterator();
   while(it.hasNext()){
    Object[] rows = (Object[]) it.next();// common sql
    authors.add(new AuthorFormBean(String.valueOf(rows[0]),String.valueOf(rows[1]),String.valueOf(rows[2]),String.valueOf(rows[3]),String.valueOf(rows[4]),String.valueOf(rows[5]),String.valueOf(rows[6]),String.valueOf(rows[7]),((Boolean)rows[8]).booleanValue()));
   }