?? 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 + -