statistic.jsp

网上购物系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%//@ page import="SessionCount.SessionCounter" %>

<table width="220" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FF0000">
  <tr>
    <td height="36" valign="middle" background="images/index-left2-1.gif" bgcolor="#FFFFFF"><div align="center" class="glow_white">站内统计</div></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td><%
//====================================
try
{
Statement stmtArticleCount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlArticleCount="Select count(*)  from tArticle";
ResultSet RsArticleCount=stmtArticleCount.executeQuery(sqlArticleCount); 

int ArticleCount=0; //总的记录数 

if (RsArticleCount.next()){ 
ArticleCount=RsArticleCount.getInt(1); 
}%>
            □- 文章中心 ：<font color="#FF0000"><%=ArticleCount%></font> 篇
            <%//out.print(ArticleCount);
RsArticleCount.close(); //关闭记录集对象
stmtArticleCount.close(); //关闭语句对象
}
catch(Exception e)
{
  System.out.println(e.getMessage());
} 
//================================================
%>
            <br />
            <%
try
{
//====================================
Statement stmtSoftCount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlSoftCount="Select count(*)  from tSoft";
ResultSet RsSoftCount=stmtSoftCount.executeQuery(sqlSoftCount); 

int SoftCount=0; //总的记录数 

if (RsSoftCount.next()){ 
SoftCount=RsSoftCount.getInt(1); 
}%>
            □- 下载中心 ：<font color="#FF0000"><%=SoftCount%></font> 个
            <%//out.print(ArticleCount);
RsSoftCount.close(); //关闭记录集对象
stmtSoftCount.close(); //关闭语句对象
}
catch(Exception e)
{
  System.out.println(e.getMessage());
} 
//================================================
%>
            <br />
            □- 当前在线 ：<font color="#FF0000">
			<%//= SessionCounter.getActiveSessions() %>
			</font>人 <br />
            <!--论坛信息 修改论坛首页调用的代码-->
            <script src="http://www.deepteach.com/Forum/Dv_News.asp?GetName=deep_info"></script>
          </td>
        </tr>
      </table></td>
  </tr>
</table>