manageframe.java

一个简单的银行管理系统

        AlterStaff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                AlterStaffActionPerformed(evt);
            }
        });

        Staff.add(AlterStaff);

        SearchStaff.setText("\u67e5\u8be2\u5458\u5de5");
        SearchStaff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SearchStaffActionPerformed(evt);
            }
        });

        Staff.add(SearchStaff);

        jMenuBar1.add(Staff);

        Manage.setText("\u7ba1\u7406");
        IDLoacate.setText("\u5e10\u53f7\u5206\u914d");
        IDLoacate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                IDLoacateActionPerformed(evt);
            }
        });

        Manage.add(IDLoacate);

        PasswordRecovery.setText("\u5bc6\u7801\u6062\u590d");
        PasswordRecovery.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                PasswordRecoveryActionPerformed(evt);
            }
        });

        Manage.add(PasswordRecovery);

        jMenuBar1.add(Manage);

        setJMenuBar(jMenuBar1);

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(manageTabPane, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 760, Short.MAX_VALUE)
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(manageTabPane, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 325, Short.MAX_VALUE)
                .addContainerGap())
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    //员工操作帐号恢复
    private void PasswordRecoveryActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_PasswordRecoveryActionPerformed
// TODO 将在此处添加您的处理代码：
        new PasswordMange().setVisible(true);
    }//GEN-LAST:event_PasswordRecoveryActionPerformed

    //查询员工资料
    private void SearchStaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SearchStaffActionPerformed
// TODO 将在此处添加您的处理代码：
        new SearchStaffInfo(tableStaff,staffModel).setVisible(true);
    }//GEN-LAST:event_SearchStaffActionPerformed

    //插入员工信息
    private void InsertStaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_InsertStaffActionPerformed
// TODO 将在此处添加您的处理代码：
        new InsertStaff().setVisible(true);
    }//GEN-LAST:event_InsertStaffActionPerformed

    //修改员工资料
    private void AlterStaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AlterStaffActionPerformed
// TODO 将在此处添加您的处理代码：
        new AlterStaff().setVisible(true);
    }//GEN-LAST:event_AlterStaffActionPerformed
    
    //为员工分配帐号和操作权限
    private void IDLoacateActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_IDLoacateActionPerformed
// TODO 将在此处添加您的处理代码：
        new StaffManage().setVisible(true);
    }//GEN-LAST:event_IDLoacateActionPerformed

    //页签板的响应事件
    private void manageTabPaneStateChanged(javax.swing.event.ChangeEvent evt) {//GEN-FIRST:event_manageTabPaneStateChanged
        // TODO 将在此处添加您的处理代码：
        if(manageTabPane.getSelectedIndex()==0)
        {
            showStaff();    
        }
        if(manageTabPane.getSelectedIndex()==1)
        {
            showCurrentDeposit();    
        }
        if(manageTabPane.getSelectedIndex()==2)
        {
            showFixedDeposit();    
        }
        if(manageTabPane.getSelectedIndex()==3)
        {
            showCurrentFetchMoney();    
        }
        if(manageTabPane.getSelectedIndex()==4)
        {
            showFixedFetchMoney();    
        }
        if(manageTabPane.getSelectedIndex()==5)
        {
            showTransfer();    
        }
        if(manageTabPane.getSelectedIndex()==6)
        {
            showNetTransfer();    
        }
        if(manageTabPane.getSelectedIndex()==7)
        {
            showTransact();    
        }
    }//GEN-LAST:event_manageTabPaneStateChanged

    
    //显示员工信息
    private void showStaff()
    {
        String staffID = "";
        String name = "";
        String sex = "";
        String date = "";
        String salary = "";
        String operate = "";
        
        int rowCount = staffModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            staffModel.removeRow(i);
        }
        try
        {
            tableStaff.setModel(staffModel);
            String sql = "Select * from Staff";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                staffID = result.getString("staffID");
                name = result.getString("name");
                sex = result.getString("sex");
                salary = result.getString("salary");
                date = result.getString("dateJoined");
                operate = result.getString("operate");
                
                    
                String[] info ={staffID,name,sex,date,salary,operate};
                staffModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
    
    //显示活期存款信息
    private void showCurrentDeposit()
    {
        String depositID = "";
        String inTime = "";
        String staffID = "";
        String accountID = "";
        String name = "";
        String sum = "";
        
        int rowCount = currentDepositModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            currentDepositModel.removeRow(i);
        }
        try
        {
            tableCurrentDeposit.setModel(currentDepositModel);
            String sql = "Select * from currentDeposit";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                depositID = result.getString("depositID");
                inTime = result.getString("depositTime");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                name = result.getString("depositer");
                sum = result.getString("currentSum");
                    
                String[] info ={depositID,inTime,staffID,accountID,name,sum};
                currentDepositModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
    
    
    //显示定期存款信息
     private void showFixedDeposit()
    {
        String depositID = "";
        String inTime = "";
        String staffID = "";
        String accountID = "";
        String name = "";
        String sum = "";
        String limitTime = "";
        String auto = "";
        
        int rowCount = fixedDepositModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            fixedDepositModel.removeRow(i);
        }
        try
        {
            tableFixedDeposit.setModel(fixedDepositModel);
            String sql = "Select * from fixedDeposit";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                depositID = result.getString("depositID");
                inTime = result.getString("depositTime");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                name = result.getString("depositer");
                sum = result.getString("fixedSum");
                auto = result.getString("auto");
                limitTime = result.getString("limit");
                
                String[] info ={depositID,inTime,staffID,accountID,name,sum,limitTime,auto};
                fixedDepositModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     
     //显示活期取款信息
     private void showCurrentFetchMoney()
    {
        String fetchID = "";
        String fetchTime = "";
        String staffID = "";
        String accountID = "";
        String sum = "";
        String name = "";
        
        int rowCount = currentFetchModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            currentFetchModel.removeRow(i);
        }    
        try
        {
            tableFetchMoney.setModel(currentFetchModel);
            String sql = "Select * from currentFetch";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {