Updating if file exists...

[Michael Winner]

Hello!
I've been working on this little problem for a while. I'm simply checking a database table to see if a record exists. If it does, it gets updated. If it doesn't, a new record is created. Can somebody lend a hand with the code? Thanks for any help!
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc B", "bob", "jim");
String strSQL = "SELECT ID, FName, Lame FROM tblContacts WHERE ID = " + UserID;

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(strSQL);
if(!rs.next()){ //If record does not exist
rs.moveToInsertRow();
rs.updateInt("FName", FName);
rs.updateInt("LName", LName);
rs.insertRow();
}else{
rs.next();
rs.updateInt("FName", FName);
rs.updateInt("LName", LName);
rs.updateRow();
}

[Jeanne Boyarsky]

You need two SQL statements to do this. The first is to check if it is there. If it is there, you need a second to update the data. If not, you need a second to insert the data.

[Michael Winner]

Really? Does that mean I need to also create a second database connection? Oh, yeah.. thanks for the reply

[Jeanne Boyarsky]

You can use the same database connection. For example,

  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc B", "bob", "jim");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(query1);
// do stuff with result set
rs.close();
stmt.close();
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(query2);
// do stuff with result set 2
rs.close();
stmt.close();
con.close();
} 

[Gregg Bolinger]

I don't think you need 2 SQL statements. I could be wrong.
Are you getting errors? What isn't working? We need more information

[Jeanne Boyarsky]

Gregg,
I forgot that some drivers let you do that. Sorry for the confusion.