providercheckoper.java

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

package operation;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

import dataBase.DataBase;
import entity.Provider;

public class ProviderCheckOper
{
	private DataBase db = null;
	public ProviderCheckOper()
	{
		db = new DataBase();
	}
	public void close()
	{
		db.close();
	}
	
	public Collection getProviderInfo()
	{
		try
		{
			Collection ret = new ArrayList();
			String sql = "select * from providerinfo";
			ResultSet rs = db.getResult(sql);
			while(rs.next())
			{
				Provider provider = new Provider();
				provider.setProviderId(rs.getInt(1));
				provider.setProviderName(rs.getString(2));
				provider.setProviderTex(rs.getString(3));
				provider.setProviderTel(rs.getString(4));
				provider.setProviderConn(rs.getString(5));
				provider.setProviderAddress(rs.getString(6));
				provider.setProviderBank(rs.getString(7));
				provider.setProviderAccount(rs.getString(8));
				provider.setProviderNotice(rs.getString(9));
				ret.add(provider);
				
			}
			rs.close();
			db.close();
			return ret;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
}