📄 order[1].jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style18 {color: #999999}
-->
</style>
</head>
<%! //处理字符串的常用方法
public String getString(String s) {
if(s == null) s = "";
try{
byte a[] = s.getBytes("ISO-8859-1");
s = new String(a);
}
catch(Exception e) { }
return s;
}
%>
<%
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
if (session.getValue("userid") == null||"".equals(session.getValue("userid"))){
%>
<script language="javascript">
alert("您还没有登陆！");
window.location.href ="login.jsp";
</script>
<%
}
else {
%>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="858" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="center" valign="top">
<table id="Table_06" width="100%" height="274" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="/images/6xiang_93.gif" width="10"></td>
<td height="300" colspan="3" align="center" valign="top">
<table width="100%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%"><img src="images/1_img2.jpg" width="117" height="113"> 您的位置：<a href="index.jsp">HOME</a> >> 订单查询 </td>
<td width="14%" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><a href="index.jsp">花坊首页</a></span></td>
<td width="11%" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="usercenter.jsp">会员中心</A></span></td>
<td width="13%" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="cart.jsp">我的购物车</A></span></td>
<td width="12%" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="help.jsp">帮助中心</A></span></td>
</tr>
</table>
<br><br>
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#ECDECE" bordercolordark="#FFFFFF">
<tr valign="middle" bgcolor="#ECDECE">
<td width="15%" height="25" align="center">订单号</td>
<td width="12%" align="center">付款方式</td>
<td width="14%" height="25" align="center">总金额</td>
<td width="16%" height="25" align="center">订购日期</td>
<td width="13%"height="25" align="center">支付状态</td>
<td width="18%" height="25" align="center">订单状态</td>
<td width="12%" height="25" align="center">操 作</td>
</tr>
<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM orderinfo where userid="+"'"+userid+"'");
while (rs.next())
{ String id=rs.getString(1);
float total=rs.getFloat(6);
String orderdate=rs.getString(7);
String status=rs.getString(8);
String paytype=rs.getString(9);
String paid=rs.getString(11);
%>
<tr>
<td align="center"><%=id%></td>
<td align="center"><%=paytype%></td>
<td align="center"><%=total%></td>
<td align="center"><%=orderdate%></td>
<td align="center"><%=paid%></td>
<td align="center"><%=status%></td>
<td align="center"><a href="orderinfo.jsp?id=<%=id%>"><font color="#990000">查看详细信息</font></a></td>
</tr>
<%
}%>
</table>
<%
con.close();
}
catch(SQLException event) { }
}
%>
<br> </td>
<td background="/images/6xiang_98.gif" width="3" ></td>
</tr>
<tr>
<td background="/images/6xiang_146.gif" width="10" height="20"></td>
<td width="245" height="20" background="/images/6xiang_204.gif"></td>
<td width="291" height="20" background="/images/6xiang_205.gif"></td>
<td width="309" height="20" background="/images/6xiang_206.gif"></td>
<td background="/images/6xiang_148.gif" width="3" height="20"></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -