How to Create Multiple User Login Form in java using MySQL Database and NetBeans IDE?

1.Now open Netbeans IDE and click on file > new project. Select categories as java and project as java application from that window:

How to Create Login From in Java

2. Click next and then give your project name and then click finished.

3. Now right click on your project and select new > JFrame Form:

4. After this new window will appear from this window drag Panel and extend it, and drag three label, two Text Field, one Button ,one ComboBox and drop to the jframe from. Change the name of the label to username, password and select user type. Change the variable name of the Text Field by right clicking it and named it as txtuser and txtpass respectively. Change the Button text to Login. And right click the combobox click on properties and click on model, add the item there like admin, user etc. which will looks like this:

And finally our login form will looks like the following one:

5. After download and installing wamp server open it, and then open your localhost, for this open up your any browsing software and type localhost or 127.0.0.1 in the address bar. Then new page will appear then scroll down and find phpmyadmin and click on that. Then you will be able to see the login page. Login in by entering username and password (Default username is root and password is empty). And then click on new and create one database having any name you want and the click OK, then create table having three field in and click on go. After that, you need to insert the field name like: username, password and usertype. and then select the length (like 50, 30, 100 etc) as well as data type (recommend varchar) as your requirement and then click on save. OR You can watch the video for this designing part, you may understand better in video.

some screenshot of creating database are:

NOTE: we have to insert username, password and usertype in our database. So, for this, Click on insert tab and insert username, password and usertype as:

6. Declare following variable inside the class your jframe, for this select source from the top of the jframe.

Connection con = null;
PreparedStatement pst=null;
ResultSet rs = null;

7. Now double click the Login button and write the following code:

try{
String query = "SELECT * FROM `multiuserlogin` WHERE username=? and password=? and usertype=?";
con = DriverManager.getConnection("jdbc:mysql://localhost/multiuserlogin", "root", "");
pst=con.prepareStatement(query);
pst.setString(1, txtuser.getText());
pst.setString(2, txtpass.getText());
pst.setString(3, String.valueOf(jComboBox1.getSelectedItem()));
rs=pst.executeQuery();
if(rs.next()){
JOptionPane.showMessageDialog(this, "username and password matched and you are logined as "+rs.getString("usertype"));
if(jComboBox1.getSelectedIndex()==0){
admin a = new admin();
a.setVisible(true);
this.setVisible(false);
}
else{
user u = new user();
u.setVisible(true);
this.setVisible(false);
}}
else{
JOptionPane.showMessageDialog(this, "username and password do not matched");

}
}
catch(Exception ex){
JOptionPane.showMessageDialog(this, ex.getMessage());

}

8. Now you need to have MySQL connector for java so download it. Click Here and Add this jar file in your project libraries folder by right clicking libraries >click add jar. Select downloaded jar file and click open.

9. To run this program you need to right click on your jframe and click run file as below:

Now enter right username, password  and click Login.