Advertisement
Guest User

Untitled

a guest
Jul 26th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. public void consultarAluno()
  2. {
  3. try {
  4. setId(Integer.parseInt(JOptionPane.showInputDialog("Digite o ID do aluno:")));
  5. Connection conexao = DriverManager.getConnection("jdbc:mysql://localhost/bd_eclipse", "root", "etecjau" );
  6. PreparedStatement at = conexao.prepareStatement("SELECT * FROM ALUNO WHERE ID= ?");
  7. at.setInt(1, getId());
  8. ResultSet rs = at.executeQuery();
  9. while(rs.next()) {
  10. JOptionPane.showMessageDialog(null, "Nome: " + rs.getString("NOME") + "\nCurso: " + rs.getString("CURSO"));
  11.  
  12. }
  13. conexao.close();
  14. }
  15.  
  16. catch (Exception e)
  17. {
  18. JOptionPane.showMessageDialog(null, "Falha na consulta");
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement