productbean.java

一个简单的购物软件

package HW;
import java.sql.*;
import java.util.*;

import com.sun.corba.se.spi.orbutil.fsm.Guard.Result;

public class ProductBean {
	Product p;
	Connection conn;
	
	public Connection addProduct(Product product){
		conn = new DataBaseConnection().getConnection();
		try{
			PreparedStatement psm= conn.prepareStatement("insert into products values(?,?,?,?,?,?)");
			psm.setString(1,product.getProductid());
			psm.setString(2,product.getCategory());
			psm.setString(3,product.getName());
			psm.setString(4,product.getProducer());
			psm.setFloat(5,product.getPrice());
			psm.setString(6,product.getDescn());
			psm.executeUpdate();
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}
	public ArrayList getProductInfo(String categoryId)
	{
		ArrayList<Product> list = new ArrayList<Product>();
		Product product =new Product();
		
		try{
			Statement st=conn.createStatement();
			ResultSet rs=st.executeQuery("select productid,category,name,producer,price,descn from products where category='"+categoryId+"'");
			//PreparedStatement psm= conn.prepareStatement("select productid,category,name,producer,price,descn from products where category='"+categoryId+"'");
		    
		    while(rs.next()){
		    	product=new Product();
				product.setProductid(rs.getString("productid"));
				product.setCategory(rs.getString("category"));
				product.setName(rs.getString("name"));
				product.setProducer(rs.getString("producer"));
				product.setPrice(rs.getFloat("price"));
				product.setDescn(rs.getString("descn"));
			    conn.commit();
		    	list.add(product);
		    }
		
		}catch(Exception e){
			e.printStackTrace();
		}
		
		return list;
	}
	public Product getP() {
		return p;
	}

	public void setP(Product p) {
		this.p = p;
	}
	public ArrayList selectAll(){
		Product product;
		ResultSet rt = null;
		ArrayList<Product> lt=new ArrayList<Product>();
		try{
		Statement st = conn.createStatement();
		rt=st.executeQuery("select productid,category,name,producer,price,descn from products");
		while(rt.next()){
			product=new Product();
			product.setProductid(rt.getString("productid"));
			product.setCategory(rt.getString("category"));
			product.setName(rt.getString("name"));
			product.setProducer(rt.getString("producer"));
			product.setPrice(rt.getFloat("price"));
			product.setDescn(rt.getString("descn"));
		    conn.commit();
		    lt.add(product);
		}
		}catch(Exception e){
			e.printStackTrace();
		}
		return lt;
	}
	

}