📄 your.jsp
字号:
<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String user_id= (String) session.getValue("user_id");
//叛断Session变量是否超时
if((user_id==null)|(user_id=="")){
response.sendRedirect("timeout.htm");
}
//叛断此用户是否已经注册
String user_id1="1";
if(user_id1.equals(user_id)){
response.sendRedirect("notreg.htm");
}
//叛断此用户是否已经提交档案
String sql="select * from scott.larchives where user_id='"+user_id+"'";
ResultSet rs_lar=stmt.executeQuery(sql);
if(!rs_lar.next()){
response.sendRedirect("notregist.htm");
}
Statement stmt_word=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.leaveword where for_id='"+user_id+"' order by id desc";
ResultSet rs_word=stmt_word.executeQuery(sql);
Statement stmt_apply=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.apply where for_id='"+user_id+"' ";
ResultSet rs_apply=stmt_apply.executeQuery(sql);
Statement stmt_back=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.back where for_id='"+user_id+"' ";
ResultSet rs_back=stmt_back.executeQuery(sql);
Statement stmt_friend=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.friend where for_id='"+user_id+"' ";
ResultSet rs_friend=stmt_friend.executeQuery(sql);
Statement stmt_user=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.user_reg where user_id='"+user_id+"' ";
ResultSet rs_user=stmt_user.executeQuery(sql);
%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Namo WebEditor v4.0(Trial)">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>您的入会日期是</title>
<style>
<!--
.x:link { color: white; text-decoration: none }
.x:visited { color: white; text-decoration: none }
.x:active { color: red; text-decoration: none }
.x:hover { color: red;text-decoration:nome}
tr { font-size: 10pt }
body { font-size: 10pt }
a:link { color: blue; text-decoration: none }
a:visited { color: blue; text-decoration: none }
a:active { color: red; text-decoration: none }
a:hover { color: red; text-decoration: none }
-->
</style>
</head>
<body leftmargin="5" topmargin="0">
<table width="772" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/top.gif" width="772" height="112" usemap="#Map" border="0"></td>
</tr>
</table>
<table border="0" width="772" height="176" cellspacing="0" cellpadding="0">
<tr>
<td width="507" height="170" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="16">
<tr bgcolor="#CDDCEB">
<td colspan="7" width="424" height="18"> 有如下网友向您提出交友请求:</td>
</tr>
<tr>
<td width="76" align="center" height="1" style="border-bottom-style: solid">日期</td>
<td width="51" align="center" height="1" style="border-bottom-style: solid">姓名</td>
<td width="41" align="center" height="1" style="border-bottom-style: solid">性别</td>
<td width="42" align="center" height="1" style="border-bottom-style: solid">年龄</td>
<td width="71" align="center" height="1" style="border-bottom-style: solid">来自</td>
<td width="65" align="center" height="1" style="border-bottom-style: solid">网名</td>
<td width="80" align="center" height="1" style="border-bottom-style: solid">态度</td>
</tr>
<% int i=0;
while(i<16 && rs_apply.next()){
%>
<tr bgcolor="#DDF9FF">
<td width="76" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=replacenull(rs_apply.getString("apply_date"))%></td>
<td width="51" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><a href="read.jsp?user_id=<%=replacenull(rs_apply.getString("user_id"))%>"><%=replacenull(rs_apply.getString("user_name"))%></a></td>
<td width="41" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=replacenull(rs_apply.getString("user_sex"))%></td>
<td width="42" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=replacenull(rs_apply.getString("user_age"))%></td>
<td width="71" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=replacenull(rs_apply.getString("user_home"))%></td>
<td width="65" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=replacenull(rs_apply.getString("user_netname"))%></td>
<td width="80" height="1" align="center" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><a href="accept.jsp?id=<%=replacenull(rs_apply.getString("id"))%>&user_id=<%=replacenull(rs_apply.getString("user_id"))%>">[愿意]</a><a href="refuse.jsp?id=<%=replacenull(rs_apply.getString("id"))%>&user_id=<%=replacenull(rs_apply.getString("user_id"))%>">[拒绝]</a></td>
</tr>
<% i++;
}%>
<tr>
<td width="125" colspan="2" height="15"> </td>
<td width="81" colspan="2" height="15"></td>
<td width="69" height="15"></td>
<td width="63" height="15"></td>
<td width="78" height="15"></td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr bgcolor="#CDDCEB">
<td colspan="5" height="18"> 您的交友请求有如下回复:</td>
</tr>
<tr bgcolor="#F2F2F2">
<td width="21%" align="center" style="border-bottom-style: solid">日期</td>
<td width="16%" align="center" style="border-bottom-style: solid">姓名</td>
<td width="9%" align="center" style="border-bottom-style: solid">性别</td>
<td width="13%" align="center" style="border-bottom-style: solid">网名</td>
<td width="38%" align="center" style="border-bottom-style: solid"> </td>
</tr>
<%i=0;
while(i<16 && rs_back.next()){
%>
<tr bgcolor="#FFF2EC">
<td width="21%" align="center"><%=replacenull(rs_back.getString("back_date"))%></td>
<td width="16%" align="center"><%=replacenull(rs_back.getString("name"))%></td>
<td width="9%" align="center"><%=replacenull(rs_back.getString("sex"))%></td>
<td width="13%" align="center"><%=replacenull(rs_back.getString("netname"))%></td>
<td width="38%" align="center">
<%String result1="已接受";
if(result1.equals(rs_back.getString("result")))
{%>
已接受 <a href="moveto.jsp?id=<%=rs_back.getString("id")%>">[移入好友列表]</a>
<%}%>
<%result1="已拒绝";
if(result1.equals(rs_back.getString("result"))){
%> 已拒绝
<%}%>
[<a href="delqq.jsp?id=<%=rs_back.getString("id")%>">删除</a>]</td>
</tr>
<% i++;
}%>
<tr>
<td width="21%"> </td>
<td width="16%"></td>
<td width="9%"></td>
<td width="13%"></td>
<td width="38%"> </td>
</tr>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="2">
<tr bgcolor="#EBEBEB">
<td colspan="4"><b><font color="#008000"><u> 网友留言</u></font></b></td>
</tr>
<tr>
<td width="90" align="center" style="border-bottom-style: solid">日期</td>
<td width="61" align="center" style="border-bottom-style: solid">网名</td>
<td width="261" align="center" style="border-bottom-style: solid" height="18">内容</td>
<td width="98" align="center" style="border-bottom-style: solid"> </td>
</tr>
<%i=0;
while(i<16 && rs_word.next()){
%>
<tr>
<td width="90" align="center" bgcolor="#DDF9FF" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="23"><%=replacenull(rs_word.getString("date"))%></td>
<td width="61" align="center" bgcolor="#DDF9FF" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="23"><a href="read1.jsp?user_id=<%=rs_word.getString("user_id")%>" target="_blank"><%=replacenull(rs_word.getString("netname"))%></a></td>
<td width="261" height="23" bgcolor="#DDF9FF" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF"><%=rs_word.getString("word")%></td>
<td width="98" align="center" bgcolor="#DDF9FF" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="23"><a href="leaveword.jsp?user_id=<%=rs_word.getString("user_id")%>">[回复]</a>[<a href="delliuyan.jsp?id=<%=rs_word.getString("id")%>">删除</a>]</td>
</tr>
<% i++;
}%>
<tr>
<td width="90" align="center"> </td>
<td width="61" align="center"></td>
<td width="261" align="center"></td>
<td width="98" align="center"></td>
</tr>
</table>
<%sql="select * from scott.larchives where user_id='"+user_id+"'";
rs_lar=stmt.executeQuery(sql);
if(rs_lar.next()){%>
<table border="0" height="2" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td height="6" width="498" style="border-bottom-style: solid" bordercolor="#000000"> </td>
</tr>
<tr bgcolor="#FFF5F0">
<td height="17" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF">您的人气度为<font color="red"><%=replacenull(rs_lar.getString("renqi"))%></font></td>
</tr>
<tr bgcolor="#FFF5F0">
<td height="17" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF">您的档案已被浏览了<font color="red"><%=replacenull(rs_lar.getString("click"))%></font>次</td>
</tr>
<tr bgcolor="#FFF5F0">
<td height="17" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF">您的入会日期是:<%=replacenull(rs_lar.getString("date"))%></td>
</tr>
<tr bgcolor="#FFF5F0">
<td height="17" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF">您的最后修改日期是:<%=replacenull(rs_lar.getString("date"))%></td>
</tr>
<tr bgcolor="#FFF5F0">
<td height="17" style="border-bottom-style: solid" bordercolor="#000000">
<a href="read.jsp?user_id=<%=user_id%>">[查看档案]</a><a href="edit.jsp?user_id=<%=user_id%>">[修改档案]</a><a href="sendphoto.jsp">[相片管理]</a></td>
</tr>
</table>
<%}%>
</td>
<td width="5" height="170" valign="top"> </td>
<td width="259" height="170" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="1">
<tr>
<td height="18" colspan="4"><font color="#008000"><b><u>您的网友列表</u></b></font></td>
</tr>
<tr bgcolor="#006600">
<td width="66" height="18" align="center" bgcolor="#CDDCEB"><font color="#000000">网名</font></td>
<td width="30" height="18" align="center" bgcolor="#CDDCEB"><font color="#000000">性别</font></td>
<td width="115" height="18" align="center" bgcolor="#CDDCEB"><font color="#000000">来自</font></td>
<td width="33" height="18" align="right" bgcolor="#CDDCEB"> </td>
</tr>
<%i=0;
while(i<6 && rs_friend.next()){
%>
<tr>
<td width="66" bgcolor="#EEEEEE" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="18"><a href="read1.jsp?user_id=<%=rs_friend.getString("user_id")%>"><%=replacenull(rs_friend.getString("netname"))%></a></td>
<td width="30" align="center" bgcolor="#EEEEEE" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="18"><%=replacenull(rs_friend.getString("sex"))%></td>
<td width="115" bgcolor="#EEEEEE" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="18"><%=replacenull(rs_friend.getString("home"))%></td>
<td width="33" bgcolor="#EEEEEE" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#FFFFFF" height="18" align="right"><a href="delhy.jsp?id=<%=rs_friend.getString("id")%>">删除</a></td>
</tr>
<% i++;
}%>
</table>
<br>
<a href="pics.jsp" target="_blank"><font color="#660033" size="2">网友照片</font></a>
</td>
</tr>
</table>
<map name="FPMap1"> <area shape="rect" coords="381, 4, 446, 18" href="sendphoto.jsp">
<area shape="rect" coords="283, 4, 357, 18" href="register.jsp"
target="_blank"> <area shape="rect" coords="190, 4, 264, 18" href="list.jsp">
<area shape="rect" coords="8, 2, 71, 16" href="your.jsp"> <area shape="rect" coords="102, 4, 168, 18" href="no.htm">
</map>
<map name="Map">
<area shape="rect" coords="231,93,279,111" href="default.jsp">
<area shape="rect" coords="289,93,358,111" href="your.jsp">
<area shape="rect" coords="379,94,448,112" href="list.jsp">
<area shape="rect" coords="467,93,532,109" href="register.jsp">
<area shape="rect" coords="553,93,620,113" href="sendphoto.jsp">
<area shape="rect" coords="640,93,705,111" href="pics.jsp">
</map>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -