【JSP开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了JSP开源代码-formmanage.jsp的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
<%@ include file="../conn.jsp"%>
<% String SQL;
String FF=request.getParameter("Flag");
String Num=request.getParameter("Num");
if((Num!=null)&&(!Num.equals(""))){
stmt1.executeUpdate("Update scott.订单管理 set 标记='" + FF + "' where 订单号='" + Num + "'");
}
SQL = "Select * from scott.订单管理 order by 订单号";
ResultSet rst=stmt.executeQuery(SQL);
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>洋洋购物网上购物订单
管理系统</title>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="74%">
<tr>
<td width="100%" colspan="5">
<hr>
</td>
</tr>
<tr>
<td width="20%" align="center"><font face="方正姚体" size="3" color="#0000FF"><a href="newform.jsp">未处理订单</a></font></td>
<td width="20%" align="center"><font face="方正姚体" size="3" color="#0000FF"><a href="oldform.jsp">已处理订单</a></font></td>
<td width="20%" align="center"><font face="方正姚体" size="3" color="#0000FF"><a href="wasteform.jsp">无效订单</a></font></td>
<td width="20%" align="center"><font face="方正姚体" size="3" color="#0000FF"><a href="formsearch.jsp">订单
查询</a></font></td>
<td width="20%" align="center"><font face="方正姚体" size="3" color="#0000FF"><a href="formmanage.jsp">订单管理</a></font></td>
</tr>
<tr>
<td width="100%" colspan="5">
<hr><form name="Modi" action="formmanage.jsp" method="POST"><input name="Flag" type="hidden"><input name="Num" type="hidden">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#FFFFFF" bordercolordark="#808080" height="39">
<tr>
<td width="3%" align="center" bgcolor="#FFFF66" height="19"> </td>
<td width="12%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>订单号码</b></font></td>
<td width="18%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>用户名称</b></font></td>
<td width="11%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>配送方式</b></font></td>
<td width="11%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>付款方式</b></font></td>
<td width="19%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>填表时间</b></font></td>
<td width="18%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>完成时间</b></font></td>
<td width="8%" align="center" bgcolor="#FFFF66" height="19"><font face="宋体" size="2"><b>标记</b></font></td>
</tr>
<%
while(rst.next()) {
if(rst.getString("标记").equals("废")){
FF="无";
}else{
FF="废";
}
%>
<tr>
<td width="3%" align="center" bgcolor="#FFFFFF" height="16"><font size="2" color="blue"><a style="cursor: hand" href onClick="
Modi.Flag.value='<%=FF%>';
Modi.Num.value='<%=rst.getString("订单号")%>';
Modi.submit()
">改</a></font></td>
<td width="12%" align="center" bgcolor="#FFCCFF" height="16"><font face="宋体" size="2"><%=rst.getString("订单号")%></font></td>
<td width="18%" align="center" bgcolor="#CCFFFF" height="16"><font face="宋体" size="2"><%=rst.getString("用户名")%></font></td>
<td width="11%" align="center" bgcolor="#FFCCFF" height="16"><font face="宋体" size="2"><%=rst.getString("配送")%></font></td>
<td width="11%" align="center" bgcolor="#CCFFFF" height="16"><font face="宋体" size="2"><%=rst.getString("付款")%></font></td>
<td width="19%" align="center" bgcolor="#FFCCFF" height="16"><font face="宋体" size="2"><%=rst.getString("填写时间")%></font></td>
<td width="18%" align="center" bgcolor="#CCFFFF" height="16"><font face="宋体" size="2"><%=rst.getString("完成时间")%></font></td>
<td width="8%" align="center" bgcolor="#FFCCFF" height="16"><font face="宋体" size="2"><%=rst.getString("标记")%></font></td>
</tr>
<%}%>
</table></form>
<p align="center">Copyright:北京公司</td>
</tr>
</table>
</center>
</div>
</body>
</html>