当前页面: 开发资料首页 → JSP 专题 → 今天刚接触JSP,一天都搞不好的问题,在线等

今天刚接触JSP,一天都搞不好的问题,在线等

摘要: 今天刚接触JSP,一天都搞不好的问题,在线等

小弟今天第一天学JSP,请教大家关于JSP与mysql连接的问题,我安装的是jdk1.5.0_04,这个版本已经带有tomcat了.我的系统变量设置如下:

CLASSPATH
.;%JAVA_HOME%/lib

JAVA_HOME
C:/jdk1.5.0_04

PATH
%JAVA_HOME%/bin;%SystemRoot%/system32;%SystemRoot%;%SystemRoot%/System32/Wbem

TOMCAT_HOME
C:/Program Files/netbeans-4.1/enterprise1/jakarta-tomcat-5.5.7

我已经把mysql-connector-java-3.1.12-bin.jar放到了tomcat-5.5.7/common/lib和tomcat-5.5.7/shared/lib和C:/jdk1.5.0_04/lib了,但我试了N次都无法连接mysql数据库,以下是出错提示:


type Exception report

message

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

exception

javax.servlet.ServletException: org.gjt.mm.mysql.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.my_jsp._jspService(my_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)


root cause

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:150)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.my_jsp._jspService(my_jsp.java:48)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)


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



请大家指点指点,谢谢了

---

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
未能找到类错误。你试试com.mysql.jdbc.Driver你加入的包主类应当是这个，不过好象我用的mysql-connector-java-3.2.0-alpha-bin.jar支持org.gjt.mm.mysql.Driver

你还可以试试复制到.%TOMCAT_HOME%/webapp/yousite/WEB-INF/lib/里面
还不行的话你看看你是不是从IDE启动的，比如eclipse里，可能要在项目中加入引用包。

---

你用winrar打开那个mysql-connector-java-3.1.12-bin.jar,看看是否是这样的目录结构org/gjt/mm/mysql/Driver

---

你的项目的LIB文件夹中也要放这个JAR

---

谢谢各位，问题已经解决

---