📄 index.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="err.jsp" %>
<html><script language="JavaScript"></script></html>
<html>
<head>
<link rel='stylesheet' type='text/css' href='inc/FORUM.CSS'>
<META NAME="keywords" CONTENT="溢洋 溢洋论坛 xyworker@163.com java forum jsp forum">
<META NAME="description" CONTENT="溢洋 溢洋论坛 xyworker@163.com java forum jsp forum">
<script language="JavaScript">
function Popup(url, window_name, window_width, window_height)
{ settings=
"toolbar=no,location=no,directories=no,"+
"status=no,menubar=no,scrollbars=yes,"+
"resizable=yes,width="+window_width+",height="+window_height;
NewWindow=window.open(url,window_name,settings); }
function icon(theicon) {
document.input.message.value += " "+theicon;
document.input.message.focus();
}
</script>
<title>溢洋论坛</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table cellspacing="0" cellpadding="0" border="0" width="99%" align="center">
<tr><td >
<jsp:include page="inc/public.jsp" flush="true"/>
<tr>
<td width="734" class="tablerow" colspan="7" height="16">
<table border="0" cellspacing="0" width="100%" cellpadding="0">
<tr>
<td width="12%"><font color="#333399"><b><img src="image/gb.gif" width="21" height="14">论坛公告:</b></font></td>
<td width="88%"> <marquee width="648" height="12" direction="left">
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%
Connection con=yy.getConn();
Statement stmt=con.createStatement();
ResultSet rs=null;
String sql="select 公告标题,公告内容,公告时间 from 公告 order by 公告id desc";
String Notice="";
int i=0;
rs=stmt.executeQuery(sql);
//rs.last();
//if (rs.getRow()>0)
//{
while ((rs.next())&&(i<5))
{
String Time=rs.getString("公告时间");
Time=Time.substring(5,16);
Notice="<B>"+rs.getString("公告标题")+":</B><font color=black>"+rs.getString("公告内容")+"</font><font color=gray> "+Time+"</font> "+Notice;;
i++;
}
out.println(Notice);
%>
</marquee> </td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#9CCFFF">
<td width="15" height="14"> </td>
<td width="247" height="14" bgcolor="#9CCFFF">论坛列表</td>
<td width="28" align="center" height="14">新窗</td>
<td width="58" align="center" height="14">主题数量</td>
<td width="57" align="center" height="14">贴子数量 </td>
<td width="170" align="center" height="14">最后回复</td>
<td width="63" align="center" height="14">版主</td>
</tr>
<%
sql="SELECT * FROM 论坛栏目";
rs=stmt.executeQuery(sql);
while (rs.next())
{
String Time_Str=rs.getString("最后发表时间");
String Man_Str=rs.getString("最后发表人");
String Forum_id=rs.getString("论坛id");
String Forum_Mastor=rs.getString("版主姓名");
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="15"><img src="image/folder.gif" width="13" height="16"></td>
<td height="26" width="247" bgcolor="#F7FBFF"><a href="board.jsp?fid=<%=Forum_id%>"> <%=rs.getString("论坛名称")%> </a>
<br />
</td>
<td align="center" height="26" width="28"> <a href="board.jsp?fid=<%=Forum_id%>" target="_blank"><img border="0" src="image/newwin.gif" width="14" height="11"></a></td>
<td align="center" height="26" width="58"><%=rs.getString("主题数量")%></td>
<td align="center" height="26" width="57"><%=rs.getString("贴子数量")%></td>
<td height="26" width="170">时间：<%=Time_Str.substring(0,16)%><br>
作者：<%=Man_Str%></a></td>
<td align="center" height="26" width="63"><%=Forum_Mastor%></td>
</tr>
<%
}
%>
<jsp:include page="inc/showonline.jsp" flush="true"/>
</table>
</td></tr></table>
<jsp:include page="inc/jumpboard.jsp" flush="true"/>
<html><script language="JavaScript"></script></html>
<%
try {
rs.close();
stmt.close();
con.close();
}
catch (Exception ex) {
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -