src/com/fhd/dao/AccountDao.java

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

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

package com.fhd.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.fhd.bean.AccountBean;
import com.fhd.conn.DBConnection;

public class AccountDao {
	
	/**
	 * @author FHD
	 * @param filter
	 * @return list
	 * 通过filter条件得到账目列表
	 */
	public static List getAccount(String filter){
		Connection conn = DBConnection.getConnection();
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "select * from Account" + filter;
		List list = new ArrayList();
		try {
			pstmt = conn.prepareStatement(sql.trim());
			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"));
				list.add(account);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * @author FHD
	 * @param AccountBean bean
	 * @return boolean
	 * 添加一条账目
	 */
	public static boolean addAccount(AccountBean bean){
		boolean flag = false;
		Connection conn = DBConnection.getConnection();
		String sqls = "insert into Account(accountMoney,accountDetails,accountDate,itemsId,userId)  values (?,?,?,?,?)";
		try {
			PreparedStatement ptmt = conn.prepareStatement(sqls);
			ptmt.setFloat(1, bean.getAccountMoney());
			ptmt.setString(2, bean.getAccountDetails());
			ptmt.setString(3, bean.getAccountDate());