package?com.bsw.orders.dao;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;

import?com.bsw.orders.util.SQLUtil;
import?com.bsw.orders.vo.Order;

public?class?OrderDao?{
	//查詢
	public?ArrayList?findAllOrders（）{
		ArrayList?orderList?=?new?ArrayList（）;
		String?sql?=?“select?*?from?orderTable“;
		ResultSet?rs?=?SQLUtil.executeQuery（sql）;
		try?{
			int?orderId;
			String?orderName;
			int?buyer;
			double?sum;
			String?deliver;
			String?lastMT;
			String?createT;
			
			while（rs.next（））{
				orderId?=?rs.getInt（“orderid“）;
				orderName?=?rs.getString（“ordername“）;
				buyer?=?rs.getInt（“buyer“）;
				sum?=?rs.getDouble（“sum“）;
				deliver?=?rs.getString（“deliverymethod“）;
				lastMT?=?rs.getString（“lastmodifydate“）;
				createT?=?rs.getString（“createddate“）;
				orderList.add（new?Order（orderIdorderNamebuyersumdeliverlastMTcreateT））;
			}
			rs.close（）;
		}?catch?（SQLException?e）?{
			//e.printStackTrace（）;
			System.out.println（“查詢所有訂單失敗“）;
		}
		
		return?orderList;
	}
	public?ArrayList?findAllOrdersByBuyer（int?buyerId）{
		ArrayList?orderList?=?new?ArrayList（）;
		String?sql?=?“select?*?from?orderTable?where?buyer?=“+buyerId;
		ResultSet?rs?=?SQLUtil.executeQuery（sql）;
		try?{
			int?orderId;
			String?orderName;
			int?buyer;
			double?sum;
			String?deliver;
			String?lastMT;
			String?createT;
			
			while（rs.next（））{
				orderId?=?rs.getInt（“orderid“）;
				orderName?=?rs.getString（“ordername“）;
				buyer?=?rs.getInt（“buyer“）;
				sum?=?rs.getDouble（“sum“）;
				deliver?=?rs.getString（“deliverymethod“）;
				lastMT?=?rs.getString（“lastmodifydate“）;
				createT?=?rs.getString（“createddate“）;
				orderList.add（new?Order（orderIdorderNamebuyersumdeliverlastMTcreateT））;
			}
			rs.close（）;
		}?catch?（SQLException?e）?{
			//e.printStackTrace（）;
			System.out.println（“查詢用戶訂單失敗“）;
		}
		
		return?orderList;
	}
	public?ArrayList?findAllOrdersByOrderId（int?Id）{
		ArrayList?orderList?=?new?ArrayList（）;
		String?sql?=?“select?*?from?orderTable?where?orderid?=“+Id;
		ResultSet?rs?=?SQLUtil.executeQuery（sql）;
		try?{
			int?orderId;
			String?orderName;
			int?buyer;
			double?sum;
			String?deliver;
			String?lastMT;
			String?createT;
			
			while（rs.next（））{
				orderId?=?rs.getInt（“orderid“）;
				orderName?=?rs.getString（“ordername“）;
				buyer?=?rs.getInt（“buyer“）;
				sum?=?rs.getDouble（“sum“）;
				deliver?=?rs.getString（“deliverymethod“）;
				lastMT?=?rs.getString（“lastmodifydate“）;
				createT?=?rs.getString（“createddate“）;
				orderList.add（new?Order（orderIdorderNamebuyersumdeliverlastMTcreateT））;
			}
			rs.close（）;
		}?catch?（SQLException?e）?{
			//e.printStackTrace（）;
			System.out.println（“詳細訂單失敗“）;
		}
		
		return?orderList;
	}
	pu

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????473??2009-02-13?11:00??orders\.classpath

?????文件????????291??2009-02-13?11:00??orders\.mymetadata

?????文件???????1224??2009-02-13?11:00??orders\.project

?????文件?????????39??2009-02-13?11:00??orders\WebRoot\meta-INF\MANIFEST.MF

?????文件???????6941??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\dao\OrderDao.class

?????文件???????5697??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\dao\OrderItemDao.class

?????文件???????1722??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\dao\UserDao.class

?????文件???????1432??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\filter\EncodingFilter.class

?????文件???????1066??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\Exit.class

?????文件???????1977??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\LoginServlet.class

?????文件???????3221??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\OrdearItemUpdate.class

?????文件???????2919??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\SearchOrderList.class

?????文件???????1884??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\ShanChuOrderItem.class

?????文件???????1483??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\ShanChuServlet.class

?????文件???????3289??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\TianJiaOrderItemServlet.class

?????文件???????2439??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\TianJiaServlet.class

?????文件???????1726??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\XiangXiOrderItem.class

?????文件???????2256??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\servlet\XiangXiServlet.class

?????文件???????2578??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\util\SQLUtil.class

?????文件???????1957??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\vo\Order.class

?????文件???????2635??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\vo\OrderItem.class

?????文件???????1083??2009-02-13?11:00??orders\WebRoot\WEB-INF\classes\com\bsw\orders\vo\User.class

?????文件???????3830??2009-02-13?11:00??orders\WebRoot\WEB-INF\web.xml

?????文件????????392??2009-02-13?11:00??orders\WebRoot\css\styles.css

?????文件????????185??2009-02-13?11:00??orders\WebRoot\footer.jsp

?????文件????????767??2009-02-13?11:00??orders\WebRoot\header.jsp

?????文件???????5120??2009-02-13?11:00??orders\WebRoot\images\Thumbs.db

?????文件?????109314??2009-02-13?11:00??orders\WebRoot\images\banner.jpg

?????文件??????79533??2009-02-13?11:00??orders\WebRoot\images\footer.jpg

?????文件???????3648??2009-02-13?11:00??orders\WebRoot\images\notebg.gif

............此處省略61個文件信息