Jak pisze zapytania pojedynczo to wszystko działa.
st.executeUpdate("UPDATE tabelaDane SET name='Ewa' WHERE ID =1;");
st.executeUpdate("UPDATE tabelaDane SET name='Zenek' WHERE ID =2;");
st.executeUpdate("UPDATE tabelaDane SET name='Marcin' WHERE ID =3;");
st.executeUpdate("UPDATE tabelaDane SET name='Jola' WHERE ID =4;");
st.executeUpdate("UPDATE tabelaDane SET name='Arek' WHERE ID =5;");
st.executeUpdate( "UPDATE tabelaDane SET name='Ewa' WHERE ID =1;"
+ "UPDATE tabelaDane SET name='Zenek' WHERE ID =2;"
+ "UPDATE tabelaDane SET name='Marcin' WHERE ID =3;"
+ "UPDATE tabelaDane SET name='Jola' WHERE ID =4;"
+ "UPDATE tabelaDane SET name='Arek' WHERE ID =5;");
a jak wpisze kilka do jednego to wywala mi błąd:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDAT
ktoś może wie w czym jest problem