What's wrong with my JDBC select prepared statement?

Question

I'm trying to debug my prepared statement in java and I'm stuck on this checkEmail function that I implemented. When I go into debugging and it reaches the setString line, it shows NOT SPECIFIED in place of the '?'. If I hardcode 'findEmail' into the String query it will work and find the email. Here is the piece of code:

public static boolean checkEmail(String findEmail) {
    Connection conn = EstablishConnection.conn;
    boolean found = false;
    try {
        String query = "SELECT email FROM customers WHERE email=?";
        Logging.debug(query);
        PreparedStatement preparedStatement = conn.prepareStatement(query);
        preparedStatement.setString(1,findEmail);
        ResultSet rs = preparedStatement.executeQuery(query);
        //Iterate through the results of the query
        if (rs.next()) {
            found = true;
        }
        preparedStatement.close();
    } catch (Exception e) {
        Logging.debug("Exception thrown in CustomerOperations.getCustomerInfo(): " + e.getMessage());
        e.printStackTrace();
    }
    return found;

}

you need `ResultSet rs = preparedStatement.executeQuery();` – wero Feb 16 '16 at 14:16 — wero, Feb 16 '16 at 14:16
Darn I figured it was something simple. Thanks! – MeesterMarcus Feb 16 '16 at 14:19 — MeesterMarcus, Feb 16 '16 at 14:19

score 2 · Answer 1 · answered Feb 16 '16 at 14:17

2

Try to replace this :

  ResultSet rs = preparedStatement.executeQuery(query);

With:

  ResultSet rs = preparedStatement.executeQuery();

Because you had already pass the query to prepareStatement : conn.prepareStatement(query);

answered Feb 16 '16 at 14:17

Abdelhak

8,299
4
22
36

Thanks that did it! Probably did it before without prepared and switched over and forgot to remove. – MeesterMarcus Feb 16 '16 at 14:21

What's wrong with my JDBC select prepared statement?

1 Answers1