| have added MySQL Connector to libraries , but still getting error 'java.lang.ClassNotFoundException: com.mysql.jdbc.driver' [duplicate]

This question already has an answer here:

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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 javax.servlet.http.HttpSession;

/**
* Servlet implementation class LoginChek
*/
@WebServlet("/LoginChek")
public class LoginChek extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public LoginChek() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String Uname=request.getParameter("Uname");
String password=request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/3306/mydb","root","root");
Statement stmt =con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT uname,upass FROM user_reg WHERE uname='"+Uname+"' and upass='"+password+"' ");

if(rs.next())
{
HttpSession session=request.getSession();
session.setAttribute("Uname", Uname);
response.sendRedirect("member.jsp");
}
else
{
response.sendRedirect("error.jsp");

}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
doGet(request, response);
}}


**I'm using Eclicpse Photon june 2018 version and also the latest version of MySQL. I have added 'mysql-connector-java-8.0.11'to libraries of my dynamic web project using Proprties>Java BUild Path>Libraries> Add External Jar. But getting 'java.lang.ClassNotFoundException: com.mysql.jdbc.driver' error when i run my program. I'm new to java , please help. **

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer
1

Put 'mysql-connector-java-8.0.11' inside the lib folder yourProjectWebContentWEB-INFlib

yourProjectWebContentWEB-INFlib