April 05
Prof. Ismael H. F. Santos -  ismael@tecgraf.puc-rio.br                                                          2
Alterar a tabela (2)
nString[][] registros = {{"maria","mary"},{"joao","jj"}};
nConnection db = DriverManager.getConnection(url,user,pass);
nPreparedStatement ps = db.prepareStatement("update senhas set "+
n                                           "senha=? where "+
n                                           "nome=?");
nfor (int i=0; i<registros.length; i++) {
n  String nome = registros[i][0];
n  String senha = registros[i][1];
n  ps.setString(2, nome);
n  ps.setString(1, senha);
n  int ok = ps.executeUpdate();
n  System.out.println(nome+(ok==1 ? ": ok." : ": nok."));
n}
nps.close();
ndb.close();