java添加mysql驱动_java – 如何将JDBC mysql驱动程序添加到Eclipse项目？

这个问题在这里已经有一个答案：            >

How to install JDBC driver in Eclipse web project without facing java.lang.ClassNotFoundexception                                    13

>我已经下载了mysql-connector-java-5.1.24-bin.jar

>我已经在我的项目中创建了一个lib文件夹,并将jar放在那里.

>项目的属性>构建路径 – >添加JAR并选择上面的JAR.

>我还是得到java.sql.SQLException：找不到适合的jdbc驱动程序：mysql // localhost：3306 / mysql

我使用的是mysql 5.5

代码：

package DBTest;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.sql.*;

import java.util.*;

/**

* Servlet implementation class TenUsers

*/

@WebServlet("/TenUsers")

public class TenUsers extends HttpServlet {

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

PrintWriter out = response.getWriter();

String mySqlUrl = "jdbc:mysql://localhost:3306/mysql";

Properties userInfo = new Properties();

userInfo.put("user", "root");

userInfo.put("password", "SabababArba");

try{

Connection connection = DriverManager.getConnection(mySqlUrl, userInfo);

}catch(Exception e) {

out.println(e);

}

}

}

如果我添加Class.forName(“com.mysql.jdbc.Driver”);之前连接连接= DriverManager.getConnection(mySqlUrl,userInfo);我得到java.lang.ClassNotFoundException：com.mysql.jdbc.Driver