Introduction:-

The objective of this application is to enable Customers of various Banks, who can do their
account accessibility and transactions using this solution. They need not to interact with various
applications or web sites of each bank. The Admin will add new customer’s details and can
update the existing details of the customer.

The Bank Admin makes access this software to see the all Customer transactions, account
Transfer status, etc. He should be able to provide manual Response for the queries related to the
Customers.

The Customers should make request for multiple bank account access to the
Administrator. He/she can view the Account related information. The customer should able to
transfer the amount from one bank to another bank account using this system by providing the
authentication details. The customer also facilitated to generate report for own bank details for a
respective period.

1
Literature Survey:-

Existing System & Disadvantages:

Currently we are having lot of banks in the market and any person can do transactions of any
individual bank either manually or by online. But no one can do all banks transactions in a single
portal or in single bank. This is the main disadvantage in existing system to avoid this problem
we are introducing “Green Banking system (G-Banking)”.

Disadvantages:

 It does not provide transactions from one bank to another bank.

 In this system separate account for each bank.

Proposed System & Its Advantages:

In proposed system can introduced multibank system. These application users can save their time
and use all features that are available in every bank. Transaction calculations and updating are
maintained by admin and provide customer support for users. This system will act like a
mediator between banks and users. Users can maintain single username and password and
contact only one customer care service for any problems.

Advantages:

 It provides transactions from one bank to another bank.

 It provides Single account from all banks.
 In this system to provide response for the queries related to the customers.
 In this system any time transactions through software.
.

2
Objective:-

 This software reduces the time taken for doing banking operations.

 This software helps in reducing paper work because the work of three banks can be done
within one software/office only.

 This software indirectly reduces pollution because we will have to go one office rather
than three banks.

 This software helps in reducing manpower space as the work of three banks can be done
in one office only.

 This software helps in reducing electricity as the work of three banks can be done in one
office only.

3
Project Analysis:-

This application consists following modules:

1. Admin Module:

The admin module will be used by the administrator of this portal, by using this
module, an admin can do some operations like create a new account, view the
account information, Transfer amount from one account to other account and can
also see the Transaction Reports. This module consists following functionalities.

i. Create New Account: By using this functionality admin can create a new
account in any bank by selecting bank name option.
ii. View Account Information: By using this functionality admin view all
customers’ account details, this can be viewed for users who are having
account in any bank.
iii. Transfer Amount: By using this functionality admin can transfer money
from one's customer account to other accounts of same bank or other banks.
iv. Transaction Reports: By using this functionality admin can get all
transaction reports of customers.
v. List of Customers: By using this functionality Bank admin can get their
entire customers list and their details.
vi. List of Accounts: By using this functionality Bank admin can get their
entire customers list based on selected account type like saving account,
current account etc.

2. Reports Module:

In this module administrator will get different types of reports regarding

customers like Number of customers of this portal. This module is controlled by
administrator only.

4
Software Engineering Methodology:-

Software requirements:

Operating System : Windows

Technology : Java (JDBC)

Database : Sqlite (MySQL)

Softwares : Java 1.8, Netbeans

Hardware requirements:

Hardware : Pentium based systems with a minimum of p4

RAM : 512 MB (minimum)

5
Software Requirement Specification:-

E-R DIAGRAM

Fig 1: E-R Diagram

6
Data Flow Diagram:-

a) 0 Level

Customer Banks

Green Banking

Fig 2: 0 Level DFD

7
b) 1 Level DFD

Fig 3: 1 Level DFD

8
Working:-

For New User:

1. The database of all other banks is shared with Green bank.

2. A customer provides his/her account information the green bank official.
3. Green bank assigns an account ID which is link with all other banks accounts of the
customer and verified it with OTP.

Fig 4: Working for new user

9
For Existing Users:

1. Customer asks for a transaction.

2. Customer provides its account information to bank official.
3. After verification, bank official starts statement of the customer.
4. Bank official performs transaction, on the basis of customer’s statement.
5. Bank system sends an OTP on customer’s mobile number (text/call) for final completion.
6. Customer is verified by OTP, before completion of transaction.
7. A notification of successful transaction will be sent as text, email or a recorded call.

Fig 5: Working for existing user

10
Coding:-

Authentication.java

import com.sun.glass.events.KeyEvent;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import javax.swing.JOptionPane;

import javax.swing.UIManager;

public class Authentication extends javax.swing.JFrame {

Connection conn;

ResultSet rs;

PreparedStatement pst;

int attempt=1;

public Authentication() {

super("Login");

initComponents();

conn=javaconnect.ConnectDb();

String sql="select * from Admin where AdminId=? and Pin=?";

if(attempt<4){

try{

pst=conn.prepareStatement(sql);

11
 pst.setString(1, jTextField1.getText());

pst.setString(2, jPasswordField1.getText());

rs=pst.executeQuery();

if(rs.next()){

setVisible(false);

Loading ob=new Loading();

ob.setUploading();

ob.setVisible(true);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "Incorrect Credential \n ATTEMPT MADE "+attempt);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

}else if(attempt!=4){

JOptionPane.showMessageDialog(null, "ATTEMPT"+attempt);

12
 }

else{

JOptionPane.showMessageDialog(null, "ATTEMPT EXCEEDED");

jTextField1.setEnabled(false);

jPasswordField1.setEditable(false);

if(attempt==5){

this.dispose();

attempt++;

private void jTextField1KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jPasswordField1KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

13
 evt.consume();

public static void main(String args[]) {

try {

for (javax.swing.UIManager.LookAndFeelInfo info :

javax.swing.UIManager.getInstalledLookAndFeels()) {

UIManager.setLookAndFeel("com.jtattoo.plaf.smart.SmartLookAndFeel");

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(Authentication.class.getName()).log(java.util.logging.Level.SEVERE
, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(Authentication.class.getName()).log(java.util.logging.Level.SEVERE
, null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(Authentication.class.getName()).log(java.util.logging.Level.SEVERE
, null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(Authentication.class.getName()).log(java.util.logging.Level.SEVERE
, null, ex);

//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

14
 new Authentication().setVisible(true);

});

private javax.swing.JButton jButton1;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;

private javax.swing.JPanel jPanel1;

private javax.swing.JPasswordField jPasswordField1;

private javax.swing.JTextField jTextField1;

Loading:-

import java.sql.*;

import javax.swing.*;

public class Loading extends javax.swing.JFrame implements Runnable {

Connection conn;

ResultSet rs;

PreparedStatement pst;

int s=0;

Thread th;

15
public Loading() {

super("Loading");

initComponents();

th=new Thread((Runnable)this);

public void setUploading(){

setVisible(false);

th.start();

public void run(){

try{

for(int i=0;i<=200;i++){

s=s+1;

int n=jProgressBar1.getMaximum();

int v=jProgressBar1.getValue();

if(v<n){

jProgressBar1.setValue(jProgressBar1.getValue()+1);

}else{

i=201;

setVisible(false);

GBAanking ob=new GBAanking();

ob.setVisible(true);

Thread.sleep(50);

16
 }

}catch(Exception e){

public static void main(String args[]) {

try {

for (javax.swing.UIManager.LookAndFeelInfo info :

javax.swing.UIManager.getInstalledLookAndFeels()) {

if ("Nimbus".equals(info.getName())) {

javax.swing.UIManager.setLookAndFeel(info.getClassName());

break;

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(Loading.class.getName()).log(java.util.logging.Level.SEVERE, null,
ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(Loading.class.getName()).log(java.util.logging.Level.SEVERE, null,
ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(Loading.class.getName()).log(java.util.logging.Level.SEVERE, null,
ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(Loading.class.getName()).log(java.util.logging.Level.SEVERE, null,
ex);

17
 //</editor-fold>

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new Loading().setVisible(true);

});

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel6;

private javax.swing.JPanel jPanel1;

private javax.swing.JProgressBar jProgressBar1;}

GBanking:-

import com.sun.glass.events.KeyEvent;

import java.awt.Graphics;

import java.awt.Graphics2D;

import java.awt.print.PageFormat;

import java.awt.print.Printable;

import java.awt.print.PrinterException;

import java.awt.print.PrinterJob;

import java.sql.Connection;

18
import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.Random;

import javax.swing.JOptionPane;

import javax.swing.JTextField;

import net.proteanit.sql.DbUtils;

public class GBAanking extends javax.swing.JFrame {

Connection conn;

ResultSet rs;

PreparedStatement pst;

public GBAanking() {

super("G Banking");

initComponents();

conn=javaconnect.ConnectDb();

RandomId();

AccountPNB();

AccountAxis();

AccountIDBI();

Table1();

public void RandomId(){

Random ra=new Random();

jTextField1.setText(""+ra.nextInt(10000+1));

public void Table1(){

19
 try{

String sql="select
CustId,FName,LName,FBank,FAcc,SBank,SAcc,TBank,TAcc,Mob,Address,Gender,Aadhar,DOB from
Customer";

pst=conn.prepareStatement(sql);

rs=pst.executeQuery();

jTable1.setModel(DbUtils.resultSetToTableModel(rs));

}catch(Exception e){

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void PNB(){

if(jCheckBox1.isSelected() == true){

String sql="insert into PNB(CustId,FName,LName,AccNo,Bal) values (?,?,?,?,?)";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField1.getText());

pst.setString(2,jTextField2.getText());

20
 pst.setString(3,jTextField3.getText());

pst.setString(4,jTextField4.getText());

pst.setString(5,jTextField50.getText());

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

public void Axis(){

if(jCheckBox2.isSelected() == true){

String sql="insert into Axis(CustId,FName,LName,AccNo,Bal) values (?,?,?,?,?)";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField1.getText());

pst.setString(2,jTextField2.getText());

pst.setString(3,jTextField3.getText());

pst.setString(4,jTextField5.getText());

pst.setString(5,jTextField51.getText());

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

21
 }

public void IDBI(){

if(jCheckBox3.isSelected() == true){

String sql="insert into IDBI(CustId,FName,LName,AccNo,Bal) values (?,?,?,?,?)";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField1.getText());

pst.setString(2,jTextField2.getText());

pst.setString(3,jTextField3.getText());

pst.setString(4,jTextField6.getText());

pst.setString(5,jTextField52.getText());

pst.execute();

private void jButton25ActionPerformed(java.awt.event.ActionEvent evt) {

String sql="select * from Customer where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField56.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField57.setText(add1);

String add2=rs.getString("LName");

22
 jTextField58.setText(add2);

String add3=rs.getString("FBank");

jTextField8.setText(add3);

String add4=rs.getString("FAcc");

jTextField53.setText(add4);

String add5=rs.getString("SBank");

jTextField9.setText(add5);

String add6=rs.getString("SAcc");

jTextField54.setText(add6);

String add7=rs.getString("TBank");

jTextField10.setText(add7);

String add8=rs.getString("TAcc");

jTextField55.setText(add8);

String add9=rs.getString("Mob");

jFormattedTextField3.setText(add9);

String add10=rs.getString("Address");

jTextField61.setText(add10);

String add11=rs.getString("Gender");

jComboBox2.setSelectedItem(add11);

String add12=rs.getString("Aadhar");

jFormattedTextField4.setText(add12);

String add13=rs.getString("DOB");

jTextField62.setText(add13);

rs.close();

pst.close();

}else{

23
 JOptionPane.showMessageDialog(null,"INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){ }}}

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {

jTextField57.setEditable(true);

jTextField58.setEditable(true);

jTextField61.setEditable(true);

jTextField62.setEditable(true);

jComboBox2.setEditable(true);

jFormattedTextField3.setEditable(true);

jFormattedTextField4.setEditable(true);

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String value1=jTextField57.getText();

String value2=jTextField58.getText();

String value3=jTextField61.getText();

24
 String value4=jTextField62.getText();

String value5=(String)jComboBox2.getSelectedItem();

String value6=jFormattedTextField3.getText();

String value7=jFormattedTextField4.getText();

String sql="update Account set

FName='"+value1+"',LName='"+value2+"',Address='"+value3+"',DOB='"+value4+"',Gender='"+value5+
"',Mob='"+value6+"',Aadhar='"+value7+"'";

pst=conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "Profile Updated");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {

String sql="select * from PNB where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField11.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField12.setText(add1);

String add2=rs.getString("LName");

jTextField13.setText(add2);

25
 String add3=rs.getString("Bal");

jTextField14.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {

try{

String s1=jTextField14.getText();

String s2=jTextField15.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField16.setText(sum1);

26
 }catch(Exception e){

JOptionPane.showMessageDialog(null,e);

} }

public void UpdatePNB(){

try{

String value1=jTextField11.getText();

String value2=jTextField16.getText();

String sql="update Balance set FBal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {

try{

String value1=jTextField11.getText();

String value2=jTextField16.getText();

String sql="update PNB set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

UpdatePNB();

JOptionPane.showMessageDialog(null,"SUCCESSFULLY DEPOSITED");

jTextField11.setText("");

jTextField12.setText("");

27
 jTextField13.setText("");

jTextField14.setText("");

jTextField15.setText("");

jTextField16.setText("");

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from Axis where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField17.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField18.setText(add1);

String add2=rs.getString("LName");

jTextField19.setText(add2);

String add3=rs.getString("Bal");

jTextField20.setText(add3);

28
 rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField20.getText();

String s2=jTextField21.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField22.setText(sum1);

}catch(Exception e){

29
 JOptionPane.showMessageDialog(null,e);

public void UpdateAxis(){

try{

String value1=jTextField17.getText();

String value2=jTextField22.getText();

String sql="update Balance set SBal='"+value2+"' where CustId='"+value1+'"';

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String value1=jTextField17.getText();

String value2=jTextField22.getText();

String sql="update Axis set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

UpdateAxis();

JOptionPane.showMessageDialog(null,"SUCCESSFULLY DEPOSITED");

30
 jTextField17.setText("");

jTextField18.setText("");

jTextField19.setText("");

jTextField20.setText("");

jTextField21.setText("");

jTextField22.setText("");

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from IDBI where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField23.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField24.setText(add1);

String add2=rs.getString("LName");

jTextField25.setText(add2);

31
 String add3=rs.getString("Bal");

jTextField26.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton13ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField26.getText();

String s2=jTextField27.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

32
 String sum1=String.valueOf(sum);

jTextField85.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void UpdateIDBI(){

try{

String value1=jTextField23.getText();

String value2=jTextField85.getText();

String sql="update Balance set TBal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String value1=jTextField23.getText();

String value2=jTextField85.getText();

String sql="update IDBI set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

33
 pst.execute();

UpdateIDBI();

JOptionPane.showMessageDialog(null,"SUCCESSFULLY DEPOSITED");

jTextField23.setText("");

jTextField24.setText("");

jTextField25.setText("");

jTextField26.setText("");

jTextField27.setText("");

jTextField85.setText("");

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jTextField31ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

private void jTextField34ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

public void WDAxis(){

try{

String s1=jTextField34.getText();

34
 String s2=jTextField37.getText();

String sql="update Balance set SBal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton20ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField34.getText();

String s2=jTextField86.getText();

String sql="update Axis set Bal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

WDAxis();

JOptionPane.showMessageDialog(null, "WITHDRAWN SUCCESSFULLY");

jTextField34.setText("");

jTextField35.setText("");

jTextField36.setText("");

jTextField37.setText("");

jTextField38.setText("");

jTextField86.setText("");

35
 }catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField31.getText();

String s2=jTextField32.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField33.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton19ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField37.getText();

String s2=jTextField38.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

36
 jTextField86.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton22ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField42.getText();

String s2=jTextField43.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField87.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from PNB where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField28.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

37
 jTextField29.setText(add1);

String add2=rs.getString("LName");

jTextField30.setText(add2);

String add3=rs.getString("Bal");

jTextField31.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton18ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

38
String sql="select * from Axis where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField34.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField35.setText(add1);

String add2=rs.getString("LName");

jTextField36.setText(add2);

String add3=rs.getString("Bal");

jTextField37.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

39
 }

private void jButton21ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from IDBI where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField39.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField40.setText(add1);

String add2=rs.getString("LName");

jTextField41.setText(add2);

String add3=rs.getString("Bal");

jTextField42.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

40
 }catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

public void WDPNB(){

try{

String s1=jTextField28.getText();

String s2=jTextField31.getText();

String sql="update Balance set FBal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {

41
 // TODO add your handling code here:

try{

String s1=jTextField28.getText();

String s2=jTextField33.getText();

String sql="update PNB set Bal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

WDPNB();

JOptionPane.showMessageDialog(null, "WITHDRAWN SUCCESSFULLY");

jTextField28.setText("");

jTextField29.setText("");

jTextField30.setText("");

jTextField31.setText("");

jTextField32.setText("");

jTextField33.setText("");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void WDIDBI(){

try{

42
 String s1=jTextField39.getText();

String s2=jTextField42.getText();

String sql="update Balance set TBal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton23ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField39.getText();

String s2=jTextField87.getText();

String sql="update IDBI set Bal='"+s2+"' where CustId='"+s1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

WDIDBI();

JOptionPane.showMessageDialog(null, "WITHDRAWN SUCCESSFULLY");

jTextField39.setText("");

jTextField40.setText("");

jTextField41.setText("");

43
 jTextField42.setText("");

jTextField43.setText("");

jTextField87.setText("");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton24ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from PNB where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField44.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField45.setText(add1);

String add2=rs.getString("LName");

jTextField46.setText(add2);

String add3=rs.getString("Bal");

jTextField47.setText(add3);

44
 rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton28ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from Axis where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField59.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

45
 jTextField60.setText(add1);

String add2=rs.getString("LName");

jTextField63.setText(add2);

String add3=rs.getString("Bal");

jTextField64.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jButton31ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

46
String sql="select * from IDBI where CustId=?";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField67.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField68.setText(add1);

String add2=rs.getString("LName");

jTextField69.setText(add2);

String add3=rs.getString("Bal");

jTextField70.setText(add3);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

47
 }

private void jButton35ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField47.getText();

String s2=jTextField48.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField49.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton36ActionPerformed(java.awt.event.ActionEvent evt) {

try{

String s1=jTextField64.getText();

String s2=jTextField65.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField66.setText(sum1);

}catch(Exception e){

48
 JOptionPane.showMessageDialog(null,e);

private void jButton37ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:\

try{

String s1=jTextField70.getText();

String s2=jTextField71.getText();

int sum=Integer.parseInt(s1)-Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField72.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jComboBox3PopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {

// TODO add your handling code here:

try{

String s1=(String)jComboBox3.getSelectedItem();

String sql="select * from PNB where AccNo=?";

pst=conn.prepareStatement(sql);

pst.setString(1, s1);

rs=pst.executeQuery();

if(rs.next()){

49
 String add=rs.getString("Bal");

jTextField88.setText(add);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jComboBox4PopupMenuWillBecomeVisible(javax.swing.event.PopupMenuEvent evt) {

// TODO add your handling code here:

try{

String s2=(String)jComboBox4.getSelectedItem();

String sql="select * from Axis where AccNo=?";

pst=conn.prepareStatement(sql);

pst.setString(1, s2);

rs=pst.executeQuery();

if(rs.next()){

String add=rs.getString("Bal");

jTextField90.setText(add);

}catch(Exception e){

50
 JOptionPane.showMessageDialog(null,e);

private void jComboBox5PopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {

// TODO add your handling code here:

try{

String s3=(String)jComboBox5.getSelectedItem();

String sql="select * from IDBI where AccNo=?";

pst=conn.prepareStatement(sql);

pst.setString(1, s3);

rs=pst.executeQuery();

if(rs.next()){

String add=rs.getString("Bal");

jTextField92.setText(add);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

51
public void AccountPNB(){

try{

String sql= "select * from PNB";

pst=conn.prepareStatement(sql);

rs=pst.executeQuery();

while(rs.next()){

String account=rs.getString("AccNo");

jComboBox3.addItem(account);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

public void AccountAxis(){

try{

String sql= "select * from Axis";

pst=conn.prepareStatement(sql);

rs=pst.executeQuery();

while(rs.next()){

String account=rs.getString("AccNo");

jComboBox4.addItem(account);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

52
 public void AccountIDBI(){

try{

String sql= "select * from IDBI";

pst=conn.prepareStatement(sql);

rs=pst.executeQuery();

while(rs.next()){

String account=rs.getString("AccNo");

jComboBox5.addItem(account);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

private void jButton29ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField65.getText();

String s2=jTextField90.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField91.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

53
private void jButton26ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField48.getText();

String s2=jTextField88.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField89.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

private void jButton32ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

String s1=jTextField71.getText();

String s2=jTextField92.getText();

int sum=Integer.parseInt(s1)+Integer.parseInt(s2);

String sum1=String.valueOf(sum);

jTextField93.setText(sum1);

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

54
 }

public void TPNB(){

try{

String value1=(String)jComboBox3.getSelectedItem();

String value2=jTextField89.getText();

String sql="update Balance set FBal='"+value2+"' where FAcc='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TPNB1(){

try{

String value1=jTextField44.getText();

String value2=jTextField89.getText();

String sql="update Balance set FBal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

public void TransferC(){

try{

55
 String value1=(String)jComboBox3.getSelectedItem();

String value2=jTextField89.getText();

String sql="update PNB set Bal='"+value2+"' where AccNo='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "TRANSFERRED SUCCESSFULLY");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TransferD(){

try{

String value1=jTextField44.getText();

String value2=jTextField89.getText();

String sql="update PNB set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

private void jButton27ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

TransferC();

TransferD();

TPNB();

TPNB1();

56
 }

public void TAxis(){

try{

String value1=(String)jComboBox4.getSelectedItem();

String value2=jTextField91.getText();

String sql="update Balance set SBal='"+value2+"' where SAcc='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TAxis1(){

try{

String value1=jTextField59.getText();

String value2=jTextField91.getText();

String sql="update Balance set SBal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

public void TransferA(){

try{

String value1=(String)jComboBox4.getSelectedItem();

57
 String value2=jTextField91.getText();

String sql="update Axis set Bal='"+value2+"' where AccNo='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "TRANSFERED SUCCESSFULLY");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TransferB(){

try{

String value1=jTextField59.getText();

String value2=jTextField91.getText();

String sql="update Axis set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

private void jButton30ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

TransferA();

TransferB();

TAxis();

TAxis1();

58
 }

public void TIDBI(){

try{

String value1=(String)jComboBox5.getSelectedItem();

String value2=jTextField93.getText();

String sql="update Balance set TBal='"+value2+"' where TAcc='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TIDBI1(){

try{

String value1=jTextField67.getText();

String value2=jTextField93.getText();

String sql="update Balance set TBal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

public void TransferM(){

59
 try{

String value1=(String)jComboBox5.getSelectedItem();

String value2=jTextField93.getText();

String sql="update IDBI set Bal='"+value2+"' where AccNo='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "TRANSFERED SUCCESSFULLY");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

public void TransferN(){

try{

String value1=jTextField67.getText();

String value2=jTextField93.getText();

String sql="update IDBI set Bal='"+value2+"' where CustId='"+value1+"'";

pst=conn.prepareStatement(sql);

pst.execute();

}catch(Exception e){

JOptionPane.showMessageDialog(null,e); }

private void jButton33ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

TransferM();

TransferN();

TIDBI();

60
 TIDBI1();

private void jTextField74ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

private void jTextField83ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

private void jButton34ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String sql="select * from Balance where CustId=? ";

try{

pst=conn.prepareStatement(sql);

pst.setString(1,jTextField73.getText());

rs=pst.executeQuery();

if(rs.next()){

String add1=rs.getString("FName");

jTextField74.setText(add1);

String add2=rs.getString("LName");

jTextField75.setText(add2);

String add4=rs.getString("FAcc");

jTextField79.setText(add4);

61
 String add5=rs.getString("FBal");

jTextField82.setText(add5);

String add6=rs.getString("SAcc");

jTextField80.setText(add6);

String add7=rs.getString("SBal");

jTextField83.setText(add7);

String add8=rs.getString("TAcc");

jTextField81.setText(add8);

String add9=rs.getString("TBal");

jTextField84.setText(add9);

rs.close();

pst.close();

}else{

JOptionPane.showMessageDialog(null, "INCORRECT ID");

}catch(Exception e){

JOptionPane.showMessageDialog(null,e);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

62
}

private void jButton38ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try{

dispose();

new Authentication().setVisible(true);

}finally{

try{

rs.close();

pst.close();

}catch(Exception e){

private void jCheckBox1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

private void jCheckBox2ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

63
}

private void jCheckBox3ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your han

private void jCheckBox1ItemStateChanged(java.awt.event.ItemEvent evt) {

// TODO add your handling code here:

if(jCheckBox1.isSelected() == true){

jTextField4.setEditable(true);

jTextField50.setEditable(true);

}else{

jTextField4.setEditable(false);

jTextField50.setEditable(false);

private void jCheckBox2ItemStateChanged(java.awt.event.ItemEvent evt) {

// TODO add your handling code here:

if(jCheckBox2.isSelected() == true){

jTextField5.setEditable(true);

jTextField51.setEditable(true);

}else{

jTextField5.setEditable(false);

jTextField51.setEditable(false);

64
}

private void jCheckBox3ItemStateChanged(java.awt.event.ItemEvent evt) {

// TODO add your handling code here:

if(jCheckBox3.isSelected() == true){

jTextField6.setEditable(true);

jTextField52.setEditable(true);

}else{

jTextField6.setEditable(false);

jTextField52.setEditable(false);

private void jTextField2KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isLetter(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY CHARACTER");

evt.consume();

private void jTextField3KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

65
 char c=evt.getKeyChar();

if(!(Character.isLetter(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY CHARACTER");

evt.consume();

private void jTextField57KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isLetter(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY CHARACTER");

evt.consume();

private void jTextField58KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isLetter(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY CHARACTER");

66
 evt.consume();

private void jTextField4KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField5KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

67
private void jTextField6KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField50KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField56KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

68
 if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField62KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField11KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

69
private void jTextField15KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField17KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField21KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

70
 JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField23KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField27KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField73KeyTyped(java.awt.event.KeyEvent evt) {

71
 // TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField43KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField39KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

72
 }

private void jTextField34KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField38KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField28KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

73
 if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField32KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField44KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

74
private void jTextField59KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField67KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField48KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

75
 JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField65KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

private void jTextField71KeyTyped(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:

char c=evt.getKeyChar();

if(!(Character.isDigit(c) || (c==KeyEvent.VK_BACKSPACE) || c==KeyEvent.VK_ENTER)){

getToolkit().beep();

JOptionPane.showMessageDialog(null, "ENTER ONLY DIGIT");

evt.consume();

try {

for (javax.swing.UIManager.LookAndFeelInfo info :

javax.swing.UIManager.getInstalledLookAndFeels()) {

76
 if ("Nimbus".equals(info.getName())) {

javax.swing.UIManager.setLookAndFeel(info.getClassName());

break;

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(GBAanking.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(GBAanking.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(GBAanking.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(GBAanking.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);

//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new GBAanking().setVisible(true);

});

77
}

private javax.swing.JButton jButton1;

private javax.swing.JButton jButton10;

private javax.swing.JButton jButton11;

private javax.swing.JButton jButton12;

private javax.swing.JButton jButton13;

private javax.swing.JButton jButton14;

private javax.swing.JButton jButton15;

private javax.swing.JButton jButton16;

private javax.swing.JButton jButton17;

private javax.swing.JButton jButton18;

private javax.swing.JButton jButton19;

private javax.swing.JButton jButton2;

private javax.swing.JButton jButton20;

private javax.swing.JButton jButton21;

private javax.swing.JButton jButton22;

private javax.swing.JButton jButton23;

private javax.swing.JButton jButton24;

private javax.swing.JButton jButton25;

private javax.swing.JButton jButton26;

private javax.swing.JButton jButton27;

private javax.swing.JButton jButton28;

private javax.swing.JButton jButton29;

private javax.swing.JButton jButton3;

private javax.swing.JButton jButton30;

78
private javax.swing.JButton jButton31;

private javax.swing.JButton jButton32;

private javax.swing.JButton jButton33;

private javax.swing.JButton jButton34;

private javax.swing.JButton jButton35;

private javax.swing.JButton jButton36;

private javax.swing.JButton jButton37;

private javax.swing.JButton jButton38;

private javax.swing.JButton jButton4;

private javax.swing.JButton jButton5;

private javax.swing.JButton jButton6;

private javax.swing.JButton jButton7;

private javax.swing.JButton jButton8;

private javax.swing.JButton jButton9;

private javax.swing.JCheckBox jCheckBox1;

private javax.swing.JCheckBox jCheckBox2;

private javax.swing.JCheckBox jCheckBox3;

private javax.swing.JComboBox<String> jComboBox1;

private javax.swing.JComboBox<String> jComboBox2;

private javax.swing.JComboBox<String> jComboBox3;

private javax.swing.JComboBox<String> jComboBox4;

private javax.swing.JComboBox<String> jComboBox5;

private com.toedter.calendar.JDateChooser jDateChooser1;

private javax.swing.JFormattedTextField jFormattedTextField1;

private javax.swing.JFormattedTextField jFormattedTextField2;

private javax.swing.JFormattedTextField jFormattedTextField3;

79
private javax.swing.JFormattedTextField jFormattedTextField4;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel10;

private javax.swing.JLabel jLabel11;

private javax.swing.JLabel jLabel12;

private javax.swing.JLabel jLabel13;

private javax.swing.JLabel jLabel14;

private javax.swing.JLabel jLabel15;

private javax.swing.JLabel jLabel16;

private javax.swing.JLabel jLabel17;

private javax.swing.JLabel jLabel18;

private javax.swing.JLabel jLabel19;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel20;

private javax.swing.JLabel jLabel21;

private javax.swing.JLabel jLabel22;

private javax.swing.JLabel jLabel23;

private javax.swing.JLabel jLabel24;

private javax.swing.JLabel jLabel25;

private javax.swing.JLabel jLabel26;

private javax.swing.JLabel jLabel27;

private javax.swing.JLabel jLabel28;

private javax.swing.JLabel jLabel29;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel30;

private javax.swing.JLabel jLabel31;

80
private javax.swing.JLabel jLabel32;

private javax.swing.JLabel jLabel33;

private javax.swing.JLabel jLabel34;

private javax.swing.JLabel jLabel35;

private javax.swing.JLabel jLabel36;

private javax.swing.JLabel jLabel37;

private javax.swing.JLabel jLabel38;

private javax.swing.JLabel jLabel39;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel40;

private javax.swing.JLabel jLabel41;

private javax.swing.JLabel jLabel42;

private javax.swing.JLabel jLabel43;

private javax.swing.JLabel jLabel44;

private javax.swing.JLabel jLabel45;

private javax.swing.JLabel jLabel46;

private javax.swing.JLabel jLabel47;

private javax.swing.JLabel jLabel48;

private javax.swing.JLabel jLabel49;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel50;

private javax.swing.JLabel jLabel51;

private javax.swing.JLabel jLabel52;

private javax.swing.JLabel jLabel53;

private javax.swing.JLabel jLabel54;

private javax.swing.JLabel jLabel55;

81
private javax.swing.JLabel jLabel56;

private javax.swing.JLabel jLabel57;

private javax.swing.JLabel jLabel58;

private javax.swing.JLabel jLabel59;

private javax.swing.JLabel jLabel6;

private javax.swing.JLabel jLabel60;

private javax.swing.JLabel jLabel61;

private javax.swing.JLabel jLabel62;

private javax.swing.JLabel jLabel63;

private javax.swing.JLabel jLabel64;

private javax.swing.JLabel jLabel65;

private javax.swing.JLabel jLabel66;

private javax.swing.JLabel jLabel67;

private javax.swing.JLabel jLabel68;

private javax.swing.JLabel jLabel69;

private javax.swing.JLabel jLabel7;

private javax.swing.JLabel jLabel70;

private javax.swing.JLabel jLabel71;

private javax.swing.JLabel jLabel72;

private javax.swing.JLabel jLabel73;

private javax.swing.JLabel jLabel74;

private javax.swing.JLabel jLabel75;

private javax.swing.JLabel jLabel76;

private javax.swing.JLabel jLabel77;

private javax.swing.JLabel jLabel78;

private javax.swing.JLabel jLabel79;

82
private javax.swing.JLabel jLabel8;

private javax.swing.JLabel jLabel80;

private javax.swing.JLabel jLabel81;

private javax.swing.JLabel jLabel82;

private javax.swing.JLabel jLabel83;

private javax.swing.JLabel jLabel84;

private javax.swing.JLabel jLabel85;

private javax.swing.JLabel jLabel86;

private javax.swing.JLabel jLabel87;

private javax.swing.JLabel jLabel9;

private javax.swing.JPanel jPanel1;

private javax.swing.JPanel jPanel10;

private javax.swing.JPanel jPanel11;

private javax.swing.JPanel jPanel12;

private javax.swing.JPanel jPanel13;

private javax.swing.JPanel jPanel14;

private javax.swing.JPanel jPanel15;

private javax.swing.JPanel jPanel16;

private javax.swing.JPanel jPanel17;

private javax.swing.JPanel jPanel18;

private javax.swing.JPanel jPanel19;

private javax.swing.JPanel jPanel2;

private javax.swing.JPanel jPanel3;

private javax.swing.JPanel jPanel4;

private javax.swing.JPanel jPanel5;

private javax.swing.JPanel jPanel6;

83
private javax.swing.JPanel jPanel7;

private javax.swing.JPanel jPanel8;

private javax.swing.JPanel jPanel9;

private javax.swing.JScrollPane jScrollPane1;

private javax.swing.JScrollPane jScrollPane2;

private javax.swing.JTabbedPane jTabbedPane1;

private javax.swing.JTable jTable1;

private javax.swing.JTextArea jTextArea1;

private javax.swing.JTextField jTextField1;

private javax.swing.JTextField jTextField10;

private javax.swing.JTextField jTextField11;

private javax.swing.JTextField jTextField12;

private javax.swing.JTextField jTextField13;

private javax.swing.JTextField jTextField14;

private javax.swing.JTextField jTextField15;

private javax.swing.JTextField jTextField16;

private javax.swing.JTextField jTextField17;

private javax.swing.JTextField jTextField18;

private javax.swing.JTextField jTextField19;

private javax.swing.JTextField jTextField2;

private javax.swing.JTextField jTextField20;

private javax.swing.JTextField jTextField21;

private javax.swing.JTextField jTextField22;

private javax.swing.JTextField jTextField23;

private javax.swing.JTextField jTextField24;

private javax.swing.JTextField jTextField25;

84
 private javax.swing.JTextField jTextField26;

private javax.swing.JTextField jTextField27;

private javax.swing.JTextField jTextField28;

private javax.swing.JTextField jTextField29;

private javax.swing.JTextField jTextField3;

private javax.swing.JTextField jTextField30;

private javax.swing.JTextField jTextField31;

private javax.swing.JTextField jTextField32;

private javax.swing.JTextField jTextField33;

private javax.swing.JTextField jTextField34;

private javax.swing.JTextField jTextField35;

private javax.swing.JTextField jTextField36;

private javax.swing.JTextField jTextField37;

private javax.swing.JTextField jTextField38;

private javax.swing.JTextField jTextField39;

private javax.swing.JTextField jTextField4;

private javax.swing.JTextField jTextField40;

private javax.swing.JTextField jTextField41;

private javax.swing.JTextField jTextField42;

private javax.swing.JTextField jTextField43;

private javax.swing.JTextField jTextField44;

private javax.swing.JTextField jTextField45;

private javax.swing.JTextField jTextField46;

private javax.swing.JTextField jTextField47;

private javax.swing.JTextField jTextField48;

private javax.swing.JTextField jTextField49;

85
private javax.swing.JTextField jTextField5;

private javax.swing.JTextField jTextField50;

private javax.swing.JTextField jTextField51;

private javax.swing.JTextField jTextField52;

private javax.swing.JTextField jTextField53;

private javax.swing.JTextField jTextField54;

private javax.swing.JTextField jTextField55;

private javax.swing.JTextField jTextField56;

private javax.swing.JTextField jTextField57;

private javax.swing.JTextField jTextField58;

private javax.swing.JTextField jTextField59;

private javax.swing.JTextField jTextField6;

private javax.swing.JTextField jTextField60;

private javax.swing.JTextField jTextField61;

private javax.swing.JTextField jTextField62;

private javax.swing.JTextField jTextField63;

private javax.swing.JTextField jTextField64;

private javax.swing.JTextField jTextField65;

private javax.swing.JTextField jTextField66;

private javax.swing.JTextField jTextField67;

private javax.swing.JTextField jTextField68;

private javax.swing.JTextField jTextField69;

private javax.swing.JTextField jTextField7;

private javax.swing.JTextField jTextField70;

private javax.swing.JTextField jTextField71;

private javax.swing.JTextField jTextField72;

86
 private javax.swing.JTextField jTextField73;

private javax.swing.JTextField jTextField74;

private javax.swing.JTextField jTextField75;

private javax.swing.JTextField jTextField76;

private javax.swing.JTextField jTextField77;

private javax.swing.JTextField jTextField78;

private javax.swing.JTextField jTextField79;

private javax.swing.JTextField jTextField8;

private javax.swing.JTextField jTextField80;

private javax.swing.JTextField jTextField81;

private javax.swing.JTextField jTextField82;

private javax.swing.JTextField jTextField83;

private javax.swing.JTextField jTextField84;

private javax.swing.JTextField jTextField85;

private javax.swing.JTextField jTextField86;

private javax.swing.JTextField jTextField87;

private javax.swing.JTextField jTextField88;

private javax.swing.JTextField jTextField89;

private javax.swing.JTextField jTextField9;

private javax.swing.JTextField jTextField90;

private javax.swing.JTextField jTextField91;

private javax.swing.JTextField jTextField92;

private javax.swing.JTextField jTextField93;

87
Javaconnect:-

import java.sql.*;

import javax.swing.JOptionPane;

public class javaconnect {

Connection conn=null;

public static Connection ConnectDb(){

try{

Class.forName("org.sqlite.JDBC");

Connection conn=DriverManager.getConnection("jdbc:sqlite:C:\\Users\\hp
pc\\Documents\\NetBeansProjects\\Bank_Management_System\\GBank.sqlite");

return conn;

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

return null;

88