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();
}
}
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();
}
}