model.dao.CustomerDAO.java Source code

Introduction

Here is the source code for model.dao.CustomerDAO.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 model.dao;

import java.util.*;
import javax.transaction.Transactional;
import model.pojo.*;
import model.util.HibernateUtil;
import org.hibernate.*;
import org.hibernate.criterion.Disjunction;
import org.hibernate.criterion.Restrictions;

/**
 *
 * @author rin
 */
public class CustomerDAO {
    //lay danh sach customer
    public static List<Customer> getlist() {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        List<Customer> lst = new ArrayList<Customer>();

        try {
            s.beginTransaction();
            lst = s.createCriteria(Customer.class).list();

            s.getTransaction().commit();
        } catch (Exception e) {
            e.printStackTrace();
        }

        return lst;
    }

    //tao moi customer
    public void create(Customer e) {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            s.beginTransaction();
            s.save(e);
            s.getTransaction().commit();
        } catch (Exception ex) {
            ex.printStackTrace();
            s.getTransaction().rollback();
        }
    }

    //xoa customer
    public void remove(Customer e) {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            s.beginTransaction();
            s.delete(e);
            s.getTransaction().commit();
        } catch (Exception ex) {
            ex.printStackTrace();
            s.getTransaction().rollback();
        }
    }

    //sua customer
    public void edit(Customer e) {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            s.beginTransaction();
            s.update(e);
            s.getTransaction().commit();
        } catch (Exception ex) {
            ex.printStackTrace();
            s.getTransaction().rollback();
        }
    }

    //lay customer order tu customerId
    public Customer getCus(int customerId) {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        Customer e = new Customer();
        try {
            s.beginTransaction();
            e = (Customer) s.get(Customer.class, customerId);
            s.getTransaction().commit();
        } catch (Exception ex) {
            ex.printStackTrace();
            s.getTransaction().rollback();
        }
        return e;
    }

    //tim kiem tat ca 
    public List<Customer> findAll(String key) {
        Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        List<Customer> lst = new ArrayList<Customer>();
        try {
            s.getTransaction().begin();

            Criteria criteria = s.createCriteria(Customer.class);
            Disjunction disCriteria = Restrictions.disjunction();
            disCriteria.add(Restrictions.like("name", "%" + key + "%"));
            disCriteria.add(Restrictions.like("telNumber", "%" + key + "%"));
            criteria.add(disCriteria);
            lst = criteria.list();
            //xy ly truy van 
            s.getTransaction().commit();
            return lst;
        } catch (Exception ex) {
            ex.printStackTrace();
            s.getTransaction().rollback();
            return null;
        }

    }
}