balancedao.java

仓库管理系统,适合各种行业的仓库管理系统

package com.bean.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.bean.DTO.BalanceDTO;
import com.bean.DTO.StockDTO;

public class BalanceDAO {
	private Connection con;
	private List<BalanceDTO> list=new ArrayList<BalanceDTO>();
	private PreparedStatement ps;
	
	public BalanceDAO(Connection con){
		this.con=con;
	}
	public List<BalanceDTO> getAll(){
		list.clear();
		try {
			ps=con.prepareStatement("select * from balance");
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
				BalanceDTO pd=new BalanceDTO();
				pd.setDepID(rs.getInt(1));
				pd.setBalance(rs.getFloat(2));
				list.add(pd);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
}