package Bean;

import Action.WareObj;

import java.util.ArrayList;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

/*
 * Created by IntelliJ IDEA.
 * User: ZhangRui
 * Date: 2007-10-26
 * Time: 9:52:44
*/
public class WareListBean {
    public ArrayList WareList(){
        ArrayList arr = new ArrayList();
        try {
            Connection conn = DatabaseConn.getConnection();
            ResultSet rs=null;
            String sql = "select * from shop";
            PreparedStatement smt = conn.prepareStatement(sql);
            rs = smt.executeQuery();
            while (rs.next()) {
                WareObj wareObj = new WareObj();
                wareObj.setWareName(rs.getString("wareName"));
                wareObj.setWareNum(rs.getInt("WareNum"));
                wareObj.setWarePrice(rs.getDouble("WarePrice"));
                arr.add(wareObj);
            }
            rs.close();
            conn.close();
        } catch (Exception e) {
            System.out.println(e.toString());
        }
        return arr;
    }
}