⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 uplist.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java"  pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBorder" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'uplist.jsp' starting page</title>
    <script language=javascript src="../function/admin.js"></script>
    <link rel="stylesheet" type="text/css" href="../css/admin.css">
  </head>
  
  <body BGCOLOR="#FFCCCC">
   <TABLE class=navi cellSpacing=1 align=center border=0>
	  <TBODY>
		  <TR>
		    <TH colSpan=2>当前位置:系统管理&gt;&gt;订单管理&gt;&gt;修改订单</TH>
		  </TR>
		  <TR>
		    <TD align=right>[<A href="orderlist.jsp">所有订单</A>]&nbsp;&nbsp;[<A href="do_list.jsp">已处理订单</A>]&nbsp;&nbsp;[<A href="undo_list.jsp">未处理订单</A>]&nbsp;&nbsp;[<A href="que_list.jsp">缺货订单</A>]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</TD></TR>
	 </TBODY>
</TABLE>

<FORM name=myform  action=orderlist_up.jsp  method=post>
<TABLE class=list cellSpacing=1 align=center>
<%
	try{
		String id1=request.getParameter("ID");
		ResultSet rs=null;
		String str1="select * from userorderlist where OrderlistNo='"+id1+"' ";
		rs=DBorder.executeQuery(str1);
		rs.next();
%>	  
	  <TBODY>
		  <TR>
		    	<TH colSpan=4>订单号:<%=rs.getString("OrderlistNo") %></TH>
		  </TR>
		  
		  <TR>
			    <TD>下单日期:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("SubmitTime") %>  name=submittime readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户提交订单的时间,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>用户ID:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("UserID") %> name=userid readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户ID,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>用户名:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("UserName") %>  name=username readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户姓名,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>用户实名:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("RealName") %>  name=realname readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户实名,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>用户电话:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("Tel") %>  name=usertel readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户电话,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>详细地址:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("UserAddress") %>  name=address readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户收货地址,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>邮政编码:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("Post") %>    name=post readonly="true"></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>用户邮编,不能修改!</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>发货时间:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("SendoutTime") %>  name=sendtime></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>发货时间</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>总金额:</TD>
			    <TD colSpan=2><INPUT size=30 value=<%=rs.getString("TotalPrice") %>  name=totalprise></TD>
			    <TD><SPAN class=red>*</SPAN><SPAN class=gray>书的总价钱</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>是否付款:</TD>
			    <TD colSpan=2>
					<select name="fukuan">
					<OPTION selected><%=rs.getString("IsPayoff")%></OPTION>
					<option value="是">是&nbsp;&nbsp;</option>
					<option value="否">否&nbsp;&nbsp;</option>
					</select>
				</TD>
				<TD><SPAN class=red>*</SPAN><SPAN class=gray>用户是否付款</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>是否发货:</TD>
			    <TD colSpan=2>
				    <select name="fahuo">
				    <OPTION selected><%=rs.getString("IsSendout")%></OPTION>
					<option value="是">是&nbsp;&nbsp;</option>
					<option value="否">否&nbsp;&nbsp;</option>
					</select>
				</TD>
				<TD><SPAN class=red>*</SPAN><SPAN class=gray>是否发货</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>是否缺货:</TD>
			    <TD colSpan=2>
				    <select name="quehuo">
				    <OPTION selected><%=rs.getString("Isquehuo")%></OPTION>
					<option value="是">是&nbsp;&nbsp;</option>
					<option value="否">否&nbsp;&nbsp;</option>
					</select>
				</TD>
				<TD><SPAN class=red>*</SPAN><SPAN class=gray>是否没有该书</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD>订单状态:</TD>
			    <TD colSpan=2>
				    <select name="zhuangtai">
				    <OPTION selected><%=rs.getString("OrderlistState")%></OPTION>
					<option value="已处理">已处理&nbsp;&nbsp;</option>
					<option value="未处理">未处理&nbsp;&nbsp;</option>
					<option value="已取消">已取消&nbsp;&nbsp;</option>
					</select>
				</TD>
				<TD><SPAN class=red>*</SPAN><SPAN class=gray>订单当前的状态</SPAN></TD>
		  </TR>
		  
		  <TR>
			    <TD width="15%">配送方式:</TD>
			    <TD width="35%">
				    <SELECT size=1 name=sendway disabled="disabled">
				    <option selected><%=rs.getString("SendWay") %></option>
				    <OPTION value=送货上门(货到付款)>送货上门(货到付款)</OPTION>
				    <OPTION value=普通邮寄(款到发货)>普通邮寄(款到发货)</OPTION>
				    <OPTION value=特快专递(款到发货)>特快专递(款到发货)</OPTION>
				    </SELECT>				     
			    </TD>
			    <TD width="15%">配送费用:</TD>
			    <TD width="35%"><INPUT size=15 value=0.00 name=d_deliverfee> 元</TD>
		  </TR>
		  
		  <TR>
			    <TD width="15%">支付方式:</TD>
			    <TD width="35%">
				    
				    <SELECT size=1 name=payway disabled="disabled">				  
				    <option selected><%=rs.getString("Way") %></option>
				    <OPTION value=邮政汇款>邮政汇款&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>			  
				    <OPTION value=工商银行汇款>工商银行汇款&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>
				    <OPTION value=招商银行汇款>招商银行汇款&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>
				    <OPTION value=建设银行汇款>建设银行汇款&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>
				    <OPTION value=农业银行汇款>农业银行汇款&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>
				    <OPTION value=见货即付>见货即付&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</OPTION>
				    </SELECT>
				    
				</TD>
			    <TD width="15%">支付费用:</TD>
			    <TD width="35%"><INPUT size=15 value=0.00 name=payfee> 元</TD>
		  </TR>
		  
		  <TR>
			    <TD  height="46">总计金额:</TD>
			    <TD align=right colSpan=3>应付人民币:<%=rs.getString("TotalPrice") %>元整 </TD>
		  </TR>
		  
		  <TR>
				<td height="25" colspan=4 align=center><input type=submit name=uporderlist value=修&nbsp;&nbsp;改></td>
		  </TR>
		  <input type=hidden name=id value=<%=id1 %>>
		  
<%	
	}catch(Exception e)
	{out.print(e);}
%>
	</TBODY>
</TABLE>
</FORM>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -