📄 over.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<%! float sum; %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body bgcolor="#ffdcdc">
<p><font color="#FF9900" size="4" face="隶书">购买成功，本网站采取的是货到付款的方式，我们将把您购买的产品送到以下地址:</font></p>
<div align="center"> <font color="#FF9900">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:zhuce";
Connection con=DriverManager.getConnection(url,"","");
Statement st= con.createStatement();
String strSql="select * from huiyuan where username='"+session.getValue("username")+"'";
st.executeQuery(strSql);
ResultSet rs=st.executeQuery(strSql);
if(rs.next())
%>
<img src="image/image018.gif" width="26" height="17"> </font></div>
<table width="59%" height="102" border="0" align="center" cellspacing="0">
<tr>
<td height="33" align="left" valign="middle"><font color="#FF9900">Email：
<%out.print(rs.getString("email"));%>
</font></td>
</tr>
<tr>
<td height="34" align="center" valign="middle"> <div align="left"><font color="#FF9900">地址：
<%out.print(rs.getString("dizhi"));%>
</font></div></td>
</tr>
<tr>
<td height="35" align="center" valign="middle"> <div align="left"><font color="#FF9900">姓名：
<%out.print(rs.getString("realname"));%>
<收></font></div></td>
</tr>
</table>
<p align="center"> </p>
<div align="center">
<%Statement aa= con.createStatement();
String str1="select * from cart";
st.executeQuery(str1);
ResultSet rs1=aa.executeQuery(str1);
sum=0;
while(rs1.next())
{
%>
<table width="75%" align="center">
<tr>
<td width="50%"><font color="#FF9900">物品：</font></td>
<td width="50%"><font color="#FF9900">价格：</font></td>
</tr>
<tr>
<td><font color="#FF9900">
<%out.print(rs1.getString("product_name"));%>
</font></td>
<td><font color="#FF9900">
<%//out.print(rs1.getString("jiage"));
String sf=rs1.getString("p_newprice");
out.print(sf);
float s=Float.parseFloat(sf);
sum=sum+s;
%>
</font></td>
</tr>
</table>
</div>
<%}
rs1.close();
aa.close();
out.println("<center><font color=#ff9900>总价格为："+sum+"</font></center><br>");
%>
<p align="center"><font color="#FF9900">
<%
Statement ss= con.createStatement();
String Sql="delete from cart";
ss.executeUpdate(Sql);
//rs.close();
//st.close();
%>
<font size="7" face="隶书">欢迎下次光临本网站！</font></font></p>
<p align="center"><a href="index.jsp"><font color="#FF9900" size="3" face="Kai">返回主页</font></a></p>
<p> </p>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -