visble.java

网上书店,简单代码.让初学者容易掌握内容

package bookshop;
import java.sql.*;
public class Visble {
	// 分页控制子模块
	// 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 + "<Center><TABLE BORDER=1 WIDTH='95%'>";
			tt = tt + "<TR><TD BGCOLOR=#FFFFCC Width='15%'>书籍名称:</TD><TD>"+ rs.getString("name") + "</TD>";
			tt = tt + "<TD BGCOLOR=#FFFFCC Width='14%'>书籍作者：</TD><TD Width='21%'><Font color=#ff0000>" + rs.getString("author") + "</font></TD>";
			tt = tt + "<TR><TD BGCOLOR=#FFFFCC Width='15%'>书籍类别：</TD><TD><Font color=#ff0000><B>" + rs.getString("category") + "</B></Font></TD>";
			tt = tt + "<TD BGCOLOR=#FFFFCC>书籍价格：</TD><TD>" + rs.getInt("hits") + "</TD></TR>";
			tt = tt + "<TR><TD  BGCOLOR=#FFFFCC Width='15%'>书籍介绍：</TD>";
			String memo = rs.getString("introduction");
			tt = tt + "<TD COLSPAN=3>" + memo + "</TD></TR>";
			tt = tt + "</TABLE></Center>";
		}catch(SQLException e) {}
		return tt;
	}
	
	
}