do_change_orderforminformation.jsp
来自「这个是我自己做的网络购物程序 大家有兴趣的话可以拿去作为参考」· JSP 代码 · 共 193 行
JSP
193 行
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<head>
<script language="javascript">
function ok(rURL)
{
document.form.action = rURL;
document.form.submit();
}
</script>
</head>
<BODY>
<FORM name=form METHOD="POST">
<center><font size=6 face="黑体">订 单 信 息 修 改</font></center><br>
<br>
<%
String orderno=(String)request.getParameter("orderno");
byte[] get_orderno=orderno.getBytes("ISO-8859-1");
orderno=new String(get_orderno,"GB2312");
Connection con=null;
ResultSet rs=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con=DriverManager.getConnection ("jdbc:odbc:bookshop","sa","");
String SQLstr="select * from orderform where orderno=? ";
PreparedStatement pstmt=con.prepareStatement(SQLstr);
pstmt.setString(1,orderno);
rs= pstmt.executeQuery();
if(!rs.next())
{out.print("找不订单号码为:  "+orderno+" 的信息！<br>");
out.print("<a href=change_orderforminformation.jsp>继续修改</a><br>");
out.print("<a href=manage_orderform.jsp >返回书籍管理页面</a><br>");
}
else
{
out.print("<Table >");
%>
<tr><Td>订单号码</td>
<TD ><input type=text name=1 value=<%out.print(rs.getString(1));%>></TD></tr>
<tr><Td>会员号码</td><td><input type=text name=2 value=<%out.print(rs.getString(2));%>></td></tr>
<tr><Td>书籍号码</td><td><input type=text name=3 value=<%out.print(rs.getString(3));%>></td></tr>
<tr><Td>订购数量</td><td><input type=text name=4 value=<%out.print(rs.getString(4));%>></td></tr>
<tr><Td>下单日期</td><td><input type=text name=5 value=<%out.print(rs.getString(5));%>></td></tr>
<tr><Td>订单金额</td><td><input type=text name=6 value=<%out.print(rs.getString(6));%>></td></tr><br>
<tr><td><input type=button value=提交修改 onClick="ok('db_change_orderforminformation.jsp');"></td>  
<td><input type=button value=返回上页 onClick="ok('change_orderforminformation.jsp');"></td> </tr>
<% }
out.print(" </Table><br><br>");
pstmt.close();
con.close();}
catch(SQLException e)
{ out.print(e);}
%>
<div align="center">
<SCRIPT LANGUAGE=javascript>
<!--
function winopen(url)
{
window.open(url,"","menubar=no,toolbar=no,location=no,directories=no,status=no,width=400,height=500,left=20,top=20,scrollbars=yes");
}
//-->
</SCRIPT>
<style>
<!--
BODY {
SCROLLBAR-FACE-COLOR: rgb(167,200,223);
SCROLLBAR-3DLIGHT-COLOR: rgb(255,207,116);
SCROLLBAR-DARKSHADOW-COLOR: rgb(255,227,163);
SCROLLBAR-BASE-COLOR: rgb(0,0,10)
}
-->
</style>
<link href="books_css.css" rel="stylesheet" type="text/css">
<table width=760 border="1" cellspacing="0" cellpadding="0" align="center">
<br>
<br>
<br>
<br>
<tr bgcolor="#61A0E0">
<td width="20%" ><><b>问题解答</b></td>
<td width="20%" ><><b>购买商品</b></td>
<td width="20%" ><><b>关于我们</b></td>
<td width="20%" ><><b>其它服务</b></td>
<td width="20%" ><><b>其它服务</b></td>
</tr>
<tr>
<td valign=top> <table width="100%" border="0" cellspacing="0" cellpadding="0" class=head_down2 bgcolor=#ffffff>
<tr>
<td>·<a href="/question/default1.asp" target="_blank">帮助中心</a></td>
</tr>
<tr>
<td>·<a href="/ADService/inform.asp" target=_blank>投诉</a></td>
</tr>
<tr>
<td>·<a href="/sms/sms.asp" target="_blank">站内短信</a></td>
</tr>
</table></td>
<td valign=top> <table width="100%" border="0" cellspacing="0" cellpadding="0" class=head_down2 bgcolor=#ffffff>
<tr>
<td>·<a href="new_user_infomation.jsp" target="_blank">注册用户</a> <a href="change_userinformation.jsp" target="_blank">更改注册信息</a></td>
</tr>
<tr>
<td>·<a href="/vieworder/listorder.asp" target="_blank">查看、取消定单</a></td>
</tr>
<tr>
<td>·<a href="/groupshop/default.asp" target="_blank">团购</a> / <a href="/pixiao/default.asp" target="_blank">批发</a></td>
</tr>
</table></td>
<td valign=top> <table width="100%" border="0" cellspacing="0" cellpadding="0" class=head_down2 bgcolor=#ffffff>
<tr>
<td>·<a href="/adservice/about.asp" target="_blank">本站简介</a></td>
</tr>
<tr>
<td>·<a href="/adservice/about2.asp" target="_blank">如何联系我们</a></td>
</tr>
<tr>
<td>·<a href="/adservice/default.asp" target="_blank">广告服务</a></td>
</tr>
</table></td>
<td valign=top><table width="100%" border="0" cellspacing="0" cellpadding="0" class=head_down2 bgcolor=#ffffff>
<tr>
<td>·<a href="/sitemap10wan/3/1.htm" target="_blank">图书目录</a></td>
</tr>
<tr>
<td>·<a href="/adservice/sitemap.asp" target="_blank">网站地图</a></td>
</tr>
<tr>
<td ></td>
</tr>
</table></td>
<td valign=top><table width="100%" border="0" cellspacing="0" cellpadding="0" class=head_down2 bgcolor=#ffffff>
<tr>
<td>·<a href="/adservice/bookshr.asp" target="_blank">招聘英才</a></td>
</tr>
<tr>
<td>·<a href="/union/default.asp" target=_blank>网站联盟-与我们一起卖书</a></td>
</tr>
<tr>
<td >·<a href="/adservice/about2.asp" target="_blank">诚征各城市快递公司</a></td>
</tr>
</table></td>
</tr>
</table>
<div align="center" class="font12">
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="center">
<p><span class="font12">客服电话：021-82382773 021-82389225（工作时间：8：30—17：30） <a href="/sms/sms.asp" target="_blank"><font color="#FF0000">※站内短信</font></a><br>
传真：(010)-82373299 客户服务E-mail:<a href="cy0530cy@163.com">cy0530cy@163.com</a><br>
<a href="http://www.bookschina.com"><b>网上书店</b></a> <a href="/adservice/tiaojian.asp" target="_blank">(草鱼图书网)使用条件</a> <a href="http://www.bookschina.com"><b>网上书店</b></a>
<a href="/adservice/tiaojian.asp" target="_blank"></a><a href="/adservice/yinsi.asp" target="_blank">(草鱼图书网)隐私声明</a><strong></strong><strong><br>
</strong> <a href="http://www.miibeian.gov.cn" target="_blank">经营许可证编号：沪ICP备07017600号</a>
<a href="/include/type2.asp" target="_blank">沪汇监发[2002]122号</a></span><br>
<a href="http://www.hd315.gov.cn/beian/view.asp?bianhao=010202002042800018" target="_blank"><img src="javanb.gif" width="200" height="60" border="0"></a><span class="font12"><strong>
<a href="/adservice/chengxin.asp" target="_blank"><img src="yumen.GIF" width="150" height="60" border="0"></a><br>
</strong></span><strong><br>
</strong></p>
</div>
</td>
</tr>
</table>
</div>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?