日期:2014-05-18  浏览次数:20638 次

关于JSP自定义标签的问题

运行该程序回出现错误     请高手指教


---标签类
package   com.item.tag;
import   java.sql.Connection;
import   java.sql.ResultSet;
import   java.sql.ResultSetMetaData;
import   java.sql.Statement;
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.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   setBookid(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 '   > ");

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
{

return   this.EVAL_PAG