HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:598)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: org.apache.jsp.inquire_jsp
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:133)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:596)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.
package database.operation;
import java.sql.*;
public class QueryBean {
String databaseName="";
String tableName="";
String user="";
String secret="";
StringBuffer queryResult;
public QueryBean()
{
queryResult =new StringBuffer();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){}}public void setDatabaseName(String s)
{
databaseName=s.trim();
queryResult=new StringBuffer();}
public String getDatabaseName()
{
return databaseName;
}
public void setTableName(String s)
{
tableName=s.trim();
queryResult=new StringBuffer();
}
public String getTableName()
{return tableName;
}
public void setSecret(String s)
{
secret=s.trim();
queryResult=new StringBuffer();
}
public String getSecret()
{return secret;
}public void setUser(String s)
{
user=s.trim();
queryResult=new StringBuffer();
}
public StringBuffer getQueryResult()
{
Connection con;
Statement sql;
ResultSet rs;
try{
queryResult.append("<table border=1>");
String url="jdbc:oracle:thin:@localhost:1521:orcl"+databaseName;
String id=user;
String password=secret;
con=DriverManager.getConnection(url,id,password);
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null, null, tableName, null);
int 字段个数=0;
queryResult.append("<tr>");
while(rs1.next())
{ 字段个数++;
String clumnName= rs1.getString(4);
queryResult.append("<td>"+clumnName+"</td>");
}
queryResult.append("</tr>");
sql=con.createStatement();
rs=sql.executeQuery("select * from "+ tableName);
while(rs.next())
{
queryResult.append("</tr>");
for(int k=1;k<=字段个数;k++)
{
queryResult.append("<td>"+rs.getString(k)+"</td>");
}
queryResult.append("</tr>");
}
queryResult.append("</table>");
con.close();
}
catch(SQLException e)
{
queryResult.append("请输入正确的用户名密码");
}
return queryResult;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'inquire.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head>
<%@page import ="database.operation.QueryBean" %>
<jsp:useBean id="base" class="database.operation.QueryBean" scope="session">
</jsp:useBean>
<jsp:setProperty name="base" property="*"/>
<body bgcolor=lightgreen><font size=2>
<form action="" method=post>
输入数据库名:<input type=text name=databaseName >
输入表的名字:<input type=text name=tableName>
<br>
输入 用户名:<input type=text name=user>
输入 密码:<input type=text name=secret>
<input type=submit name="g" value=提交>
</form>
在<jsp:getProperty name="base" property="tableName"/>就是这个垃圾表中查询数据
<br>
<jsp:getProperty name="base" property="queryResult"/>
</jsp:getProperty>
</font>
</body>
</html>
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:598)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: org.apache.jsp.inquire_jsp
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:133)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:596)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.
package database.operation;
import java.sql.*;
public class QueryBean {
String databaseName="";
String tableName="";
String user="";
String secret="";
StringBuffer queryResult;
public QueryBean()
{
queryResult =new StringBuffer();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){}}public void setDatabaseName(String s)
{
databaseName=s.trim();
queryResult=new StringBuffer();}
public String getDatabaseName()
{
return databaseName;
}
public void setTableName(String s)
{
tableName=s.trim();
queryResult=new StringBuffer();
}
public String getTableName()
{return tableName;
}
public void setSecret(String s)
{
secret=s.trim();
queryResult=new StringBuffer();
}
public String getSecret()
{return secret;
}public void setUser(String s)
{
user=s.trim();
queryResult=new StringBuffer();
}
public StringBuffer getQueryResult()
{
Connection con;
Statement sql;
ResultSet rs;
try{
queryResult.append("<table border=1>");
String url="jdbc:oracle:thin:@localhost:1521:orcl"+databaseName;
String id=user;
String password=secret;
con=DriverManager.getConnection(url,id,password);
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null, null, tableName, null);
int 字段个数=0;
queryResult.append("<tr>");
while(rs1.next())
{ 字段个数++;
String clumnName= rs1.getString(4);
queryResult.append("<td>"+clumnName+"</td>");
}
queryResult.append("</tr>");
sql=con.createStatement();
rs=sql.executeQuery("select * from "+ tableName);
while(rs.next())
{
queryResult.append("</tr>");
for(int k=1;k<=字段个数;k++)
{
queryResult.append("<td>"+rs.getString(k)+"</td>");
}
queryResult.append("</tr>");
}
queryResult.append("</table>");
con.close();
}
catch(SQLException e)
{
queryResult.append("请输入正确的用户名密码");
}
return queryResult;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'inquire.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head>
<%@page import ="database.operation.QueryBean" %>
<jsp:useBean id="base" class="database.operation.QueryBean" scope="session">
</jsp:useBean>
<jsp:setProperty name="base" property="*"/>
<body bgcolor=lightgreen><font size=2>
<form action="" method=post>
输入数据库名:<input type=text name=databaseName >
输入表的名字:<input type=text name=tableName>
<br>
输入 用户名:<input type=text name=user>
输入 密码:<input type=text name=secret>
<input type=submit name="g" value=提交>
</form>
在<jsp:getProperty name="base" property="tableName"/>就是这个垃圾表中查询数据
<br>
<jsp:getProperty name="base" property="queryResult"/>
</jsp:getProperty>
</font>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货