问题描述

在java文件的main方法中调试mysql连接及查询时没有问题
在web project 项目工连接mysql报错

image.png

错误信息
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/phpmyadmin?useUnicode=true&characterEncoding=UTF-8
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at util.DBHelper.getConnection(DBHelper.java:34)
at dao.ItemsDAO.getAllItems(ItemsDAO.java:22)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:176)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

原因：
在连接mysql数据库时，正常的java application可以连接，但是到javabean web中就出错，说是Class.forName(dirver)找不到驱 动。
解决办法：
我将oracle的mysql-connector-java-5.1.13-bin.jar的包放到了web-inf下的lib文件夹下

mysql 的jar包加入

参考：at org.apache.catalina.loader.WebappClassLoader.loadClass问题处理