Tuesday, June 4, 2013
Connecting the database and return values using hibernate session
public class InvPersonalInformationDAO {
private static InvPersonalInformationDAO invPersonalInformationDAO;
public InvPersonalInformationDAO(){}
public static InvPersonalInformationDAO getInstance(){
if(invPersonalInformationDAO == null){
invPersonalInformationDAO = new InvPersonalInformationDAO();
}
return new InvPersonalInformationDAO();
}
public List getInventoryList()throws EPASException{
List inventoryList = new ArrayList();
try {
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("SELECT invEmpPiBasicDet FROM InvEmpPiBasicDet invEmpPiBasicDet WHERE invEmpPiBasicDet.invEmpMstStatus = '1' ");
Iterator iterator = query.list().iterator();
while(iterator.hasNext()){
InvEmpPiBasicDet invEmpPiBasicDet = (InvEmpPiBasicDet)iterator.next();
System.out.println("invEmpPiBasicDet.getBasicsalary() : "+invEmpPiBasicDet.getBasicsalary());
inventoryList.add(EntityToBeanConverter.convertInvEmpPiBasicDetToInvPersonalInformationBean(invEmpPiBasicDet));
}
} catch (Exception e) {
e.printStackTrace();
throw new EPASException(e);
}finally{
HibernateSessionFactory.closeSession();
}
return inventoryList;
}
public static void main(String[] args) {
InvPersonalInformationDAO id=new InvPersonalInformationDAO();
//or //
//InvPersonalInformationDAO id=InvPersonalInformationDAO.getInstance();
try {
List l1=id.getInventoryList();
} catch (EPASException e) {
e.printStackTrace();
}
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment