📄 listboard.jsp.htm
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.*,java.sql.*,java.text.DateFormat,java.net.*"%>
<html>
<head>
<title>论坛板块列表</title>
</head>
<body>
<%//防止某些用户不进行登陆，直接想进入此页面
if (session.getAttribute("username")==null){
response.sendRedirect("login1.jsp");
}%>
<%
//接收登陆用户的身份等级信息rankid
int rankid=Integer.parseInt(request.getParameter("rankid"));
//加载数据库驱动并用连接池连结数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
%>
<center><h2>论坛栏目</h2></center>
<marquee scrollamount="2">
Welcome，来自<%=request.getRemoteAddr()%>的朋友，现在是 <%=(new java.util.Date()).toLocaleString()%>
</marquee>
<h3>
     <a href="manage.jsp?rankid=<%=rankid%>">用户管理</a>
     <a href="logout.jsp"%>退出论坛</a>
     <a href="userinf.jsp"%>查看修改用户信息</a>
</h3>
<br>
<table width="90%" align="center" cellpadding="3" cellspacing="1">
<tr>
<td bgcolor="#009933" width="5%"> </td>
<td bgcolor="#009933" width="54%" align="center">论坛</td>
<td bgcolor="#009933" width="8%" align="center">主题</td>
<td bgcolor="#009933" width="8%" align="center">帖子</td>
<td bgcolor="#009933" width="27%" align="center">最新帖子</td>
</tr>
<tr height="100">
<td bgcolor="#efefef" width="5%" align="center"> <img src="images/board.gif"></td>
<td bgcolor="#efefef" width="54%">
  <a href="listarticle.jsp?bid=1&rankid=<%=rankid%>">JSP技术</a>
<br>  探讨JSP技术方面的话题，如JavaBean、Servlet、JDBC等
<%
//查询JSP技术讨论区斑主的用户名
ResultSet rs = stmt.executeQuery("SELECT User.UserName FROM Articles , User where Articles.BoardID=1 and User.Rank=1 and Articles.AuthorID=User.ID");
rs.next();
String bm =rs.getString("UserName");
rs.close();
%>
<br>  版主:<%=bm%>
</td>
<%
//查询JSP技术讨论区发表的主题文章数量
rs = stmt.executeQuery("select Count(*) from Articles where BoardID=1 and ReplyID=0");
rs.next();
int sub1num=rs.getInt(1);
rs.close();
//查询JSP技术讨论区发表的所有文章数量
rs = stmt.executeQuery("select Count(*) from Articles where BoardID=1");
rs.next();
int total1num=rs.getInt(1);
rs.close();
%>
<td bgcolor="#efefef" width="8%" align="center"><%=sub1num%></td>
<td bgcolor="#efefef" width="8%" align="center"><%=total1num%></td>
<td bgcolor="#efefef" width="25%" nowrap="nowrap">
<%
//查询最新发表的文章
rs = stmt.executeQuery("select PostTime,UserName,Title from Articles,User where Articles.BoardID=1 and Articles.AuthorID=User.ID order by PostTime DESC");
rs.next();
%>
  <%=rs.getString("PostTime")%>
<br>  作者： <%=rs.getString("UserName")%>
<br>  标题： <%=rs.getString("Title")%>
</td>
</tr>
<tr height="100">
<td bgcolor="#efefef" width="5%" align="center"> <img src="images/board.gif"></td>
<td bgcolor="#efefef" width="54%">
  <a href="listarticle.jsp?bid=2&rankid=<%=rankid%>">音乐星空</a>
<br>  畅游音乐的天堂，感受美好的世界
<%
//查询音乐星空讨论区斑主的用户名
rs.close();
rs = stmt.executeQuery("select User.UserName from Articles,User where Articles.BoardID=2 and User.Rank=2 and Articles.AuthorID=User.ID");
rs.next();
bm =rs.getString("UserName");
rs.close();
%>
<br>  版主:<%=bm%>
</td>
<%
//查询音乐星空发表的主题文章数量
rs = stmt.executeQuery("SELECT Count(*) FROM Articles where BoardID=2 and ReplyID=0");
rs.next();
sub1num=rs.getInt(1);
rs.close();
//查询音乐星空发表的所有文章数量
rs = stmt.executeQuery("select Count(*) from Articles where BoardID=2");
rs.next();
total1num=rs.getInt(1);
rs.close();
%>
<td bgcolor="#efefef" width="8%" align="center"><%=sub1num%></td>
<td bgcolor="#efefef" width="8%" align="center"><%=total1num%></td>
<td bgcolor="#efefef" width="25%" nowrap="nowrap">
<%
//查询最新发表的文章
rs = stmt.executeQuery("SELECT PostTime,UserName,Title FROM Articles,User where Articles.BoardID=2 and Articles.AuthorID=User.ID order by PostTime DESC");
rs.next();
%>
  <%=rs.getString("PostTime")%>
<br>  作者： <%=rs.getString("UserName")%>
<br>  标题： <%=rs.getString("Title")%>
</td>
</tr>
</table>
<%
//关闭连
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -