public void atualizar(AlunoDO aluno, Transacao tr) throws Exception {
Connection con = tr.obterConexao();
String sql =
"update aluno set nusp=?, email=?, nome=?, sobrenome=?, link_lattes=?, instituicao=?, codigo_CV=?, codigo_hist=? where id=?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, aluno.getNusp());
ps.setString(2, aluno.getEmail());
ps.setString(3, aluno.getNome());
ps.setString(4, aluno.getSobrenome());
ps.setString(5, aluno.getLattes());
ps.setString(6, aluno.getInstituicao());
ps.setString(7, aluno.getCv());
ps.setString(8, aluno.getHist());
ps.setInt(9, aluno.getId());
int result = ps.executeUpdate();
} // atualizar
