服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > JAVA > 新手入门 > 基础入门 > 查看文档

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             ht.put(rsmd.getcolumnname(i+1),rs.getobject(i+1));
        }
        array.add(ht);
    }
    hibernatesessionfactory.closssession();
    return array;
}


扫描关注微信公众号