Java项目个人理财项目

package com.tarena.pfm.biz.impl; import java.util.Calendar; import java.util.Date; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.Transaction; import com.tarena.pfm.biz.WasteBookBiz; import com.tarena.pfm.entity.BookList; import com.tarena.pfm.entity.User; import com.tarena.pfm.entity.WasteBook; import com.tarena.pfm.util.HibernateSessionFactory; public class WasteBookBizImpl implements WasteBookBiz { public void addWasteBook(WasteBook wasteBook) { Session session = HibernateSessionFactory.getSession(); Transaction tran = null; try { tran = session.beginTransaction(); session.save(wasteBook); User user = wasteBook.getUser(); session.update(user); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } } @SuppressWarnings("unchecked") public List<BookList> findDebtBooksByDebtName(Integer userId, String debtName) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.debtType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and i.itemName = :debtName and (i.debtType = 'indebt' or i.debtType = 'outdebt')"; Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setString("debtName", debtName).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findDebtBooksInDaily(Integer userId, Calendar day) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.debtType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.bizDate = :day " + "and (i.debtType = 'indebt' or i.debtType = 'outdebt')"; Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setDate("day", day.getTime()).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findDebtBooksInMonth(Integer userId, Calendar month) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.debtType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.bizDate >= :monthStart and wb.bizDate <= :monthEnd " + "and (i.debtType = 'indebt' or i.debtType = 'outdebt')"; month.set(Calendar.DAY_OF_MONTH, 1); Date monthStart = month.getTime(); month.set(Calendar.DAY_OF_MONTH, this.getMaxMonthDays(month .get(Calendar.YEAR), month.get(Calendar.MONTH) + 1)); Date monthEnd = month.getTime(); Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setDate("monthStart", monthStart).setDate("monthEnd", monthEnd).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findDebtBooksInYear(Integer userId, int year) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.debtType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.bizDate >= :yearStart and wb.bizDate <= :yearEnd " + "and (i.debtType = 'indebt' or i.debtType = 'outdebt')"; Calendar cal = Calendar.getInstance(); cal.set(year, 0, 1, 0, 0, 0); Date yearStart = cal.getTime(); cal.set(Calendar.MONTH, 11); cal.set(Calendar.DAY_OF_MONTH, 31); Date yearEnd = cal.getTime(); Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setDate("yearStart", yearStart) .setDate("yearEnd", yearEnd).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findLifeBooksByItemName(Integer userId, String itemName) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.itemType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.item.itemName = :itemName " + "and (i.itemType = 'income' or i.itemType = 'outlay')"; Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setString("itemName", itemName).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findLifeBooksByMoney(Integer userId, double money, String operate) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.itemType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.money " + operate + " :money " + "and (i.itemType = 'income' or i.itemType = 'outlay')"; Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setDouble("money", money).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } @SuppressWarnings("unchecked") public List<BookList> findLifeBooksInDaily(Integer userId, Calendar day) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.itemType ) " + "from WasteBook wb left join wb.item i where wb.user.id = :userId " + "and wb.bizDate = :day " + "and (i.itemType = 'income' or i.itemType = 'outlay')"; Transaction tran = null; List<BookList> books = null; try { tran = session.beginTransaction(); books = session.createQuery(hql).setInteger("userId", userId) .setDate("day", day.getTime()).list(); tran.commit(); } catch (HibernateException e) { e.printStackTrace(); tran.rollback(); } finally { HibernateSessionFactory.closeSession(); } return books; } // has been test @SuppressWarnings("unchecked") public List<BookList> findLifeBooksInMonth(Integer userId, Calendar month) { Session session = HibernateSessionFactory.getSession(); String hql = "select new com.tarena.pfm.entity.BookList(wb.id, wb.bizDate, wb.money, i.itemName, wb.desc, i.itemTy