Tutusfunny

The ATM Login System is developed using Java and mysql.In this tutorial we explain how to set security password. We have created two fields Account No,Pinno. : Enter the Account No and Pinno in the database matches.if the Account matched with Pinno Display the Message as “Welcome” otherwise “Check the Accno and Pinno”.

First Step we created database which name is “lmc”   inside the database created the table users .user table consist of following coloums  id,accno,pinno.

Second  Step after design the form we have established the database connection inorder to connect java and mysql databse. I wrote the code below.

import java.sql.*; //

    Connection con;
    PreparedStatement pst;
    ResultSet rs;

   public void Connect()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/lmc", "root", "");
            
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
           ex.printStackTrace();
        }
        
    }

Paste the code inside the Login Button

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        try {
         
            String accno = txtaccno.getText();
            char pwd[] = txtpinno.getPassword(); // use the getPassword method for set security password
            
            String vpwd = new String(pwd);
            
            pst = con.prepareStatement("select pinno from users where accno = ?");
            pst.setString(1, accno);
            rs = pst.executeQuery();
            
            if(rs.next())
            {
                String dbpwd = rs.getString(1).trim();
                if(vpwd.equals(dbpwd))
                {
                    JOptionPane.showMessageDialog(this, "Welcom LMC Bank");
                }
            }
            else
            {
                 JOptionPane.showMessageDialog(this, "Check Accno and Pinno");
                txtaccno.setText("");
                 txtpinno.setText("");
                 txtaccno.requestFocus();
            }
  
        } catch (SQLException ex) {
           ex.printStackTrace();
        }
 
    }

I have attached the video tutorial below it will help you  to do this  step by step.