Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void caricaActionPerformed(java.awt.event.ActionEvent evt) {
- String username = null,ruolo=null,password;
- username = usernameField.getText();
- password = passwordField.getText();
- ruolo = ruoloField.getText();
- try {
- aggiungiUtente(username,password,ruolo);
- } catch (SQLException ex) {
- Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void aggiungiUtente(String username,String password,String ruolo) throws SQLException {
- Connection conn;
- String url="jdbc:mysql://localhost:3306/gestionale",user="root",psw="141299Fm";
- conn = (Connection) DriverManager.getConnection(url,user,psw);
- conn.setAutoCommit(false);
- String sql= "insert into Utenti('username',password','ruolo') VALUES(?,?,?)";
- try{
- PreparedStatement st = conn.prepareStatement(sql);
- st.setString(1, username);
- st.setString(1, password);
- st.setString(1, ruolo);
- ResultSet rs = st.executeQuery();
- System.out.println(rs);
- }catch(SQLException e)
- {
- Logger.getLogger(InserisciUtente.class.getName()).log(Level.SEVERE, null, e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement