jadwaldao.java

sistem information for universitas

package dao;
import java.util.ArrayList;
import java.util.List;
import model.Dosen;
import model.Fakultas;
import model.Jadwal;
import model.Matakuliah;
import model.ObjectPaging;
import model.Semester;
import org.hibernate.Query;
import org.hibernate.Session;
public class JadwalDAO {
    int jadwalPerPage=20;
    public JadwalDAO() {
    }
    public Jadwal loadJadwal(long id) throws Exception {
        HibernateUtil.beginTransaction();
        Session session=HibernateUtil.getSession();
        Jadwal jadwal=null;
        try {
            jadwal=(Jadwal)session.load(Jadwal.class,id);
        } catch(Exception ex) {
            throw ex;
        }
        return jadwal;
    }
    //=======NO PAGING=======
    public List getListJadwal(Semester semester) throws Exception {
        HibernateUtil.beginTransaction();
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            list=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input")
            .setParameter("input",semester).list();
        } catch(Exception ex) {
            throw ex;
        }
        return list;
    }
    public List getListJadwal(Semester semester,Dosen dosen) throws Exception {
        HibernateUtil.beginTransaction();
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            list=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.dosen= :input2")
            .setParameter("input1",semester).setParameter("input2",dosen).list();
        } catch(Exception ex) {
            throw ex;
        }
        return list;
    }
    public List getListJadwal(Semester semester,Matakuliah matakuliah) throws Exception {
        HibernateUtil.beginTransaction();
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            list=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.matakuliah= :input2")
            .setParameter("input1",semester).setParameter("input2",matakuliah).list();
        } catch(Exception ex) {
            throw ex;
        }
        return list;
    }
    public List getListJadwal(Semester semester,Fakultas fakultas) throws Exception {
        HibernateUtil.beginTransaction();
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            list=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.matakuliah.fakultas= :input2")
            .setParameter("input1",semester).setParameter("input2",fakultas).list();
        } catch(Exception ex) {
            throw ex;
        }
        return list;
    }
    //=======NO PAGING=======
    //=======PAGING=======
    public ObjectPaging getListJadwal(int pageNumber,Semester semester) throws Exception {
        HibernateUtil.beginTransaction();
        ObjectPaging objectPaging=new ObjectPaging();
        int totalItem=getListJadwal(semester).size();
        int totalPage=totalItem/jadwalPerPage;
        if(totalItem%jadwalPerPage>0)totalPage++;
        if(pageNumber<1) {
            pageNumber=1;
        }
        if(pageNumber>totalPage) {
            pageNumber=totalPage;
        }
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            Query query=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input")
            .setParameter("input",semester);
            list=query.setFirstResult(jadwalPerPage*(pageNumber-1))
            .setMaxResults(jadwalPerPage).list();
        } catch(Exception ex) {
            throw ex;
        }
        int beginPagePaging=pageNumber-5;
        int endedPagePaging=pageNumber+5;
        if(beginPagePaging<1) {
            beginPagePaging=1;
            endedPagePaging=11;
            if(endedPagePaging>totalPage) {
                endedPagePaging=totalPage;
            }
        } else if(endedPagePaging>totalPage) {
            endedPagePaging=totalPage;
            beginPagePaging=totalPage-10;
            if(beginPagePaging<1) {
                beginPagePaging=1;
            }
        }
        List listPaging=new ArrayList();
        for(int i=beginPagePaging;i<=endedPagePaging;i++) {
            listPaging.add(i);
        }
        objectPaging.setListObject(list);
        objectPaging.setListPaging(listPaging);
        objectPaging.setPageNumber(pageNumber);
        objectPaging.setTotalPage(totalPage);
        return objectPaging;
    }
    public ObjectPaging getListJadwal(int pageNumber,Semester semester,Dosen dosen) throws Exception {
        HibernateUtil.beginTransaction();
        ObjectPaging objectPaging=new ObjectPaging();
        int totalItem=getListJadwal(semester,dosen).size();
        int totalPage=totalItem/jadwalPerPage;
        if(totalItem%jadwalPerPage>0)totalPage++;
        if(pageNumber<1) {
            pageNumber=1;
        }
        if(pageNumber>totalPage) {
            pageNumber=totalPage;
        }
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            Query query=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.dosen= :input2")
            .setParameter("input1",semester).setParameter("input2",dosen);
            list=query.setFirstResult(jadwalPerPage*(pageNumber-1))
            .setMaxResults(jadwalPerPage).list();
        } catch(Exception ex) {
            throw ex;
        }
        int beginPagePaging=pageNumber-5;
        int endedPagePaging=pageNumber+5;
        if(beginPagePaging<1) {
            beginPagePaging=1;
            endedPagePaging=11;
            if(endedPagePaging>totalPage) {
                endedPagePaging=totalPage;
            }
        } else if(endedPagePaging>totalPage) {
            endedPagePaging=totalPage;
            beginPagePaging=totalPage-10;
            if(beginPagePaging<1) {
                beginPagePaging=1;
            }
        }
        List listPaging=new ArrayList();
        for(int i=beginPagePaging;i<=endedPagePaging;i++) {
            listPaging.add(i);
        }
        objectPaging.setListObject(list);
        objectPaging.setListPaging(listPaging);
        objectPaging.setPageNumber(pageNumber);
        objectPaging.setTotalPage(totalPage);
        return objectPaging;
    }
    public ObjectPaging getListJadwal(int pageNumber,Semester semester,Matakuliah matakuliah) throws Exception {
        HibernateUtil.beginTransaction();
        ObjectPaging objectPaging=new ObjectPaging();
        int totalItem=getListJadwal(semester,matakuliah).size();
        int totalPage=totalItem/jadwalPerPage;
        if(totalItem%jadwalPerPage>0)totalPage++;
        if(pageNumber<1) {
            pageNumber=1;
        }
        if(pageNumber>totalPage) {
            pageNumber=totalPage;
        }
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            Query query=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.matakuliah= :input2")
            .setParameter("input1",semester).setParameter("input2",matakuliah);
            list=query.setFirstResult(jadwalPerPage*(pageNumber-1))
            .setMaxResults(jadwalPerPage).list();
        } catch(Exception ex) {
            throw ex;
        }
        int beginPagePaging=pageNumber-5;
        int endedPagePaging=pageNumber+5;
        if(beginPagePaging<1) {
            beginPagePaging=1;
            endedPagePaging=11;
            if(endedPagePaging>totalPage) {
                endedPagePaging=totalPage;
            }
        } else if(endedPagePaging>totalPage) {
            endedPagePaging=totalPage;
            beginPagePaging=totalPage-10;
            if(beginPagePaging<1) {
                beginPagePaging=1;
            }
        }
        List listPaging=new ArrayList();
        for(int i=beginPagePaging;i<=endedPagePaging;i++) {
            listPaging.add(i);
        }
        objectPaging.setListObject(list);
        objectPaging.setListPaging(listPaging);
        objectPaging.setPageNumber(pageNumber);
        objectPaging.setTotalPage(totalPage);
        return objectPaging;
    }
    public ObjectPaging getListJadwal(int pageNumber,Semester semester,Fakultas fakultas) throws Exception {
        HibernateUtil.beginTransaction();
        ObjectPaging objectPaging=new ObjectPaging();
        int totalItem=getListJadwal(semester,fakultas).size();
        int totalPage=totalItem/jadwalPerPage;
        if(totalItem%jadwalPerPage>0)totalPage++;
        if(pageNumber<1) {
            pageNumber=1;
        }
        if(pageNumber>totalPage) {
            pageNumber=totalPage;
        }
        Session session=HibernateUtil.getSession();
        List list=new ArrayList();
        try {
            Query query=session.createQuery("SELECT jadwal FROM Jadwal jadwal WHERE jadwal.semester= :input1 AND jadwal.matakuliah.fakultas= :input2")
            .setParameter("input1",semester).setParameter("input2",fakultas);
            list=query.setFirstResult(jadwalPerPage*(pageNumber-1))
            .setMaxResults(jadwalPerPage).list();
        } catch(Exception ex) {
            throw ex;
        }
        int beginPagePaging=pageNumber-5;
        int endedPagePaging=pageNumber+5;
        if(beginPagePaging<1) {
            beginPagePaging=1;
            endedPagePaging=11;
            if(endedPagePaging>totalPage) {
                endedPagePaging=totalPage;
            }
        } else if(endedPagePaging>totalPage) {
            endedPagePaging=totalPage;
            beginPagePaging=totalPage-10;
            if(beginPagePaging<1) {
                beginPagePaging=1;
            }
        }
        List listPaging=new ArrayList();
        for(int i=beginPagePaging;i<=endedPagePaging;i++) {
            listPaging.add(i);
        }
        objectPaging.setListObject(list);
        objectPaging.setListPaging(listPaging);
        objectPaging.setPageNumber(pageNumber);
        objectPaging.setTotalPage(totalPage);
        return objectPaging;
    }
    //=======PAGING=======
}