import java.sql.ResultSet;
import java.sql.SQLException;

//分頁
public class Page   {
    private String view ;
    
    public String getView() {
        return view;
    }
    
    public void setView(ResultSet rs,String style,int go,int pagesize) throws SQLException {
        
        if(style.equals("table")){
            this.view = "<table border='2' width='350' align='center'>";
            int i = 0;
            if(go != 1)
                rs.absolute(go-1);
            else{
                rs.first();
                rs.previous();
            }
            int colsize = rs.getMetaData().getColumnCount();
            while (rs.next()) {
                if(++i <= pagesize){
                    this.view= this.view +"<tr>";
                    for(int k = 0;k<colsize;k++){
                        this.view= this.view +"<td>"+rs.getString(k+1) + "</td>";
                    }
                    this.view= this.view +"</tr>";
                }else{
                    break;
                }
            }
            //最后一頁
            if((go+pagesize) > this.getRow(rs)){
                this.view = this.view +"<tr><td><a href ='PageServlet?goto="+(go-pagesize)+"'>上一頁</a></td><td>末 頁</td></tr>";
            }//第一頁
            else if(go == 1){
                this.view = this.view +"<tr><td>首 頁</td><td><a href ='PageServlet?goto="+(go+pagesize)+"'>下一頁</a></td></tr>";
            } else{
                this.view = this.view +"<tr><td><a href ='PageServlet?goto="+(go-pagesize)+"'>上一頁</a></td><td><a href ='PageServlet?goto="+(go+pagesize)+"'>下一頁</a></td></tr>";
            }
            this.view= this.view +"</table>";
        }else{
            this.view = "沒有該樣式";
        }
    }
    
    public int getRow(ResultSet rs) throws SQLException {
        ResultSet rsr = rs;
        rsr.last();
        return rsr.getRow();
    }
    
}