0

Anyone know why I returned this error?

are my classes are:

conexionDB:

public class ConexionDB {
    private Connection cnn;

    private static ConexionDB instance;

    private ConexionDB() {

        try {
            Class.forName("com.mysql.jdbc.Driver");
            cnn = DriverManager.getConnection("jdbc:mysql://localhost:3306/control?useSSL=false", "root", "root");
        } catch (ClassNotFoundException | SQLException e) {

            e.printStackTrace();
        }
    }

    public static ConexionDB estado() {
        if (instance == null) {
            instance = new ConexionDB();
        }
        return instance;
    }

    public Connection getCnn() {
        return cnn;
    }

    public void cerraConexion() {
        instance = null;
    }

}

Servlet:

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

  String error;
  String email = request.getParameter("email");
  String password = request.getParameter("password");
  HttpSession session = request.getSession();
  EmpleadosDAO empleadoDAO = new EmpleadosDAO();
  EmpleadosDTO userName = empleadoDAO.login(new EmpleadosDTO(email, password));


if (userName == null) {
   error = "Invalid Email or password";
   session.setAttribute("error", error);
   response.sendRedirect("index.jsp");
} else {
   session.setAttribute("user", userName);
   response.sendRedirect("welcome.jsp");
}

dao:

private final String SQL_LOGIN = "SELECT email from empleados where email=? and password=?";
private ConexionDB con = ConexionDB.estado();

public EmpleadosDTO login(EmpleadosDTO c) {

    java.sql.PreparedStatement ps;
    ResultSet res;
    EmpleadosDTO l = null;

    try {

        ps = con.getCnn().prepareStatement(SQL_LOGIN);

        ps.setString(1, c.getEmail());
        ps.setString(2, c.getPassword());

        res = ps.executeQuery();
        while (res.next()) {
            l = new EmpleadosDTO(res.getString(1), res.getString(2));
        }
        return l;
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } finally {
        con.cerraConexion();
    }
        return l;
}

the error:

abr 18, 2016 12:25:42 AM org.apache.catalina.core.StandardWrapperValve invoke Grave: Servlet.service() para servlet LoginController lanzó excepción java.lang.NullPointerException at com.controlventas.dao.EmpleadosDAO.login(EmpleadosDAO.java:29) at com.controlventas.controller.ClienteCONTROLLER.doGet(ClienteCONTROLLER.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:851) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:278) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744)

Vinoth Krishnan
  • 2,925
  • 6
  • 29
  • 34
  • Could you explain a little about what your code is doing? – Matt C Apr 18 '16 at 06:05
  • You basically asked "Why do I get a NullPointerException?". The duplicate answers exactly that. It should help you to be able to ask "Why is variable X null?". Once you're at that point, and still can't figure out the answer, feel free to ask a new question (don't forget to point out the exact variable X). In the meanwhile, I suggest to start here as to correct approach of using JDBC in a servlet based web application: http://stackoverflow.com/q/2299469 – BalusC Apr 18 '16 at 07:25

0 Answers0