📄 db_change_orderforminformation.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><BODY>
<FORM ACTION="register.jsp" METHOD="POST">
<center><font size=6 face="黑体">书 籍 信 息 修 改</font></center><br>
<br>
<%
String orderno=request.getParameter("1");
byte[] get_orderno=orderno.getBytes("ISO-8859-1");
orderno= new String(get_orderno,"GB2312");
String memberno=request.getParameter("2");
byte[] get_memberno=memberno.getBytes("ISO-8859-1");
memberno= new String(get_memberno,"GB2312");
String prono=request.getParameter("3");
byte[] get_prono=prono.getBytes("ISO-8859-1");
prono= new String(get_prono,"GB2312");
String ordernum=request.getParameter("4");
byte[] get_ordernum=ordernum.getBytes("ISO-8859-1");
ordernum= new String(get_ordernum,"GB2312");
String orderdate=request.getParameter("5");
byte[] get_orderdate=orderdate.getBytes("ISO-8859-1");
orderdate=new String(get_orderdate,"GB2312");
String total=request.getParameter("6");
byte[] get_total=total.getBytes("ISO-8859-1");
total=new String(get_total,"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="update orderform set "+ "orderno=?,memberno=?,prono=?,ordernum=?,orderdate=?,total=? where orderno=? ";
PreparedStatement pstmt=con.prepareStatement(SQLstr);
pstmt.setString(1,orderno);
pstmt.setString(2,memberno);
pstmt.setString(3,prono);
pstmt.setString(4,ordernum);
pstmt.setString(5,orderdate);
pstmt.setString(6,total);
pstmt.setString(7,orderno);
int num= pstmt.executeUpdate();
if(num>0)
{out.print("恭喜您成功修改！<br><br>");
out.print("<a href=change_orderforminformation.jsp>返回上页</a><br><a href=login.jsp>主  页</a>");
}
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -