Updating a database

[johno77]

Hello

I have created the following code to update a paticular mysql record. Could any one inform me of how if the record is not present to add it to the database.

Thanks - heres the relevant code


try {
String query1 = "UPDATE system SET cox='"+first+"', def='"+second+"' WHERE name_d='"+name+"'";
System.out.println(query1);
Statement state1 = connect.createStatement();
ResultSet resultset1=state1.executeQuery(query1);
JOptionPane.showMessageDialog(null,"Database updated: "

}
catch (Exception exp)
{
JOptionPane.showMessageDialog(null,"Problem with SQL query" + input );
}

 

[sedj]

Your SQL will be something like

INSERT INTO system VALUES ('one', 'two', 'three');

To determine whether or not you need to do an update or insert, you could execute some SQL such as

SELECT COUNT(*) FROM system WHERE name_d = 'qqq';

If it is 0, then INSERT, if its not then UPDATE.

 

[Grentis]

I think that you can take a boolean response from the statement and not a resultSet.

boolean res = state1.execute(query1);
if(!res){
String query2 = "INSERT INTO ......";
state1.execute(query2);
}

so you can control the result of the first query. If it's fail you execute the second (insert query)

Grentis