hibernate开发中使用原生语句查询

public static void main(String[] args) {
  SessionFactory sessionFactory;
  sessionFactory = new Configuration().configure().buildSessionFactory();
  Session session = sessionFactory.openSession();
  String sql = "select PWD,STATUS from CARD";
  SQLQuery query = session.createSQLQuery(sql);
  query.addScalar("PWD",new org.hibernate.type.StringType());
  query.addScalar("STATUS", new org.hibernate.type.IntegerType());
  
  List list = query.list();
  
  for (Iterator iterator = list.iterator(); iterator.hasNext();) {
   Object[] obj = (Object[]) iterator.next();
   for (int i = 0; i < obj.length; i++) {
    System.out.print(obj[i]+"  ");
   }
   System.out.println();
  }
  
 }