package bookshop;
import java.sql.*;
public class Show {
	// 分頁控制子模塊
	// ShowOnePage(ResultSet, 頁數, 每頁記錄數)
	public String ShowOnePage( ResultSet rs, int Page , int PageSize)
	{
	  String str = "";	
	  for(int i=1; i<=(Page-1) * PageSize+1; i++) {
	     try {
		 	rs.next();	
	     }catch(Exception e) {}
	  }   
	  for(int iPage=1; iPage<=PageSize; iPage++) {
		 str += RsToGbook(rs);
		 try {
		     if(!rs.next()) break;
		 }catch(Exception e) {}
	  }
	  
	  return str;
	}
	
	// 顯示單行記錄子模塊
	public String RsToGbook( ResultSet rs ) {
		String tt = "";
		try {
			tt = "<hr color=#FFFFCC width='95%" + "'>";
			tt = tt + "<form name=querydata action=add.jsp>";
			tt = tt + "<Center><TABLE BORDER=1 WIDTH='95%'>";
			tt = tt + "<input type=hidden name=number value="+rs.getString("id")+">";
			tt = tt + "<TR><TD BGCOLOR=#FFFFCC Width='15%'>書籍名稱:</TD><TD>"+ rs.getString("name") + "</TD>";
			tt = tt + "<TD BGCOLOR=#FFCCCC Width='14%'>書籍作者：</TD><TD Width='21%'><Font color=#FFCCCC>" + rs.getString("author") + "</font></TD>";
			tt = tt + "<TR><TD BGCOLOR=#FFFFCC Width='15%'>書籍類別：</TD><TD><Font color=#FFCCCC><B>" + rs.getString("category") + "</B></Font></TD>";
			tt = tt + "<TD BGCOLOR=#FFCCCC>書籍價格：</TD><TD>" + rs.getInt("hits") + "</TD></TR>";
			tt = tt + "<TR><TD  BGCOLOR=#FFCCCC Width='15%'>書籍介紹：</TD>";
			String memo = rs.getString("introduction");
			tt = tt + "<TD COLSPAN=3>" + memo + "</TD></TR>";
			tt = tt + "<input type=submit name=submit value=add>";
			tt = tt + "<input type=submit name=submit value=remove>";
			tt = tt + "</TABLE></Center>";
			tt = tt + "</form>";
		}catch(SQLException e) {}
		return tt;
	}
	
}