(java web工程连接mysql数据库找不到驱动，有读取配置文件（dbinfo.properties）)

Question

java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.ylz.utils.SqlHelper.getConnection(SqlHelper.java:64)
at com.ylz.utils.SqlHelper.executeQuery3(SqlHelper.java:109)
at com.ylz.service.UserService.checkUser(UserService.java:12)
at com.ylz.actions.LoginAction.execute(LoginAction.java:36)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.ylz.filters.MyFilter1.doFilter(MyFilter1.java:22)

Answer 1

1.找适合你MySQL的jar包。
2.把IP地址换成你本机的IP
3.你看看你数据库名称是不是叫test。
4.检查lib文件夹里面是否有MySQL的jar包。追问

jar包换了n个版本都不行，我的链接oracle数据库没有问题，数据库就是test

追答

一：连接URL格式出现了问题(Connection conn=DriverManager.
getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")
二：驱动字符串出错(com.mysql.jdbc.Driver)
三：Classpath中没有加入合适的mysql_jdbc驱动（驱动要和你的数据库版本一致）
四：驱动jar包放的位置不对

Answer 2

你的jar包一应该是导错了

import java.sql.*;

Answer 3

你的mysql的jar包 放进web-root里的 libs目录里了没？

Answer 4

找不到适当的驱动，你用的是MYSQL，看看MYSQL驱动是不是放错了~~~