各位大神!小女子我实在是没辙了!!
这是我的note.JSP代码页面:
我的tag文件是:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@ tag import="java.sql.*"%>
<%@ attribute name="tableName" required="true" %>
<%@ attribute name="user" required="true" %>
<%@ attribute name="password" required="true" %>
<%@ variable name-given="biao" scope="AT_END" %>
<%@ variable name-given="queryResult" scope="AT_END" %>
<%
StringBuffer result;
result=new StringBuffer();
try{ Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e) {}
Connection con;
PreparedStatement pre;
ResultSet rs;
try { result.append("<table border=1>");
String uri= "jdbc:mysql://localhost:3306/x-sim";
con=DriverManager.getConnection(uri,"root","3311196");
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null,null,tableName,null);
int 字段个数=0;
result.append("<tr>");
while(rs1.next())
{ 字段个数++;
String clumnName=rs1.getString(4);
result.append("<td>"+clumnName+"</td>");
}
result.append("</tr>");
pre=con.prepareStatement("SELECT * FROM "+tableName);
rs=pre.executeQuery();
while(rs.next())
{ result.append("<tr>");
for(int k=1;k<=字段个数;k++)
result.append("<td>"+rs.getString(k)+"</td>");
result.append("</tr>");
}
result.append("</table>");
con.close();
}
catch(SQLException e)
{ result.append("请输入表名");
}
jspContext.setAttribute("queryResult", new String(result));
jspContext.setAttribute("biao", tableName);
%>
出现的JSP页面错误是:
究竟是哪里有错?!!!