org.apache.jasper.JasperException: Exception in JSP: /LX/test.jsp:6360:  </head>
61: <body> 
62: <%----%><%
63: Class.forName("com.mysql.jdbc.Driver").newInstance(); 
64: String url ="jdbc:mysql://localhost/aaa?user=root&password=haha&useUnicode=true&characterEncoding=8859_1" ; 
65: //假设test是你的数据库 
66: Connection conn= DriverManager.getConnection(url); Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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 javax.servlet.ServletException: org/aspectj/lang/Signature
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.LX.test_jsp._jspService(test_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
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.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.LX.test_jsp._jspService(test_jsp.java:66)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
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.17 logs.
--------------------------------------------------------------------------------
==============================
<%@ page contentType="text/html; charset=gb2312"%> 
<%@ page import="java.sql.*"%> <html> 
<head>
<title>数据库测试程序</title>
</head>
<body> 
<%----%><%
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
String url ="jdbc:mysql://localhost/aaa?user=root&password=haha&useUnicode=true&characterEncoding=8859_1" ; 
//假设test是你的数据库 
Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
String sql="select * from userinfo"; 
//从test表读数据 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {%> 
您的第一个字段内容为:<%=new String(rs.getString(1).getBytes("ISO8859-1"))%>
您的第二个字段内容为::<%=new String(rs.getString(2).getBytes("ISO8859-1"))%> 
<%}%> 
<%out.print("数据库操作成功,恭喜你");%> 
<%rs.close(); 
stmt.close(); 
conn.close(); 
%> 
</body> 
</html> 

解决方案 »

  1.   

    java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
      

  2.   

    我也说不清楚了,以前遇到过一次 拷贝src\lib\aspectjrt.jar  到Tomcat\common\lib下就好了 古道西风瘦马说:MySQL Connector/J的debug版本依赖于Aspect/J 拷贝解压目录/src/lib/aspectjrt.jar 到 WEB-INF/lib 或tomcat的common/lib
    这次比较奇怪 开始好用后来怎么又不好用了。
      

  3.   

    终于找到原因了  分享下。上面说 以前遇到过一次 拷贝src\lib\aspectjrt.jar  到Tomcat\common\lib下就好了
    好是好了,但访问MySQL时Tomcat有错误信息。
    现在终于找到原因了,我拷贝连接器的时候mysql-connector-java-5.0.3-bin.jar跟mysql-connector-java-5.0.3-bin-g.jar 两个一起拷贝了,最后把所有的mysql-connector-java-5.0.3-bin-g.jar都删除就好了。 http://bbs.chinaunix.net/viewthread.php?tid=582214
    http://community.csdn.net/Expert/topic/4696/4696227.xml?temp=.5021479
    这里谢谢echomyf(ECHO),参考他的回复解决的问题