showkindindexbook.java

这是一个网上书站的例子

package com.zxf.page;

import java.sql.ResultSet;

import com.db.Jdo;

public class ShowKindIndexBook 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 bookid,bookname,bookprice,bookagio,bmpurl from book where smallcatalogid in (select smallcatalogid from smallcatalog where bigcatalogid="+bigcatalogid+") order by sailcount desc limit 0,1");
			buffer.append("<table width=170 border=0><tr><td><A class=unbrown14b href=bigcbook.jsp?id="+bigcatalogid+" target=_blank>"+bigcatalogname+"</A><div align=right><a href=bigcbook.jsp?id="+bigcatalogid+"><img src=image/more_m.jpg border=0></a></div></td></tr><tr>");
			while(rs1.next())
			{
				int bid=rs1.getInt("bookid");
				String bmpurl=rs1.getString("bmpurl");
				String bookname=rs1.getString("bookname");
				float bookprice=rs1.getFloat("bookprice");
				float bookagio=10*rs1.getFloat("bookagio");
				buffer.append("  <td>&nbsp;<table width=170 border=0> <tr><td width=170 height=90 align=center>&nbsp;<A  href=detailbook.jsp?id="+bid+" target=_blank><img src="+bmpurl+" width=100 height=130></A></td></tr> <tr><td height=40>&nbsp;<A  href=detailbook.jsp?id="+bid+" target=_blank>."+bookname+"</A><SPAN class=red12>￥"+bookprice+"</SPAN><SPAN  class=gray12italic>(折"+bookagio+")</SPAN></td></tr></table></td>");
			}
			
			
			buffer.append("</tr></table>");
			
			buffer.append("</td>");
			jdo.destroy();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		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();
	}


}