usercount.java

来自「这是一个JSP做的主页管理系统」· Java 代码 · 共 47 行

package com.gbsource.homepage.admin;

import java.sql.*;
/**
 * Title:        华源网络主页基地管理
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      Gbsource Studio
 * @author fishwu
 * @version 1.0
 */

public class UserCount
{
  private static BeansConstants CONST;
  private int PageSize;
  private int TotalCount;
  private int PageCount;
  public  UserCount()
  {
    PageSize = CONST.PageSize;
    String sql;
    sql = "select count(*) from users";
    try{
      Database db = new Database(sql);
      ResultSet rs = db.executeQuery();
      if(rs.next())
        TotalCount = rs.getInt(1);
      else
        TotalCount = 0;
      sql = null;
      rs.close();
      rs = null;
      db.close();
      db = null;
    }catch(Exception e){}
    PageCount = (TotalCount-1) / PageSize + 1;
  }
  public int getCount()
  {
    return TotalCount;
  }
  public int getPageCount()
  {
    return PageCount;
  }
}