📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看帖子信息</title>
</head>
<body onLoad="clockon(bgclock);">
<jsp:include page="top.jsp" flush="true"/>
<jsp:include page="top1.jsp" flush="true"/>
<jsp:include page="top2.jsp" flush="true"/>
<jsp:include page="top3.jsp" flush="true"/>
<jsp:useBean id="connection" scope="request" class="com.JDBConnection"/>
<jsp:useBean id="showTime" scope="request" class="com.ShowTime"/>
<%
//以下是查询主题的总数目
String selectNumber="";
String selectNumberSQL="select count(*) as number from tb_forumSend";
ResultSet allNumberRS=connection.executeQuery(selectNumberSQL);
try{
while(allNumberRS.next()){
selectNumber=allNumberRS.getString("number");
}
}catch(Exception e){}
//以下是查询今日主题总数目
String selectNumberDate="";
String selectNumberSQLDate="select count(*) as number from tb_forumSend where creatime='"+showTime.showTodayTime()+"'";
ResultSet allNumberDateRS=connection.executeQuery(selectNumberSQLDate);
try{
while(allNumberDateRS.next()){
selectNumberDate=allNumberDateRS.getString("number");
}
}catch(Exception e){}
connection.closeConnection();
%>
<table width="777" height="33" border="0" align="center" cellpadding="0" cellspacing="0" background="image/navigation3.jpg">
<tr>
<td> <font color="#FFFFFF">≡ 主题信息 ≡ </font></td>
</tr>
</table>
<%for(int i=0;i<4;i++){%>
<table width="777" border="0" align="center" cellpadding="0" cellspacing="0" background="image/navigation4.jpg">
<tr>
<td width="84" rowspan="2"> </td>
<td width="518" height="36" valign="bottom"> <a href="showInformation.jsp">明日科技出版的『 JSP 』类图书专区 </a> </td>
<td width="175" rowspan="2">创建时间：2006年09月30日<br><br>主题总数：<%=selectNumber%><br><br>今日主题数：<%=selectNumberDate%></td>
</tr>
<tr>
<td height="43"><font color="63659C">版主：mr</font></td>
</tr>
</table>
<%}%>
<jsp:include page="low.jsp" flush="true"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -