default.jsp
来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 624 行 · 第 1/2 页
JSP
624 行
<tr>
<td>职业:<font color="#ff0000"><%=rs_girl.getString("job")%></font></td>
</tr>
<tr>
<td>来自:<font color="#ff0000"><%=rs_girl.getString("home")%></font></td>
</tr>
</table>
<%}
}%> </td>
<td width="202">
<% if(!rs_boy.next()){%>
<table border="0" width="206" cellspacing="0" cellpadding="0">
<tr>
<td width="100" align="center" rowspan="7"><img border="0" src="image/x.jpg" width="79" height="105"></td>
<td width="15" align="center" rowspan="7"> </td>
<td width="60"> </td>
</tr>
<tr>
<td width="60"></td>
</tr>
<tr>
<td width="60"></td>
</tr>
<tr>
<td width="60"></td>
</tr>
<tr>
<td width="60"></td>
</tr>
<tr>
<td width="60" bgcolor="white"></td>
</tr>
<tr>
<td width="60"></td>
</tr>
</table>
<%}else{
Statement stmt7=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.friendimg where id='"+rs_boy.getString("user_id") +"' order by id desc";
ResultSet rs_boyimg=stmt7.executeQuery(sql);
if(rs_boyimg.next()){
%>
<table border="0" width="208" cellspacing="0" cellpadding="0">
<tr>
<td width="100" align="center" rowspan="6" height="155"><a href='read.jsp?user_id=<%=rs_boy.getString("user_id")%>'>
<img border="1" src='display.jsp?id=<%=rs_boyimg.getString("fid")%>' width="90" height="120"></a></td>
<td width="15" align="center" rowspan="6"> </td>
<td><font color="black"> </font></td>
</tr>
<tr>
<td>性别:<font color="#FF0000">男</font></td>
</tr>
<tr>
<td>网名:<font color="#ff0000"><%=rs_boy.getString("netname")%></font></td>
</tr>
<tr>
<td>学历:<font color="#ff0000"><%=rs_boy.getString("education")%></font></td>
</tr>
<tr>
<td>职业:<font color="#ff0000"><%=rs_boy.getString("job")%></font></td>
</tr>
<tr>
<td>来自:<font color="#ff0000"><%=rs_boy.getString("home")%></font></td>
</tr>
</table>
<%}
}%> </td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr align="center">
<td width="100%" valign="top">
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table border="0" cellpadding="5" cellspacing="0" align="center" width="100%">
<tr>
<td bordercolor="#FF9900" colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25%"><img src="image/1%5B3%5D.gif" width="12" height="12">
本周强力推荐<img src="image/1%5B3%5D.gif" width="12" height="12"></td>
<td width="75%">
<hr noshade size="1">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" width="30%" rowspan="8"><a href='read.jsp?user_id=21'><font color="black"><img border="1" src='display.jsp?id=43' width="90" height="120"></font></a><a href="read.jsp?user_id=143" target="_blank"><br>
详细资料--> </a></td>
<td rowspan="8" align="center" valign="top">
<table width="98%" border="0" cellspacing="0" cellpadding="2">
<tr align="center" bgcolor="#FFFFFF">
<td width="70%" height="15">第1期（2月12日--3月19日）</td>
</tr>
<tr>
<td width="70%">
<p>网名：<font color="#660000"> 真水无香</font></p>
</td>
</tr>
<tr align="center">
<td width="70%" align="left">来自：<font color="#660000">
广东省深圳市</font></td>
</tr>
<tr align="center">
<td width="70%" align="left">
<p>职业： 管理</p>
</td>
</tr>
<tr align="center">
<td width="70%" align="left">
<p>性格： 比较犹豫</p>
</td>
</tr>
<tr align="center">
<td width="70%" align="left">
<p>OICQ：<font color="#660000"> -没填-</font></p>
</td>
</tr>
<tr align="center">
<td width="70%" align="left">
<p>生日：<font color="#660000"> 保密</font></p>
</td>
</tr>
<tr align="center">
<td width="70%" align="left"> 主页： <font color="#660000"></font></td>
</tr>
<tr align="center">
<td width="70%" align="left">
<p>自我介绍：喜欢玩风云江湖</p>
</td>
</tr>
</table>
</td>
</tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
<tr align="center"> </tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td> </td>
</tr>
</table>
</td>
<!--2td-->
<td width="151" bgcolor="white" valign="top" align="center">
<table border="0" width="98%" cellpadding="0" cellspacing="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr valign="top">
<td></td><br>
</tr>
</table>
<table border="0" width="100%" bgcolor="#067B0F" cellpadding="1" cellspacing="1">
<tr>
<td width="151">
<table
border="0" cellspacing="0" width="100%" height="1" align="center" cellpadding="0">
<tr bgcolor="#067B0F">
<td width="153" height="15" bgcolor="#AEC9E3">
<p
align="center"><font face="Wingdings" color="#000000">1</font><font face="Wingdings" color="#FFFF33">
</font><font color="#000000">人气排行榜 </font>
</td>
</tr>
<tr>
<td width="153" height="33" bgcolor="white">
<table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#DDF9FF">
<tr bgcolor="#DDF9FF">
<td width="28%" align="center" ><font color="#000000">性别</font></td>
<td width="46%" align="center" height="16">
<p align="left"><font color="#000000">网名</font></p>
</td>
<td width="26%" align="center" height="16"><font color="#FFFFFF">人气</font>
</td>
</tr>
<% int i=1;
while(i<11 && rs_lar.next()){
%>
<tr>
<td width="28%" align="center" height="18" ><%=replacenull(rs_lar.getString("sex"))%></td>
<td width="46%" align="center" height="18">
<p align="left"><a href="read.jsp?user_id=<%=replacenull(rs_lar.getString("user_id"))%>"><%=replacenull(rs_lar.getString("netname"))%></a>
</td>
<td width="26%" align="center" height="18"><%=replacenull(rs_lar.getString("renqi"))%>
</td>
</tr>
<%i++;
}
rs_lar.close();%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" width="100%" bgcolor="#067B0F" cellspacing="1" cellpadding="1">
<tr>
<td width="151">
<table
border="0" cellspacing="0" width="100%" bordercolor="white" cellpadding="0">
<tr bgcolor="#067B0F">
<td height="15" bgcolor="#AEC9E3">
<p
align="center"><font face="Wingdings" color="#FFFF66">1
</font><font color="#FFFF66">最新加入网友</font>
</td>
</tr>
<tr>
<td height="23" bgcolor="white">
<table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#DDF9FF">
<tr bgcolor="#DDF9FF">
<td width="26%" bgcolor="#DDF9FF">
<p align="center"><font color="#000000">性别</font></p>
</td>
<td width="53%" height="16">
<p align="left"><font color="#000000">网名</font></p>
</td>
<td width="21%" height="16"><font color="#000000">人气</font></td>
</tr>
<% i=1;
while(i<11 && rs_new.next()){
%>
<tr bgcolor="#DDF9FF" class="unnamed1">
<td width="26%" align="center" height="18"><%=replacenull(rs_new.getString("sex"))%> </td>
<td width="53%" align="left" height="18" bgcolor="#DDF9FF">
<p align="left"><a href="read.jsp?user_id=<%=replacenull(rs_new.getString("user_id"))%>"><%=replacenull(rs_new.getString("netname"))%></a>
</td>
<td width="21%" align="center" height="18"><%=replacenull(rs_new.getString("renqi"))%></td>
</tr>
<%i++;
}
rs_new.close();%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<p> </p>
<p> [<a href="adminlogin.jsp">管理入口</a>] </p>
</table>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="a.jpg" width="774" height="120"></td>
</tr>
</table>
<table border="1" cellspacing="7" cellpadding="7" bordercolorlight="#990000" bordercolordark="#990000" bordercolor="#660000" width="780" bgcolor="#FFF7F7" align="center" >
<tr align="center">
<% sql="select * from scott.friendimg order by fid desc";
rs_lar=stmt.executeQuery(sql);
i=1;
while(rs_lar.next()){
%>
<td> <a href="display.jsp?id=<%=rs_lar.getString("fid")%>" target="_blank"><img border="1" src='displaypic.jsp?id=<%=rs_lar.getString("fid")%>' width="90" height="120" alt="点击放大！" onClick="return js_openpage(this.href);"></a>
<br>
<a href="read.jsp?user_id=<%=rs_lar.getString("id")%>" target="_blank">详细资料</a>
<% String rrr="ok";
String admin_pass= (String) session.getValue("admin_pass");
if(rrr.equals(admin_pass)){
%>
<a href="deluser.jsp?user_id=<%=rs_lar.getString("id")%>">删</a> <a href="delpic.jsp?id=<%=rs_lar.getString("fid")%>">删照</a>
<%}%>
</td>
<%if((i%6)==0){
out.print("<tr align='center'>");
}
i++;
}%>
</tr>
</table>
<table width=772 border=0 cellspacing=0 cellpadding=0 align="center">
<tr align=center>
<td colspan=2 height="17">
<hr width=350 size=1 noshade>
<tr align=center>
<td colspan=2 height="17"> Copyright ©亮中计算机技术服务有限公司 2004
</table>
<map name="Map2">
<area shape="rect" coords="235,94,274,113" href="default.jsp">
<area shape="rect" coords="298,96,363,111" href="your.jsp">
<area shape="rect" coords="383,95,445,110" href="list.jsp">
<area shape="rect" coords="472,95,531,111" href="register.jsp">
<area shape="rect" coords="556,95,615,109" href="sendphoto.jsp">
<area shape="rect" coords="638,92,698,110" href="pics.jsp">
</map>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?