TechSupportNepTechSupportNep - Programming & Tech

  • Home
  • C#.NET
  • PHP
  • JAVA
  • Python
  • ASP.NET
  • VB.NET
  • Android
  • C
  • Tech
    • Tech News
  • Patreoner
TechSupportNep
  • Home
  • Programming
  • JAVA
  • How to Create User Registration Form in java using MySQL Database?
JAVA

How to Create User Registration Form in java using MySQL Database?

By Er. Ran Bahadur B.K. Last updated Aug 15, 2021
0 8,988
Share

In this tutorial we are going to talk about how to create user registration form in java using MySQL Server database.

If you don’t know how to create login form in java, first of all, you need to read these tutorials:

Login form in java using SQL Server Database: HERE

Login form in java using MySQL Database: HERE

After reading these tutorial, you will understand basics about java, JDK, JRE, environment variable, required server application etc.

So, i consider that you have the basic knowledge of all these things, and required application in your system. But specifically, in this tutorial we need these two application.

Download NetBeans IDE: HERE

Download WAMP Server: HERE

STEPS:

 

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 eight label, seven Text Field, one Button ,one ComboBox and drop to the jframe from. Change the name of the label to first name, last name, address, gender, email, phone, username and password. Change the variable name of the Text Field and combo box by right clicking it and named it as txtfName, txtLname, txtAdd, cmbGender, txtEmail, txtPhone, txtUser and txtpass respectively. Change the Button text to Register. And right click the combobox click on properties and click on model, add the item there like Male, Female and Others etc. which will looks like this:

how to create user registration form in java using mysql database?
how to create user registration form in java using mysql database?

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

how to create user registratoin form in java using mysql database?
how to create user registration form in java using mysql database?

6. 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 eight field in and click on go. After that, you need to insert the field name like: fname, lname, addr, email, phone, gender, username and password. 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:

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

Connection con = null;
PreparedStatement pst = null;

8. Now double click the Register button and write the following code:

try{
String query = "INSERT INTO `user`(`fname`, `lname`, `addr`, `gender`, `email`, `phone`, `username`, `password`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
con = DriverManager.getConnection("jdbc:mysql://localhost/userregistration", "root", "");
pst=con.prepareStatement(query);
pst.setString(1, txtFname.getText());
pst.setString(2, txtLname.getText());
pst.setString(3, txtAdd.getText());
pst.setString(4, cmbGender.getSelectedItem().toString());
pst.setString(5, txtEmail.getText());
pst.setString(6, txtPhone.getText());
pst.setString(7, txtUser.getText());
pst.setString(8, txtPass.getText());
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "REGISTER SUCCESSFULLY");


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

}

9. 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.

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

Now fill the form and click that register button. That’s it. 🙂

If you like this tutorial share this tutorials with your friends or in any java group so that they will know about this tutorial.

 

 

If you are confused then you can watch the following video:

Continue Reading
Create a Registration Form Using Swing Package In Javahow to create user registration form in javahow to design login and register form in java netbeansjava registration form with mysql databasejava user registration formmake user registration form in javaregistration form in java with database connectivity using netbeansregistration form in netbeans with mysqlsource code for registration form in java netbeansTechSupportNepuser registration form in java
0 8,988
Share FacebookTwitterReddItWhatsAppPinterestEmail
Er. Ran Bahadur B.K.60 posts 56 comments

Ran Bahadur B.K. is the owner of TechSupportNep who is working with the aim of providing the quality Technology content. He is creating Tech and Programming videos, you can see all them in his YouTube Channel(https://www.youtube.com/TechSupportNep). He is also working with some company.

Prev Post

How to Create User Registration Form in C#.NET Using SQL Server Database?

Next Post

How to Insert, Delete and Update in SQLite Database Using Android?

You might also like More from author
JAVA

How to Generate and Send OTP SMS for Free Using java?

JAVA

How to Send Free SMS using Java?[With Source Code]

Leave a comment
Help Needed

This website is free of annoying ads. We want to keep it like this. You can help with your support:

Donate!

The need for Support! Why to Support?

If you need your own website? contact me!
erranbahadurbk
Fiverr
Seller
Hello there,This is me Ran Bahadur B.K., A graduated computer engineer. I have 3+ years of work experience in wordpress design and development. I have strong knowledge of HTML, CSS and PHP which are the three ingredients of web development. Currently i am working with the software company so i also have experience in desktop apps and mobile apps development.

Latest

Python

How to Create Login Application in Python using SQLite Database?

How to use View Binding in Android?

Windows 10 Build 1909 Features that you should know.

How to Create a Complete Login and Forgot Password System in java ?

Prev Next 1 of 15
  • About us
  • Contact us
  • Privacy Policy
  • Disclaimer
© 2022 All Rights Reserved.
Website By: Ran Bahadur B.K.