使用Hibernate编写通用数据库操作代码

叁歲伎倆 2022-02-01 01:21 237阅读 0赞

insert方法   
public void insert(Object o)\{   
Session session = HibernateSessionFactory.currentSession();   
Transaction t = session.beginTransaction();   
session.save(o);   
t.commit();   
HibernateSessionFactory.clossSession();   
\}   
**delete方法**   
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();   
\}   
**update方法**   
public void update(Object o,Serializable id)\{   
Session session = HibernateSessionFactory.currentSession();   
Transaction t = session.beginTransaction();   
session.update(o,id);   
t.commit();   
HibernateSessionFactory.clossSession();   
\}   
**基于HQL的通用select方法**   
public ArrayList select(String sql)\{   
Session session = HibernateSessionFactory.currentSession();   
Query query = createQuery(sql);   
List list = query.list();   
HibernateSessionFactory.clossSession();   
return (ArrayList)list;   
\}   
**基于SQL的通用select方法**   
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;

本文转自左正博客园博客，原文链接：http://www.cnblogs.com/soundcode/archive/2010/12/20/1911939.html，如需转载请自行联系原作者