serviceframe.java

一个简单的银行管理系统

        });

        jMenu2.add(setBankCardPassword);

        setRate.setText("\u4fee\u6539\u5229\u7387");
        setRate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                setRateActionPerformed(evt);
            }
        });

        jMenu2.add(setRate);

        jMenuBar1.add(jMenu2);

        jMenu3.setText("\u5b58\u6b3e");
        jMenu3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenu3ActionPerformed(evt);
            }
        });

        currentDeposit.setText("\u6d3b\u671f\u5b58\u6b3e");
        currentDeposit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                currentDepositActionPerformed(evt);
            }
        });

        jMenu3.add(currentDeposit);

        fixedDeposit.setText("\u5b9a\u671f\u5b58\u6b3e");
        fixedDeposit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                fixedDepositActionPerformed(evt);
            }
        });

        jMenu3.add(fixedDeposit);

        jMenuBar1.add(jMenu3);

        jMenu4.setText("\u53d6\u6b3e");
        jMenu4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenu4ActionPerformed(evt);
            }
        });

        currentFetch.setText("\u6d3b\u671f\u53d6\u6b3e");
        currentFetch.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                currentFetchActionPerformed(evt);
            }
        });

        jMenu4.add(currentFetch);

        fixedFetch.setText("\u5b9a\u671f\u53d6\u6b3e");
        fixedFetch.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                fixedFetchActionPerformed(evt);
            }
        });

        jMenu4.add(fixedFetch);

        jMenuBar1.add(jMenu4);

        jMenu5.setText("\u8f6c\u5e10");
        jMenu5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenu5ActionPerformed(evt);
            }
        });

        transfer.setText("\u8f6c\u5e10");
        transfer.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                transferActionPerformed(evt);
            }
        });

        jMenu5.add(transfer);

        jMenuBar1.add(jMenu5);

        jMenu6.setText("\u6302\u5931");
        accountLost.setText("\u5e10\u53f7\u6302\u5931");
        accountLost.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                accountLostActionPerformed(evt);
            }
        });

        jMenu6.add(accountLost);

        bankCardLost.setText("\u501f\u8bb0\u5361\u6302\u5931");
        bankCardLost.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bankCardLostActionPerformed(evt);
            }
        });

        jMenu6.add(bankCardLost);

        jMenuBar1.add(jMenu6);

        jMenu7.setText("\u53d6\u6d88");
        jMenu8.setText("\u53d6\u6d88\u6302\u5931");
        jMenu8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenu8ActionPerformed(evt);
            }
        });

        cancelAccountLost.setText("\u53d6\u6d88\u5e10\u53f7\u6302\u5931");
        cancelAccountLost.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cancelAccountLostActionPerformed(evt);
            }
        });

        jMenu8.add(cancelAccountLost);

        cancelBankCardLost.setText("\u53d6\u6d88\u501f\u8bb0\u5361\u6302\u5931");
        cancelBankCardLost.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cancelBankCardLostActionPerformed(evt);
            }
        });

        jMenu8.add(cancelBankCardLost);

        jMenu7.add(jMenu8);

        deleteAccount.setText("\u6d88\u6237");
        deleteAccount.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                deleteAccountActionPerformed(evt);
            }
        });

        jMenu7.add(deleteAccount);

        deleteBankCard.setText("\u6d88\u5361");
        deleteBankCard.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                deleteBankCardActionPerformed(evt);
            }
        });

        jMenu7.add(deleteBankCard);

        jMenuBar1.add(jMenu7);

        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(jTabbedPane4, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 696, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jTabbedPane4, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 285, Short.MAX_VALUE)
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

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

    //修改利率
    private void setRateActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_setRateActionPerformed
// TODO 将在此处添加您的处理代码：
        new SetRate().setVisible(true);
    }//GEN-LAST:event_setRateActionPerformed

    private void jTabbedPane4StateChanged(javax.swing.event.ChangeEvent evt) {//GEN-FIRST:event_jTabbedPane4StateChanged
// TODO 将在此处添加您的处理代码：
        if(jTabbedPane4.getSelectedIndex()==0)
        {
            showAccount();    
        }
        if(jTabbedPane4.getSelectedIndex()==1)
        {
            showBankCard();    
        }
        if(jTabbedPane4.getSelectedIndex()==2)
        {
            showNetMember();    
        }
        if(jTabbedPane4.getSelectedIndex()==3)
        {
            showDepositor();    
        }
        if(jTabbedPane4.getSelectedIndex()==4)
        {
            showRate();    
        }
    }//GEN-LAST:event_jTabbedPane4StateChanged

     //显示帐号信息
    private void showAccount()
    {
        String accountID = "";
        String state = "";
        String accountType = "";
        String sum = "";
        String rateMoney = "";
        String date = "";
        
        int rowCount = accountModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            accountModel.removeRow(i);
        }
        try
        {
            accountTable.setModel(accountModel);
            String sql = "Select * from deAccount";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                accountID = result.getString("accountID");
                state = result.getString("state");    
                sum = result.getString("accountSum");
                rateMoney = result.getString("rateMoney");
                date = result.getString("openDate");
                accountType = result.getString("accountType");
  
                String[] info ={accountID,state,accountType,sum,rateMoney,date};
                accountModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
    
    //显示活期存款信息
    private void showBankCard()
    {
        String cardID = "";
        String state = "";
        String accountID = "";
        String sendDate = "";
        
        int rowCount = bankCardModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            bankCardModel.removeRow(i);
        }
        try
        {
            bankCardTable.setModel(bankCardModel);
            String sql = "Select * from bankCard";
            Statement stat = conn.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                cardID = result.getString("cardID");
                state = result.getString("state");
                accountID = result.getString("accountID");
                sendDate = result.getString("sendDate");
                
                String[] info ={cardID,state,accountID,sendDate};
                bankCardModel.addRow(info);                     
            }
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
    }
    
    
    //显示定期存款信息
     private void showNetMember()
    {
        String loginID = "";
        String accountID = "";
        String addr = "";
        String phone = "";
        String mobilePhone = "";
        String email = "";
        
        int rowCount = netMemberModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            netMemberModel.removeRow(i);
        }
        try