userlist.java

JSP主页基地管理系统

package com.gbsource.homepage.admin;

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

public class UserList
{
  private static BeansConstants CONST;
  private String keyword = null;
  private int page = 1;
  private int Count = 0;
  private ResultSet rs = null;
  public UserList(HttpServletRequest request)
  {
    keyword = request.getParameter("keyword");
    try{
      page = Integer.parseInt(request.getParameter("page"));
    }catch(Exception e){page = 1;}
    String sql = null;
    Database db = null;
    try{
      if(keyword == null || "".equals(keyword))
        sql = "select count(*) from users";
      else
        sql = "select count(*) from users where userid like '%" + ToSQL.WriteToSQL(keyword) + "%'";
      db = new Database(sql);
      rs = db.executeQuery();
      if(rs.next())
      {
        Count = rs.getInt(1);
      }
      else
      {
        Count = 0;
      }
      if(page < 1) page = 1;
      if(page > this.getPageCount()) page = this.getPageCount();
      db.close();
    }catch(Exception e){}
    sql = null;
    db = null;
  }
  public int getCount()
  {
    return this.Count;
  }
  public int getPage()
  {
    return this.page;
  }
  public String getKeyword()
  {
    return this.keyword;
  }
  public int getPageCount()
  {
    return (Count - 1) / CONST.PageSize + 1;
  }
}