orderlistbean.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;

public class OrderListBean 
{
	private ArrayList orderList = new ArrayList();
	
	public OrderListBean()
	{
		//default
	}
	
	//得到所有订购的定单
	public ArrayList getOrderList(String username)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			String query = "select * from orderbyuser where username like '"+username+"'";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				int ordernum = rs.getInt("ordernum");
				String pesticidename = rs.getString("pesticidename");
				int qty = rs.getInt("qty");
				String orderdate = rs.getString("orderdate");
				Order aOrder = new Order(ordernum,pesticidename,qty,orderdate);
				orderList.add(aOrder);
			}
			
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());		
		} catch (Exception e) {
			System.out.println(e.toString());
		}
		
		return orderList;
	}
	
	public ArrayList GetOrderByAdmin(String start,String end)
	{
		ArrayList aArrayList = new ArrayList();
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			String query = "select * from orderbyuser where orderdate > '"+start+"'" +
					" and orderdate <'"+end+"'";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				int ordernum = rs.getInt("ordernum");
				String pesticidename = rs.getString("pesticidename");
				int qty = rs.getInt("qty");
				String orderdate = rs.getString("orderdate");
				String username = rs.getString("username");
				Order aOrder = new Order(ordernum,pesticidename,qty,orderdate,username);
				aArrayList.add(aOrder);
			}
			
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());		
		} catch (Exception e) {
			System.out.println(e.toString());
		}
		return aArrayList;
	}
}