Advertisement
Guest User

Untitled

a guest
Apr 6th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. try {
  2. Connection lig = DriverManager.getConnection("jdbc:mysql://localhost/fppd", "root", "");
  3. PreparedStatement stmt = lig.prepareStatement(
  4. "SELECT Data, Local, NumeroProva, Rio FROM `calendario` WHERE NumeroProva = ? AND Escalao = ? ");
  5.  
  6. stmt.setInt(1, Integer.parseInt(txtProcurarNumero.getText()));
  7. stmt.setString(2, txtescalao.getText());
  8. ResultSet res = stmt.executeQuery();
  9. while (res.next()) {
  10. txtnumeroprova.setText(res.getString("NumeroProva"));
  11. txtdata.setText(res.getString("Data"));
  12. txtlocal.setText(res.getString("Local"));
  13. txtrio.setText(res.getString("Rio"));
  14. JOptionPane.showMessageDialog(frame, "Prova encontrada");
  15. }
  16. res.close();
  17.  
  18. } catch (SQLException e1) {
  19. JOptionPane.showMessageDialog(frame, e1.getLocalizedMessage());
  20. }
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement