jsp+servlet+mysql写的简易购物网站系统代码

这是一个网页版的javascript购物网站系统

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个文件信息