package?org.jsoft.boc.user;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?org.jsoft.model.Catalog;
import?org.jsoft.model.Product;

public?class?CatalogOperator?{
	public?List?queryCatalogAll（）
			throws?Exception?{
		List?catalogs=new?ArrayList（）;
	
		Class.forName（“com.mysql.jdbc.Driver“）;
		Connection?conn?=?DriverManager.getConnection（
				“jdbc:mysql://localhost/studentscore“?“root“?“123456“）;
		Statement?st?=?conn.createStatement（）;

		
		String?sql?=?“select?catalogidcatalogname?from?catalog“;
		ResultSet?rs=st.executeQuery（sql）;
		while（rs.next（））{
			Catalog?c=new?Catalog（）;
			c.setCatalogId（rs.getInt（“catalogid“））;
			c.setCatalogName（rs.getString（“catalogname“））;
			catalogs.add（c）;
		}
		return?catalogs;

	}
	public?List?queryByCatalogId（int?catalogId）
			throws?Exception?{
		List?ps=new?ArrayList（）;
		
		Class.forName（“com.mysql.jdbc.Driver“）;
		Connection?conn?=?DriverManager.getConnection（
				“jdbc:mysql://localhost/studentscore“?“root“?“123456“）;
		Statement?st?=?conn.createStatement（）;
		
		
		String?sql?=?“select?pidpnameppricepno?from?product?WHERE?catalogid=“+catalogId;
		ResultSet?rs=st.executeQuery（sql）;
		while（rs.next（））{
			Product?p=new?Product（rs.getInt（“pid“）rs.getDouble（“pprice“）rs.getString（“pno“）rs.getString（“pname“））;

			ps.add（p）;
		}
		return?ps;
		
	}

	public?static?void?main（String[]?args）?throws?Exception?{
		List?cs=new?CatalogOperator（）.queryByCatalogId（1）;
		for（Product?c:cs）{
			System.out.println（c.getProductName（））;
		}
	
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\
?????文件?????????845??2014-05-24?10:08??ShoppingCar\.classpath
?????文件????????1038??2014-05-24?10:08??ShoppingCar\.project
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\.settings\
?????文件?????????503??2014-05-24?10:08??ShoppingCar\.settings\.jsdtscope
?????文件?????????395??2014-05-24?10:08??ShoppingCar\.settings\org.eclipse.jdt.core.prefs
?????文件?????????469??2014-05-24?10:08??ShoppingCar\.settings\org.eclipse.wst.common.component
?????文件?????????349??2014-05-24?10:08??ShoppingCar\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-05-24?10:08??ShoppingCar\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-05-24?10:08??ShoppingCar\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\
?????文件??????????67??2014-07-16?19:33??ShoppingCar\build\classes\db.properties
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\boc\
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\boc\user\
?????文件????????3453??2014-07-16?20:02??ShoppingCar\build\classes\org\jsoft\boc\user\CatalogOperator.class
?????文件????????4876??2014-07-16?20:02??ShoppingCar\build\classes\org\jsoft\boc\user\PagesOperator.class
?????文件????????2647??2014-07-17?16:22??ShoppingCar\build\classes\org\jsoft\boc\user\UserOperator.class
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\dao\
?????文件????????1964??2014-07-16?20:02??ShoppingCar\build\classes\org\jsoft\dao\ProductsDAO.class
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\filter\
?????文件????????1586??2014-07-16?20:15??ShoppingCar\build\classes\org\jsoft\filter\EncodeFilter.class
?????文件????????1828??2014-07-17?04:31??ShoppingCar\build\classes\org\jsoft\filter\SercurityFilter.class
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\model\
?????文件????????1530??2014-07-17?15:13??ShoppingCar\build\classes\org\jsoft\model\Cart.class
?????文件?????????742??2014-07-17?04:23??ShoppingCar\build\classes\org\jsoft\model\CartItem.class
?????文件?????????763??2014-07-16?20:02??ShoppingCar\build\classes\org\jsoft\model\Catalog.class
?????文件????????1799??2014-07-16?20:02??ShoppingCar\build\classes\org\jsoft\model\Product.class
?????目錄???????????0??2014-07-17?16:26??ShoppingCar\build\classes\org\jsoft\servlet\
............此處省略72個文件信息