大家伙儿帮忙看看这断JSP代码(想改成分页显示)

大家帮忙看看这断JSP代码(想改成分页显示)
这是一个已经写好的JSP
只要轻松修改一下SQL语句就可以在   您的机器上运行
(我用的是SQL2005数据库)
taglib－－－－代码

package   com.item.tag;
import   java.sql.Connection;
//import   java.sql.PreparedStatement;
import   java.sql.ResultSet;
import   java.sql.ResultSetMetaData;
import   java.sql.Statement;
//import   java.util.List;

import   javax.servlet.http.HttpServletRequest;
import   javax.servlet.jsp.JspException;
import   javax.servlet.jsp.JspWriter;
import   javax.servlet.jsp.PageContext;
//import   javax.servlet.jsp.tagext.BodyContent;
import   javax.servlet.jsp.tagext.BodyContent;
import   javax.servlet.jsp.tagext.BodyTag;
import   javax.servlet.jsp.tagext.Tag;

import   com.item.bean.ConnectionDatabase;

public   class   HandleTestPage   implements   BodyTag
{
private   BodyContent   body;
private   PageContext   page;
private   String     userid;


public   void   setUserid(String   userid)
{
this.userid   =   userid;
}


public   void   get()
{
//   List   data   =   null;

Connection   con   =   null;
JspWriter   out   =   page.getOut();

try
{
con   =   ConnectionDatabase.conn();
Statement   st   =   con.createStatement();
String   sql   =   "select   *   from   [firstItem].[dbo].[userManager]   where   user_id   =   "   +   userid;
ResultSet   rs   =   st.executeQuery(sql);
ResultSetMetaData   rsmd   =   rs.getMetaData();
int   cols   =   rsmd.getColumnCount();
//out.print( " <input   type   =   'text '   name   =   'userid '   > ");
HttpServletRequest   request   =   null;
//request.setAttribute( "userid ",   userid);
out.print( " <table   border=2>   <tr> ");

for   (int   i   =   1;   i   <   cols   +   1;   i++)
{
out.print( " <th> "   +   rsmd.getColumnName(i)   +   " </th> ");
}
out.print( " </tr> ");

while   (rs.next())
{
out.print( " <tr> ");
for   (int   i   =   1;   i   <   cols   +   1;   i++)
{
out.print( " <td> "   +   rs.getString(i)   +   " </td> ");
}
out.print( " </tr> ");
}

out.print( " </table> ");

}
catch   (Exception   e)
{
e.printStackTrace();
}
finally
{
try
{
if   (con   !=   null)
{
con.close();
}
}
catch   (Exception   e)
{
e.printStackTrace();
}
}

//   return   data;
}
public   int   doStartTag()   throws   JspException
{
//   TODO   Auto-generated   method   stub
if(userid   !=   null)
get();
return   this.SKIP_BODY;
}

public   int   doEndTag()   throws   JspException