showkindusercatalog.java

这是一个网上书站的例子

package com.zxf.page;

import java.sql.ResultSet;


import com.db.Jdo;

public class ShowKindUserCatalog implements ShowKind{

	public String showDetail(ResultSet rs) {
		// TODO Auto-generated method stub
		StringBuffer buffer=new StringBuffer();
		buffer.append("<td valign='top'>");
		try
		{
			rs.next();
			int bigcatalogid=rs.getInt("bigcatalogid");
			String bigcatalogname=rs.getString("catalogname");
			Jdo jdo=new Jdo();
			ResultSet rs1=jdo.executeQuery("select smallcatalogid,catalogname from smallcatalog where bigcatalogid="+bigcatalogid);
			Jdo jdo1=new Jdo();
			int count=jdo1.rowCount("select count(*) from smallcatalog where bigcatalogid="+bigcatalogid);
			jdo1.destroy();
			System.out.println(count);
			buffer.append("<table  table width=\"220\" height=\"73\"  border=\"0\" valign=top><tr>");
			buffer.append("<td  align='center' width=\"185\">"+bigcatalogname+"</td>");
			buffer.append("</tr><tr><td><table  height= border=\"0\">");
			int row=(int)Math.ceil((double)count/(double)3);
			System.out.println(row);
			int k=1;
			
				while(k<=row)
				{
					int i=1;
					
					buffer.append("<tr>");
					
					
					while(i<=3&&rs1.next())
					{	
						
						int smallcatalogid=rs1.getInt("smallcatalogid");
						String catalogname=rs1.getString("catalogname");
						buffer.append("<td><a href=scbook.jsp?catalogid="+smallcatalogid+">"+catalogname+"</a></td>");
						i++;
					}
					buffer.append("</tr>");
					k++;
				}
			
			
			
			
			buffer.append(" </table></td></tr></table>");
			
			
			buffer.append("</td>");
			jdo.destroy();
		}
		catch(Exception e)
		{
			
		}
		return buffer.toString();
	}

	public String showTail(int totalindex) {
		// TODO Auto-generated method stub
		StringBuffer buffer=new StringBuffer();
		/*buffer.append("<table border=\"0\" align=\"right\"><tr><td>共"+totalindex+"页  分页：");
		
		for(int i=1;i<=totalindex;i++)
		{
			buffer.append("<a href=\""+"manage/allcatalog.jsp?index="+i+"\">"+i+"</a> &nbsp;");
		}
		buffer.append(" 页</td></tr></table>");*/
		return buffer.toString();
	}

}