April 05
Prof. Ismael H. F. Santos
- ismael@tecgraf.puc-rio.br
2
Popular a tabela (2)
nString[][]
registros =
{{"joao","joao"},{"maria","maria"}};
Connection
db = DriverManager.getConnection(url,user,pass);
PreparedStatement
ps = db.prepareStatement("insert into senhas "+
"values(?,?)");
for
(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);
int ok = ps.executeUpdate();
System.out.println(nome+(ok==1 ? ":
ok." : ": nok."));
}
ps.close();
ndb.close();