manageframe.java

一个简单的银行管理系统

                fetchID = result.getString("fetchID");
                fetchTime = result.getString("fetchTime");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                name = result.getString("fetcher");
                sum = result.getString("fetchSum");            
                    
                String[] info ={fetchID,fetchTime,staffID,accountID,sum,name};
                currentFetchModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     
     //显示定期取款信息
     private void showFixedFetchMoney()
    {
        String fetchID = "";
        String fetchTime = "";
        String depositID = "";
        String staffID = "";
        String accountID = "";
        String sum = "";
        String name = "";
        
        int rowCount = fixedFetchModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            fixedFetchModel.removeRow(i);
        }     
        try
        {
            tableFixedFetch.setModel(fixedFetchModel);
            String sql = "Select * from fixedFetch";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                fetchID = result.getString("fetchID");
                fetchTime = result.getString("fetchTime");
                depositID  = result.getString("depositID");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                name = result.getString("fetcher");
                sum = result.getString("fetchSum");              
                
                String[] info ={fetchID,fetchTime,depositID,staffID,accountID,sum,name};
                fixedFetchModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     //显示转帐信息
     private void showTransfer()
    {
        String transferID = "";
        String transferTime = "";
        String staffID = "";
        String accountID = "";
        String aimID = "";
        String sum = "";
        
        int rowCount = transferModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            transferModel.removeRow(i);
        }     
        try
        {
            tableTransfer.setModel(transferModel);
            String sql = "Select * from transfer";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                transferID = result.getString("transferID");
                transferTime = result.getString("transferTime");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                aimID = result.getString("aimID");
                sum = result.getString("transferSum");
                    
                String[] info ={transferID,transferTime,staffID,accountID,aimID,sum};
                transferModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     
     
    //显示网上银行转帐信息
     private void showNetTransfer()
    {
        String transferID = "";
        String transferTime = "";
        String accountID = "";
        String aimID = "";
        String sum = "";
        
        int rowCount = netTransferModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            netTransferModel.removeRow(i);
        }     
        try
        {
            tableNetTransfer.setModel(netTransferModel);
            String sql = "Select * from netTransfer";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                transferID = result.getString("transferID");
                transferTime = result.getString("transferTime");
                accountID = result.getString("accountID");
                aimID = result.getString("aimID");
                sum = result.getString("netTransferSum");
                    
                String[] info ={transferID,transferTime,accountID,aimID,sum};
                netTransferModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    } 
     //显示事务信息
     private void showTransact()
    {
        String transactID = "";
        String transactTime = "";
        String staffID = "";
        String accountID = "";
        String type = "";
        
        int rowCount = transactModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            transactModel.removeRow(i);
        }
        try
        {
            tableTransact.setModel(transactModel);
            String sql = "Select * from transact";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                transactID = result.getString("transactID");
                transactTime = result.getString("transactTime");
                staffID = result.getString("staffID");
                accountID = result.getString("accountID");
                type = result.getString("transactType");
                    
                String[] info ={transactID,transactTime,staffID,accountID,type};
                transactModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     private void StaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_StaffActionPerformed
// TODO 将在此处添加您的处理代码：
        new InsertStaff().setVisible(true);
     }//GEN-LAST:event_StaffActionPerformed
    
    //连接数据库操作－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
    public void connectDB()
    {
        String dbUrl = "jdbc:odbc:afei";
        String user = "scott";
        String password = "tiger";
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection(dbUrl,user,password);
        }
        catch(Exception connectException)
        {
            connectException.printStackTrace();
        }
    }
    
    //再次初始化界面
    public void init()
    {
        staffModel = new DefaultTableModel(staffTitle, 0);
        tableStaff = new JTable(staffModel);
        
        currentDepositModel = new DefaultTableModel(currentDepositTitle, 0);
        tableCurrentDeposit = new JTable(currentDepositModel);
        
        fixedDepositModel = new DefaultTableModel(fixedDepositTitle, 0);
        tableFixedDeposit = new JTable(fixedDepositModel);
        
        currentFetchModel = new DefaultTableModel(currentFetchTitle, 0);
        tableFetchMoney = new JTable(currentFetchModel);
        
        fixedFetchModel = new DefaultTableModel(fixedFetchTitle, 0);
        tableFixedFetch = new JTable(fixedFetchModel);
        
        transferModel = new DefaultTableModel(transferTitle, 0);
        tableTransfer = new JTable(transferModel);
        
        netTransferModel = new DefaultTableModel(netTransferTitle, 0);
        tableNetTransfer = new JTable(netTransferModel);
        
        transactModel = new DefaultTableModel(transactTitle, 0);
        tableTransact = new JTable(transactModel);
    }
    
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new ManageFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JMenuItem AlterStaff;
    private javax.swing.JMenuItem IDLoacate;
    private javax.swing.JMenuItem InsertStaff;
    private javax.swing.JMenu Manage;
    private javax.swing.JMenuItem PasswordRecovery;
    private javax.swing.JMenuItem SearchStaff;
    private javax.swing.JMenu Staff;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JScrollPane jsCurrentDeposit;
    private javax.swing.JScrollPane jsCurrentFetchMoney;
    private javax.swing.JScrollPane jsFixedDeposit;
    private javax.swing.JScrollPane jsFixedFetch;
    private javax.swing.JScrollPane jsNetTransfer;
    private javax.swing.JScrollPane jsStaff;
    private javax.swing.JScrollPane jsTransact;
    private javax.swing.JScrollPane jsTransfer;
    private javax.swing.JTabbedPane manageTabPane;
    private javax.swing.JTable tableCurrentDeposit;
    private javax.swing.JTable tableFetchMoney;
    private javax.swing.JTable tableFixedDeposit;
    private javax.swing.JTable tableFixedFetch;
    private javax.swing.JTable tableNetTransfer;
    private javax.swing.JTable tableStaff;
    private javax.swing.JTable tableTransact;
    private javax.swing.JTable tableTransfer;
    // 变量声明结束//GEN-END:variables
    private Connection conn;
    private DefaultTableModel staffModel,currentDepositModel,fixedDepositModel,currentFetchModel,fixedFetchModel,transferModel,netTransferModel,transactModel;
    private  Object[] staffTitle ={ "员工号", "姓名", "性别", "雇用日期", "薪水","有操作权限"};
    private  Object[] currentDepositTitle ={ "存款编号", "存款日期", "操作员工号", "操作帐号", "存款人","存入金额"};
    private  Object[] fixedDepositTitle ={ "存款号", "存款时间", "操作员工号", "操作帐号", "存款人", "存入金额", "存入年限", "是否转存"};
    private  Object[] currentFetchTitle ={"取款编号", "取款日期", "操作员工号", "操作帐号", "取款金额", "取款人"};
    private  Object[] fixedFetchTitle ={"取款编号", "取款日期", "存款号","操作员工号", "操作帐号", "取款金额", "取款人"};
    private  Object[] transferTitle ={ "转帐编号", "转帐时间", "操作员工号", "转帐方", "接收方", "转帐金额"};
    private  Object[] netTransferTitle ={ "转帐编号", "转帐时间", "转帐方", "接收方", "转帐金额"};
    private  Object[] transactTitle ={  "事务编号", "事务时间", "操作员工号", "帐户号", "事务类型"};
}