www.pudn.com > BeiJie.rar > CustomerCheckOper.java

package operation; 
 
import java.sql.ResultSet; 
import java.util.ArrayList; 
import java.util.Collection; 
 
import dataBase.DataBase; 
import entity.CustomerInfo; 
 
public class CustomerCheckOper 
{ 
	private DataBase db = null; 
	public CustomerCheckOper() 
	{ 
		db = new DataBase(); 
	} 
	public void close() 
	{ 
		db.close(); 
	} 
	public Collection getCustomerInfo() 
	{ 
		try 
		{ 
			Collection ret = new ArrayList(); 
			String sql = "select * from customerinfo"; 
			ResultSet rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
				CustomerInfo customerinfo = new CustomerInfo(); 
				customerinfo.setCustomerId(rs.getInt(	1)); 
				customerinfo.setCustomerNickName(rs.getString(2)); 
				customerinfo.setCustomerPassword(rs.getString(3)); 
				customerinfo.setCustomerName(rs.getString(4)); 
				customerinfo.setCustomeTex(rs.getString(5)); 
				customerinfo.setCustomerTel(rs.getString(6)); 
				customerinfo.setCustomerConn(rs.getString(7)); 
				customerinfo.setCustomerAddress(rs.getString(8)); 
				customerinfo.setCustomerBank(rs.getString(9)); 
				customerinfo.setCustomerAccount(rs.getString(10)); 
				customerinfo.setCustomerNotice(rs.getString(11)); 
				ret.add(customerinfo); 
			} 
			return ret; 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
			return null; 
		} 
	} 
}