manageframe.java

一个简单的银行管理系统

/*
 * ManageFrame.java
 *
 * Created on 2007年1月19日, 上午11:00
 */

package javaapplication1;
import java.awt.Toolkit;
import java.sql.*;
import java.util.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;


/**
 *
 * @author  zzz
 */
public class ManageFrame extends javax.swing.JFrame{
    
    /** Creates new form ManageFrame */
    public ManageFrame() {
          
        connectDB();
        init();
        initComponents();  
        //-------设置窗口位置居中---------------------------------------------------------------        
        int locationX=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()-getSize().getWidth())/2; 
        int locationY=(int)(Toolkit.getDefaultToolkit().getScreenSize().getHeight()-getSize().getHeight())/2;
        setLocation(locationX,locationY);
        //--------------------------------------------------------------------------------------

    }
    
    /** 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.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        manageTabPane = new javax.swing.JTabbedPane();
        jsStaff = new javax.swing.JScrollPane();
        tableStaff = new javax.swing.JTable();
        jsCurrentDeposit = new javax.swing.JScrollPane();
        tableCurrentDeposit = new javax.swing.JTable();
        jsFixedDeposit = new javax.swing.JScrollPane();
        tableFixedDeposit = new javax.swing.JTable();
        jsCurrentFetchMoney = new javax.swing.JScrollPane();
        tableFetchMoney = new javax.swing.JTable();
        jsFixedFetch = new javax.swing.JScrollPane();
        tableFixedFetch = new javax.swing.JTable();
        jsTransfer = new javax.swing.JScrollPane();
        tableTransfer = new javax.swing.JTable();
        jsNetTransfer = new javax.swing.JScrollPane();
        tableNetTransfer = new javax.swing.JTable();
        jsTransact = new javax.swing.JScrollPane();
        tableTransact = new javax.swing.JTable();
        jMenuBar1 = new javax.swing.JMenuBar();
        Staff = new javax.swing.JMenu();
        InsertStaff = new javax.swing.JMenuItem();
        AlterStaff = new javax.swing.JMenuItem();
        SearchStaff = new javax.swing.JMenuItem();
        Manage = new javax.swing.JMenu();
        IDLoacate = new javax.swing.JMenuItem();
        PasswordRecovery = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("\u7cfb\u7edf\u7ba1\u7406");
        manageTabPane.addChangeListener(new javax.swing.event.ChangeListener() {
            public void stateChanged(javax.swing.event.ChangeEvent evt) {
                manageTabPaneStateChanged(evt);
            }
        });

        tableStaff.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "员工号", "姓名", "性别", "雇用日期", "薪水", "有操作权限"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsStaff.setViewportView(tableStaff);

        manageTabPane.addTab("\u5458\u5de5\u4fe1\u606f", jsStaff);

        tableCurrentDeposit.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "存款编号", "存款日期", "操作员工号", "操作帐号", "存款人", "存入金额"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsCurrentDeposit.setViewportView(tableCurrentDeposit);

        manageTabPane.addTab("\u6d3b\u671f\u5b58\u6b3e\u4fe1\u606f", jsCurrentDeposit);

        tableFixedDeposit.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null}
            },
            new String [] {
                "存款号", "存款时间", "操作员工号", "操作帐号", "存款人", "存入金额", "存入年限", "是否转存"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false, true, true
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsFixedDeposit.setViewportView(tableFixedDeposit);

        manageTabPane.addTab("\u5b9a\u671f\u5b58\u6b3e\u4fe1\u606f", jsFixedDeposit);

        tableFetchMoney.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "取款编号", "取款日期", "操作员工号", "操作帐号", "取款金额", "取款人"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsCurrentFetchMoney.setViewportView(tableFetchMoney);

        manageTabPane.addTab("\u6d3b\u671f\u53d6\u6b3e\u4fe1\u606f", jsCurrentFetchMoney);

        tableFixedFetch.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null}
            },
            new String [] {
                "取款号", "取款时间", "存款号", "操作员工号", "操作帐号", "取款金额", "取款人"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsFixedFetch.setViewportView(tableFixedFetch);

        manageTabPane.addTab("\u5b9a\u671f\u53d6\u6b3e\u4fe1\u606f", jsFixedFetch);

        tableTransfer.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "转帐编号", "转帐时间", "操作员工号", "转帐方", "接收方", "转帐金额"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsTransfer.setViewportView(tableTransfer);

        manageTabPane.addTab("\u8f6c\u5e10\u4fe1\u606f", jsTransfer);

        tableNetTransfer.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "转帐编号", "转帐时间", "转帐方", "接收方", "转帐金额"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsNetTransfer.setViewportView(tableNetTransfer);

        manageTabPane.addTab("\u7f51\u4e0a\u94f6\u884c\u8f6c\u5e10", jsNetTransfer);

        tableTransact.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "事务编号", "事务时间", "操作员工号", "帐户号", "事务类型"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jsTransact.setViewportView(tableTransact);

        manageTabPane.addTab("\u4e8b\u52a1\u4fe1\u606f", jsTransact);

        Staff.setText("\u5f55\u5165");
        Staff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                StaffActionPerformed(evt);
            }
        });

        InsertStaff.setText("\u5f55\u5165\u5458\u5de5");
        InsertStaff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                InsertStaffActionPerformed(evt);
            }
        });

        Staff.add(InsertStaff);

        AlterStaff.setText("\u4fee\u590d\u5458\u5de5\u8d44\u6599");