📄 ud_order.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">
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 {
color: #660000;
font-family: "幼圆";
}
.style3 {
font-size: 14px;
font-family: "幼圆";
color: #660000;
}
.style12 {font-size: 9px}
-->
</style>
<script language="javascript">
function chkform(form1){
if (form1.status.value == ""){
alert("请输入订单状态！");
form1.status.focus();
return false;
}
if (form1.paid.value == ""){
alert("请输入支付状态！");
form1.paid.focus();
return false;
}
return true;
}
</script>
</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;
}
%>
<%
//获取session值，以及防止非法访问本页面
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
%>
<body bgcolor="#FFFFFF" >
<table width="858" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top">
<table id="Table_06" width="100%" height="274" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="11"></td>
<td height="300" colspan="3" align="center" valign="top">
<table width="98%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="819"><img src="images/_r3_c4.gif" width="85" height="86" align="absmiddle"> <span class="style1">您的位置：>> 花坊管理系统</span></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr align="left" bgcolor="#ECE9D8">
<td height="30"><span class="style2"> 淳.清凉花坊感谢您今天的辛勤工作......</span></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bordercolor="#003333" bgcolor="#EEE6D2" class="tableall_shop">
<tr bgcolor="#FAF8F1">
<td width="13%" height="360" align="left" bgcolor="#FAF8F1"><p class="style3">鲜花管理</p>
<p class="style3"><a href="main.jsp">花坊首页 </a></p>
<p class="style3"><a href="admin_order.jsp">订单列表</a></p>
<p class="style3"><a href="statistic.jsp">销售统计</a></p>
</tr>
<% String id=(String)request.getParameter("id");
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { System.out.print("runing here"); }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String condition="select * from orderinfo where orderid='"+id+"'";
rs=sql.executeQuery(condition);
while(rs.next())
{
String oid=rs.getString(1);
String uid=rs.getString(2);
String accepter=rs.getString(3);
String address=rs.getString(4);
String mess=rs.getString(5);
float total=rs.getFloat(6);
String date=rs.getString(7);
String status=rs.getString(8) ;
String paytype=rs.getString(9);
String sendtime=rs.getString(10) ;
String paid=rs.getString(11);
%>
<form action="mod_order.jsp" method="post" name="form1" onSubmit="return chkform(this)" >
<td width="87%" align="center" bordercolor="#FF00FF" bgcolor="#FAF8F1">
<br>
<table width="497" border="1">
<tr>
<th >订单ID</th>
<th ><%=oid%></th>
<th >会员ID</th>
<th ><%=uid%></th>
</tr>
<tr>
<td><div align="center">收 花 人</div></td>
<td><%=accepter%></td>
<td><div align="center">送花地址</div></td>
<td><%=address%></td>
</tr>
<tr>
<td><div align="center">订购日期</div></td>
<td><%=date%></td>
<td><div align="center">送货时间</div></td>
<td><%=sendtime%></td>
</tr>
<tr>
<td><div align="center">总 金 额</div></td>
<td><%=total%>元</td>
<td><div align="center">付款方式</div></td>
<td><%=paytype%></td>
</tr>
<tr>
<td><div align="center">订单状态</div></td>
<td><input name="status" type="text" value="<%=status%>"></td>
<td><div align="center">支付状态</div></td>
<td><input name="paid" type="text" value="<%=paid%>"></td>
</tr>
<tr>
<td height="46"><div align="center">卡片留言</div></td>
<td colspan="3"><%=mess%></td>
</tr>
<%
}
%>
<tr>
<td ><div align="center">订单细则</div></td>
<td ><div align="center">鲜花ID</div></td>
<td><div align="center">订购量</div></td>
<td><div align="center">查看鲜花信息</div></td>
</tr>
<%
String con1="select * from orderdetail where orderid='"+id+"'";
rs=sql.executeQuery(con1);
int i=0;
while(rs.next()){
i=i+1;
String bid=rs.getString("bouquetid");
int num=rs.getInt(3);
%> <tr>
<td> 第<%=i%>条</td>
<td><%=bid%></td>
<td><%=num%></td>
<td><div align="center"><a href="item1.jsp?id=<%=bid%>" >查看</a></div></td>
</tr>
<%
}
con.close();
}
catch(SQLException e) { }
%>
<tr align="center" >
<input name="id" type="hidden" value="<%=id%>">
<input name="submit1" type="submit" value="提交" onClick="return(checkform());">
<input name="back" type="button" class="button" value="返回" onClick="window.history.back()">
</tr>
</form>
</table>
</table>
</table>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -