sqlproduct.java

jsp入门级代码

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

public class SqlProduct extends AbstractProduct{
	
	public Iterator getProducts(){
		ArrayList arraylist = new ArrayList();
		Product product = Factory.getInstance().initProduct();
		String str = "select * from products";
		try{
			DBConnect dbconnect = new DBConnect();
			dbconnect.excuteQuery(str);
			while(dbconnect.next()){
				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;
		}
	}
}