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(stranull strbnull)
{
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(numknuma)
{
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);
}
}