hibernate3 createSQLQuery(sql).list取值方法

2015-03-30

477
0
JAVA

摘要:hibernate3 createSQLQuery(sql).list取值方法

List<Object> list = em.createNativeQuery("SELECT* from TableA").list();

//直接取第一列值1：


Object[] row = (Object[]) list.get(0);



	//取所有值

	for (int i=0; i<list.size; i++){ 

	Object[] row = (Object[]) list.get(i); 

	System.out.println("Element "+i+Arrays.toString(row)); 

	}

	 

	//取所有值2

	for (Iterator it=list.iterator();it.hasnext();){

	   Object[] row=(Object[]) it.next();

	    System.out.println(row[0]  +"   " + row[1]);

	}

	 

	//取所有值3

	List<Object> list = em.createNativeQuery("SELECT* from TableA")

	                                                .addEntity(Person.class)

	                     .list();

	for (Iterator it=list.iterator();it.hasnext();){

	  Person p= (Person) it.next();

	    System.out.println(p.getName());

	}