default.jsp
来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 624 行 · 第 1/2 页
JSP
624 行
<%@ include file="conn.jsp"%>
<%@ page import="java.util.*, java.text.*" %>
<%request.setCharacterEncoding("GB2312");
String user_id= (String) session.getValue("user_id");
if((user_id==null)|(user_id=="")){
session.putValue("user_id","1");
}
//取得入会人数
String sql="select count(user_id) from scott.user_reg ";
ResultSet rt=stmt.executeQuery(sql);
rt.next();
int records=rt.getInt(1);
//String name=request.getString("name");
//取得当天入会人数
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd-M月- yyyy");
java.util.Date currentTime_1 = new java.util.Date();
Statement stmt0=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select count(user_id) from scott.user_reg where date1>='"+formatter.format(currentTime_1)+"'";
ResultSet rs_today=stmt0.executeQuery(sql);
rs_today.next();
int today_records=rs_today.getInt(1);
//取得人气最高的网友（10位）
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.larchives order by renqi desc";
ResultSet rs_lar=stmt1.executeQuery(sql);
//取得人气最高的男主角
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.larchives where photo>0 and sex like '男' order by renqi desc";
ResultSet rs_boy=stmt2.executeQuery(sql);
//取得人气最高的女主角
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.larchives where photo>0 and sex like '女' order by renqi desc";
ResultSet rs_girl=stmt3.executeQuery(sql);
//取得最新加入的网友（10位）
Statement stmt4=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.larchives order by lar_id desc";
ResultSet rs_new=stmt4.executeQuery(sql);
//取得寻友启事
Statement stmt5=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.callboard order by id desc";
ResultSet rs_board=stmt5.executeQuery(sql);
%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<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>
<meta name="generator" content="Namo WebEditor v4.0(Trial)">
<style type="text/css"></style>
<link rel="stylesheet" href="ysb.css">
<style type="text/css">
<!--
body {
background-image: url(bihaibg.jpg);
}
-->
</style>
</head>
<body bgcolor="#ffffff" text="black" link="#003300" vlink="#660000" alink="#CC0033" leftmargin="1"
topmargin="0">
<table width="772" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><img src="images/top.gif" width="772" height="112" usemap="#Map2" border="0"></td>
</tr>
</table>
<table border="0" width="772" cellspacing="0" cellpadding="0" bordercolor="white" bordercolordark="white" bordercolorlight="white" bgcolor="#FFFFFF" align="center">
<tr>
<td width="182" bgcolor="#ffffff" valign="top" align="center" bordercolor="#660000">
<table
border="0" cellspacing="0" width="160"
height="1" cellpadding="0">
<tr>
<td height="102" bgcolor="white">
<table cellspacing=0 cellpadding=0 width="100%"
border=0>
<tbody>
<tr>
<td width="100%"></td>
</tr>
<tr>
<td width="100%"><img src="image/03.gif" width="165" height="24"></td>
</tr>
<tr>
<td>
<div align=center>
<center>
<table border="0" width="165" background="image/bg2.gif">
<tr align="center" valign="bottom">
<td width="100%">
<form action="login.jsp" method="POST">
<table border="0" width="160" cellspacing="0" cellpadding="0">
<tr>
<td width="31%" align="center" height="25">用户名:</td>
<td width="69%" height="25">
<input name=user_name style="BACKGROUND-COLOR:#FFEBE1;BORDER-BOTTOM:#000000 1px solid;BORDER-LEFT:#000000 1px solid;BORDER-RIGHT:#000000 1px solid;BORDER-TOP:#000000 1px solid;FONT-SIZE:9pt;WIDTH:80px">
</td>
</tr>
<tr valign="bottom">
<td width="31%" align="center" height="25">密
码:</td>
<td width="69%" height="25">
<input name=password style="BACKGROUND-COLOR:#FFEBE1;BORDER-BOTTOM:#000000 1px solid;BORDER-LEFT:#000000 1px solid;BORDER-RIGHT:#000000 1px solid;BORDER-TOP:#000000 1px solid;FONT-SIZE:9pt;WIDTH:80px" type="password">
</td>
</tr>
<tr align="center" valign="bottom">
<td colspan="2" height="30">
<input type="image" border="0" name="login" src="images/denglu.GIF" width="30" height="15" alt="用户登录">
<a href="reg.jsp" target="_blank" title="刚刚做完，只有几十张卡片！"><img src="images/zhuce.GIF" width="30" height="15" border="0" alt="新用户注册"></a>
</td>
</tr>
<tr align="center" valign="bottom">
<td colspan="2" height="17"> </td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<img src="image/02.gif" width="165" height="26" usemap="#Map" border="0"><map name="Map"><area shape="rect" coords="58,4,146,22" href="reg.jsp" target="_blank"></map>
</center>
</div>
</td>
</tr>
<tr>
<td width="100%"></td>
</tr>
</tbody>
</table>
</td>
</tr>
</table>
<table border="1" width="160" cellspacing="0" cellpadding="0" bordercolorlight="#330000" bordercolordark="#FFFFFF" bordercolor="#330000">
<tr bgcolor="#AEC9E3">
<td width="90" height="17" align="center">会员总数</td>
<td width="67" height="17" align="center">今日加入</td>
</tr>
<tr bgcolor="#DDF9FF">
<td width="90" align="center" height="20" bgcolor="#DDF9FF"><%=records%><font color="#FF0000"> </font></td>
<td width="67" align="center" height="20" bgcolor="#DDF9FF"><%=today_records%><font color="#FF0000"> </font></td>
</tr>
</table>
<br>
<table border="1" width="160" bordercolor="#CC0000" cellspacing="0" cellpadding="0" bordercolorlight="#990000" bordercolordark="#FFFFFF">
<tr bgcolor="#AEC9E3">
<td width="155" align="center" height="17"> 网 际 寻 友</td>
</tr>
<tr bgcolor="#DDF9FF">
<td width="155">
<form action="searchout.jsp" method="POST">
<table border="0" width="100%" cellspacing="0" cellpadding="0" bordercolor="#A5EF00">
<tr>
<td width="15%" height="17">
<input type="checkbox" name="c_sex" value="ON" checked>
</td>
<td width="20%" height="17">性别:</td>
<td width="65%" height="17">
<input type="radio" value="男" name="sex">
男
<input type="radio" value="女" name="sex" checked>
女</td>
</tr>
<tr>
<td width="15%" height="17">
<input type="checkbox" name="c_photo" value="ON" checked>
</td>
<td width="20%" height="17">照片</td>
<td width="65%" height="17">
<input type="radio" value="有" name="photo" checked>
有
<input type="radio" value="无" name="photo">
无 </td>
</tr>
<tr>
<td width="15%">
<input type="checkbox" name="c_name" value="ON">
</td>
<td width="20%">姓名:</td>
<td width="65%">
<input name=name style="BACKGROUND-COLOR:#FFEBE1;BORDER-BOTTOM:#000000 1px solid;BORDER-LEFT:#000000 1px solid;BORDER-RIGHT:#000000 1px solid;BORDER-TOP:#000000 1px solid;FONT-SIZE:9pt;WIDTH:90px">
</td>
</tr>
<tr>
<td width="15%">
<input type="checkbox" name="c_netname" value="ON">
</td>
<td width="20%">网名:</td>
<td width="65%">
<input name=netname style="BACKGROUND-COLOR:#FFEBE1;BORDER-BOTTOM:#000000 1px solid;BORDER-LEFT:#000000 1px solid;BORDER-RIGHT:#000000 1px solid;BORDER-TOP:#000000 1px solid;FONT-SIZE:9pt;WIDTH:90px" >
</td>
</tr>
<tr>
<td width="15%">
<input type="checkbox" name="c_job" value="ON">
</td>
<td width="20%">职业:</td>
<td width="65%">
<SELECT name="job" size="1">
<OPTION selected value=管理>管理</OPTION>
<OPTION value=工程>工程</OPTION>
<OPTION value=金融财务>金融财务</OPTION>
<OPTION value=技术>技术</OPTION>
<OPTION value=经济业务>经济业务</OPTION>
<OPTION value=法律>法律</OPTION>
<OPTION value=保险>保险</OPTION>
<OPTION value=教师>教师</OPTION>
<OPTION value=科研>科研</OPTION>
<OPTION value=设计>设计</OPTION>
<OPTION value=行政>行政</OPTION>
<OPTION value=文体卫生>文体卫生</OPTION>
<OPTION value=服务>服务</OPTION>
<OPTION value=军队公安>军队公安</OPTION>
<OPTION value=IT>IT</OPTION>
<OPTION value=公务员>公务员</OPTION>
<OPTION value=其它>其它</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td width="15%">
<input type="checkbox" name="c_age" value="ON">
</td>
<td width="20%">年龄:</td>
<td width="65%">
<input type="text" name="age1" size="2" value="30">
岁到
<input type="text" name="age2" size="2" value="20">
岁</td>
</tr>
<tr valign="bottom">
<td colspan="3" height="30">
<p align="center">
<input type="submit" name="Submit" value="搜索">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br>
</td>
<!--1td-->
<td width="439" valign="top">
<table border="0" width="100%">
<tr align="center">
<td>
<table border="0" width="419" cellspacing="0" cellpadding="0" height="163">
<tr>
<td width="228" valign="top">
<% if(!rs_girl.next()){%>
<table border="0" width="213" cellspacing="0" cellpadding="0">
<tr>
<td width="100" align="right" rowspan="7"><img border="0" src="image/x.jpg" width="79" height="105"></td>
<td width="15" align="center" rowspan="7"> </td>
<td><font color="#FFFFFF"> </font></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td rowspan="5"> </td>
</tr>
<tr> </tr>
<tr> </tr>
<tr> </tr>
<tr> </tr>
</table>
<%}else{
Statement stmt6=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.friendimg where id='"+rs_girl.getString("user_id") +"' order by id desc";
ResultSet rs_girlimg=stmt6.executeQuery(sql);
if(rs_girlimg.next()){
%>
<table border="0" width="209" cellspacing="0" cellpadding="0">
<tr>
<td width="100" align="center" rowspan="6" height="155"><a href='read.jsp?user_id=<%=rs_girl.getString("user_id")%>'><font color="black"><img border="1" src='display.jsp?id=<%=rs_girlimg.getString("fid")%>' width="90" height="120"></font></a></td>
<td width="15" rowspan="6" valign="bottom"> </td>
<td><font color="black"> </font></td>
</tr>
<tr>
<td>性别:<font color="#CC0033">女</font></td>
</tr>
<tr>
<td>网名:<font color="#ff0000"><%=rs_girl.getString("netname")%></font></td>
</tr>
<tr>
<td>学历:<font color="#ff0000"><%=rs_girl.getString("education")%></font></td>
</tr>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?