@Override
public AlunoDO buscar(int idobj, Transacao tr) throws Exception {
Connection con = tr.obterConexao();
String sql = "select * from aluno where id=?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, idobj);
ResultSet rs = ps.executeQuery();
rs.next();
AlunoDO aluno = new AlunoDO();
aluno.setId(rs.getInt("id"));
aluno.setNusp(rs.getString("nusp"));
aluno.setEmail(rs.getString("email"));
aluno.setNome(rs.getString("nome"));
aluno.setSobrenome(rs.getString("sobrenome"));
aluno.setLattes(rs.getString("link_lattes"));
aluno.setInstituicao(rs.getString("instituicao"));
aluno.setCv(rs.getString("codigo_CV"));
aluno.setHist(rs.getString("codigo_hist"));
return aluno;
} // buscar
