mysql statements in java

Question

So when i use this simple update in mysql using java it gives me the error output that i have a MYSQL syntax fault. but when i copy paste it in mysql gui it works as it supposed to be am i doing something wrong?

private static final String UPDATE_PUNTEN_UITDAGING_MAKKELIJK = "UPDATE ID222177_g38.Speler "
        + "set puntenUitdagingenMakkelijk = puntenUitdagingenMakkelijk +3 "
        + " where gebruikersnaam = ? ; "
        + "UPDATE ID222177_g38.Speler "
        + "set puntenUitdagingenMakkelijk = puntenUitdagingenMakkelijk -1 "
        + " where gebruikersnaam = ? ;";


public void uptdatePuntenUitdagingen(String[] uitdaging) {


        try (
                Connection conn = DriverManager.getConnection(Connectie.JDBC_URL);
                PreparedStatement query = conn.prepareStatement(UPDATE_PUNTEN_UITDAGING_MAKKELIJK)) {
            query.setString(1, uitdaging[0]);
            query.setString(2, uitdaging[1]);

            query.executeUpdate();

        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }}

Not sure if you can execute multiple update queries in the same statement... — Robby Cornelissen, Apr 12 '18 at 10:42
I don't think you can execute multiple commands in a single `PreparedStatement` — MadProgrammer, Apr 12 '18 at 10:43
Your query contains multiple statements. See this question on how to enable this: https://stackoverflow.com/questions/10797794/multiple-queries-executed-in-java-in-single-statement — lexicore, Apr 12 '18 at 10:44
@lexicore it's a db for a class assignment so i wasn't allowed to do more than one statement at the time so i splid them up but thanks for the help — guust ysebie, Apr 12 '18 at 13:48

mysql statements in java

0 Answers0