JSP留言簿系统无版权 第3页
top.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
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="10" bgcolor="#07AFBE"></td>
</tr>
<tr>
<td width="790" align="center" valign="top"> <img src="images/banner.gif" width="550" 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>
</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>
<%}%>
<% if(eof){%>
<td width="104"> <a href="Logout_User.jsp">注销版主登录</a>
<%}else{
if(session.getAttribute("username")!=null){%>
<td width="104">
<a href="Logout_User.jsp">注销用户</a>
<%}else{%>
<td width="104"> <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>
<%if(!eof){%>
<td width="104"><a href="#" onClick="window.open('Login_manager.jsp','','width=300,height=200');">版主登录</a></td><%}
else{%>
<td width="104"> <a href="#" onClick="window.open('Login_User.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>
</table>
index.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
ResultSet rs=connBean.executeQuery("select * from v_board");
ResultSet rs_user=connBean.executeQuery("select * from tb_user where username='"+session.getAttribute("username")+"'and status='版主'");
需要完整内容的请联系QQ3249114，JSP留言簿系统没有版权免费，转发请注明源于www.751com.cn
<table width="777" height="197" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="53%" height="5" valign="top"></td>
</tr>
<tr>
<td valign="top"><table width="100%" height="171" border="0" cellpadding="0" cellspacing="0" class="table">
<tr>
<td width="2%" height="26"