Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2017
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. try {
  2. String login = studentLog.textField.getText();
  3. String sql = "select * from student where nr_indeksu=?";
  4. Class.forName("org.h2.Driver");
  5. Connection connection = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/test", "sa", "");;
  6. PreparedStatement stmt = connection.prepareStatement(sql);
  7. stmt.setString(1, login);
  8. ResultSet resultSet = stmt.executeQuery();
  9. while(resultSet.next()) {
  10. String ocena = resultSet.getString("ocena");
  11. System.out.println(ocena);
  12. label.setText(ocena);
  13. }
  14. } catch (ClassNotFoundException | SQLException e1) {
  15. // TODO Auto-generated catch block
  16. e1.printStackTrace();
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement