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

连接MySQL的怪问题
大家好,小弟初学JSP,在连接数据库的时候遇到了一个奇怪的问题,希望大家能帮我解决一下,在这儿,先谢过大家了:


我用的一些工具的版本如下:
  Tomcat                 5.0.28
  MySQL                     5.0.27
  MySQL   的驱动     mysql-connector-java-5.0.4
 

这是我环境变量的配置:

Classpath=

D:\Program   Files\Java\mysqljdbc\mysql-connector-java-5.0.4-bin.jar;
%JAVA_HOME%\lib\mysql-connector-java-5.0.4-bin-g.jar;.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;C:\Program   Files\Apache   Software   Foundation\Tomcat   5.0\common\lib\servlet-api.jar;E:\ServletAndJSPDev;


另外我把Mysql的   驱动程序版本是:mysql-connector-java-5.0.4
安装到了%JAVA_HOME%\lib\mysql-connector-java-5.0.4-bin-g.jar;
        和     D:\Program   Files\Java\mysqljdbc\mysql-connector-java-5.0.4-bin.jar;

还有我把   驱动程序的两个   .jar   文件拷贝到了   tomcat   安装目录的commmon\lib\

这样之后我启动   Tomcat  

在我的test.jsp   中只有这样的几行代码:

<%@   page   language= "java "   contentType= "text/html;   charset=utf-8 "%>
<%@   page   info= "database   handler "   %>
<%@   page   import= "java.io.* "   %>  
<%@   page   import= "java.sql.* "   %>      
<%@   page   import= "javax.servlet.* "   %>
<%@   page   import= "javax.servlet.http.* "   %>
<%  
    Class.forName( "org.gjt.mm.mysql.Driver ").newInstance();
%>

可是在运行的时候却报告这么一个错误:

type   Exception   report

message  

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

exception  

javax.servlet.ServletException:   org/aspectj/lang/Signature
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.dd_jsp._jspService(dd_jsp.java:64)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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)


root   cause  

java.lang.NoClassDefFoundError:   org/aspectj/lang/Signature
java.lang.Class.forName0(Native   Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.dd_jsp._jspService(dd_jsp.java:57)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236