top.jsp

这是一个JSP+SQL Server论坛管理系统 基本实现了论坛的所有功能 数据库文件在上传的文件中

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<jsp:include page="counter.jsp"/>
<%
ResultSet rs_user=connBean.executeQuery("select * from tb_user where username='"+session.getAttribute("username")+"'and status='版主'");
boolean eof=rs_user.next();
%>
<script language="javascript">
function clockon(){
	var date=new Date();
	var YY=date.getYear();
	var MM=date.getMonth()+1;
	var DD=date.getDate();
	var KK=date.getDay();
	var HH=date.getHours();
	var mm=date.getMinutes();
	var SS=date.getSeconds();
	if (MM<10) MM="0"+MM;
	if (DD<10) DD="0"+DD;
	if (HH<10) HH="0"+HH;
	if (mm<10) mm="0"+mm;
	if (SS<10) SS="0"+SS;
	switch (KK){
		case 1:
			KK="星期一";
			break;
		case 2:
			KK="星期二";
			break;
		case 3:
			KK="星期三";
			break;
		case 4:
			KK="星期四";
			break;
		case 5:
			KK="星期五";
			break;
		case 6:
			KK="星期六";
			break;
		case 0:
			KK="星期日";
			break;
	}
	var str_date=" 系统公告："+YY+"年"+MM+"月"+DD+"日 "+KK+" "+HH+":"+mm+":"+SS;
	if(document.all){
	div_date.innerHTML=str_date;
	}
	var timer=setTimeout("clockon()",200);
}
</script>
<table width="777" height="124"  border="0" align="center" cellpadding="0" cellspacing="0" class="table">
  <tr>
    <td align="center" valign="top" height="5"  bgcolor="#FFCCCC"></td>
  </tr>
  <tr>
    <td width="790" align="center" valign="top">      <img src="images/banner.gif" width="500" height="124"></td>
  </tr>
  <tr>
    <td align="center" valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0" class="table_T">
      <tr>
        <td height="5"></td>
      </tr>
    </table></td>
  </tr>
</table>

<table width="777" height="21"  border="0" align="center" cellpadding="0" cellspacing="0" background="images/revigate.GIF">
  <tr align="center" valign="middle">
  	<%if(session.getAttribute("username")!=null){%>
	<td width="104"><a href="Topic_add.jsp">签写留言</a></td>
        <td width="101"><a href="modify.jsp">修改资料</a></td>
	<%}else{%>
	<td width="104"><a href="reg.jsp">用户注册</a></td>
	<%}%>
    <td width="104">
	<%if(session.getAttribute("username")!=null){%>
	<a href="Logout_User.jsp">注销用户</a>
	<%}else{%>
	<a href="#" onClick="window.open('Login_User.jsp','','width=300,height=200');">用户登录</a>
	<%}%>
	</td>
    <td width="104"><a href="index.jsp">查看留言</a></td>
    <td width="104"><a href="#" onClick="window.location.reload();">刷新页面</a></td>
    <td width="104">
	<%if(eof){%>
	<a href="Logout_User.jsp">注销版主登录</a>
	<%}else{
	%><a href="#" onClick="window.open('Login_manager.jsp','','width=300,height=200');">版主登录</a><%}%></td>
  </tr>
</table>
<table width="777" height="47"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr align="center" valign="middle">
    <td height="2" colspan="6"></td>
  </tr>
  <tr align="center" valign="middle">
    <td width="18" height="17" align="left"><img src="images/speaker.GIF" width="16" height="16"></td>
    <td width="290" align="left"><div id="div_date">系统公告：</div></td>
    <td width="469" align="right" class="word">
	<%if(session.getAttribute("username")!=null){
	out.println("[ "+session.getAttribute("username")+" ]您好！您不想说点什么吗？如果想请点击“签写留言”！");
	}else{
	out.println("您好！如果您想说点什么，那么请先注册或登录！");
	}%>
	</td>
  </tr>
  <tr align="center" valign="middle">
    <td colspan="3"><marquee direction="left" scrollamount="2" scrolldelay="2">
      您好！　欢迎访问“在水一方”留言簿！！！已经有[ <%=application.getAttribute("count")%> ]人访问过本网站！
    </marquee></td>
  </tr>
</table>