package cn.register.product;
import  cn.register.Factory;
import  java.util.ArrayList;
import  java.util.Iterator;
//import  java.sql.*;
import  cn.register.db.DBConnect;

public class SqlProduct extends AbstractProduct{
	
	public Iterator getProducts(){
		ArrayList<Object> arraylist = new ArrayList<Object>();
		//Product product = Factory.getInstance().initProduct();       //語句1
		String str = "select * from products";
		try{
			DBConnect dbconnect = new DBConnect();
            dbconnect.excuteQuery(str);
			while(dbconnect.next()){
				Product product = Factory.getInstance().initProduct();   //語句2    注此語句不能放在語句1處
				product.setProduct_id(dbconnect.getInt(1));
				product.setProduct_name(dbconnect.getString(2));
				product.setPrice(dbconnect.getFloat(3));
				product.setDescription(dbconnect.getString(4));			
				arraylist.add(product);
			}	
			return arraylist.iterator();
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}
	}
}

       //這是因為java se 5.0新增加了對泛型的支持,在使用vector的時候要求你指明存儲內(nèi)容的類型
		//java.util.Vector<String> vectorComment = new java.util.Vector<String>();
       //如： Vector<Object>  vectorComment = new Vector<Object>();