Advertisement
olekturbo

Untitled

Mar 17th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1.  
  2. dalej.addMouseListener(new MouseAdapter() {
  3. @Override
  4. public void mouseClicked(MouseEvent arg) {
  5. Connection c = null;
  6. try {
  7. Class.forName("org.postgresql.Driver");
  8. c = DriverManager
  9. .getConnection("jdbc:postgresql://localhost:5432/aszewczak",
  10. "aszewczak", "123");
  11. c.setAutoCommit(false);
  12.  
  13.  
  14. PreparedStatement st = c.prepareStatement("INSERT INTO uzytkownik (data_urodzenia, miasto, wzrost, pensja, plec ) VALUES (?, ?, ?, ?, ?)");
  15. st.setObject(1, Date.valueOf(data.getText()));
  16. st.setString(2, miasto.getText());
  17. st.setInt(3, Integer.parseInt(wzrost.getText()));
  18. st.setFloat(4, Float.parseFloat(pensja.getText()));
  19. st.setString(5, plec.getText());
  20. st.executeUpdate();
  21. st.close();
  22. c.commit();
  23. c.close();
  24.  
  25. info.setText("DODANE!");
  26. } catch (Exception e) {
  27. System.err.println( e.getClass().getName()+": "+ e.getMessage() );
  28. System.exit(0);
  29. }
  30. }
  31. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement