Native SQL Example

Configuration configurationObj = new Configuration();
configurationObj.configure("hibernate.cfg.xml");
SessionFactory sessionFactoryObj = configurationObj.buildSessionFactory();
Session sessionObj = sessionFactoryObj.openSession();

System.out.println("\n---------USING OBJECT ARRAY--------\n");
SQLQuery sqlQuery1 = sessionObj.createSQLQuery(" SELECT * FROM ITEMS_DATA");
List itemList1 = sqlQuery1.list();

Iterator itemListIterator1 = itemList1.iterator();
System.out.println("ID \t NAME \t CATEGORY ");
System.out.println("--------------------------");
while(itemListIterator1.hasNext()){
      Object data[]=(Object[])itemListIterator1.next();
      System.out.print(data[0]+"\t");
      System.out.print(data[1]+"\t");
      System.out.println(data[2]);
}
System.out.println("--------------------------");

System.out.println("\n---------USING POJO CLASS------------\n");
SQLQuery sqlQuery2 = sessionObj.createSQLQuery(" SELECT * FROM
ITEMS_DATA").addEntity(Item.class);

List itemList2 = sqlQuery2.list();
Iterator itemListIterator2 = itemList2.iterator();
System.out.println("ID \t NAME \t CATEGORY ");

System.out.println("--------------------------");
while(itemListIterator2.hasNext()){
      Item itemObj=(Item)itemListIterator2.next();
      System.out.print(itemObj.getId()+"\t");
      System.out.print(itemObj.getName()+"\t");
      System.out.println(itemObj.getCategory());
}
System.out.println("--------------------------");

sessionObj.close();
sessionFactoryObj.close();