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;
		}
	}
}