901ccd7aea18001e1aa3f6da0f9d7068

来自「网上购物系统」· 代码 · 共 42 行

package com.cric.onlineshopclothes.dao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cric.onlineshopclothes.util.DBUtils;


public class CustomerDAO {
	public List getProductList(){
		DBUtils db=new DBUtils();
		ResultSet rs=null;
		List list=new ArrayList();
		
		String sqlStr="select * from customer";
		try{
			rs=db.excuteQuery(sqlStr);
			while(rs.next()){
				Customer product=new Customer();
				product.setPid(rs.getInt("pid"));
				product.setProductName(rs.getString("productName"));
				product.setProductDetail(rs.getString("productDetail"));
				product.setProductPrice(rs.getFloat("productPrice"));
				product.setProductAmount(rs.getInt("productAmount"));
				product.setProductPic(rs.getString("productPic"));
				product.setProductState(rs.getInt("productState"));
				list.add(product);
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return 	list;
	}

}