Adding values entered in java program(in a form) to sql database:

Question

I am trying to capture & store user details(name, password etc) & store them in sql database so as to be used by users to login in future.

How do I save the details as a row in the database, yet they are entered as individual strings? Also, how do I capture &store details like gender(Male,Female) selected from a Combobox? Thanks.

private class achandler implements ActionListener {
        @Override
        public void actionPerformed(ActionEvent ae) {
            //capture user details
            String fnamevalue = fnametext.getText();
            String lnamevalue = lnametext.getText();
            String usernamevalue = usernametext.getText();
            char[] pwdvalue = pwdtext.getPassword();
            char[] pwdrptvalue = pwdrpttext.getPassword();

            if(pwdvalue == pwdrptvalue) {
            //add user details to an array
            String[] userdetail = {fnamevalue, lnamevalue, usernamevalue, pwdvalue.toString()};

            try {
            Class.forName("com.mysql.jdbc.Driver");
            String Url = "jdbc:mysql://localhost/nsibirwa?" +
                                   "user=root&password=1234";

            Connection con = DriverManager.getConnection(Url);
            Statement stmt = con.createStatement();

            //I am stuck here!!!! i.e. adding 'userdetail' as a tuple in the database


        }
        catch (SQLException e) {
            System.out.println("SQL Exception: "+ e.toString());
        } 
        catch (ClassNotFoundException cE) {
            System.out.println("Class Not Found Exception: "+ cE.toString());
        }
       }
            else {
            JOptionPane.showMessageDialog(null, "password not matching!", 
                        "Password error", JOptionPane.ERROR_MESSAGE);
            }

     }
   }

Please remember not to store the passwords in clear. A good hash function (not MD5) and a salt are essential. — Pablo
– Pablo, Commented Jun 8, 2012 at 11:05

user330315 · Accepted Answer · 2012-06-08 11:04:10Z

2

adding 'userdetail' as a tuple in the database

Something like:

Connection con = DriverManager.getConnection(Url);
PreparedStatement stmt = con.prepareStatement("insert into user_details (fname, lname, username, pwd) values (?,?,?,?));
stmt.setString(1, fnamevalue);
stmt.setString(2, lnamevalue);
stmt.setString(3, username);
stmt.setString(4, new String (pwdvalue));
stmt.executeUpdate();

Your code has another problem:

if (pwdvalue == pwdrptvalue)

you can not compare objects like that. You need to convert those char[] to Strings and use equals() to compare them. Search for "java string equals" to find out why. This is very basic Java knowledge (and is covered in each and every tutorial I have seen)

This assumes you have a table named user_details with the columns fname, lname, username and pwd. If your table definition is different you need to adjust the insert statement.

Also, how do I capture &store details like gender(Male,Female) selected from a Combobox?

I would suggest you open a second question for that. You should not mix completely different topics (JDBC/SQL vs. plain Swing) in a single question.

answered Jun 8, 2012 at 11:04

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

emrys Over a year ago

Thanks a_horse_with_no_name. It worked wonderfully. Actually, some user details are captured using a Combobox (e.g. user selects their gender from the two options). I was hoping to find out how I can also add these to the same row along with the others in the user_details table.

user330315 Over a year ago

@ambroz: use getSelectedItem() on the combobox and then use that value in the insert statement.

Collectives™ on Stack Overflow

Adding values entered in java program(in a form) to sql database:

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related