📄 show_user_information.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>
<center><font size=3 color=blue>欢迎光临，您的信息如下：</font> </center>
<br>
<%
String un=(String)request.getParameter("custom_name");
//String un=(String)session.getAttribute("username");
String password=request.getParameter("password");
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 member where memberno=? "+ " and password=?";
PreparedStatement pstmt=con.prepareStatement(SQLstr);
pstmt.setString(1,un);
pstmt.setString(2,password);
rs= pstmt.executeQuery();
if(!rs.next())
{out.print("找不到用户为"+un+"的资料！<br>");
out.print("<a href=find_userinformation.jsp>继续查询</a><br>");
out.print("<a href=login.jsp >返回主页面</a><br>");
}
else
{ out.print("<font size=5 color=blue>您好，您的信息如下 ：</font><br><br><br>");
out.print("<Table Border=3>");
out.print("<TR>");
out.print("<TH width=100>"+"会员名");
out.print("<TH width=100>"+"性别");
out.print("<TH width=100>"+"真实姓名");
out.print("<TH width=100>"+"密码");
out.print("<TH width=100>"+"等级");
out.print("<TH width=100>"+"电子邮箱");
out.print("<TH width=100>"+"地址");
out.print("<TH width=100>"+"邮政编码");
out.print("<TH width=100>"+"电话");
out.print("<TH width=100>"+"手机");
out.print("<TH width=100>"+"工作地址");
out.print("</TR>");
out.print("<TR>");
String name=rs.getString(1);
out.print("<TD >"+name+"</TD>");
String sex=rs.getString(2);
out.print("<TD >"+sex+"</TD>");
String truename=rs.getString(3);
out.print("<TD >"+ truename+"</TD>");
String PWD=rs.getString(4);
out.print("<TD >"+PWD+"</TD>");
String power=rs.getString(5);
out.print("<TD >"+power+"</TD>");
String email=rs.getString(6);
out.print("<TD >"+ email+"</TD>");
String address=rs.getString(7);
out.print("<TD >"+ address+"</TD>");
String zip=rs.getString(8);
out.print("<TD >"+zip+"</TD>");
String tel=rs.getString(7);
out.print("<TD >"+ tel+"</TD>");
String mp=rs.getString(7);
out.print("<TD >"+mp+"</TD>");
String workplace=rs.getString(7);
out.print("<TD >"+ workplace+"</TD>");
out.print("</TR>") ;
}
out.print(" </Table><br><br>");
pstmt.close();
con.close();
}
catch(SQLException e)
{ out.print("");}
%>
<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>
<% out.print("<a href=find_userinformation.jsp>返回上页</a>   <a href=login.jsp>主  页</a><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 + -