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;
}