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

最新推荐文章于 2024-09-29 19:21:13 发布

阿春

最新推荐文章于 2024-09-29 19:21:13 发布

阅读量551

点赞数

分类专栏： Hibernate 文章标签： hibernate 数据库 session object sql insert

本文链接：https://blog.csdn.net/achun2050/article/details/1609294

版权

Hibernate 专栏收录该内容

2 篇文章 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;

}