do_change_userinformation.jsp
来自「这个是我自己做的网络购物程序 大家有兴趣的话可以拿去作为参考」· JSP 代码 · 共 220 行
JSP
220 行
<%@ 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>
<center><font size=3 color=blue>欢迎光临，您的信息如下：</font> </center>
<br>
<%
String username=request.getParameter("username");
byte[] get_username=username.getBytes("ISO-8859-1");
username= new String(get_username,"GB2312");
String power=request.getParameter("power");
byte[] get_power=power.getBytes("ISO-8859-1");
power= new String(get_power,"GB2312");
String password=request.getParameter("password");
byte[] get_password=password.getBytes("ISO-8859-1");
password= new String(get_password,"GB2312");
String true_name=request.getParameter("truename");
byte[] get_name2=true_name.getBytes("ISO-8859-1");
true_name= new String(get_name2,"GB2312");
String sex=request.getParameter("sex");
byte[] get_sex=sex.getBytes("ISO-8859-1");
sex=new String(get_sex,"GB2312");
String tel=request.getParameter("tel");
byte[] get_tel=tel.getBytes("ISO-8859-1");
tel=new String(get_tel,"GB2312");
String mp=request.getParameter("mp");
byte[] get_mp=mp.getBytes("ISO-8859-1");
mp=new String(get_mp,"GB2312");
String address=request.getParameter("address");
byte[] get_address=address.getBytes("ISO-8859-1");
address=new String(get_address,"GB2312");
String zip=request.getParameter("zip");
byte[] get_zip=zip.getBytes("ISO-8859-1");
zip=new String(get_zip,"GB2312");
String email=request.getParameter("email");
byte[] get_email=email.getBytes("ISO-8859-1");
email=new String(get_email,"GB2312");
String unit=request.getParameter("workplace");
byte[] get_unit=unit.getBytes("ISO-8859-1");
unit=new String(get_unit,"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 member set "+ "sex=?,membername=?,password=?,power=?,email=?,address=?,postcode=?,tel=?,mobile=?,work_place=? where memberno=? ";
PreparedStatement pstmt=con.prepareStatement(SQLstr);
pstmt.setString(1,sex);
pstmt.setString(2,true_name);
pstmt.setString(3,password);
pstmt.setString(4,power);
pstmt.setString(5,email);
pstmt.setString(6,address);
pstmt.setString(7,zip);
pstmt.setString(8,tel);
pstmt.setString(9,mp);
pstmt.setString(10,unit);
pstmt.setString(11,username);
int num= pstmt.executeUpdate();
if(num>0)
{out.print("恭喜您成功修改资料！<br><br>");
out.print("<a href=find_userinformation.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 + =
减小字号Ctrl + -
显示快捷键?