defaultaccountdetaildaoimpl.java

因为许多人出去吃饭都一个人付帐

package cn.com.sdcncsi.lunch.balance.dao;

import java.util.Collection;
import java.util.Iterator;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cn.com.sdcncsi.lunch.balance.domain.AccountBook;
import cn.com.sdcncsi.lunch.balance.domain.AccountDetail;
import cn.com.sdcncsi.lunch.domain.User;
import cn.com.sdcncsi.lunch.utils.Constants;

public class DefaultAccountDetailDaoImpl extends HibernateDaoSupport implements IAccountDetailDao {

	private static Log logger = LogFactory.getLog(DefaultAccountDetailDaoImpl.class.getName());
	
	
	public Collection<AccountDetail> getAccountDetails(String accountId) {
		String hql = "from AccountDetail where accountId = '"+accountId+"'";
		return this.getHibernateTemplate().find(hql);
	}

	public boolean saveAccountDetail(AccountDetail accountDetail) {
		logger.debug("saveAccountDetail");
		this.getHibernateTemplate().save(accountDetail);
		return true;
	}

	public boolean saveAccountDetails(Collection<AccountDetail> accountDetails) {
		logger.debug("accountDetails:"+accountDetails.size());
		for(AccountDetail accountDetail : accountDetails){
			saveAccountDetail(accountDetail);
		}
		return true;
	}

	public Collection<AccountDetail> getAccountDetailByUser(User user) {
		return getAccountDetailByUser(user, Constants.NOPAID);
	}
	
	private Collection<AccountDetail> getAccountDetailByUser(User user, String paid){
		// TODO Auto-generated method stub
		Session session = getHibernateTemplate().getSessionFactory().openSession();
		String hql = "select a from AccountDetail a, AccountBook b where a.user = '" + user.getId() + "' and a.accountBook = b.id and b.paid = '" + paid + "' order by a.id";
		Query query = session.createQuery(hql);
		Collection co = query.list();
		Iterator it = co.iterator();
		while(it.hasNext()){
//			Object[] obja = (Object[])it.next();
//			AccountDetail accountDetail = (AccountDetail)obja[0];
//			AccountBook accountBook = (AccountBook)obja[1];
			AccountDetail accountDetail = (AccountDetail)it.next();
			logger.debug("init lazy manual accountBook:"+accountDetail.getAccountBook().getUser().getUserId());
			logger.debug("init lazy manual user:"+accountDetail.getUser().getUserId());
		}
		session.close();
		return co;
	}

}