<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="file" class="x.b.bookinfo" scope="page">
</jsp:useBean>
<jsp:useBean id="login" class="x.b.database" scope="page">
</jsp:useBean>
<html>
<body><center>
<%!
int i;
String[] title,publichouse,author;
float[] price;
int[]id;
int quantity;
String item;
boolean isexit;
int removenumber;
float total;
%>
<%
ResultSet rs,rs1;
try
{
String s="select * from book_info";
rs=login.executeQuery(s);
i=0;
while(rs.next())
{
i++;}
out.print(i);title=new String[i];
publichouse=new String[i];
author=new String[i];
price=new float[i];
id=new int[i];
i=0;
String s1="select * from book_info";
rs1=login.executeQuery(s1);
out.print("<table border=1>");while(rs1.next())
{
 title[i]=rs1.getString(1);
 id[i]=rs1.getInt(2);
 author[i]=rs1.getString(3);
 price[i]=rs1.getFloat(4);
 publichouse[i]=rs1.getString(5);
out.print("<tr align=center>");
out.print("<td>"+title[i]+"</td>");
out.print("<td>"+id[i]+"</td>");
out.print("<td>"+author[i]+"</td>");
out.print("<td>"+price[i]+"</td>");
out.print("<td>"+publichouse[i]+"</td>");
out.print("<td><a href=c.jsp?action=add&item="+i+">add to</a></td>");out.print("</tr >");
i++;}
out.print("</table>");}catch(Exception e)
{
}%>
<%
String action=request.getParameter("action");
if(action!=null)
{%>
<form action="put.jsp" method="post">
<table border=1>
<tr>
<td>bookname</td>
<td>bookid</td>
<td>author</td>
<td>price</td>
<td>publichouse</td>
<td>----</td></tr>
<%Vector buylist=(Vector)session.getValue("shoppingcart");
item=request.getParameter("item");
int bookid;
isexit=false;
try
{
bookid=Integer.parseInt(item);
if(action.equals("add"))

file.settitle(title[bookid]);
file.setprice(price[bookid]);
file.setauthor(author[bookid]);
file.setpublichouse(publichouse[bookid]);
file.setid(id[bookid]);
file.setquantity(1);if(buylist==null)
{
buylist=new Vector();
buylist.addElement(file);}else
{
for(int i=0;i<buylist.size();i++)
{
int tempid=((x.b.bookinfo)buylist.elementAt(i)).getid();
int temp=((x.b.bookinfo)buylist.elementAt(i)).getquantity();
if(tempid==file.getid())
{
isexit=true;
((x.b.bookinfo)buylist.elementAt(i)).setquantity(temp+1);
}
}
if(!isexit)
{
buylist.addElement(file);
}
} if(action.equals("del"))
//if(action=="del")
{ out.print("okk");
for(int i=0;i<buylist.size();i++)
{
int tempid=((x.b.bookinfo)buylist.elementAt(i)).getid();
if(tempid==bookid)removenumber=i;
}
buylist.removeElementAt(removenumber);}
session.putValue("shoppingcart",buylist);
total=0;
for(int i=0;i<buylist.size();i++)
{
out.print("<tr>");
out.print("<td>"+((x.b.bookinfo)buylist.elementAt(i)).gettitle()+"</td>");
out.print("<td>"+((x.b.bookinfo)buylist.elementAt(i)).getid()+"</td>");
out.print("<td>"+((x.b.bookinfo)buylist.elementAt(i)).getquantity()+"</td>");
out.print("<td>"+((x.b.bookinfo)buylist.elementAt(i)).getprice()+"</td>");
out.print("<td>"+((x.b.bookinfo)buylist.elementAt(i)).getpublichouse()+"</td>");
int temp=((x.b.bookinfo)buylist.elementAt(i)).getid();
int quantity=((x.b.bookinfo)buylist.elementAt(i)).getquantity();
float price=((x.b.bookinfo)buylist.elementAt(i)).getprice();
total=total+price*quantity;
out.print("<td><a href=c.jsp?action=del&item="+i+">删除</a></td>");
out.print("</tr>");
}
out.print("</table>");
out.print("total"+total);
}
}
catch(Exception e1)
{}
%></table>
<input type="submit" value="ok">
</form>
<%
}
%>
</center>
</body>
</html>
////////////////////////////////////////
package x.b;
import java.io.*;
public class bookinfo
{
                     String publichouse,author,title;
                     float price;
                     int id;
                     int quantity;
                     public void setpublichouse(String a)
                     {
                              publichouse=a;
                     }
                     public void setauthor(String b)
                     {
                               author=b;
                     }
                     public void settitle(String c)
                     {
                               title=c;
                     }
                     public void setprice(float d)
                     {
                               price=d;
                     }
                     public void setid(int e)
                     {
                                id=e;
                     }
                     public void setquantity(int f)
                     {
                                 quantity=f;
                     }
                     public String getpublichouse()
                     {
                                 return publichouse;
                     }
                     public String getauthor()
                     {
                                 return author;
                     }
                     public String gettitle()
                     {
                                 return title;
                     }
                     public int getid()
                     {
                                 return id;
                     }
                     public float getprice()
                     {
                                 return price;
                     }
                     public int getquantity()
                     {
                                 return quantity;
                     }
}
////////////////////////////////////////
bean 文件和JSP 文件都在这里了。代码的功能只是实现了增加。但是删除不了。。望大家给我指点