求助.....新手问题.....HTTP Status 500 错误.....

Question

我装的是 JDK1.4和Tomcat4.1
         环境都装好了...也都测试了....JSP,Servlet,javaBean都可以编译.......
         但是我一连接数据库就出现500错误.....
         我用的是Access 在系统DNS中也设置了相应的数据源和指向数据库.....
         
         搞不明白问题出在哪了??????
         有劳高手指点一,二啊!!!!!!!
         

Answer 1

type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /jdbc.jsp(4,44) equal symbol expected
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:49)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:383)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:81)
at org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:124)
at org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:91)
at org.apache.jasper.compiler.Parser.parseUseBean(Parser.java:526)
at org.apache.jasper.compiler.Parser.parseAction(Parser.java:622)
at org.apache.jasper.compiler.Parser.parseElements(Parser.java:758)
at org.apache.jasper.compiler.Parser.parse(Parser.java:77)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:157)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:111)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:183)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:427)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:142)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

Answer 2

可能是标签错误
把jcbc.jsp
贴出来看

Answer 3

下面就是写的了....     jdbc.jsp 　
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title> teacherinfo </title>
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DBconn1" scope="page" class"DBconn"/>
ResultSet rs=DBconn1.excuteQuery("select*from teacherinfo");
while(rs.next()){
out.print("<LI>"+rs.getString("teacherID")+"</LI>");
outprint("<LI>"+rs.getString("teacherName")+"</LI>");
outprint("<LI>"+rs.getString("PhoneNo")+"</LI>");
outprint("<LI>"+rs.getString("Password")+"</LI>");} rs.close();
%>
</body>
</html>
　　DBconn.class
    import java.sql.*;
public class DBconn{
     String Driver="sun.jdbc.odbc.JdbcOdbcDriver";
     String Conn="jdbc:odbc:soure";
     Connection conn=null;
     ResultSet rs=null;
     public DBconn(){
          try{
             Class.forName(Driver);
          }
          catch(java.lang.ClassNotFoundException e){
              System.err.println("Err in driver:"+e.getMessage());
          }
     }
     public ResultSet executeQuery(String sql){
          rs=null;
          try{
             conn=DriverManager.getConnection(Conn);
             Statement stm=conn.createStatement();
             rs=stm.executeQuery(sql);
          }
          catch(SQLException ex){
              System.err.println("Err in executeQuery:"+ex.getMessage());
          }
          return rs;
     }
}

Answer 4

<jsp:useBean id="DBconn1" scope="page" class"DBconn"/>
这一行 class="DBconn"

Answer 5

呵呵...我还以为是别的原因呢 ....看来我还得多练练......
      
      还有下面这个错误.....我应该在哪改......     
        
Generated servlet error:
    [javac] Compiling 1 source fileE:\JBuilder\tomcat5\TOMCAT 4\Tomcat 4.1\work\Standalone\localhost\web4\jdbc_jsp.java:50: cannot resolve symbol
symbol  : class DBconn 
location: class org.apache.jsp.jdbc_jsp
      DBconn DBconn1 = null;
      ^An error occurred at line: 7 in the jsp file: /jdbc.jspGenerated servlet error:
E:\JBuilder\tomcat5\TOMCAT 4\Tomcat 4.1\work\Standalone\localhost\web4\jdbc_jsp.java:52: cannot resolve symbol
symbol  : class DBconn 
location: class org.apache.jsp.jdbc_jsp
        DBconn1 = (DBconn) pageContext.getAttribute("DBconn1", PageContext.PAGE_SCOPE);
                   ^An error occurred at line: 7 in the jsp file: /jdbc.jspGenerated servlet error:
E:\JBuilder\tomcat5\TOMCAT 4\Tomcat 4.1\work\Standalone\localhost\web4\jdbc_jsp.java:55: cannot resolve symbol
symbol  : class DBconn 
location: class org.apache.jsp.jdbc_jsp
            DBconn1 = (DBconn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "DBconn");
                       ^

Answer 6

把你的DBconn.java 最前面加上 package xxx;
然后修改
<jsp:useBean id="DBconn1" scope="page" class="xxx.DBconn"/>这样就可以了
因为默认的包结构的类引用的问题
加上包结构就好了