使用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://www.htsjk.com/shujukukf/17358.html
www.htsjk.Com
true
http://www.htsjk.com/shujukukf/17358.html
NewsArticle
使用Hibernate编写通用数据库操作代码 insert方法 public void insert(Object o){ Session session = HibernateSessionFactory.currentSession(); Transaction t = session.beginTransaction(); session.save(o); t.commit(); HibernateSessio...
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。