Advertisement
Guest User

Untitled

a guest
Apr 9th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. private void caricaActionPerformed(java.awt.event.ActionEvent evt) {
  2. String username = null,ruolo=null,password;
  3. username = usernameField.getText();
  4. password = passwordField.getText();
  5. ruolo = ruoloField.getText();
  6. try {
  7. aggiungiUtente(username,password,ruolo);
  8. } catch (SQLException ex) {
  9. Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, ex);
  10. }
  11. }
  12. private void aggiungiUtente(String username,String password,String ruolo) throws SQLException {
  13. Connection conn;
  14. String url="jdbc:mysql://localhost:3306/gestionale",user="root",psw="141299Fm";
  15. conn = (Connection) DriverManager.getConnection(url,user,psw);
  16. conn.setAutoCommit(false);
  17. String sql= "insert into Utenti('username',password','ruolo') VALUES(?,?,?)";
  18. try{
  19. PreparedStatement st = conn.prepareStatement(sql);
  20. st.setString(1, username);
  21. st.setString(1, password);
  22. st.setString(1, ruolo);
  23.  
  24. ResultSet rs = st.executeQuery();
  25.  
  26. System.out.println(rs);
  27. }catch(SQLException e)
  28. {
  29. Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, e);
  30. }
  31.  
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement