📄 buybook2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="buyCar" %>
<jsp:useBean id="buycar" class="buyCar" scope="session" >
</jsp:useBean>
<HTML>
<BODY>
我要<a href="buyBook1.jsp">继续购买</a><br>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到！");
}
try
{
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","6599996");
sql=con.createStatement();
//列出要买的书
if(request.getParameter("Goods_id")==null||(request.getParameter("Goods_id").trim()).length()==0)
{//如果没有要购买书,只是查看购物车中的商品
}
else
{
int Goods_id=Integer.parseInt(request.getParameter("Goods_id"));
out.print("<Table Border>");
out.print("<TR><td colspan=4 align=center>您要买的书是:</td></tr>");
out.print("<TR>");
out.print("<Td width=40 >"+"序号");
out.print("<Td width=400 >"+"书名");
out.print("<Td width=80>"+"单价");
out.print("<Td width=80>"+"本数");
out.print("</TR>");
out.print("<TR>");
out.print("<TD >"+Goods_id+"</TD>");
rs=sql.executeQuery("SELECT * FROM Goods where Goods_id="+Goods_id);
rs.next();
out.print("<TD >"+rs.getString("Goods_name")+"</TD>");
out.print("<TD >"+rs.getFloat("Goods_price")+"</TD>");
out.print("<form action=addGoods.jsp method=post>");
out.print("<TD >"+"<input type=input name=book_count size=6>");
out.print("<input type=hidden name=Goods_id value="+Goods_id+">");
out.print("<input type=submit value=提交></TD></form>");
out.print("</TR>") ;
out.print("</Table>");
}
//列出已放入购物车的书
double all_price=0;//总价
out.print("<Table Border>");
out.print("<TR><td colspan=7 align=center>您的购物车中的书有:</td></tr>");
out.print("<TR>");
out.print("<Td width=40 >"+"序号");
out.print("<Td width=400 >"+"书名");
out.print("<Td width=40>"+"数目");
out.print("<Td width=40>"+"单价");
out.print("<Td width=80>"+"总价");
out.print("<Td width=120>"+"删除");
out.print("<Td width=120>"+"减少");
out.print("</TR>");
Hashtable list=buycar.listMyGoods();
Enumeration enum=list.keys();
while(enum.hasMoreElements())
{
String goods=(String)enum.nextElement();
byte b[]=goods.getBytes("ISO-8859-1");
goods=new String(b);
out.print("<TR>");
out.print("<TD >"+goods+"</TD>");
rs=sql.executeQuery("SELECT * FROM Goods where Goods_id="+goods);
rs.next();
out.print("<TD >"+rs.getString("Goods_name")+"</TD>");
out.print("<TD >"+list.get(goods)+"</TD>");
out.print("<TD >"+rs.getFloat("Goods_price")+"</TD>");
out.print("<TD >"+rs.getFloat("Goods_price")*((Integer)list.get(goods)).intValue()+"</TD>");
all_price=all_price+rs.getFloat("Goods_price")*((Integer)list.get(goods)).intValue();
out.print("<TD ><a href='deleteGoods.jsp?Goods_id="+goods+"'>从购物车中去除</a>"+"</TD>");
out.print("<form action=minusGoods.jsp method=post>");
out.print("<TD >"+"<input type=input name=book_count size=6>");
out.print("<input type=hidden name=Goods_id value="+goods+">");
out.print("<input type=submit value=提交></TD></form>");
out.print("</TR>") ;
}
out.print("<TR>");
out.print("<td colspan=4 align=center>"+"总价为:"+"</TD>");
out.print("<Td>"+all_price+"</TD><Td> </TD><Td> </TD>");
out.print("</TR>");
out.print("</Table>");
con.close();
}
catch(Exception e1)
{
out.print("出现异常！");
}
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -