showkindadminnote.java

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

package com.zxf.page;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.db.Jdo;

public class ShowKindAdminNote implements ShowKind {


	public String showDetail(ResultSet rs) {
		StringBuffer buffer=new StringBuffer();
		buffer.append("<td>");
		
		try {
			rs.next();
			String id=rs.getString("id");
			String title=rs.getString("title");
			String content=rs.getString("content");
			String author=rs.getString("author");
			String date=rs.getString("leavedate");
			Jdo jdo=new Jdo();
			String username=jdo.executeQueryString("select username from user where userid="+author);
			jdo.destroy();
			
			buffer.append("<table width=487  border=1><tr><td width=297><span class=style2>"+title+"<span class=style3>--<span class=style4>"+username+"</span></span></span></td><td width=133 ><span class=style2><span class=styl>"+date+"</span></span></td><td width=43><A href=\"deletenote.do?id="+id+"\" onClick=\"var bl=confirm('是否删除？'); if(bl){return true} else {return false;}\">删除</A></td></tr><tr><td  colspan=3>&nbsp;"+content+"</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/notemanage.jsp?index="+i+"\">"+i+"</a> &nbsp;");
		}
		buffer.append(" 页</td></tr></table>");
		return buffer.toString();
	}


}