bankmanager.java

本工程模拟网上社区,其中包括银行,软件销售公司,软件投资公司,茶餐馆,和多个服务器.

                 System.out.println("SQLException:"+e.getMessage()+"\n"+"At bankManager class while Fresh the Loan Table.");
       }                                        
    }
     
    private void applyLoanItemMousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_applyLoanItemMousePressed
       applyLoanOperate();
    }//GEN-LAST:event_applyLoanItemMousePressed
    private void applyLoanOperate(){
        jScrollPane.setViewportView(applyLoanPanel);
       loanPanel.setVisible(false);
       customerPanel.setVisible(false);
       firstPanel.setVisible(false);
       applyLoanPanel.setVisible(true);
       
       applyLoanFresh();
    }
    private void applyLoanBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_applyLoanBtnMouseClicked
        applyLoanOperate();
    }//GEN-LAST:event_applyLoanBtnMouseClicked

    private void customerMousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_customerMousePressed
        jScrollPane.setViewportView(customerPanel);
        loanPanel.setVisible(false);
        customerPanel.setVisible(true);
        firstPanel.setVisible(false);
        applyLoanPanel.setVisible(false);
        try{       
            customerList.removeAll();
            FileReader fin=new FileReader("D:\\customer.txt");
            char b[]=new char[10240];
            fin.read(b);
            String str=new String(b);
            StringTokenizer st=new StringTokenizer(str,"\n");
            String temp[]=new String[st.countTokens()];
            for(int i=0;i<temp.length;i++){
                temp[i]=st.nextToken();
            }
            customerList.setListData(temp);
        }
        catch(IOException e){ 
            System.out.println(e.getMessage()); 
        }  
    }//GEN-LAST:event_customerMousePressed

    private void loanItemMousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_loanItemMousePressed
            jScrollPane.setViewportView(loanPanel);
            loanPanel.setVisible(true);
            customerPanel.setVisible(false);
            firstPanel.setVisible(false);
            applyLoanPanel.setVisible(false);
            bank.connection();
            try{
                Statement st=bank.serverCon.createStatement();
                ResultSet rs=st.executeQuery("select * from Loan");
                int row=0;
                while(rs.next()){
                    loanTable.setValueAt(rs.getString("编号"),row,0);
                    loanTable.setValueAt(rs.getString("贷款人账号"),row,1);
                    loanTable.setValueAt(rs.getString("贷款人姓名"),row,2);
                    loanTable.setValueAt(rs.getDouble("贷款金额"),row,3);
                    loanTable.setValueAt(rs.getString("贷款日期"),row,4);
                    loanTable.setValueAt(rs.getString("还款日期"),row,5);
                    loanTable.setValueAt(rs.getInt("贷款时间"),row,6);
                    loanTable.setValueAt(rs.getDouble("利率"),row,7);
                    loanTable.setValueAt(rs.getString("是否还款"),row,8);
                    row++;
               }
               st.close();
               bank.serverCon.close();
            }
            catch(SQLException e){ 
                System.out.println(e.getMessage());
            }
    }//GEN-LAST:event_loanItemMousePressed

    private void loanBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_loanBtnMouseClicked
                 jScrollPane.setViewportView(loanPanel);
                 loanPanel.setVisible(true);
                 customerPanel.setVisible(false);
                 firstPanel.setVisible(false);
                 applyLoanPanel.setVisible(false);
                 bank.connection();
                     try{
                         Statement s=bank.serverCon.createStatement();
                         ResultSet rs=s.executeQuery("select * from Loan");
                         int row=0;
                         while(rs.next()){
                             loanTable.setValueAt(rs.getString("编号"),row,0);
                             loanTable.setValueAt(rs.getString("贷款人账号"),row,1);
                             loanTable.setValueAt(rs.getString("贷款人姓名"),row,2);
                             loanTable.setValueAt(rs.getDouble("贷款金额"),row,3);
                             loanTable.setValueAt(rs.getString("贷款日期"),row,4);
                             loanTable.setValueAt(rs.getString("还款日期"),row,5);
                             loanTable.setValueAt(rs.getInt("贷款时间"),row,6);
                             loanTable.setValueAt(rs.getDouble("利率"),row,7);
                             loanTable.setValueAt(rs.getString("是否还款"),row,8);
                             row++;
                         }
                         s.close();
                         bank.serverCon.close();
                     }catch(SQLException e){ System.out.println(e.getMessage());}
    }//GEN-LAST:event_loanBtnMouseClicked

    private void staffBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_staffBtnMouseClicked
               jScrollPane.setViewportView(firstPanel);
               firstPanel.setVisible(true);
               loanPanel.setVisible(false);
               customerPanel.setVisible(false);
               applyLoanPanel.setVisible(false);
               new totalJFrame("中国银行职工信息管理系统").setVisible(true);       
    }//GEN-LAST:event_staffBtnMouseClicked

    private void customerBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_customerBtnMouseClicked
            jScrollPane.setViewportView(customerPanel);
            loanPanel.setVisible(false);
            customerPanel.setVisible(true);
            firstPanel.setVisible(false);
            applyLoanPanel.setVisible(false);
        try{       
                 customerList.removeAll();
                 FileReader fin=new FileReader("D:\\customer.txt");
                 char b[]=new char[10240];
                 fin.read(b);
                 String str=new String(b);
                 StringTokenizer st=new StringTokenizer(str,"\n");
                 String temp[]=new String[st.countTokens()];
                 for(int i=0;i<temp.length;i++)
                 {
                     temp[i]=st.nextToken();
                 }
                 customerList.setListData(temp);
        }catch(IOException e){ System.out.println(e.getMessage()); }
    }//GEN-LAST:event_customerBtnMouseClicked

    private void exitBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_exitBtnMouseClicked
        
        if(bank.visitors<=0){
            JOptionPane.showMessageDialog(this,"服务器即将关闭！");
            bank.done=true;
            try{
            Socket socket=new Socket(bank.localIP,3009);
            bank=null;
            out.println("bankexit/");
            out.flush();
            }
            catch(Exception e)
            {
                System.out.println(e.toString());
            }
            hall.setVisible(true);
            hall=null;
            out=null;
            this.dispose();
        }
        else{
            JOptionPane.showMessageDialog(this,"无法关闭服务器，仍有客户在利用服务！");
        }
       
    }//GEN-LAST:event_exitBtnMouseClicked

    private void staffItemActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_staffItemActionPerformed
                  jScrollPane.setViewportView(firstPanel);
                  firstPanel.setVisible(true);
                  loanPanel.setVisible(false);
                  customerPanel.setVisible(false);
                  applyLoanPanel.setVisible(false);
                  new totalJFrame("中国银行职工信息管理系统").setVisible(true);
    }//GEN-LAST:event_staffItemActionPerformed

    private void exitItemMousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_exitItemMousePressed
                     this.dispose();
    }//GEN-LAST:event_exitItemMousePressed

    private void customerActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_customerActionPerformed
          jScrollPane.setViewportView(customerPanel);
            firstPanel.setVisible(false);
            loanPanel.setVisible(false);
            customerPanel.setVisible(true);
            applyLoanPanel.setVisible(false);
        try{       
                 customerList.removeAll();
                 FileReader fin=new FileReader("D:\\customer.txt");
                 char b[]=new char[10240];
                 fin.read(b);
                 String str=new String(b);
                 StringTokenizer st=new StringTokenizer(str,"\n");
                 String temp[]=new String[st.countTokens()];
                 for(int i=0;i<temp.length;i++)
                 {
                     temp[i]=st.nextToken();
                 }
                 customerList.setListData(temp);
        }catch(IOException e){ System.out.println(e.getMessage()); }   
    }//GEN-LAST:event_customerActionPerformed
    
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton adoptBtn;
    private javax.swing.JButton applyLoanBtn;
    private javax.swing.JMenuItem applyLoanItem;
    private javax.swing.JPanel applyLoanPanel;
    private javax.swing.JTable applyLoanTable;
    private javax.swing.JMenuItem customer;
    private javax.swing.JButton customerBtn;
    private javax.swing.JList customerList;
    private javax.swing.JPanel customerPanel;
    private javax.swing.JButton exitBtn;
    private javax.swing.JMenuItem exitItem;
    private javax.swing.JTextArea firstArea;
    private javax.swing.JPanel firstPanel;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JScrollPane jScrollPane;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JButton loanBtn;
    private javax.swing.JMenuItem loanItem;
    private javax.swing.JPanel loanPanel;
    private javax.swing.JTable loanTable;
    private javax.swing.JButton refuseBtn;
    private javax.swing.JButton staffBtn;
    private javax.swing.JMenuItem staffItem;
    // 变量声明结束//GEN-END:variables
    
}