<%@ 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 文件都在这里了。代码的功能只是实现了增加。但是删除不了。。望大家给我指点
<%@ 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 文件都在这里了。代码的功能只是实现了增加。但是删除不了。。望大家给我指点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货