institutiondao.java

来自「java 实现了oa办公系统。java 实现了oa办公系统」· Java 代码 · 共 75 行

package service;

import java.util.List;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

import entity.Institution;
import db.HibSessionFactory;

/**
 * @author BWeiMing
 *
 */
public class InstitutionDao {

    public void addInstitution(Institution e) throws HibernateException{
        e.setCreatetime(new java.util.Date());
        Session session = HibSessionFactory.currentSession();
        Transaction tx = session.beginTransaction();
        session.save(e);
        tx.commit();
        HibSessionFactory.closeSession();
    }

    public void deleteInstitution(Institution e) throws HibernateException{
        Session session = HibSessionFactory.currentSession();
        Transaction tx = session.beginTransaction();
        session.delete(e);
        tx.commit();
        HibSessionFactory.closeSession();
    }

    public Institution loadInstitution(long id) throws HibernateException{
        Session session = HibSessionFactory.currentSession();
        Transaction tx = session.beginTransaction();
        Institution e=(Institution)session.load(Institution.class,new Long(id));
        tx.commit();
        HibSessionFactory.closeSession();
        return e;
    }

    public List listInstitution() throws HibernateException{
        Session session = HibSessionFactory.currentSession();
        Transaction tx = session.beginTransaction();
        Query query = session.createQuery("select e from Institution as e order by createtime");
        List list = query.list();
        tx.commit();
        HibSessionFactory.closeSession();
        return list;
    }

    public void updateInstitution(Institution ins) throws HibernateException{
        Institution e =this.loadInstitution(ins.getId().longValue());
        if (ins.getExplain()!=null){
            e.setExplain(ins.getExplain());
        }
        if(ins.getName()!=null){
            e.setName(ins.getName());
        }
        if (ins.getReason()!= null) {
            e.setReason(ins.getReason());
        }
        Session session = HibSessionFactory.currentSession();
        Transaction tx = session.beginTransaction();
        session.update(e);
        tx.commit();
        HibSessionFactory.closeSession();
    }


}