在将"java.lang.ClassNotFoundException:com.mysql.jdbc.Driver"添加到构建路径并使用Class.forName()注册后，如何修复"java.lang.ClassNotFoundException:com.mysql.jdbc.Driver" [英] How to fix 'java.lang.ClassNotFoundException: com.mysql.jdbc.Driver' after adding it to the build path and registered using Class.forName();

问题描述

我从Eclipse Jee的构建路径中添加了mysql-connector-java-8.0.12.jar.一世还通过添加以下内容来注册该课程:

I had added mysql-connector-java-8.0.12.jar from build path in Eclipse Jee. I had also registered that class by adding :

Class.forName("com.mysql.jdbc.Driver");

但是它仍然给我这个错误:

but still it is giving me this error :

java.lang.ClassNotFoundException:com.mysql.jdbc.Driver

这是Student.java Servlet的代码.

This is the code of Student.java Servlet.

import javax.servlet.*;
import javax.servlet.http.*;

import java.io.*;
import java.sql.*;

public class Student extends HttpServlet
{

    public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
    {
        // business logic
        response.setContentType("text/html");
        PrintWriter out=response.getWriter();

        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sem5", "root", "root");

            String sql = "insert into p4 values(?,?,?,?,?,?,?)";
            PreparedStatement ps = con.prepareStatement(sql);

            String enroll = request.getParameter("enroll");
            String username = request.getParameter("username");
            String password = request.getParameter("password");
            String gender = request.getParameter("gender");
            String email = request.getParameter("email");
            String mobile = request.getParameter("mobile");
            String address = request.getParameter("address");


            ps.setString(1, enroll.toString());
            ps.setString(2, username.toString());
            ps.setString(3, password.toString());
            ps.setString(4, gender.toString());
            ps.setString(5, email.toString());
            ps.setString(6, mobile.toString());
            ps.setString(3, address.toString());

            ps.executeUpdate();

            ps.close();
        }
        catch(Exception ex) {
            System.out.println("Exception : "+ ex);
            out.println("Error");
        }
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
    {
        doGet(request,response);
    }
}

预先感谢...

推荐答案

您需要使用 com.mysql.cj.jdbc.Driver 代替 com.mysql.jdbc.Driver ，同时使用MySQL连接器8.请参阅文档此处.

You need to use com.mysql.cj.jdbc.Driver instead of com.mysql.jdbc.Driver while using MySQL connector 8. Please refer the documentation here.

这篇关于在将"java.lang.ClassNotFoundException:com.mysql.jdbc.Driver"添加到构建路径并使用Class.forName()注册后，如何修复"java.lang.ClassNotFoundException:com.mysql.jdbc.Driver"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！