通用Hibernate方法
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://zizhuyuan.cnblogs.com
个人博客:http://www.zizhuyuan.net
本文版权归作者(代号极光)、紫竹园和博客园共有,欢迎转载,但请在文章明显位置给出原文连接,否则保留追究法律责任的权利。