serviceframe.java

一个简单的银行管理系统

        {
            netMemberTable.setModel(netMemberModel);
            String sql = "Select * from netMember";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                loginID = result.getString("loginID");
                accountID = result.getString("accountID");
                addr = result.getString("addr");
                phone = result.getString("phone");
                mobilePhone = result.getString("mobilePhone");
                email = result.getString("email");
                    
                String[] info ={loginID,accountID,addr,phone,mobilePhone,email};
                netMemberModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     
     //显示活期取款信息
     private void showDepositor()
    {
        String name = "";
        String sex = "";
        String IDcard = "";
        String addr = "";
        String phone = "";
        
        int rowCount = depositorModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            depositorModel.removeRow(i);
        }    
        try
        {
            depositorTable.setModel(depositorModel);
            String sql = "Select * from depositor";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                IDcard = result.getString("IDcard");
                name = result.getString("name");
                sex = result.getString("sex");
                addr = result.getString("addr");
                phone = result.getString("phone");
                
                    
                String[] info ={name,sex,IDcard,addr,phone};
                depositorModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
     //显示活期取款信息
     private void showRate()
    {
        String inTime = "";
        String rate = "";
        
        int rowCount = rateModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            rateModel.removeRow(i);
        }    
        try
        {
            rateTable.setModel(rateModel);
            String sql = "Select * from limitRate";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                inTime = result.getString("InTime");
                rate = result.getString("rate");
                
                String[] info ={inTime,rate};
                rateModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
    //消卡
    private void deleteBankCardActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteBankCardActionPerformed
// TODO 将在此处添加您的处理代码：
        new DeleteBankCard(staffID).setVisible(true);
    }//GEN-LAST:event_deleteBankCardActionPerformed

    //消户
    private void deleteAccountActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteAccountActionPerformed
// TODO 将在此处添加您的处理代码：
        new DeleteAccount(staffID).setVisible(true);
    }//GEN-LAST:event_deleteAccountActionPerformed

    //取消借记卡挂失
    private void cancelBankCardLostActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancelBankCardLostActionPerformed
// TODO 将在此处添加您的处理代码：
        new CancelBankCardLost(staffID).setVisible(true);
    }//GEN-LAST:event_cancelBankCardLostActionPerformed

    //借记卡挂失
    private void bankCardLostActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bankCardLostActionPerformed
// TODO 将在此处添加您的处理代码：
        new BankCardLost(staffID).setVisible(true);
    }//GEN-LAST:event_bankCardLostActionPerformed

    //取消帐号挂失
    private void cancelAccountLostActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancelAccountLostActionPerformed
// TODO 将在此处添加您的处理代码：
        new CancelAccountLost(staffID).setVisible(true);
    }//GEN-LAST:event_cancelAccountLostActionPerformed

    //帐号挂失
    private void accountLostActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_accountLostActionPerformed
// TODO 将在此处添加您的处理代码：
        new AccountLost(staffID).setVisible(true);
    }//GEN-LAST:event_accountLostActionPerformed

    //活期取款
    private void currentFetchActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_currentFetchActionPerformed
// TODO 将在此处添加您的处理代码：
        new CurrentFetch(staffID).setVisible(true);
    }//GEN-LAST:event_currentFetchActionPerformed


    //转帐
    private void transferActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_transferActionPerformed
        new Transfer(staffID).setVisible(true);
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_transferActionPerformed

    //定期存款
    private void fixedDepositActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_fixedDepositActionPerformed
// TODO 将在此处添加您的处理代码：
        new FixedDeposit(staffID).setVisible(true);
    }//GEN-LAST:event_fixedDepositActionPerformed

    private void jMenu4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu4ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jMenu4ActionPerformed

    //活期存款
    private void currentDepositActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_currentDepositActionPerformed
// TODO 将在此处添加您的处理代码：
        new CurrentDeposit(staffID).setVisible(true);
    }//GEN-LAST:event_currentDepositActionPerformed

    //修改借记卡密码
    private void setBankCardPasswordActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_setBankCardPasswordActionPerformed
// TODO 将在此处添加您的处理代码：
        new ChangeBankCardPassword(staffID).setVisible(true);
    }//GEN-LAST:event_setBankCardPasswordActionPerformed

    //修改自己操作帐户密码
    private void setOperatePasswordActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_setOperatePasswordActionPerformed
// TODO 将在此处添加您的处理代码：
        new ChangeOperatePassword(staffID).setVisible(true);
    }//GEN-LAST:event_setOperatePasswordActionPerformed

    //设置储户帐号密码
    private void setAccountPasswordActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_setAccountPasswordActionPerformed
// TODO 将在此处添加您的处理代码：
        new ChangeAccountPassword(staffID).setVisible(true);
    }//GEN-LAST:event_setAccountPasswordActionPerformed

    private void jMenu2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu2ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jMenu2ActionPerformed

    //新建银行借记卡
    private void newBankCardActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_newBankCardActionPerformed
// TODO 将在此处添加您的处理代码：
        new InsertBankCard(staffID).setVisible(true);
    }//GEN-LAST:event_newBankCardActionPerformed

    //新建帐号响应事件
    private void newAccountActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_newAccountActionPerformed
// TODO 将在此处添加您的处理代码：
        new InsertAccount(staffID).setVisible(true);
    }//GEN-LAST:event_newAccountActionPerformed

    private void jMenu5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu5ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jMenu5ActionPerformed

    private void jMenu8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu8ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jMenu8ActionPerformed

    private void jMenu3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu3ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jMenu3ActionPerformed
    
    /**
     * @param args the command line arguments
     */
        //再次初始化界面
    public void init()
    {
        accountModel = new DefaultTableModel(accountTitle, 0);
        accountTable = new JTable(accountModel);
        
        bankCardModel = new DefaultTableModel(bankCardTitle, 0);
        bankCardTable = new JTable(bankCardModel);
        
        netMemberModel = new DefaultTableModel(netMemberTitle, 0);
        netMemberTable = new JTable(netMemberModel);
        
        depositorModel = new DefaultTableModel(depositorTitle, 0);
        depositorTable= new JTable(depositorModel);  
        
        rateModel = new DefaultTableModel(rateTitle, 0);
        rateTable= new JTable(rateModel);  
    }
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
        //        new ServiceFrame().setVisible(true);
            }
        });
    }
    
    
    //连接数据库操作－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
    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();
        }
    }
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JMenuItem accountLost;
    private javax.swing.JTable accountTable;
    private javax.swing.JMenuItem bankCardLost;
    private javax.swing.JTable bankCardTable;
    private javax.swing.JMenuItem cancelAccountLost;
    private javax.swing.JMenuItem cancelBankCardLost;
    private javax.swing.JMenuItem currentDeposit;
    private javax.swing.JMenuItem currentFetch;
    private javax.swing.JMenuItem deleteAccount;
    private javax.swing.JMenuItem deleteBankCard;
    private javax.swing.JTable depositorTable;
    private javax.swing.JMenuItem fixedDeposit;
    private javax.swing.JMenuItem fixedFetch;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenu jMenu3;
    private javax.swing.JMenu jMenu4;
    private javax.swing.JMenu jMenu5;
    private javax.swing.JMenu jMenu6;
    private javax.swing.JMenu jMenu7;
    private javax.swing.JMenu jMenu8;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JTabbedPane jTabbedPane4;
    private javax.swing.JTable netMemberTable;
    private javax.swing.JMenuItem newAccount;
    private javax.swing.JMenuItem newBankCard;
    private javax.swing.JTable rateTable;
    private javax.swing.JMenuItem setAccountPassword;
    private javax.swing.JMenuItem setBankCardPassword;
    private javax.swing.JMenuItem setOperatePassword;
    private javax.swing.JMenu setPassword;
    private javax.swing.JMenuItem setRate;
    private javax.swing.JMenuItem transfer;
    // 变量声明结束//GEN-END:variables
    private Connection conn;
    private DefaultTableModel accountModel,bankCardModel,netMemberModel,depositorModel,rateModel;
    private  Object[] accountTitle ={ "帐号", "帐号状态", "帐号类型", "帐号余额", "利息","开户日期"};
    private  Object[] bankCardTitle ={ "卡号", "卡状态", "帐号", "发卡日期"};
    private  Object[] netMemberTitle ={ "用户名", "银行帐号", "住址", "固定电话", "移动电话", "邮箱"};
    private  Object[] depositorTitle ={"姓名", "性别", "证件号", "地址", "电话"};
    private  Object[] rateTitle ={"存款年限", "利率"};
}