provideroperation.java

该源代码实现了系统的进货

package operation;

import dataBase.DataBase;
import java.util.ArrayList;
import java.util.Collection;
import entity.*;
import java.sql.*;

public class ProviderOperation
{
	public ProviderOperation()
	{
		db = new DataBase();
	}
	
	//获取供应商编号
	public int addProviderId()
	{
		try
		{
			sql1 = "select * from ProviderInfo";
			rs = db.getResult(sql1);
			rs.last();
			providerID = rs.getRow()+1;
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		return providerID;
	}
	
	//录入供应商信息
	public void addProviderInfo(boolean flag,int providerid,String providername,String providertax,String providertel,String providerconn,String provideraddress,String providerbank,String provideraccount,String providernotice)
	{
		if (flag == true)
		{
			sql2 = "insert into ProviderInfo values('"+providerid+"','"+providername+"','"+providertax+"','"+providertel+"','"+providerconn+"','"+provideraddress+"','"+providerbank+"','"+provideraccount+"','"+providernotice+"')";
			db.ExeQuery(sql2);
		}
	}
	public void providerModify(boolean flag,int providerid,String providername,String providertax,String providertel,String providerconn,String provideraddress,String providerbank,String provideraccount,String providernotice)
	{
		 if(flag==true)
		 {
		  sql2 = "update ProviderInfo set providername='"+providername+"',providertax='"+providertax+"',providertel='"+providertel+"',providerconn='"+providerconn+"',provideraddress='"+provideraddress+"',providerbank='"+providerbank+"',provideraccount='"+provideraccount+"',providernotice='"+providernotice+"'where providerid="+providerid;
		  db.ExeQuery(sql2);
		 }
	}
	//关闭连接
	public void close()
	{
		db.close();
	}
	public void shut()
	{
		db.shut();
	}
	
	private DataBase db = null;
	private String sql1 = "";
	private String sql2 = "";
	private ResultSet rs = null;
	private int providerID = 0;
}