package fengyun.Fastmail.beans;

import java.sql.*;
import java.util.*;

public class AddressList {
	private java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat ("yyyy.MM.dd");
	private int page = 1;
	private int start = 0;
	private int end = 0;
	private String userid = null;
	private Pager pager = null;
	private ResultSet rs = null;
	public void setPage(int page) { this.page = page; }
	public int getPage() { return page; }
	public void setUserid(String userid) { this.userid = userid; }
	public String getUserid() { return userid; }
	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 address where userid='" + userid + "'");
	    rs.next();
	    int total = rs.getInt(1);
	    pager = new Pager(total,page,10);
	    start = pager.getStart();
	    end = pager.getEnd();
	    rs.close();
	    if (total == 0) {
	      return false;
	    } else {
	      rs = mysql.executeQuery("select * from address where userid='"+userid+"' order by id");
	      rs.absolute(start);
	      mysql.close();
	    }
	  } catch (Exception ex) {
	    System.err.println("Address.select():");
	    ex.printStackTrace(System.err);
	  }
	  return true;
	}
	public boolean next() {
	  try {
	    return (rs.next() && ++start<=end);
	  } catch (Exception ex) {
	    return false;
	  }
	}
	public int getId() {
	  try {
	    return (rs.getInt("id"));
	  } catch (Exception ex) {
	    return 0;
	  }
	}
	public String getRegdate() {
	  try {
	    return (formatter.format(rs.getDate("regdate")));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getUsername() {
	  try {
	    return (rs.getString("Username"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getEmail() {
	  try {
	    return (rs.getString("email"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getHomepage() {
	  try {
	    return (rs.getString("homepage"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getGender() {
	  try {
	    return (rs.getString("gender"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getLocation() {
	  try {
	    return (rs.getString("location"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getBpcode() {
	  try {
	    return (rs.getString("bpcode"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getHandset() {
	  try {
	    return (rs.getString("handset"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getZipcode() {
	  try {
	    return (rs.getString("zipcode"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getPhone() {
	  try {
	    return (rs.getString("phone"));
	  } catch (Exception ex) {
	    return null;
	  }
	}
	public String getBgcolor() {
	 return ((start%2==0)?"#f3f3f3":"#ffffff");
	}
	public boolean isValid() {
	  return (page>0 && userid != null && !userid.equals(""));
	}
}