what will be the query for ms access table to update a specific row?
Code below is not making a valid result set resulting in exception?
need help:-/
import java.sql.*;
class OdbcAccessQuery {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:WWFDB");
Statement sta = con.createStatement();
// getting the data back
ResultSet res = sta.executeQuery(
"UPDATE WWFTABLE SET NAME='sky' WHERE ID=5");
res.close();
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}