Java Simple Banking System CRUD Operations.zip

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package javadesktopapp; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author Cyber */ public class ApplicationMainMenu extends javax.swing.JFrame { static final String DRIVER = "com.mysql.jdbc.Driver"; //Driver //static final String DATABASE_URL1 = "jdbc:oracle:thin:@localhost:1521:orcl", "gebre", "gebre12"; static final String DATABASE_URL = "jdbc:mysql://localhost/bank"; //JDBC Connection conn = null; // Manages connion Statement statement = null; // Query statement PreparedStatement ps; //Prepared statement ResultSet rs; //Result set /** * Creates new form BankInfoSyst */ public ApplicationMainMenu() { // super(Title) super("Banking Information System"); initComponents(); setLocationRelativeTo(null); txtCustomerName1.setEditable(false); txtCurrBal1.setEditable(false); txtCustomerName2.setEditable(false); txtCurrBal2.setEditable(false); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jPanel1 = new javax.swing.JPanel(); jTabbedPane1 = new javax.swing.JTabbedPane(); jPanel3 = new javax.swing.JPanel(); jLabel9 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel(); jLabel14 = new javax.swing.JLabel(); txtCustomerName = new javax.swing.JTextField(); cboSex = new javax.swing.JComboBox(); btnOpenAcct = new javax.swing.JButton(); btnModifyAcct = new javax.swing.JButton(); btnDeleteAcct = new javax.swing.JButton(); btnClear = new javax.swing.JButton(); btnSearchAcct = new javax.swing.JButton(); jLabel15 = new javax.swing.JLabel(); txtSearchAcctNo = new javax.swing.JTextField(); txtAcctNo = new javax.swing.JTextField(); txtInitialBalance = new javax.swing.JTextField(); cboBranch = new javax.swing.JComboBox(); jPanel5 = new javax.swing.JPanel(); jLabel18 = new javax.swing.JLabel(); jLabel19 = new javax.swing.JLabel(); jLabel20 = new javax.swing.JLabel(); jLabel22 = new javax.swing.JLabel(); txtWithAmt1 = new javax.swing.JTextField(); btnDeposit = new javax.swing.JButton(); btnClear1 = new javax.swing.JButton(); btnSearch1 = new javax.swing.JButton(); jLabel26 = new javax.swing.JLabel(); txtSearchAcctNo1 = new javax.swing.JTextField(); txtCurrBal1 = new javax.swing.JTextField(); txtCustomerName1 = new javax.swing.JTextField(); jPanel6 = new javax.swing.JPanel(); jLabel27 = new javax.swing.JLabel(); btnRegister3 = new javax.swing.JButton(); btnClear3 = new javax.swing.JButton(); btnSearch4 = new javax.swing.JButton(); txtSearchAcctNo2 = new javax.swing.JTextField(); txtCustomerName2 = new javax.swing.JTextField(); txtCurrBal2 = new javax.swing.JTextField(); jLabel21 = new javax.swing.JLabel(); txtWithAmt2 = new javax.swing.JTextField(); jLabel34 = new javax.swing.JLabel(); jLabel35 = new javax.swing.JLabel(); jLabel36 = new javax.swing.JLabel(); jPanel4 = new javax.swing.JPanel(); jLabel17 = new javax.swing.JLabel(); txtSearchAcctNo3 = new javax.swing.JTextField(); btnSearch2 = new javax.swing.JButton(); jLabel23 = new javax.swing.JLabel(); btnViewAll = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); tblTransactions = new javax.swing.JTable(); jLabel24 = new javax.swing.JLabel(); lblTotal = new javax.swing.JLabel(); jLabel16 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jPanel1.setBackground(new java.awt.Color(102, 153, 255)); jTabbedPane1.setBackground(new java.awt.Color(204, 204, 204)); jTabbedPane1.setForeground(new java.awt.Color(0, 102, 102)); jTabbedPane1.setFont(new java.awt.Font("Eras Demi ITC", 1, 26)); // NOI18N jLabel9.setFont(new java.awt.Font("Eras Bold ITC", 0, 36)); // NOI18N jLabel9.setForeground(new java.awt.Color(0, 153, 153)); jLabel9.setText("Open Bank Account"); jLabel10.setFont(new java.awt.Font("Eras Demi ITC", 0, 22)); // NOI18N jLabel10.setForeground(new java.awt.Color(0, 153, 153)); jLabel10.setText("Acct No:"); jLabel11.setFont(new java.awt.Font("Eras Demi ITC", 0, 22)); // NOI18N jLabel11.setForeground(new java.awt.Color(0, 153, 153)); jLabel11.setText("Customer Name:"); jLabel12.setFont(new java.awt.Font("Eras Demi ITC", 0, 22)); // NOI18N jLabel12.setForeground(new java.awt.Color(0, 153, 153)); jLabel12.setText("Sex:"); jLabel13.setFont(new java.awt.Font("Eras Demi ITC", 0, 22)); // NOI18N jLabel13.setForeground(new java.awt.Color(0, 153, 153)); jLabel13.setText("Branch:"); jLabel14.setFont(new java.awt.Font("Eras Demi ITC", 0, 22)); // NOI18N jLabel14.setForeground(new java.awt.Color(0, 153, 153)); jLabel14.setText("Initial Balance:"); txtCustomerName.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N txtCustomerName.setForeground(new java.awt.Color(0, 153, 153)); cboSex.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N cboSex.setForeground(new java.awt.Color(0, 153, 153)); cboSex.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select Sex", "Male", "Female" })); btnOpenAcct.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N btnOpenAcct.setForeground(new java.awt.Color(0, 153, 153)); btnOpenAcct.setText("Open"); btnOpenAcct.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnOpenAcctActionPerformed(evt); } }); btnModifyAcct.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N btnModifyAcct.setForeground(new java.awt.Color(0, 153, 153)); btnModifyAcct.setText("Modify"); btnModifyAcct.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnModifyAcctActionPerformed(evt); } }); btnDeleteAcct.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N btnDeleteAcct.setForeground(new java.awt.Color(0, 153, 153)); btnDeleteAcct.setText("Delete"); btnDeleteAcct.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnDeleteAcctActionPerformed(evt); } }); btnClear.setFont(new java.awt.Font("Eras Demi ITC", 0, 24)); // NOI18N btnClear.setForeground(new java.awt.Color(0, 153, 153)); btnClear.setText("Clear"); btnClear.addActionListener(new java.awt.event.ActionList