com.javaweb.service.TintucService.java Source code

Introduction

Here is the source code for com.javaweb.service.TintucService.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.Tintuc;
import java.util.ArrayList;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

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

    //Ly tt c tin tc
    public ArrayList<Tintuc> GetAllTintuc() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;
        ArrayList<Tintuc> listTintuc = new ArrayList<Tintuc>();
        try {
            tx = session.getTransaction();
            tx.begin();

            Query query = session.createQuery("from Tintuc");
            listTintuc = (ArrayList) query.list();
            tx.commit();
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
            System.out.println("Error!" + e.toString());
        } finally {
            session.close();
        }
        return listTintuc;
    }

    //Thm or sa tin tc
    public boolean InsertTintuc(Tintuc tt) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

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

    //Get tin tc ID
    public Tintuc GetTintucID(int TintucID) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

        try {
            tx = session.getTransaction();
            tx.begin();
            tx.commit();

            String strQuery = "from Tintuc where idTinTuc =" + TintucID;
            Query query = session.createQuery(strQuery);
            Tintuc tintuc = (Tintuc) query.uniqueResult();
            return tintuc;
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
                System.out.println(e.toString());
            }
        } finally {
            session.close();
        }
        return null;
    }

    //Xa Tin Tc
    public boolean DeleteTintuc(int idtt) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;

        try {
            tx = session.getTransaction();
            tx.begin();
            Tintuc tt = new Tintuc();
            tt.setIdtintuc(idtt);
            session.delete(tt);
            tx.commit();
            return true;
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
            System.out.println(e.toString());
        } finally {
            session.close();
        }
        return false;
    }

    public int tintuccount = 0;

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

    //Tm tin tc
    public ArrayList<Tintuc> SearchTintuc(int pageSize, int pageNumber, String TintucKey) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = null;
        ArrayList listTintuc = new ArrayList<Tintuc>();
        try {
            tx = session.getTransaction();
            tx.begin();
            Query query = session.createQuery("from Tintuc where NgayDang = '" + TintucKey + "'");
            tintuccount = query.list().size();
            query = query.setFirstResult(pageSize * (pageNumber - 1));
            query.setMaxResults(pageSize);
            listTintuc = (ArrayList) query.list();
            tx.commit();
        } catch (Exception e) {
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
        return listTintuc;
    }
}