com.javaweb.service.ChuyenbayService.java Source code

Introduction

Here is the source code for com.javaweb.service.ChuyenbayService.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.javaweb.service;

import com.javaweb.hibernate.util.HibernateUtil;
import com.javaweb.model.Chuyenbay;
import java.util.ArrayList;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 *
 * @author DuongNguyen
 */
public class ChuyenbayService {

    //Cp nht Chuyn bay
    public boolean InsertChuyenbay(Chuyenbay cb) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

        try {
            tx = session.getTransaction();
            tx.begin();
            session.saveOrUpdate(cb);
            tx.commit();
            return true;
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
            System.out.println(e.toString());
        } finally {
            session.close();
        }
        return false;
    }

    //Xa Chuyn bay
    public boolean DeleteChuyenbay(int idCB) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

        try {
            tx = session.getTransaction();
            tx.begin();
            Chuyenbay cb = new Chuyenbay();
            cb.setIdchuyenbay(idCB);
            session.delete(cb);
            tx.commit();
            return true;
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
            System.out.println(e.toString());
        } finally {
            session.close();
        }
        return false;
    }

    //Tm kim chuyn bay theo yu cu khch hng
    public ArrayList<Chuyenbay> TimKiemChuyenbay(String Tu, String Den, String NgayKhoiHanh) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;
        ArrayList listChuyenbay = new ArrayList<Chuyenbay>();
        try {
            tx = session.getTransaction();
            tx.begin();
            Query query = session.createQuery("from Chuyenbay where " + "Tu like  '" + Tu + "' and " + "Den like '"
                    + Den + "' " + "and NgayKhoiHanh = '" + NgayKhoiHanh + "'");
            listChuyenbay = (ArrayList) query.list();
            tx.commit();
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
        return listChuyenbay;
    }

    //Ly Chuyn bay theo ID
    public Chuyenbay GetChuyenbayById(String ChuyenbayID) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

        try {
            tx = session.getTransaction();
            tx.begin();
            String strQuery = "from Chuyenbay where idchuyenbay = " + ChuyenbayID;
            Query query = session.createQuery(strQuery);
            Chuyenbay cb = (Chuyenbay) query.uniqueResult();
            tx.commit();
            return cb;
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
            System.out.println(e.toString());
        } finally {
            session.close();
        }
        return null;
    }

    public int chuyenbaycount = 0;

    //Ly tt c thng tin ti khon
    public ArrayList<Chuyenbay> GetAllChuyenbay(int pageSize, int pageNumber) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;
        ArrayList<Chuyenbay> listChuyenbay = new ArrayList<Chuyenbay>();
        try {
            tx = session.getTransaction();
            tx.begin();
            Query query = session.createQuery("from Chuyenbay");
            chuyenbaycount = query.list().size();
            query = query.setFirstResult(pageSize * (pageNumber - 1));
            query.setMaxResults(pageSize);
            listChuyenbay = (ArrayList) query.list();
            tx.commit();
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
        return listChuyenbay;
    }

    //Tm chuyn bay
    public ArrayList<Chuyenbay> SearchChuyenbay(int pageSize, int pageNumber, String Tu, String Den,
            String NgayKhoiHanh) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;
        ArrayList listChuyenbay = new ArrayList<Chuyenbay>();
        try {
            tx = session.getTransaction();
            tx.begin();
            Query query = session.createQuery("from Chuyenbay where " + "Tu like  '" + Tu + "' and " + "Den like '"
                    + Den + "' " + "and NgayKhoiHanh = '" + NgayKhoiHanh + "'");
            chuyenbaycount = query.list().size();
            query = query.setFirstResult(pageSize * (pageNumber - 1));
            query.setMaxResults(pageSize);
            listChuyenbay = (ArrayList) query.list();
            tx.commit();
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
        return listChuyenbay;
    }
}