p
ublic void insert(Object o){Session session = HibernateSessionFactory.
currentSession();Transaction t = session.be
ginTransaction();session.save(o);t
.COMm
IT();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) t
hrows Exception{Session session = HibernateSessionFactory.currentSession();Connection con = session.connection();
PRepare
dstatement pstmt = con.prepa
redstatement(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.getColumnN
ame(i+1),rs.getObject(i+1));} array.add(ht);}HibernateSessionFactory.clossSession();return array;}