update database

[manuzerwa]

On need to delete a row from my database but I fail with these codes, please help

String query = "DELETE FROM IDENTIFICATION WHERE IDmalade='"+ID.getText()+"'";

Note: IDmalade is a primary key in my database
ID is a text field name on my form

Thanks

[JosAH]

What was the error message?

kind regards,

Jos

[manuzerwa]

There is no error message, but when I click on update button my database is not updated

[JosAH]

There is no error message, but when I click on update button my database is not updated

Is the code in your event handler executed at all?

kind regards,

Jos

[cristian.rivera]

Here try this, Add the MySQL JDBC library to your project and use this code:

private static String server_username = "";
private static String server_password = "";
private static String url = "jdbc:mysql://host/database";

Connection conn;
try {

Class.forName("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection(url, server_username, server_password);

String query = "DELETE FROM IDENTIFICATION WHERE IDmalade = '" + ID.getText() + "'";
Statement st = (Statement) conn.createStatement();
st.executeUpdate(query);

st.close();
conn.close();
} catch (Exception e) {
System.err.println(e);
}