reservedaoimpl.java

超市进销存系统,采用mvc+DAO模式编写

package mybaobao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;

public class ReserveDAOImpl implements ReserveDAO {

	public List getlist() throws Exception {
		List list=new ArrayList();
		String sql =
			"SELECT WareID,ResQty from reserve" ;
		PreparedStatement pstmt = null ;
		DBConnection dbc = new DBConnection();
		
		try
		{
			pstmt = dbc.getConnection().prepareStatement(sql) ;
			ResultSet rs = pstmt.executeQuery() ;
			while(rs.next())
			{
				Reserve reserve=new Reserve();
				reserve.setWareId(rs.getInt(1));
				reserve.setResQty(rs.getInt(2));
				list.add(reserve) ;
			}
			rs.close() ;
			pstmt.close() ;
		}
		catch (Exception e)
		{
			System.out.println(e) ;
			
		}
		finally
		{
			dbc.close() ;
		}
		return list ;
	}

}