String url;
url = "jdbc:odbc:UserDB";
String user, pass;
user = "ian";
pass = "stjklsq";
Connection con;
Statement stmt;
ResultSet rs;
try {
con = DriverManager.getConnection(url, user, pass);
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("SELECT * FROM Users where nick=\"ian\"");
// Get the resultset ready, update the passwd field, commit
rs.first();
rs.updateString("password", "unguessable");
rs.updateRow();
rs.close();
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
