visitordaoimpl.java

来自「有简单的网上书店需求及设计流程」· Java 代码 · 共 65 行

package org.wiely.dao.impl;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.wiely.dao.VisitorDAO;
import org.wiely.vo.Visitor;

public class VisitorDAOImpl extends BaseDAO implements VisitorDAO {

	@SuppressWarnings("unchecked")
	@Override
	public List getVisitors(int currentPage,int pageSize) throws Exception {
		Session session = getSession();
		Query query;
		List l = new ArrayList();
		
		String hql = "from Visitor v";
		query = session.createQuery(hql);
		int startRow =(currentPage-1)*pageSize;
		query.setFirstResult(startRow);
		query.setMaxResults(pageSize);
		List list =query.list();
		
		for(int i=0;i<list.size();i++){
			Visitor v = new Visitor();
		     v=(Visitor)list.get(i);
		     l.add(v);
		}
		session.close();
		
		return l;
	}

	@Override
	public void insertVisitor(Visitor visitor) throws Exception {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.save(visitor);
		tx.commit();
		session.close();

	}

	@SuppressWarnings("unchecked")
	@Override
	public int getTotalRecords() throws Exception {
		Session session = getSession();
		Query query;
		
		String hql = "from Visitor v";
		query=session.createQuery(hql);
		
		List list =query.list();		
		int totalSize = list.size();
		
		session.close();
		return totalSize;
	}

}