public void insert(Object o){

Session session = HibernateSessionFactory.currentSession();

Transaction t = session.beginTransaction();

session.save(o);

t.commit();

HibernateSessionFactory.clossSession();

}

public void delete(Object o,Serializable id){

Session session = HibernateSessionFactory.currentSession():

Transaction t = session.beginTransaction();

Object o = session.get(o.class,id);

if(o!=null){

session.delete(o);

}

t.commit();

HibernateSessionFactory.clossSession();

}

public void update(Object o,Serializable id){

Session session = HibernateSessionFactory.currentSession();

Transaction t = session.beginTransaction();

session.update(o,id);

t.commit();

HibernateSessionFactory.clossSession();

}

public ArrayList select(String sql){

Session session = HibernateSessionFactory.currentSession();

Query query = createQuery(sql);

List list = query.list();

HibernateSessionFactory.clossSession();

return (ArrayList)list;

}

public ArrayList select(String sql) throws Exception{

Session session = HibernateSessionFactory.currentSession();

Connection con = session.connection();

PreparedStatement pstmt = con.preparedStatement(sql);

ResultSet rs = pstmt.executeQuery();

ResultSetMetaData rsmd = rs.getMetaData();

Hashtable ht = null;

ArrayList array = new ArrayList();

while(rs.next()){

ht = new Hashtable();

for(int i=0;i<rsmd.getColumnCount();i++){

ht.put(rsmd.getColumnName(i+1),rs.getObject(i+1));

} 

array.add(ht);

}

HibernateSessionFactory.clossSession();

return array;

}