JDBC delete statement with multiple columns
Posted
by
user1643033
on Stack Overflow
See other posts from Stack Overflow
or by user1643033
Published on 2012-12-01T04:49:47Z
Indexed on
2012/12/01
5:03 UTC
Read the original article
Hit count: 114
It says I ended this statement wrong when if I input it into sql plus with just the addition of ; it works perfectly. What am I doing wrong?
Statement statement = connection.createStatement();
statement.executeUpdate("delete from aplbuk MODEL = '"+ textField_4.getText() + "'AND year = '" + textField_1.getText() + "' AND Litres = '" + textField_2.getText()
+ "' AND ENGINE_TYPE = '" + textField_3.getText() + "'");
statement.close();
© Stack Overflow or respective owner