HTTP Status 500 错误

[zhuangqinying]

环境ＪＳＰ＋Tomcat/5.0.27出现如下错误信息：

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: /fenye2.jsp(2,0) The value for the useBean class attribute javaBean.dbBean is invalid.
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:150)
org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1225)
org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1116)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2219)
org.apache.jasper.compiler.Node$Root.accept(Node.java:456)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Generator.generate(Generator.java:3269)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:244)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:470)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.

ＪＡＶＡＢＥＡＮ的目录如下：
－－jspBean
------fenye2.jsp
------WEB_INF
------classes
-------javaBean
---dbBean.class

[lingkeylbh]

org.apache.jasper.JasperException: /fenye2.jsp(2,0) The value for the useBean class attribute javaBean.dbBean is invalid.
你的javabean无效啊，class是public的吗

[myvicy]

usebean的属性无效。

[zhuangqinying]

package javaBean;

import java.sql.*;

public class dbBean {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

dbBean() {

try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testData",
"sa", "");

} catch (ClassNotFoundException cn) {
cn.printStackTrace();
} catch (SQLException sqle) {
sqle.printStackTrace();
}

}

public ResultSet dbExecuteQury(String sql) {
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
return rs;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}

public int dbExecuteUpdate(String sql) {
try {
stmt = conn.createStatement();
int m = stmt.executeUpdate(sql);
return m;
} catch (SQLException e) {
e.printStackTrace();

}
return 0;
}

public void close() {
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

[zhuangqinying]

在fenye2.jsp中：
<jsp:useBean id="dbBean" class="javaBean.dbBean" scope="session"/>