src/com/fhd/dao/ReportDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.fhd.dao;

import java.sql.PreparedStatement;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import com.fhd.bean.*;
import com.fhd.conn.DBConnection;


public class ReportDao {
	
	/**
	 * @author FHD
	 * @param itemsId
	 * @param stDate
	 * @param edDate
	 * @return ReportBean
	 * 通过日期得到账单
	 */
	public static ReportBean getAccountByDate(String itemsId,String stDate,String edDate){
		ReportBean bean = new ReportBean();
		List accountList =new ArrayList();
		String filters ="";
		HashMap map = new HashMap();
		if(!itemsId.equals("")){
			filters = "itemsId = "+itemsId+" and";
			String sumMoney = "";
			String getSumById = "select sum(accountMoney) as sumMoney from Account where itemsId="+itemsId;
			try {
				PreparedStatement pstmt = DBConnection.getConnection().prepareStatement(getSumById);
				ResultSet rs = pstmt.executeQuery();
				sumMoney = rs.getString(1);
				map.put("sumMoney", sumMoney);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		String sqls = "select * from Account where "+filters+" accountDate  between '"+stDate+"' and '"+edDate+"'";
		try {
			PreparedStatement pstmt = DBConnection.getConnection().prepareStatement(sqls);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				AccountBean account = new AccountBean();
				account.setAccountId(rs.getInt("accountId"));
				account.setAccountMoney(rs.getFloat("accountMoney"));
				account.setAccountDetails(rs.getString("accountDetails"));
				account.setAccountDate(rs.getString("accountDate"));
				account.setItemsId(rs.getInt("itemsId"));
				account.setUserId(rs.getInt("userId"));
				accountList.add(account);	
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}