package com.gbsource.homepage.admin;import java.sql.*;import com.gbsource.util.ToSQL;import javax.servlet.http.HttpServletRequest;/** * Title:        華源網(wǎng)絡主頁基地管理 * 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;  }}