BANKING SYSTEM USING JAVA CODE INCLUDE JDBC AND GUI

import java.awt.*;
import java.awt.event.*;
import java.awt.FlowLayout;
import java.sql.*;
import javax.swing.*;
public class Bank extends JFrame implements ActionListener
{
static JLabel label1,label2,label3,sep;
static JButton sign,create,deposit,withdraw,trans,balance,close,clear;
static JTextField txtA1;
static JTextField txtA2;
static Connection con;
static Statement st1,st2,st3;
static ResultSet rs1;
int numd;
int numf;
int nume;
public Bank()
   {
  super(" Mukunth's Bank");
  setLayout(new FlowLayout());
  try {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  con = DriverManager.getConnection ("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=bank.mdb;DriverID=22}","","");
  st1=con.createStatement();
rs1=st1.executeQuery("select * from tab1");
}
catch(Exception e)
{
System.out.println("there was some error in establishing connection : "+e);
}
sep = new JLabel("Existing User Signin  :  ");
add(sep);
label1 = new JLabel(" Account Number : ");
add(label1);
    txtA1 = new JTextField(15);
add(txtA1);
label2 = new JLabel("        Name :       ");
add(label2);
txtA2 = new JTextField(15);
add(txtA2);
sign=new JButton("SIGN IN");
add(sign);
sep = new JLabel("                                                                                           ");
add(sep);
    sep = new JLabel("                                    ");
add(sep);
sep = new JLabel("New User Signin  :  ");
add(sep);
    create=new JButton("CREATE ACCOUNT");
add(create);
sep = new JLabel("                                                                                          ");
add(sep);
sep = new JLabel("                                                    ");
add(sep);
deposit=new JButton("DEPOSIT");
add(deposit);
withdraw=new JButton("WITHDRAW");
add(withdraw);
trans=new JButton("TRANSACTION");
add(trans);
    balance=new JButton("BALANCE");
add(balance);
clear=new JButton("CLEAR");
add(clear);
sep = new JLabel("                                                                                      ");
add(sep);
close=new JButton("CLOSE");
add(close);
create.addActionListener(this);
deposit.addActionListener(this);
withdraw.addActionListener(this);
trans.addActionListener(this);
balance.addActionListener(this);
clear.addActionListener(this);
close.addActionListener(this);
    sign.addActionListener(this);
    deposit.setEnabled(false);
withdraw.setEnabled(false);
trans.setEnabled(false);
balance.setEnabled(false);
  }
 public void actionPerformed(ActionEvent e)
{
if(e.getSource()==create)
{
String stra = JOptionPane.showInputDialog(null,"Please enter the NAME to open a CURRENT ACCOUNT");
String strb = JOptionPane.showInputDialog(null,"Please enter the ACCOUNT NUMBER");
if(stra==null || strb==null)
{
  JOptionPane.showMessageDialog(null," Either any one or both the values were left blank");
          deposit.setEnabled(false);
  withdraw.setEnabled(false);
  trans.setEnabled(false);
  balance.setEnabled(false);
  create.setEnabled(true);
      sign.setEnabled(true);
}
else
{
try
   {
st2=con.createStatement();
String rr="insert into tab1 values('"+stra+"','"+strb+"',0,0,0)";
st2.executeUpdate(rr);
st2.close();
JOptionPane.showMessageDialog(null,"ACCOUNT Created Successfully");
txtA1.setText(strb);
txtA2.setText(stra);
  }
catch(Exception e2)
{
JOptionPane.showMessageDialog(null," There is already a user with same ACCOUNT NUMBER ,Give another ACCOUNT NUMBER ");
}
  deposit.setEnabled(true);
withdraw.setEnabled(true);
trans.setEnabled(true);
balance.setEnabled(true);
create.setEnabled(true);
   sign.setEnabled(true);
}
}
else if(e.getSource()==sign)
{
  String num=txtA1.getText();
try
{
st1.close();
st1=con.createStatement();
rs1=st1.executeQuery("Select * from tab1 where AccNum Like '"+num+"'");
rs1.next();
txtA1.setText(rs1.getString("AccNum"));
txtA2.setText(rs1.getString("UserName"));
}
catch(Exception e2)
{
JOptionPane.showMessageDialog(null,"Invalid Account Number");
}
deposit.setEnabled(true);
withdraw.setEnabled(true);
trans.setEnabled(true);
balance.setEnabled(true);
create.setEnabled(false);
}
else if(e.getSource()==deposit)
      {
      String strc = JOptionPane.showInputDialog(null,"Please enter the amount to be DEPOSITED");
   numd=Integer.parseInt(strc);
   int numb=Integer.parseInt(txtA1.getText());
    if (numd<=0)
    {
    JOptionPane.showMessageDialog(null," NO Amount Deposited");
    }
    else
    {
    try
{
   int num,num1;
   st3=con.createStatement();
    rs1=st3.executeQuery("select * from tab1 where Accnum like '"+txtA1.getText()+"'");
    rs1.next();
    num1=Integer.parseInt(rs1.getString("Deposit"));
    num=Integer.parseInt(rs1.getString("Balance"));
    JOptionPane.showMessageDialog(null,"Amount Deposited Successfully , Amount is "+numd);
    numf=num+numd;
    num1=num1+numd;
st2=con.createStatement();
String ss="update tab1 set Deposit="+num1+" where AccNum="+numb+"";
   String aa="update tab1 set Balance="+numf+" where AccNum="+numb+"";
st2.executeUpdate(ss);
st2.executeUpdate(aa);
st2.close();
st3.close();
}
catch(Exception e2)
{
JOptionPane.showMessageDialog(null,"Amount can not be DEPOSITED");
}
    }
      }
else if(e.getSource()==withdraw)
  {
       String strd = JOptionPane.showInputDialog(null,"Please enter the amount to be WITHDRAWN");
       nume=Integer.parseInt(strd);
       int numc=Integer.parseInt(txtA1.getText());
       if(numf<=nume)
{
  JOptionPane.showMessageDialog(null,"Sorry can not Withdraw, no sufficient Balance");
}
else
{
try
   {
    int num1;
   st3=con.createStatement();
    rs1=st3.executeQuery("select * from tab1 where Accnum like '"+txtA1.getText()+"'");
    rs1.next();
    num1=Integer.parseInt(rs1.getString("Withdraw"));
    numf=Integer.parseInt(rs1.getString("Balance"));
    JOptionPane.showMessageDialog(null,"Amount Withdrawn is "+nume);
    numf=numf-nume;
    num1=num1+nume;
    st2=con.createStatement();
   String pp="update tab1 set Withdraw="+num1+" where AccNum="+numc+"";
   String pp1="update tab1 set Balance="+numf+" where AccNum="+numc+"";
st2.executeUpdate(pp);
st2.executeUpdate(pp1);
st2.close();
   }
catch(Exception e2)
{
JOptionPane.showMessageDialog(null," Can't WITHDRAW ");
}
   }
  }

else if(e.getSource()==balance)
{
             String num=txtA1.getText();

try
   {
     
st3=con.createStatement();
    rs1=st3.executeQuery("select * from tab1 where Accnum like '"+num+"'");
    rs1.next();
    numf=Integer.parseInt(rs1.getString("Balance"));
   
JOptionPane.showMessageDialog(null,"Balance is "+numf);
   }
catch(Exception e2)
{
JOptionPane.showMessageDialog(null," Balance null ");
}
 
}
else if(e.getSource()==trans)
{
String strq = JOptionPane.showInputDialog(null,"Enter the ACCOUNT NUMBER to view the TRANSACTION DONE");
int numk=Integer.parseInt(strq);
   int numa=Integer.parseInt(txtA1.getText());
if(numk==numa)
{
JOptionPane.showMessageDialog(null,"Amount Deposited  is "+numd);
JOptionPane.showMessageDialog(null,"Amount Withdrawn is "+nume);
}
else
{
JOptionPane.showMessageDialog(null,"The Account Number is not the same as in the TEXTFIELD");
}
}

else if(e.getSource()==clear)
{
txtA1.setText("");
txtA2.setText("");
deposit.setEnabled(false);
withdraw.setEnabled(false);
trans.setEnabled(false);
balance.setEnabled(false);
create.setEnabled(true);
            sign.setEnabled(true);
}
else if(e.getSource()==close)
{
System.exit(0);
}
 }
 public static void main(String args[])
   {
    Bank obj = new Bank();
    obj.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    obj.setSize(250,320);
    obj.setVisible(true);
    }

}

https://apkmodstudio.com/mango-live-mod-apk