package?DAO;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?DB.DBUtil;
import?MODEL.CartProduct;
import?MODEL.Product;

public?class?CartDao?{
	Connection?dbconn=DBUtil.getConnection（）;
	
	
	public?List?query（）?throws?Exception{	??????????????????????????????????//查詢所有商品
		List?productList?=?new?ArrayList（）;
		String?sql?=?“select?*?from?cartproducts“;
		PreparedStatement?pstmt?=?dbconn.prepareStatement（sql）;
		ResultSet?result?=?pstmt.executeQuery（）;
		while（result.next（））?{
			CartProduct?product?=?new?CartProduct（）;
			product.setPname（result.getString（“pname“））;
			product.setPrice（result.get

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1008??2018-11-10?15:40??Database?（1）\.classpath

?????文件????????908??2018-10-29?08:44??Database?（1）\.project

?????文件????????567??2018-10-29?08:44??Database?（1）\.settings\.jsdtscope

?????文件????????364??2018-10-29?08:44??Database?（1）\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2018-10-29?08:44??Database?（1）\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-10-29?08:44??Database?（1）\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-10-29?08:44??Database?（1）\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-10-29?08:44??Database?（1）\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2913??2018-12-19?01:49??Database?（1）\build\classes\DAO\CartDao.class

?????文件???????2359??2018-12-18?19:26??Database?（1）\build\classes\DAO\ProductDao.class

?????文件???????2150??2018-12-18?19:26??Database?（1）\build\classes\DAO\UserDao.class

?????文件???????1191??2018-11-18?15:39??Database?（1）\build\classes\DB\DBUtil.class

?????文件???????1379??2018-12-18?18:32??Database?（1）\build\classes\MODEL\CartProduct.class

?????文件???????1367??2018-12-18?18:31??Database?（1）\build\classes\MODEL\Product.class

?????文件???????1422??2018-12-18?18:31??Database?（1）\build\classes\MODEL\User.class

?????文件???????4337??2018-12-19?07:34??Database?（1）\build\classes\Servlet\CheckServlet.class

?????文件???????3863??2018-12-19?07:24??Database?（1）\build\classes\Servlet\QueryProductServlet.class

?????文件???????2048??2018-12-19?01:49??Database?（1）\src\DAO\CartDao.java

?????文件???????1238??2018-12-18?19:26??Database?（1）\src\DAO\ProductDao.java

?????文件???????1127??2018-12-18?19:26??Database?（1）\src\DAO\UserDao.java

?????文件????????755??2018-11-09?21:22??Database?（1）\src\DB\DBUtil.java

?????文件????????926??2018-12-18?18:32??Database?（1）\src\MODEL\CartProduct.java

?????文件????????914??2018-12-18?18:31??Database?（1）\src\MODEL\Product.java

?????文件????????996??2018-12-18?18:31??Database?（1）\src\MODEL\User.java

?????文件???????3817??2018-12-19?07:34??Database?（1）\src\Servlet\CheckServlet.java

?????文件???????3599??2018-12-19?07:24??Database?（1）\src\Servlet\QueryProductServlet.java

?????文件????????322??2018-11-06?12:03??Database?（1）\WebContent\css\cart.css

?????文件????????846??2018-12-18?23:59??Database?（1）\WebContent\css\head.css

?????文件???????1949??2018-12-18?23:58??Database?（1）\WebContent\css\index.css

?????文件???????4797??2018-11-19?09:54??Database?（1）\WebContent\css\list.css

............此處省略45個(gè)文件信息