index.jsp

jsp 和 access 联合开发的聊天小程序

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.jsp" %>
<%@ include file="top.jsp" %>
<link href="css.css" rel="stylesheet" type="text/css">
<meta name="Keywords" content="Eron留言本，初学期所做，请随意使用修改，本人不保留任何权利，嘿" />
<title>留言本</title>

<%
try{
String name;
name= (String) session.getValue("name");
if(name!=null)
{
out.print("<table bgcolor='#cccccc' width='771' align=center border=0 cellspacing=1><tr><td bgcolor=white align=center>管理员<font color=blue>"+session.getValue("name")+"</font>");
out.print("已登陆&nbsp;&nbsp;&nbsp;&nbsp;<a href=index.jsp?loginout=true>退出登陆</a></td></tr></table><br>");
String loginout=request.getParameter("loginout");
	if(loginout!=null)
	{
		if(loginout.compareTo("true")==0)
		{
			session.removeAttribute("name");
			response.sendRedirect("index.jsp");
		}
	}
}else{
	out.print("<center><a href=login.jsp>管理登陆</a></center>");
}

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from a order by sj desc");
int i=1;
int pagesize=8;
int pagecount;
int rowcount;
int gopage;
rs.last(); //将指针移动到表中的记录的最后面
rowcount = rs.getRow();//统计出一共有多少个记录
pagecount=(rowcount+pagesize-1)/pagesize;//得到需要显示的总页数
//=============================以数字显示需要跳转到哪一页===========================================
if(request.getParameter("page")!=null){//假如接收的页面数不为空
gopage = java.lang.Integer.parseInt(request.getParameter("page"));//就把接收的页面数pagg赋值给gopage
}else{//否则
gopage=1;//gopage为1，即显示第一页
}
//==================================================================================================
rs.absolute((gopage-1)*pagesize+1);//将指针定位到哪一条记录

while(i<=pagesize && !rs.isAfterLast()){
%>
<table width="771" border="0" align="center" cellspacing="1" bgcolor="#666666">
  <tr>
    <td width="200" height="178" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0">
      <tr>
        <td height="82"align="center"><img src=<%out.print(rs.getString("tx"));%>>		</td>
      </tr>
      <tr>
        <td height="25"><div align="center">
          <%
		out.print(rs.getString("username")+"&nbsp;[<font color='#6666ff'>"+rs.getString("sex")+"</font>]");
		%>
        </div></td>
      </tr>
      <tr>
        <td height="25"><div align="center">
          <%
		out.print(rs.getString("sj"));
		%>
        </div></td>
      </tr>
      <tr>
        <td height="25"><div align="center"><img src="images/email.gif" width="60" height="17"  alt="<%out.print(rs.getString("email"));%>"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<a href='tencent://message/?uin=<%out.print(rs.getString("qq"));%>"&Site=im.qq.com&Menu=yes'><img src="images/QQ.gif" width="60" height="17" alt="点击与对方建立QQ临时会话"border=0/></a></div></td>
      </tr>
      
    </table></td>
    <td bgcolor="#FFFFFF"><div align="center">
      <br />
      <table width="90%" height="20" border="0" cellspacing="1" bgcolor="#CCCCCC">
        <tr>
          <td bgcolor="#FFFFFF"><div align="left">主题：
<%
		  out.print(rs.getString("zt"));
		  %>          
          </div></td>
        </tr>
      </table>
      <br />
      <table width="90%" height="127" border="0" cellspacing="1" bgcolor="#CCCCCC">
        <tr>
          <td bgcolor="#FFFFFF">
		    <div align="left">
		      <%
		  out.print(rs.getString("nr"));
		  %>  
	          </div></td>
        </tr>
      </table>
      <br />
      <table width="90%" height="20" border="0" cellspacing="1" bgcolor="#CCCCCC">
        <tr>
          <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0">
            <tr>
              <td width="50%"><span class="STYLE2">毕业设计之留言本</span></td>
              <td>		  <%
		  if(name!=null){
		  out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=del.jsp?id="+rs.getInt("id")+"><font color='#666666'>删除</font></a>");
		  }
		  %></td>
              <td width="15%" class="STYLE3"><div align="center"><a href="#top">#TOP </a><a href="#foot">#BOT</a></div></td>
            </tr>
          </table>		  </td>
        </tr>
      </table>
      <br>
    </div></td>
  </tr>
</table><br>
<%
rs.next();
i++;
}
	rs.close();
	stmt.close();						
%>
<table width="771" height="22" border="0" align="center" cellspacing="1" bgcolor="#999999">
  <tr>
    <td height="20" align="center" bgcolor="#CCCCCC" style="WORD-BREAK: break-all; WORD-WRAP: break-word">
共<%=pagecount%>页&nbsp;&nbsp;当前第<%=gopage%>页
      <% 
for(int j=1;j<=pagecount;j++){
out.print("&nbsp;&nbsp;<a href='index.jsp?page="+j+"'>"+j+"</a>");
}
}catch(Exception e){
out.print("<center>错误页码或无记录</center>");

}
%>&nbsp;&nbsp;&nbsp;&nbsp; 
      <div id="Layer1">
  <form id="form1" name="form1" method="post" action="index.jsp" >
        <label>
        <input name="page" type="text" class="dl2" id="page" size="3" />
        </label>
                    <label>
                    <input name="Submit" type="submit" class="dl2" value="GO" />
              </label>
</form>  </div>
</td>
  </tr>
</table>

<%@ include file="foot.jsp" %>