moneyclassda.java

医药供应链管理系统

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return tmp;
	}
	/**
	 * 现金费用单，通过ID返回该单bean
	 * @param m_id
	 * @return
	 */
	public AccountlistBean showAccountlist(int m_id){
		AccountlistBean bean = null;
		String sql = "SELECT money.m_time, money.m_mbc_type, msmallclass.msc_name, bank.b_name, money.m_amount, money.m_note, login.l_name " +
				"FROM money INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_id = ?";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistBean();
				bean.setM_time(rs.getString("m_time"));
				bean.setM_mbc_type(rs.getInt("m_mbc_type"));
				bean.setMsc_name(rs.getString("msc_name"));
				bean.setB_name(rs.getString("b_name"));
				bean.setM_amount(rs.getDouble("m_amount"));
				bean.setM_note(rs.getString("m_note"));
				bean.setL_name(rs.getString("l_name"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return bean;
	} 
	/**
	 * 帐务查询返回集合
	 * @return
	 */
	public ArrayList showMoney(){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"ORDER BY m_time desc";
		try {
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务小类m_msc_id返回集合
	 * @param m_msc_id
	 * @return
	 */
	public ArrayList showMoneyByM_msc_id(int m_msc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_msc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_msc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务大类m_mbc_id返回集合
	 * @param m_mbc_id
	 * @return
	 */
	public ArrayList showMoneyByM_mbc_id(int m_mbc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_mbc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_mbc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务大类m_mbc_id和帐务小类m_msc_id返回集合
	 * @param m_mbc_id
	 * @param m_msc_id
	 * @return
	 */
	public ArrayList showMoneyByM_mbc_idAndM_msc_id(int m_mbc_id, int m_msc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_mbc_id = ? AND m_msc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_mbc_id);
			pstmt.setInt(2, m_msc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过银行m_b_id返回集合
	 * @param m_b_id
	 * @return
	 */
	public ArrayList showMoneyByM_b_id(int m_b_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_b_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_b_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过银行帐务m_b_id和帐务小类m_msc_id返回集合
	 * @param m_b_id
	 * @param m_msc_id
	 * @return
	 */
	public ArrayList showMoneyByM_b_idAndM_msc_id(int m_b_id, int m_msc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_b_id = ? AND m_msc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_b_id);
			pstmt.setInt(2, m_msc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过银行m_b_id和帐务大类m_mbc_id返回集合
	 * @param m_b_id
	 * @param m_mbc_id
	 * @return
	 */
	public ArrayList showMoneyByM_b_idAndM_mbc_id(int m_b_id, int m_mbc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_b_id = ? AND m_mbc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_b_id);
			pstmt.setInt(2, m_mbc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过银行m_b_id和帐务大类m_mbc_id和帐务小类m_msc_id返回集合
	 * @param m_b_id
	 * @param m_mbc_id
	 * @param m_msc_id
	 * @return
	 */
	public ArrayList showMoneyByM_b_idAndM_mbc_idAndM_msc_id(int m_b_id, int m_mbc_id, int m_msc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_b_id = ? AND m_mbc_id = ? AND m_msc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_b_id);
			pstmt.setInt(2, m_mbc_id);
			pstmt.setInt(3, m_msc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务类型m_mbc_type返回集合
	 * @param m_mbc_type
	 * @return
	 */
	public ArrayList showMoneyByM_mbc_type(int m_mbc_type){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_mbc_type = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_mbc_type);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务类型m_mbc_type和帐务小类m_msc_id返回集合
	 * @param m_mbc_type
	 * @param m_msc_id
	 * @return
	 */
	public ArrayList showMoneyByM_mbc_typeAndM_msc_id(int m_mbc_type, int m_msc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_mbc_type = ? AND m_msc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_mbc_type);
			pstmt.setInt(2, m_msc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务类型m_mbc_type和帐务大类m_mbc_id返回集合
	 * @param m_mbc_type
	 * @param m_mbc_id
	 * @return
	 */
	public ArrayList showMoneyByM_mbc_typeAndM_mbc_id(int m_mbc_type, int m_mbc_id){
		ArrayList arry = new ArrayList();
		AccountlistShowBean bean = null;
		String sql = "SELECT money.m_id, money.m_mbc_type, mbigclass.mbc_name, msmallclass.msc_name, login.l_name, money.m_time, bank.b_name, money.m_amount " +
				"FROM money INNER JOIN mbigclass ON money.m_mbc_id = mbigclass.mbc_id INNER JOIN msmallclass ON money.m_msc_id = msmallclass.msc_id AND " +
				"mbigclass.mbc_id = msmallclass.msc_mbc_id INNER JOIN bank ON money.m_b_id = bank.b_id INNER JOIN login ON money.m_l_id = login.l_id " +
				"WHERE m_mbc_type = ? AND m_mbc_id = ? ORDER BY m_time desc";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, m_mbc_type);
			pstmt.setInt(2, m_mbc_id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				bean = new AccountlistShowBean(rs.getInt("m_id"), rs.getInt("m_mbc_type"), rs.getString("mbc_name"), rs.getString("msc_name"), rs.getString("l_name"), rs.getString("m_time"), rs.getString("b_name"), rs.getDouble("m_amount"));
				arry.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return arry;
	}
	/**
	 * 通过帐务类型m_mbc_type和帐务大类m_mbc_id和帐务小类m_msc_id返回集合
	 * @param m_mbc_type
	 * @param m_mbc_id