myeclipse java web项目 连接mysql数据库问题 提示46行有错。。
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: An exception occurred processing JSP page /bbs2/WebRoot/showarticletree.jsp at line 46
43: }%>
44:
45: <%
46: Class.forName("com.mysql.jdbc.Driver").newInstance();
47: String url = "jdbc:myaql://localhost/bbs2?user=root&password=root";
48: Connection conn = DriverManager.getConnection(url);
49: Statement stmt = conn.createStatement();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.bbs2.WebRoot.showarticletree_jsp._jspService(showarticletree_jsp.java:137)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.bbs2.WebRoot.showarticletree_jsp._jspService(showarticletree_jsp.java:99)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
追问:已经引入了啊。。。。还是那个错误。。。。已经把newInstance()去掉了。。。找到了 有那个的。。。呵呵 没事儿的 我也是忙着考试了 前几天就没怎么留心这个 我同学忙我看了 是那个tomcat不行 有问题。。。已经解决了 不过还是谢谢你怎么算引用那个
其他:没有引入mysql的jar包 加载驱动不要newInstance(),这个方法是返回一个驱动对象的实例,加载的话只要Class.forName("com.mysql.jdbc.Driver");就可以了。 如果你用jdbc连接需要引入驱动包 没有引用jdbc ?
上一个:在database.yml中没有设置encoding:utf8,使用时界面上都正常,但是保存到mysql数据库中的中文都是乱码。
下一个:请问下以下数据库哪些在现在的实际工程中用得比较多啊? MySql SQLserver2005 DB2 ORCALE 谢谢!