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