userlist.java

mail sent and revesive system jsp+mysql

package fengyun.Fastmail.beans.admin;

import java.sql.*;
import java.util.*;
import fengyun.Fastmail.beans.*;

public class UserList {
	private int page = 1;
	private int start = 0;
	private int end = 0;
    private int pagesize = 20;
	private Pager pager = null;
	private ResultSet rs = null;
	public void setPage(int page) { this.page = page; }
	public int getPage() { return page; }

	public boolean isFirstPage() {
	  return (pager.isFirstPage());
	}
	public boolean isLastPage() {
	  return (pager.isLastPage());
	}
	public boolean select() {
	  try {
	    Mysql mysql = new Mysql();
	    rs = mysql.executeQuery("select count(*) from profile");
	    rs.next();
	    int total = rs.getInt(1);
	    pager = new Pager(total,page,pagesize);
	    start = pager.getStart();
	    end = pager.getEnd();
	    rs.close();
	    if (total == 0) {
	      return false;
	    } else {
	      rs = mysql.executeQuery("select * from profile order by userid asc");
	      rs.absolute(start);
	      mysql.close();
	    }
	  } catch (Exception ex) {
	    System.err.println("UserList.select():");
	    ex.printStackTrace(System.err);
	  }
	  return true;
	}
	public boolean next() {
	  try {
	    return (rs.next() && ++start<=end);
	  } catch (Exception ex) {
	    return false;
	  }
	}
	public String getUserid() {
	  try {
	    return (rs.getString("userid"));
	  } catch (Exception ex) {
	    return null;
	  }
	}

	public String getUsername() {
	  try {
	    return (rs.getString("Username"));
	  } catch (Exception ex) {
	    return null;
	  }
	}

	public String getGender() {
	  try {
	    return (rs.getString("gender"));
	  } catch (Exception ex) {
	    return null;
	  }
	}

	public String getBgcolor() {
	 return ((start%2==0)?"#f3f3f3":"#ffffff");
	}
	public boolean isValid() {
	  return (page>0);
	}
}