Java - Login And Register Form With MySQL DataBase - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Java - Login And Register Form With MySQL DataBase, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel database,
Artikel How To Create SignUp And SignIn Form In Java,
Artikel Java,
Artikel Java Login And Register Form With MySQL DataBase,
Artikel Java Login Form,
Artikel java register form,
Artikel login,
Artikel Login And Register Form In Java,
Artikel mysql,
Artikel register, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : Java - Login And Register Form With MySQL DataBase
link : Java - Login And Register Form With MySQL DataBase
in a previous Java tutorial we did a login and register form design ( video link: https://youtu.be/XAowXcmQ-kA ),
and in this one will see how to connect the login and signup form with a mysql database
to do that you need to download mysql connector, watch tutorial from here: https://www.youtube.com/watch?v=zM7oe2_S-jY
and add it to your project
we will ceate a class (MyConnection) to connect our login and register forms with mysql database
in the register form wi will create a function (checkUsername) to check if the username you want to register is already exists in the database table
what we will check when the user click on the register button:
- if the username jtextfield is empty
- if the password jtextfield is empty
- if the retype_password text is equal to the password text
- if the username already exists in the database using the "checkUsername" function
- if the jdatechooser is empty
in the login fom it's simple;
the user enter his login and password and click on the login button,
and all we have to do is to check if a user with this username and password already exists on the database, and if the user don't exists show a warning message , else show a new form with the user username displayed on a jlabel.
Anda sekarang membaca artikel Java - Login And Register Form With MySQL DataBase dengan alamat link https://dev-create.blogspot.com/2018/05/java-login-and-register-form-with-mysql.html
Judul : Java - Login And Register Form With MySQL DataBase
link : Java - Login And Register Form With MySQL DataBase
Java - Login And Register Form With MySQL DataBase
How To Make SignUp And SignIn Form In Java Using NetBeans With MySQL DataBase
in a previous Java tutorial we did a login and register form design ( video link: https://youtu.be/XAowXcmQ-kA ),
and in this one will see how to connect the login and signup form with a mysql database
to do that you need to download mysql connector, watch tutorial from here: https://www.youtube.com/watch?v=zM7oe2_S-jY
and add it to your project
we will ceate a class (MyConnection) to connect our login and register forms with mysql database
in the register form wi will create a function (checkUsername) to check if the username you want to register is already exists in the database table
what we will check when the user click on the register button:
- if the username jtextfield is empty
- if the password jtextfield is empty
- if the retype_password text is equal to the password text
- if the username already exists in the database using the "checkUsername" function
- if the jdatechooser is empty
in the login fom it's simple;
the user enter his login and password and click on the login button,
and all we have to do is to check if a user with this username and password already exists on the database, and if the user don't exists show a warning message , else show a new form with the user username displayed on a jlabel.
Project Source Code:
------------ Create A Class "MyConnection" To Connect Our Forms With Database
import java.sql.Connection;
import java.sql.DriverManager;
/**
*
* @author 1BestCsharp
*/
public class MyConnection {
// create a function to connect with mysql database
public static Connection getConnection(){
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/java_login_register", "root", "");
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
return con;
}
}
------------ On The Register Form ------------
// function to check if the username already exist in database table
public boolean checkUsername(String username)
{
PreparedStatement ps;
ResultSet rs;
boolean checkUser = false;
String query = "SELECT * FROM `the_app_users` WHERE `u_uname` =?";
try {
ps = MyConnection.getConnection().prepareStatement(query);
ps.setString(1, username);
rs = ps.executeQuery();
if(rs.next())
{
checkUser = true;
}
} catch (SQLException ex) {
Logger.getLogger(RegisterForm.class.getName()).log(Level.SEVERE, null, ex);
}
return checkUser;
}
// on the register button click
private void jButton_Register_ActionPerformed(java.awt.event.ActionEvent evt) {
String fname = jTextField_FN.getText();
String lname = jTextField_LN.getText();
String uname = jTextField_UN.getText();
String pass = String.valueOf(jPasswordField_PASS.getPassword());
String re_pass = String.valueOf(jPasswordField_REPASS.getPassword());
String bdate = null;
String address = jTextArea_ADDRESS.getText();
if(uname.equals(""))
{
JOptionPane.showMessageDialog(null, "Add A Username");
}
else if(pass.equals(""))
{
JOptionPane.showMessageDialog(null, "Add A Password");
}
else if(!pass.equals(re_pass))
{
JOptionPane.showMessageDialog(null, "Retype The Password Again");
}
else if(checkUsername(uname))
{
JOptionPane.showMessageDialog(null, "This Username Already Exist");
}
else{
if(jDateChooser_BDATE.getDate() != null)
{
SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd");
bdate = dateformat.format(jDateChooser_BDATE.getDate());
}
PreparedStatement ps;
String query = "INSERT INTO `the_app_users`(`u_fname`, `u_lname`, `u_uname`, `u_pass`, `u_bdate`, `u_address`) VALUES (?,?,?,?,?,?)";
try {
ps = MyConnection.getConnection().prepareStatement(query);
ps.setString(1, fname);
ps.setString(2, lname);
ps.setString(3, uname);
ps.setString(4, pass);
if(bdate != null)
{
ps.setString(5, bdate);
}else{
ps.setNull(5, 0);
}
ps.setString(6, address);
if(ps.executeUpdate() > 0)
{
JOptionPane.showMessageDialog(null, "New User Add");
}
} catch (SQLException ex) {
Logger.getLogger(RegisterForm.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
------------ On The Login Form ------------
// on the login button click
private void jButton_LOGINActionPerformed(java.awt.event.ActionEvent evt) {
PreparedStatement ps;
ResultSet rs;
String uname = jTextField1.getText();
String pass = String.valueOf(jPasswordField1.getPassword());
String query = "SELECT * FROM `the_app_users` WHERE `u_uname` =? AND `u_pass` =?";
try {
ps = MyConnection.getConnection().prepareStatement(query);
ps.setString(1, uname);
ps.setString(2, pass);
rs = ps.executeQuery();
if(rs.next())
{
HOME_JFrame mf = new HOME_JFrame();
mf.setVisible(true);
mf.pack();
mf.setLocationRelativeTo(null);
mf.setExtendedState(JFrame.MAXIMIZED_BOTH);
mf.jLabel1.setText("Welcome < "+uname+" >");
this.dispose();
}
else{
JOptionPane.showMessageDialog(null, "Incorrect Username Or Password", "Login Failed", 2);
}
} catch (SQLException ex) {
Logger.getLogger(LoginForm.class.getName()).log(Level.SEVERE, null, ex);
}
}
////// OUTPUT :
 |
| java register form - add username |
it's the same for password and retype password
 |
| java register form - username already exists |
 |
| java login form - login failed |
 |
| java login form - login success -> show new form |
More Java Projects:
Demikianlah Artikel Java - Login And Register Form With MySQL DataBase
Sekianlah artikel Java - Login And Register Form With MySQL DataBase kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel Java - Login And Register Form With MySQL DataBase dengan alamat link https://dev-create.blogspot.com/2018/05/java-login-and-register-form-with-mysql.html
