sqlproduct.java

mysql+连接池+JavaBean 实现用户注册登陆系统

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的时候要求你指明存储内容的类型
		//java.util.Vector<String> vectorComment = new java.util.Vector<String>();
       //如： Vector<Object>  vectorComment = new Vector<Object>();