src/com/fhd/dao/ItemsDao.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.ItemsBean;
import com.fhd.conn.DBConnection;

public class ItemsDao {
	
	/**
	 * @author FHD
	 * @param String filter
	 * @return list
	 * 通过filter条件查询items收支项目
	 */
	public static List getItems(String filter){
		Connection conn = DBConnection.getConnection();
		ResultSet rs = null;
		String sql = "select * from Items "+filter;
		ArrayList list = new ArrayList();
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				ItemsBean items = new ItemsBean();
				items.setItemsId(rs.getInt("itemsId"));
				items.setItemType(rs.getString("itemsType"));
				items.setItemDetails(rs.getString("itemsDetails"));
				list.add(items);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * @author FHD
	 * @param String filter
	 * @return list
	 * 通过id查找收支项目类型
	 */
	public static String getItemsTypeById(int itemsId) {
		String type = "";
		try {
			PreparedStatement pstmt = DBConnection.getConnection().prepareStatement("select itemsType from Items where itemsId ='"+ itemsId + "'");
			ResultSet rs = pstmt.executeQuery();
			if (rs.next()) {
				type = rs.getString("itemsType");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return type;