Thursday 9 April 2009

[Hibernate] native SQL example- One return column case

String gSql = "select sYear from VIEW_REPORT_BillingRegion group by sYear";

// Query query = sessionFactory.getCurrentSession().createQuery(gSql);
SQLQuery query = this.sessionFactory.getCurrentSession().createSQLQuery(gSql).addScalar("sYear", Hibernate.STRING);


List[Object] list = query.list();
System.out.println("======="+list.size());
for( Object objArr : list){
System.out.println(objArr );
}
System.out.println("============"+list.size());

Wednesday 8 April 2009

[Hibernate] native SQL example

@SuppressWarnings("unchecked")
@Transactional
public void getTest(IUiListCfg uiListCfg) throws ReportException {

try {
String sSql = "select sGroupId, sGroupName from tRmCo_Group";
SQLQuery query = this.sessionFactory.getCurrentSession().createSQLQuery(sSql).addScalar("sGroupId", Hibernate.STRING).addScalar("sGroupName", Hibernate.STRING);

List list = query.list();
for( Object[] objArr : list){
for( Object obj : objArr){

System.out.println(obj );
}
}
System.out.println("============"+list.size());

} catch (Exception e) {
e.printStackTrace();
}
}