www.pudn.com > BeiJie.rar > 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; 
}