entercheckoperation.java

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

package operation;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.Vector;

import dataBase.DataBase;
import entity.EnterCheckView;
import entity.EnterPageBean;

public class EnterCheckOperation
{

	private ResultSet rs = null;

	private ArrayList list = null;

	private String sql = "";

	private DataBase db = null;
	
	Vector v;
	
	public int totalrows = 0;

	public EnterCheckOperation()
	{
		db = new DataBase();
		v = new Vector();
	}
	
	
	
	public ArrayList getEnterCheckArrayList(String starttime,String endtime)
	{
		list = new ArrayList();
		sql = "select * from enterinfocheckview where EnterDate between '"+starttime+"' and '"+endtime+"'"; 
		try
		{
			rs = db.getResult(sql);
			while (rs.next())
			{
				String enterID = rs.getString(1);// 杩涜揣缂栧彿
				int productID = rs.getInt(2);// 鍟嗗搧缂栧彿
				int enterQuantity = rs.getInt(3);// 杩涜揣鏁伴噺
				float enterPrice = rs.getFloat(4);// 杩涜揣鍗曚环
				float enterSum = rs.getFloat(5);// 杩涜揣閲戦