defaultaccountbookdaoimpl.java

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

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

import java.util.Date;
import java.util.Iterator;
import java.util.List;

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;

public class DefaultAccountBookDaoImpl extends HibernateDaoSupport implements IAccountBookDao {

	public List<AccountBook> getAccountBooks() {
		return (List)this.getHibernateTemplate().find("from AccountBook");
	}

	public List<AccountBook> getAccountBooksByUser(String userId) {
		return (List)this.getHibernateTemplate().find("from AccountBook where payUserId='"+userId+"'");
	}
	
	public boolean saveAccountBook(AccountBook accountBook){
		accountBook.setAccountDate(new Date());
		try{
			this.getHibernateTemplate().save(accountBook);
		}catch(Exception e){
			e.printStackTrace();
		}
		return true;
	}

	public AccountBook getAccountBookByPrimary(Integer id) {
		// TODO Auto-generated method stub
		AccountBook accountBook = null;
		try{
			Session session=this.getHibernateTemplate().getSessionFactory() .openSession();
			accountBook = (AccountBook)session.get(AccountBook.class, id);
			//this.getHibernateTemplate().initialize(accountBook.getAccountDetails());
			logger.debug("accountBook getId:"+accountBook.getId());
			logger.debug("accountBook getAccountBill:"+accountBook.getAccountBill());
			logger.debug("accountBook getAccountDate:"+accountBook.getAccountDate());
			logger.debug("accountBook getAccountDetails:"+accountBook.getAccountDetails());
			//logger.debug("accountBook id:"+accountBook.getId());
			session.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		return accountBook;
	}

	public List<AccountBook> getAccountBooksByPaid(String paid) {
		// TODO Auto-generated method stub
		List accountBooks = null;
		try{
			Session session=this.getHibernateTemplate().getSessionFactory().openSession();
			Query query = session.createQuery("from AccountBook where paid ='" + paid + "'");
			accountBooks = query.list();
			Iterator it = accountBooks.iterator();
			while(it.hasNext()){
				AccountBook accountBook = (AccountBook)it.next();
				logger.debug("accountBook getId:"+accountBook.getId());
				logger.debug("accountBook getAccountBill:"+accountBook.getAccountBill());
				logger.debug("accountBook getAccountDate:"+accountBook.getAccountDate());
				logger.debug("accountBook getAccountDetails:"+accountBook.getAccountDetails());
			}
			session.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		return accountBooks;
		
	}

}