【JSP开源代码栏目提醒】:网学会员,鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“all_orders.jsp”一文,供大家参考学习!
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.faq" />
<%@ include file="function.inc.jsp"%>
<%
if(session.getAttribute("username")==null||session.getAttribute("username")=="")
{
response.sendRedirect("../member/login.jsp?url="+request.getRequestURI());
}
%>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("GBK");
String temp=new String(temp_t,"ISO8859_1");
return temp;
}
catch(Exception e)
{
}
return "null";
}
%>
<html>
<head>
<title>总订单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
<p><b><div align="center"><font size="+3">总 订 单</font></div></b></p>
<table width="100%" border="0" align="center">
<tr bgcolor="#FFCCCC">
<td width="15%">
<div align="center"><font color="#0000FF">订单号</font></div>
</td>
<td width="56%">
<div align="center"><font color="#0000FF">订单用户名</font></div>
</td>
<td width="13%">
<div align="center"><font color="#0000FF">地址</font></div>
</td>
<td width="16%">
<div align="center"><font color="#0000FF">电话</font></div>
</td>
</tr>
<%
String sql;
sql="select distinct user_name,user_address,user_tel from orders where status=0";
ResultSet RS=workM.executeQuery(sql);
try
{
int i=1;
while(RS.next())
{
String user_name,user_address,user_tel;
user_name=RS.getString("user_name");
user_address=RS.getString("user_address");
user_tel=RS.getString("user_tel");
%>
<tr bgcolor="#CCFFCC">
<td width="15%">
<div align="center"> <font color="#0000FF"> <%=i%>
</font></div>
</td>
<td width="56%">
<div align="center"><font color="#0000FF"><%=getStr(user_name)%></font></div>
</td>
<td width="13%">
<div align="center"><font color="#0000FF"><%=getStr(user_address)%></font></div>
</td>
<td width="16%">
<div align="center"><font color="#0000FF"><%=getStr(user_tel)%></font></div>
</td>
<%
i=i+1;
}
}
catch(Exception ex)
{
out.println(ex.getMessage());
}
%>
<tr align="center">
<td colspan="4">
<br><a href="search_order1.jsp">订单
查询</a>
</td>
</tr>
<tr align="center">
<td colspan="4">
<br><br>
<a href="javascript:self.close();">关闭窗口</a>|<a href="javascript:self.print();">打印该页</a>
</td>
</tr>
</table>
<p> </p>
</div>
</body>
</html>