www.pudn.com > BeiJie.rar > 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中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			// e.printStackTrace(); 
			e.printStackTrace(); 
			System.out.println("getOrderArrayList³ö´í "); 
		} 
		return null; 
	} 
	 
	public OrderCheckBean listData(String page,String starttime,String endtime) throws Exception 
	{ 
		int pageNum = Integer.parseInt(page); 
		System.out.println(starttime); 
		String rowsql = "select count(*) from ordercheckview where OrderDate between '"+starttime+"' and '"+endtime+"'"; 
		ResultSet rst = db.getResult(rowsql); 
		while(rst.next()) 
		{ 
			totalrows = rst.getInt(1); 
		} 
		OrderCheckBean ocb = new OrderCheckBean(this); 
		String sql = "select * from ordercheckview where OrderDate between '"+starttime+"' and '"+endtime+"'"+" limit "+0+","+pageNum*ocb.rowsPerPage; 
		ResultSet rs = db.getResult(sql); 
		int i = 0; 
		while(rs.next()) 
		{ 
			if(i>(pageNum-1)*ocb.rowsPerPage-1) 
			{ 
				Object[] obj = new Object[9]; 
				obj[0] = rs.getString(1); 
				obj[1] = rs.getString(2); 
				obj[2] = rs.getString(3); 
				obj[3] = rs.getString(4); 
				obj[4] = rs.getString(5); 
				obj[5] = rs.getString(6); 
				obj[6] = rs.getString(7); 
				obj[7] = rs.getString(8); 
				obj[8] = rs.getString(9); 
				 
				 
				v.add(obj); 
			} 
			i++; 
		} 
		rs.close(); 
		rst.close(); 
		db.close(); 
		ocb.curPage=pageNum; 
		 
		ocb.data=v; 
		return ocb; 
	} 
	 
	public Vector getResult() throws Exception 
	{ 
		return v; 
	} 
 
}