showkindadminorder.java

这是一个网上书站的例子

package com.zxf.page;

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

import com.db.Jdo;

public class ShowKindAdminOrder implements ShowKind{
	
	public String showDetail(ResultSet rs) {
		StringBuffer buffer=new StringBuffer();
		buffer.append("<td>");
		
		try {
			rs.next();
			
			String ordernum=rs.getString("ordernumber");
			String date=rs.getString("orderdate");
			String issend=rs.getString("issend");
			String userid=rs.getString("orderuserid");
			String totalprice=rs.getString("totalprice");
			String status="";
			Jdo jdo=new Jdo();
			if(issend.equals("0"))
			{
				status="未发货";
			}
			else
			{
				status="已发货";
			}
			String username=jdo.executeQueryString("select username from user where userid="+userid);
			
			buffer.append("<table width=658 border=0><tr><td width=23>");
			if(issend.equals("0"))
			{
				buffer.append("<div id=chec"+ordernum+"><input type=checkbox name=order value="+ordernum+"></div>");
			}
			buffer.append("</td>");
			buffer.append("<td width=88><a href=manage/detailorder.jsp?number="+ordernum+" target=_blank>"+ordernum+"</a></td>");
			buffer.append("<td width=68>&nbsp;"+username+"</td><td width=60>货到付款</td><td width=78>&nbsp;"+totalprice+"元</td> <td width=73>&nbsp;<input  id="+ordernum+" type=text value="+status+" readonly=true size=5></td> <td width=65>"+date+"</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 width=200>共"+totalIndex+"页  分页：");
		
		for(int i=1;i<=totalIndex;i++)
		{
			buffer.append("<a href=\""+"manage/showorder.jsp?index="+i+"\">"+i+"</a> &nbsp;");
		}
		buffer.append(" 页</td></tr></table>");
		return buffer.toString();
	}



}