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