📄 index.jsp
字号:
<%@ page import="java.sql.*,java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<html>
<head>
<link rel='stylesheet' type='text/css' href='imbed/forum.css'>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="80%" height="512" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="70%"height="72" colspan="2"><img src="images/qtop5.jpg" width="717" height="72"></td>
<td width="30%" align="left"><p><br>
</p>
<p> <img src="images/dot.gif" width="12" height="11"> <font size="2">
<a href="javascript:window.external.addFavorite('http://59.64.156.13','911论坛')" title="911论坛">收藏本站</a>
</font>
</p></td>
</tr>
<tr>
<td height="24" colspan="3" background="images/qback8.gif">
<form method="POST" name="form1" action="pass.jsp">
<tr bordercolor="#333333" bgcolor="#C9E4EB">
<td height="45" colspan="3">
<%
if (session.getValue("UserName")==null)
{
%>
<font size='2'>用户名:</font><input type="text" name="username" size="7"> <font size='2'>密码:</font><input type="password" name="password" size="6"> 【<a href='javascript:form1.submit()'><font size="2">登录</font></a>】【<a href="register.jsp"><font size="2">注册</font></a>】【<a href="forget_psw.jsp"><font size="2">忘记密码</font></a>】
<%
}
else
{ out.println("<font size='2'>"+session.getValue("UserName")+",欢迎您</font>");
out.println(" 【<a href='modify_info.jsp'><font size='2'>修改个人信息</font></a>】");
out.println(" 【<a href='logout.jsp'><font size='2'>退出</font></a>】");
if ((session.getValue("UserClass")!=null)&&session.getValue("UserClass").equals("3"))
{
out.println(" 【<a href='management_index.html'><font size='2'>管理员管理</font></a>】");
}
else if ((session.getValue("UserClass")!=null)&&session.getValue("UserClass").equals("2"))
{
out.println(" 【<a href='host_management_index.html'><font size='2'>版主管理</font></a>】");
}
else if ((session.getValue("UserClass")!=null)&&session.getValue("UserClass").equals("1"))
{
out.println(" 【<a href='apply_host.jsp'><font size='2'>申请版主</font></a>】");
}
}
%>
</td>
</tr>
<tr bordercolor="#333333" bgcolor="#FFFFFF">
<td width="70%"><img src="images/qleft6.jpg" width="319" height="37"><img src="images/qback6.gif" width="400" height="37"></td>
<td height="30%" colspan="2" background="images/qback6.gif"></td>
</tr>
<tr bordercolor="#333333" bgcolor="#FFFFFF">
<td height="154" colspan="3"><img src="images/qleft7.jpg" width="323" height="154"><img src="images/qleft8.jpg" width="295" height="154"><img src="images/qleft9.gif" width="406" height="154"></td>
</tr>
<tr bordercolor="#333333" bgcolor="#FFFFFF">
<td height="92" colspan="3" background="images/qback2.gif" ><p><strong><font size='2'>公告内容：</font></strong> </p>
<jsp:include page="imbed/scroll_bulletin.jsp" /></td>
</tr>
<tr bordercolor="#333333" bgcolor="#FFFFFF">
<td height="45" colspan="3"><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td width="23%"><div align="center"><strong><font size="2">论坛列表</font></strong></div></td>
<td width="19%"><div align="center"><strong><font size="2">主题数量</font></strong></div></td>
<td width="16%"><div align="center"><strong><font size="2">帖子数量</font></strong></div></td>
<td width="16%"><div align="center"><strong><font size="2">最后回复</font></strong></div></td>
<td width="21%"><div align="center"><strong><font size="2">版主</font></strong></div></td>
</tr>
<%
int i=0;
String sql="";
ResultSet rs=null;
ResultSet rs1=null;
int numofsubject=0;
sql="SELECT * FROM Community";
rs=yy.executeQuery(sql);
while (rs.next())
{
i=0;
String Time_Str=rs.getString("last_publishtime");
String Man_Str=rs.getString("last_publisher");
String Forum_id=rs.getString("community_id");
String State=rs.getString("state");
sql="select subject_id from Subject where community_id="+Forum_id;
rs1=yy.executeQuery(sql);
while(rs1.next())
{i++;}
numofsubject=i;
String Forum_Mastor=rs.getString("host_name");
if(Time_Str==null)
Time_Str="";
if (Man_Str==null)
Man_Str="无";
else
Man_Str="<a href='member.jsp?member="+Man_Str+"'>"+Man_Str+"</a>";
if ((Forum_Mastor==null)||(Forum_Mastor.equals("")))
Forum_Mastor="招骋中...";
else
Forum_Mastor="<a href=member.jsp?member="+Forum_Mastor+">"+Forum_Mastor+"</a>";
%>
<tr bgcolor="#F7FBFF">
<td align="center" height="26" width="5%"><img src="images/folder.gif" width="13" height="16"></td>
<td height="26" width="23%" bgcolor="#F7FBFF">
<%
if(State.equals("0")){%>
<font size='2'> <%=rs.getString("community_name")%></font>
<% }
else if(State.equals("1")){%>
<a href="forum_display.jsp?fid=<%=Forum_id%>"><font size='2'> <%=rs.getString("community_name")%></font> </a><%}%></td>
<td align="center" height="26" width="16%"><font size='2'><%=numofsubject%></font></td>
<td align="center" height="26" width="16%"><font size='2'><%=rs.getString("numofmessage")%></font></td>
<td height="26" width="19%"><br><font size='2'>时间：<%=Time_Str.substring(0,10)%><br>
作者：<%=Man_Str%></font></a></td>
<td align="center" height="26" width="21%"><font size='2'><%=Forum_Mastor%></font></td>
</tr>
<%
}
%>
</table>
<table width="100%">
<tr>
<%
String online,user_rank;
int k=0;
int j=0;
sql="select isonline from User";
rs=yy.executeQuery(sql);
while(rs.next())
{
online=rs.getString("isonline");
if(online.equals("1"))
k=k+1;
}
sql="select user_rank from User where isonline="+1;
rs=yy.executeQuery(sql);
while(rs.next())
{
user_rank=rs.getString("user_rank");
if(user_rank.equals("0"))
j=j+1;
}
yy.closeConn();
%>
<td valign="top" background="images/qback2.gif" ><p> <font size="2"> <strong>论坛统计信息</strong></font></p>
<p><strong><font size="2"><br>
在线用户 - </font></strong><font size="2">共<strong><%=k%></strong>人在线
</font></p>
<p><strong><font size="2"><br>
</font></strong></p></td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -