www.pudn.com > BeiJie.rar > ProductOperation.java

package operation; 
 
import dataBase.DataBase; 
import java.util.ArrayList; 
import java.util.Collection; 
import entity.*; 
import java.sql.*; 
 
public class ProductOperation 
{ 
	public ProductOperation() 
	{ 
		db = new DataBase(); 
	} 
	 
	//获得供应商编号 
	public int addProviderId(String providername) 
	{ 
		try 
		{ 
			sql1 = "select * from ProviderInfo where ProviderName = '"+providername+"'"; 
			rs = db.getResult(sql1); 
			while(rs.next()) 
			{ 
				String providerIDTemp = rs.getString("ProviderID"); 
				providerID = Integer.parseInt(providerIDTemp); 
			} 
		} 
		catch(SQLException e) 
		{ 
			e.printStackTrace(); 
		} 
		return providerID; 
	} 
	 
	//获取商品编号 
	public int addProductId() 
	{ 
		try 
		{ 
			sql2 = "select * from ProductInfo"; 
			rs = db.getResult(sql2); 
			rs.last(); 
			productID = rs.getRow()+1; 
		} 
		catch(SQLException e) 
		{ 
			e.printStackTrace(); 
		} 
		return productID; 
	} 
	 
	//录入商品信息 
	public void addProductInfo(boolean flag,int productID,int providerID,String productName,String productSign,String productType,String productRegulate,String productTax,String productPlace,String productNotice) 
	{ 
		if (flag == true) 
		{ 
			sql3 = "insert into ProductInfo values('"+productID+"','"+providerID+"','"+productName+"','"+productSign+"','"+productType+"','"+productRegulate+"','"+productTax+"','"+productPlace+"','"+productNotice+"')"; 
			db.ExeQuery(sql3); 
		} 
	} 
	public void productModify(boolean flag,int productID,int providerID,String productName,String productSign,String productType,String productRegulate,String productTax,String productPlace,String productNotice) 
	{ 
		if(flag==true) 
		{ 
			sql3 = "update ProductInfo set providerID='"+providerID+"',productName='"+productName+"',productSign='"+productSign+"',productType='"+productType+"',productRegulate='"+productRegulate+"',productTax='"+productTax+"',productPlace='"+productPlace+"',productNotice='"+productNotice+"'where productID="+productID; 
			db.ExeQuery(sql3); 
		} 
	} 
	//关闭连接 
	public void close() 
	{ 
		db.close(); 
	} 
	public void shut() 
	{ 
		db.shut(); 
	} 
	private DataBase db = null; 
	private String sql1 = ""; 
	private String sql2 = ""; 
	private String sql3 = ""; 
	private ResultSet rs = null; 
	private int providerID = 0; 
	private int productID = 0; 
}