showkindbook.java

来自「这是一个网上书站的例子」· Java 代码 · 共 51 行

package com.zxf.page;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import com.db.Jdo;



public class ShowKindBook implements ShowKind {

	public String showDetail(ResultSet rs) {
		StringBuffer buffer=new StringBuffer();
		buffer.append("<td>");
		
		try {
			rs.next();
			int bookid=rs.getInt("bookid");
			String bookname=rs.getString("bookname");
			int catalogid=rs.getInt("smallcatalogid");
			String bmpurl=rs.getString("bmpurl");
			Jdo jdo=new Jdo();
			String catalogname=jdo.executeQueryString("select catalogname from smallcatalog where smallcatalogid="+catalogid);
			jdo.destroy();
			buffer.append("<table width=\"275\" height=\"134\" border=\"0\"><tr><td width=\"117\" height=\"130\"><a href=\"manage/bookdetail.jsp?id="+bookid+"\"><img src=\""+bmpurl+" \" width=\"114\" height=\"115\" border=0></a></td><td width=\"148\" valign=\"top\" align=\"center\"><p>"+bookname+"</p><p>"+catalogname+"</p><p> <a href=\"deletebook.do?id="+bookid+"\" onClick=\"var bl=confirm('是否删除？'); if(bl){return true} else {return false;}\">删除：</a></p><p><a href=\"manage/bookdetail.jsp?id="+bookid+"\">查看并修改</a></p></td></tr></table>");
			buffer.append("</td>");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			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/showresult.jsp?index="+i+"\">"+i+"</a> &nbsp;");
		}
		buffer.append(" 页</td></tr></table>");
		return buffer.toString();
	}

}