?? listboard.jsp.htm
字號(hào):
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.*,java.sql.*,java.text.DateFormat,java.net.*"%>
<html>
<head>
<title>論壇板塊列表</title>
</head>
<body>
<%//防止某些用戶(hù)不進(jìn)行登陸，直接想進(jìn)入此頁(yè)面
if (session.getAttribute("username")==null){
response.sendRedirect("login1.jsp");
}%>
<%
//接收登陸用戶(hù)的身份等級(jí)信息rankid
int rankid=Integer.parseInt(request.getParameter("rankid"));
//加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)并用連接池連結(jié)數(shù)據(jù)庫(kù)
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，來(lái)自<%=request.getRemoteAddr()%>的朋友，現(xiàn)在是 <%=(new java.util.Date()).toLocaleString()%>
</marquee>
<h3>
     <a href="manage.jsp?rankid=<%=rankid%>">用戶(hù)管理</a>
     <a href="logout.jsp"%>退出論壇</a>
     <a href="userinf.jsp"%>查看修改用戶(hù)信息</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技術(shù)</a>
<br>  探討JSP技術(shù)方面的話題，如JavaBean、Servlet、JDBC等
<%
//查詢(xún)JSP技術(shù)討論區(qū)斑主的用戶(hù)名
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>
<%
//查詢(xún)JSP技術(shù)討論區(qū)發(fā)表的主題文章數(shù)量
rs = stmt.executeQuery("select Count(*) from Articles where BoardID=1 and ReplyID=0");
rs.next();
int sub1num=rs.getInt(1);
rs.close();
//查詢(xún)JSP技術(shù)討論區(qū)發(fā)表的所有文章數(shù)量
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">
<%
//查詢(xún)最新發(fā)表的文章
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>  標(biāo)題： <%=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%>">音樂(lè)星空</a>
<br>  暢游音樂(lè)的天堂，感受美好的世界
<%
//查詢(xún)音樂(lè)星空討論區(qū)斑主的用戶(hù)名
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>
<%
//查詢(xún)音樂(lè)星空發(fā)表的主題文章數(shù)量
rs = stmt.executeQuery("SELECT Count(*) FROM Articles where BoardID=2 and ReplyID=0");
rs.next();
sub1num=rs.getInt(1);
rs.close();
//查詢(xún)音樂(lè)星空發(fā)表的所有文章數(shù)量
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">
<%
//查詢(xún)最新發(fā)表的文章
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>  標(biāo)題： <%=rs.getString("Title")%>
</td>
</tr>
</table>
<%
//關(guān)閉連
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -