testpanel.java~61~

来自「银行信用评估系统」· JAVA~61~ 代码 · 共 877 行 · 第 1/3 页

                                            queryx[0] = "select Dqhyhk from UserBank ";
                                            strbx1[0] = "Dqhyhk";
                                         }
                                          else if (strbl.equals("定期")) {
                                            queryx[0] = "select Dq from UserBank";
                                            strbx1[0] = "Dq";
                                          }
                                          else if (strbl.equals("银行卡")) {
                                           queryx[0] = "select Yhk from UserBank";
                                           strbx1[0] = "Yhk";
                                         }
                                         else if (strbl.equals("仅开立活期存折帐户")) {
                                           queryx[0] = "select Jkhqzh from UserBank";
                                           strbx1[0] = "Jkhqzh";
                                           }
                                          else if (strbl.equals("无帐户")) {
                                             queryx[0] = "select Wzh from UserBank";
                                             strbx1[0] = "Wzh";
                                             }
                                          pstmt5 = con.prepareStatement(queryx[0]);
                                          rs5 = pstmt5.executeQuery();
                                          if (rs5.next()) {
                                            strx0 = rs5.getString(strbx1[0]); //调整分
                                            sum1 += Integer.parseInt(strx0);
                                            jTextField1.setText(sum1+" ");
                                          }
                                        }
                                        else  sum1 += 0;

                                        //年龄
                                          queryb= "select * from Users where userid=?";
                                          pstmt5 = con.prepareStatement(queryb);
                                         strx0="1000";
                                         pstmt5.setString(1,strx0);
                                          rs5=pstmt5.executeQuery();
                                          if(rs5.next()){
                                          strbl=rs5.getString("UserAge");
                                          }
                                       if(strbl!=null) {
                                        int a=Integer.parseInt(strbl);
                                         if (18<=a && 22>=a) {
                                            queryx[0] = "select Callan from userlist ";
                                            strbx1[0] = "Callan";
                                         }
                                          else if (23<=a && 34>=a) {
                                            queryx[0] = "select Youth from userlist";
                                            strbx1[0] = "Youth";
                                          }
                                          else if (35<=a && 40>=a) {
                                            queryx[0] = "select Midlife from userlist";
                                            strbx1[0] = "Midlife";
                                          }
                                          else if (41<=a && 60>=a) {
                                            queryx[0] = "select Adiaphorous from userlist";
                                            strbx1[0] = "Adiaphorous";
                                          }
                                          else if (61<=a ) {
                                          queryx[0] = "select Agedness from userlist";
                                          strbx1[0] = "Agedness";
                                        }
                                          pstmt5 = con.prepareStatement(queryx[0]);
                                          rs5 = pstmt5.executeQuery();
                                          if (rs5.next()) {
                                            strx0 = rs5.getString(strbx1[0]); //调整分
                                            sum1 += Integer.parseInt(strx0);
                                              jTextField1.setText(sum1+" ");
                                          }
                                        }
                                        else  sum1 += 0;
                                        //业务往来
                                             queryb= "select * from view5 where userid=?";
                                             pstmt5 = con.prepareStatement(queryb);
                                            strx0="1000";
                                            pstmt5.setString(1,strx0);
                                             rs5=pstmt5.executeQuery();
                                             if(rs5.next()){
                                             strbl=rs5.getString("UseNum");
                                             }
                                          if(strbl!=null) {
                                           int a=Integer.parseInt(strbl);
                                            if (2>a) {
                                               queryx[0] = "select Ywjs from UserBank ";
                                               strbx1[0] = "Ywjs";
                                            }
                                            else if (6>=a && 2<=a) {
                                              queryx[0] = "select Ywyb from UserBank ";
                                              strbx1[0] = "Ywyb";
                                           }
                                             else if (6<a ) {
                                             queryx[0] = "select Ywmq from UserBank";
                                             strbx1[0] = "Ywmq";
                                           }
                                             pstmt5 = con.prepareStatement(queryx[0]);
                                             rs5 = pstmt5.executeQuery();
                                             if (rs5.next()) {
                                               strx0 = rs5.getString(strbx1[0]); //调整分
                                               sum1 += Integer.parseInt(strx0);
                                                 jTextField1.setText(sum1+" ");
                                             }
                                           }
                                           else  sum1 += 0;
                                          //是否本行员工
                                           queryb= "select * from users where userid=?";
                                           pstmt5 = con.prepareStatement(queryb);
                                          strx0="1000";
                                          pstmt5.setString(1,strx0);
                                           rs5=pstmt5.executeQuery();
                                           if(rs5.next()){
                                           strbl=rs5.getString("UserCard");
                                           strbl=strbl.trim();
                                           }
                                        if(strbl!=null) {
                                        queryx[0] = "select * from YHworker where YHworkerCard=?";
                                        strbx1[0] = "YHworkerCard";
                                         pstmt5 = con.prepareStatement(queryx[0]);
                                         pstmt5.setString(1,strbl);
                                           rs5 = pstmt5.executeQuery();
                                           if (rs5.next()) {
                                              sum1 +=2;
                                              }
                                             else {
                                               sum1 +=0;
                                             }
                                             jTextField1.setText(sum1+" ");
                                        }
                                         else  sum1 += 0;
                                         //借款情况
                                             queryb= "select * from view6 where userid=?";
                                             pstmt5 = con.prepareStatement(queryb);
                                            strx0="1000";
                                            pstmt5.setString(1,strx0);
                                             rs5=pstmt5.executeQuery();
                                             if(rs5.next()){
                                             strbl=rs5.getString("UseState");
                                             }
                                          if(strbl!=null) {
                                             if (strbl.equals("有借款已还清")) {
                                               queryx[0] = "select Yjkyh from UserBank ";
                                               strbx1[0] = "Yjkyh";
                                            }
                                             else if (strbl.equals("有逾期记录")) {
                                               queryx[0] = "select Yyqjl from UserBank";
                                               strbx1[0] = "Yyqjl";
                                             }
                                             else if (strbl.equals("从未借款")) {
                                              queryx[0] = "select Cwjk from UserBank";
                                              strbx1[0] = "Cwjk";
                                            }
                                            else if (strbl.equals("有借款还清记录，但尚有未到期借款")) {
                                              queryx[0] = "select Y_ywdqjk from UserBank";
                                              strbx1[0] = "Y_ywdqjk";
                                              }
                                             else if (strbl.equals("无借款还清记录，但尚有未到期借款")) {
                                                queryx[0] = "select W_ywdqjk from UserBank";
                                                strbx1[0] = "W_ywdqjk";
                                                }
                                             pstmt5 = con.prepareStatement(queryx[0]);
                                             rs5 = pstmt5.executeQuery();
                                             if (rs5.next()) {
                                               strx0 = rs5.getString(strbx1[0]); //调整分
                                               sum1 += Integer.parseInt(strx0);
                                               jTextField1.setText(sum1+" ");
                                             }
                                           }
                                           else  sum1 += 0;
                                           //存款余额
                                             queryb= "select * from view7 where userid=?";
                                             pstmt5 = con.prepareStatement(queryb);
                                            strx0="1000";
                                            pstmt5.setString(1,strx0);
                                             rs5=pstmt5.executeQuery();
                                             if(rs5.next()){
                                             strbl=rs5.getString("AccountDeposit");
                                             }
                                          if(strbl!=null) {
                                            int a=Integer.parseInt(strbl);
                                           if (10000>a) {
                                              queryx[0] = "select Ck1w from UserBank ";
                                              strbx1[0] = "Ck1w";
                                           }
                                           else if (30000>=a && 10000<=a) {
                                             queryx[0] = "select Ck1_3w from UserBank ";
                                             strbx1[0] = "Ck1_3w";
                                          }
                                            else if (30000<a ) {
                                            queryx[0] = "select Ck3w from UserBank";
                                            strbx1[0] = "Ck3w";
                                          }

                                             pstmt5 = con.prepareStatement(queryx[0]);
                                             rs5 = pstmt5.executeQuery();
                                             if (rs5.next()) {
                                               strx0 = rs5.getString(strbx1[0]); //调整分
                                               sum1 += Integer.parseInt(strx0);
                                               jTextField1.setText(sum1+" ");
                                             }
                                           }
                                           else  sum1 += 0;
      }

    catch(Exception ef)
          { System.out.print("系统错误，请重新运行。"+ef.getClass().getName());
            ef.printStackTrace();
           }
   return sum1;
  }




  void jButton1_actionPerformed(ActionEvent e) {
    String m=jTextField1.getText();
    String c=m;
    try
    {
       int i=Integer.parseInt(m);
       i=i+this.Badrecordadjust();
       jLabel7.setText(i+" ");
    if(120>=i && 100<=i)
    {jLabel4.setText("A");
      jLabel6.setText("50000元");
    }
    else if(100>i && 90<=i)
   {jLabel4.setText("B");
      jLabel6.setText("40000元");
   }
   else if(90>i && 80<=i)
  {jLabel4.setText("C");
     jLabel6.setText("30000元");
  }
  else if(80>i && 70<=i)
    {jLabel4.setText("D");
       jLabel6.setText("20000元");
    }
    else if(70>i && 60<=i)
      {jLabel4.setText("E");
         jLabel6.setText("10000元");
      }
      else if(60>i && 50<=i)
        {jLabel4.setText("F");
           jLabel6.setText("5000元");
        }
        else if(50>i && 35<=i)
      {jLabel4.setText("G");
         jLabel6.setText("2000元");
      }
      else
      {jLabel4.setText("H");
           jLabel6.setText("0元");
      }

       jTextField1.setText(c);
      c="1000";
      String qur="insert into Creditcard(UserId,CreditcardGrade,CreditcardCode) values('"+c+"\'"+","+"\'"+jLabel4.getText()+"\'"+",'000')";
      Statement ps;
      ps=con.createStatement();
      ps.execute(qur);
    }
    catch(Exception eff)
     { jTextField1.setText("请输入数字，谢谢合作！");
     }
  }

  void jButton2_actionPerformed(ActionEvent e) {
    eventFrame.jSplitPane1.remove(eventFrame.jSplitPane1.getRightComponent());
    eventFrame.jSplitPane1.add(new helloPanel(),eventFrame.jSplitPane1.RIGHT);
  }
}

class testPanel_jButton1_actionAdapter implements java.awt.event.ActionListener {
  testPanel adaptee;

  testPanel_jButton1_actionAdapter(testPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class testPanel_jButton2_actionAdapter implements java.awt.event.ActionListener {
  testPanel adaptee;

  testPanel_jButton2_actionAdapter(testPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}