cart_add.jsp

解压在c盘

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.Vector"%>
<%@ page import="goodselement"%>
<%@ page import="chStr"%>


<%
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement(); 

int ID=Integer.parseInt(request.getParameter("goodsID"));
String sql="select * from goods where key="+ID;
ResultSet rs=stmt.executeQuery(sql);
int price=0;
if(rs.next()){
	price=rs.getInt("price");
}
goodselement mygoodselement=new goodselement();
mygoodselement.ID=ID;
mygoodselement.price=price;
mygoodselement.number=1;
boolean Flag=true;
Vector cart=(Vector)session.getAttribute("cart");
if(cart==null){
	cart=new Vector();
}else{
	for(int i=0;i<cart.size();i++){
		goodselement goodsitem=(goodselement)cart.elementAt(i);
		if(goodsitem.ID==mygoodselement.ID){  
			goodsitem.number++;
			cart.setElementAt(goodsitem,i);
			Flag=false;
		}
	}
}
if(Flag)   cart.addElement(mygoodselement);
session.setAttribute("cart",cart);
rs.close(); 
stmt.close(); 
conn.close();
response.sendRedirect("cart_see.jsp");
%>