insert方法
public void insert(Object o){
Session session = HibernateSessionFactory.currentSession().
Transaction t = session.beginTransaction().
session.save(o).
t.commit().
HibernateSessionFactory.clossSession().
}
0delete方法
public void 0delete(Object o,Serializable id){
Session session = HibernateSessionFactory.currentSession():
Transaction t = session.beginTransaction().
Object o = session.get(o.class,id).
if(o!=null){
session.0delete(o).
}
t.commit().
HibernateSessionFactory.clossSession().
}
0update方法
public void 0update(Object o,Serializable id){
Session session = HibernateSessionFactory.currentSession().
Transaction t = session.beginTransaction().
session.0update(o,id).
t.commit().
HibernateSessionFactory.clossSession().
}
基于HQL的通用0select方法
public ArrayList 0select(String sql){
Session session = HibernateSessionFactory.currentSession().
Query query = createQuery(sql).
List list = query.list().
HibernateSessionFactory.clossSession().
return (ArrayList)list.
}
基于SQL的通用0select方法
public ArrayList 0select(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
ht.put(rsmd.getColumnName(i 1),rs.getObject(i 1)).
}
array.add(ht).
}
HibernateSessionFactory.clossSession().
return array.
}