customerdao.java

struts+Spring+Hibernate经典入门源码

package com.softeem.customer.model;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import com.softeem.customer.pojo.Customers;

public class CustomerDAO {

	private SessionFactory sessionFactory;

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}

	public List findAll(String hql,int page ,int pageSize) {
		List list = new ArrayList();
		int first = (page-1)*pageSize;
		Session session = sessionFactory.openSession();
		Query query = session.createQuery(hql).setFirstResult(first).setMaxResults(pageSize);
		list = query.list();
		session.close();
		return list;
	}

	public int getRecordsNum(String hql)
	{
		Session session = sessionFactory.openSession();
		Query query = session.createQuery(hql);
		long num =  (Long) query.uniqueResult();
		session.close();
		return (int)num;

	}
	public Customers findById(int id) {
		Customers pojo = new Customers();
		Session session = sessionFactory.openSession();
		pojo = (Customers) session.get(Customers.class, id);
		session.close();
		return pojo;
	}

	public void save(Customers cus) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		session.save(cus);
		tran.commit();
		session.close();

	}

	public void update(Customers cus) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		session.update(cus);
		tran.commit();
		session.close();

	}

	public void delete(String[] ids) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		for (int i = 0; i < ids.length; i++) {
			// Customers pojo=(Customers) session.get(Customers.class,
			// Integer.parseInt(ids[i]));
			Customers pojo = new Customers();
			pojo.setId(Integer.parseInt(ids[i]));
			session.delete(pojo);
		}
		tran.commit();
		session.close();
	}

	public static void main(String[] args) {
//		CustomerDAO dao = new CustomerDAO();
//		List list = dao.findAll();
//		System.out.println(list.size());
	}
}