SQL Exception . update row in jdbc

Question

I need to write a query to update a row in the database. but exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe pr?s de 'SET eMail = '11111', SET phoneNumber = '111111' WHERE name = 'Saba', surname= 'M' ? la ligne 1 .

what is the problem?

public static void updateUser(User user, Connection connection) throws SQLException {
PreparedStatement ps = null;
ps = connection.prepareStatement("UPDATE USERS SET login = ?, SET eMail = ?, SET phoneNumber = ? WHERE name = ?, surname= ?");
        ps.setString(1, user.getLogin());
        ps.setString(2, user.geteMail());
        ps.setString(3, user.getPhoneNumber());
        ps.setString(4, user.getName());
        ps.setString(5, user.getSurname());
        ps.executeUpdate();

Lukas Eder · Accepted Answer · 2015-11-08 12:26:41Z

1

The UPDATE statement only has a single SET clause. You repeated the SET keyword, which is wrong. Besides, you forgot the AND keyword to combine predicates. Write this instead:

try (PreparedStatement ps = connection.prepareStatement(
      "UPDATE USERS "
    + "SET login = ?, eMail = ?, phoneNumber = ? "
    + "WHERE name = ? AND surname = ?")) {

    // ...
}

answered Nov 8, 2015 at 12:26

Lukas Eder

224k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Exception . update row in jdbc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related