productdao.java

来自「用mvc实现购物车,简单使用,欢迎大家来下载啊」· Java 代码 · 共 73 行

package com.xaccp.db.dao;

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

import com.xaccp.db.DBManager;
import com.xaccp.entity.Product;

public class ProductDAO {
	//查询所有
	public ArrayList<Product> getAllProduct(){
		ArrayList<Product> list = new ArrayList<Product>();
		
		String sql = "select * from product";
		DBManager db = new DBManager();
		db.openDB();
		ResultSet rs = db.executeQuery(sql);
		try {
			while(rs != null && rs.next()){
				Product prod = new Product();
				prod.setProdNo(rs.getInt("prodNo"));
				prod.setProdName(rs.getString("prodName"));
				prod.setProdPrice(rs.getDouble("prodPrice"));
				prod.setProdCount(rs.getInt("prodCount"));
				prod.setProdState(rs.getString("prodState"));
				list.add(prod);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		db.closedDB();
		
		return list;
	}
	
	public Product getAProduct(int prodId){
		Product prod = new Product();
		String sql = "select * from product where prodNo=" + prodId;
		DBManager db = new DBManager();
		db.openDB();
		ResultSet rs = db.executeQuery(sql);
		
		try {
			if(rs != null && rs.next()){
				prod.setProdNo(rs.getInt("prodNo"));
				prod.setProdName(rs.getString("prodName"));
				prod.setProdPrice(rs.getDouble("prodPrice"));
				prod.setProdCount(rs.getInt("prodCount"));
				prod.setProdState(rs.getString("prodState"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		db.closedDB();
		return prod;
	}
}