April 05
Prof. Ismael H. F. Santos
- ismael@tecgraf.puc-rio.br
2
JDBC Tradicional
public
void
updateCustomer(Customer customer) {
Connection conn = null;
PreparedStatement ps = null;
try {
conn = getConnection();
ps = conn.prepareStatement(“update customer set ” +
“firstName = ?, lastName = ?, ...”);
ps.setString(1,
customer.getFirstName());
ps.setString(2,
customer.getLastName());
ps.executeUpdate();
} catch (SQLException
e) {
log.error(e);
} finally {
try { if (ps != null) ps.close();
}
catch (SQLException
e) {log.error(e);}
try {if (conn != null)
conn.close();}
catch (SQLException
e) {log.error(e);}
}
}
private Connection
getConnection() {
//... Mais código de encanador
}