productdaoimpl.java

一个经典购物车（shoppingcart）实例代码

package com.jpioneer.application.product.dao.impl;

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

import com.jpioneer.application.book.domain.Book;
import com.jpioneer.application.product.dao.ProductDao;
import com.jpioneer.application.product.domain.Product;
import com.jpioneer.application.util.DBCon;

public class ProductDaoImpl implements ProductDao {

	public List listAllProducts() throws Exception {
		List list =new ArrayList();
		Connection con=DBCon.getCon();
		String sql="select * from product";
		PreparedStatement stm=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
		ResultSet rs=stm.executeQuery();
		Product p=null;
		while (rs.next()){
			int productId=rs.getInt("productId");
			String productName=rs.getString("productName");
			double price=rs.getDouble("price");
			double stock=rs.getDouble("stock");
			String unit=rs.getString("unit");
			p=new Product();
			p.setProductId(productId);
			p.setProductName(productName);
			p.setPrice(price);
			p.setStock(stock);
			p.setUnit(unit);			
			list.add(p);
		}
		return list;
	}

}