二級(jí)考試java輔導(dǎo)：HQL返回值

Hibernate查詢單個(gè)字段，Hibernate把每個(gè)id做成一個(gè)元素的一維數(shù)組，List存放的是一維數(shù)組。
    Query query = s.createQuery("select u.id from User as u");
    List list = query.list();
    for (i=0; i< list.size(); i++) {
    Long id = (Long) list.get(i);
    System.out.println(id);
    }
    Hibernate查詢多個(gè)字段，Hibernate把每個(gè)id和name做成一個(gè)2個(gè)元素的一維數(shù)組，List存放的是一維數(shù)組。
    Query query = s.createQuery("select u.id,u.name from User as u");
    List list = qurey.list();
    for (int i=0; i< list.size(); i++) {
    Object[] row = (Object[])list.get(i);
    Long id = (Long) row[0];
    String name = (String) row[1];
    System.out.println(“id = ”+id+“ name = ”+name);
    }
    Hibernate查詢一個(gè)字段和User對(duì)象，Hibernate把每個(gè)id和User對(duì)象做成一個(gè)2個(gè)元素的一維數(shù)組，List存放的是一維數(shù)組。
    Query query = s.createQuery("select u.id , u from User as u");
    List list = query.list();
    for (int i=0; i< list.size(); i++) {
    Object[] row = (Object[])list.get(i);
    Long id = (Long) row[0];
    User user = (User) row[1];
    System.out.println(“id = ”+id+“ name = ”+name+“ User = ”+user);
    }