admindaoimpl.java

有简单的网上书店需求及设计流程

package org.wiely.dao.impl;

import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.wiely.dao.AdminDAO;
import org.wiely.vo.Admin;

public class AdminDAOImpl extends BaseDAO implements AdminDAO {

	// use log4j.jar to provide logger provices
	static Logger logger = Logger.getLogger(AdminDAOImpl.class);

	@SuppressWarnings("unchecked")
	@Override
	public Admin checkAdmin(Admin admin) throws Exception {
		Session session = getSession();
		Query query;

		String hql = "from Admin a where a.adminname =? and a.adminpassword = ?";

		query = session.createQuery(hql);
		query.setParameter(0, admin.getAdminname());
		query.setParameter(1, admin.getAdminpassword());

		List list = query.list();

		if (list.size() == 1) {
			Admin a = (Admin) list.get(0);
			session.close();
			return a;
		} else {
			session.close();
			return null;
		}
	}

	@SuppressWarnings("unchecked")
	@Override
	public boolean exitsAdmin(String adminname) throws Exception {
		Session session = getSession();
		Query query;
		Boolean flag;

		String hql = "from Admin a where a.adminname= '" + adminname + "'";

		query = session.createQuery(hql);

		List list = query.list();

		if (list.size() >=1) {
			flag = true;
			session.close();
			return flag;
		} else {
			flag = false;
			session.close();
			return flag;
		}

	}

	@SuppressWarnings("unchecked")
	@Override
	public boolean isMaxScore(int adminid) throws Exception {
		Session session = getSession();
		Query query;
		int i = maxScore();
		logger.info("maxScore："+i);

		String hql = "from Admin a where a.score=" + i+"and a.adminid ="+adminid;
		query = session.createQuery(hql);

		List list = query.list();	
 
		if (list.size()!=0) {
			session.close();
			return true;
		} else {
			session.close();
			return false;
		}

	}

	@SuppressWarnings("unchecked")
	public int maxScore() throws Exception {
		Session session = getSession();
		Query query;

		String hql = "select max(a.score) from Admin as a";
		query = session.createQuery(hql);
		List list = query.list();

		int i = (Integer) list.get(0);		
		session.close();
		return i;
	}	
	
	@SuppressWarnings("unchecked")
	public int score(int adminid)throws Exception{
		Session session =getSession();
		Query query ;
		
		String hql="select a.score from Admin as a where a.adminid="+adminid;
		query =session.createQuery(hql);
		List list =query.list();
		
		int i =(Integer)list.get(0);
		session.close();
		return i;
	}

	@Override
	public void register(Admin admin) throws Exception {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.save(admin);
		tx.commit();
		session.close();

	}

	@Override
	public void addScore(Admin admin) throws Exception {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.update(admin);
		tx.commit();
		session.close();
		
	}

}