I am trying to make an INSERT to my database this way:
package org.gradle.demo;
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.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
@WebServlet(name = "HelloServlet", urlPatterns = {"register"}, loadOnStartup = 1)
public class RegisterServlet extends HttpServlet {
private Connection conn;
protected void doPost(HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException {
String username = request.getParameter("username");
String password = request.getParameter("password");
try {
conn = DBUtils.initializeSqlConnection();
Statement statement = conn.createStatement();
int count = statement.executeUpdate("INSERT INTO users (username, pass) VALUES ('" + username + "', '" + password + "')");
System.out.println(count);
} catch (SQLException e) {
System.err.println("SQL Exception trying to insert new user");
System.err.println(e.getMessage());
}
request.setAttribute("username", username);
request.getRequestDispatcher("loginsucces.jsp").forward(request, response);
}
}
I am using Gradle with this dependency:
dependencies {
providedCompile group: 'javax.servlet', name: 'javax.servlet-api', version: '3.1.0'
compile group: 'org.postgresql', name: 'postgresql', version: '42.2.2'
testCompile group: 'junit', name: 'junit', version: '4.12'
testCompile group: 'org.mockito', name: 'mockito-core', version: '2.19.0'
testCompile group: 'io.github.bonigarcia', name: 'webdrivermanager', version: '2.2.3'
testCompile group: 'org.seleniumhq.selenium', name: 'selenium-java', version: '3.13.0'
}
And also I have tested my connection in another class doing a SELECT and it connects perfectly, but as soon as I try to make an INSERT it throws the:
No suitable driver found for jdbc:postgresql://localhost/training_log