orderlistcheckoperation.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.OrderCheckBean;
import entity.OrderListCheck;
import entity.PageBean;

public class OrderListCheckOperation
{
	private ResultSet rs = null;

	private ArrayList list = null;

	private String sql = "";

	private DataBase db = null;
	
	Vector v;
	
	public int totalrows;
	public OrderListCheckOperation()
	{
		db = new DataBase();
		v = new Vector();
	}

	/**
	 * @param shouldpayid
	 * @return
	 */
	public ArrayList getOrderArrayList(String starttime,String endtime)
	{
		list = new ArrayList();
		sql = "select * from ordercheckview where OrderDate between '"+starttime+"' and '"+endtime+"'";
		System.out.println(sql);
		try
		{
			rs = db.getResult(sql);
			while (rs.next())
			{
				String orderID = rs.getString("OrderID");
				int productID = rs.getInt("ProductID");
				int customerID = rs.getInt("CustomerID");
				int orderQuantity = rs.getInt("OrderQuantity");
				Date orderDate = rs.getDate("orderDate");
				String orderNotice = rs.getString("OrderNotice");
				String orderState = rs.getString("OrderState");
				String productName = rs.getString("ProductName");
				String customerName = rs.getString("CustomerName");
				OrderListCheck ordercheckview = new OrderListCheck(orderID,
						productID, customerID, orderQuantity, orderDate,
						orderNotice, orderState, productName, customerName);
				list.add(ordercheckview);
			}
			rs.close();
			db.close();// 鍏抽棴DB涓