freehalfadjust.java~1~

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

          strbx1[0] = "Dxoverdraft";
        }
        else if (strbx[0].trim().equals("呆帐透支")) {
          queryx[0] = "select Dzoverdraft from Unlrecord";
          strbx1[0] = "Dzoverdraft";
        }

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

      //在我行贷款有 不良行为
     if(strbx[1].trim().equals("有")) {
       sum1 -= 100;
    }else  sum1 -= 0;

      //涉嫌犯罪或正受法律处罚和调查
    if(strbx[2]!=null){
      if(strbx[2].trim().equals("涉嫌犯罪")) {
         queryx[1] = "select Criminal from Unlrecord ";
         strbx1[1]="Criminal";
      }
       else if(strbx[2].trim().equals("法律处罚")) {
         queryx[1] = "select Punish from Unlrecord";
         strbx1[1]="Punish";
       }
       else if(strbx[2].trim().equals("司法调查")) {
         queryx[1] = "select JusticeInq from Unlrecord";
         strbx1[1]="JusticeInq";
       }
       pstmt5 = con.prepareStatement(queryx[1]);
       rs5=pstmt5.executeQuery();
       if(rs5.next()){
         strx0 = rs5.getString(strbx1[1]); //调整分
         jTextField5.setText(strx0);
         sum1+=Integer.parseInt(strx0);
       }
     } else {sum1+=0;}

       //其它未偿还的债务
    if(strbx[3]!=null) {
        if (strbx[3].trim().equals("其他未偿债务5000-10000"))
        {
          queryx[2] = "select Qt5_1 from Unlrecord ";
          strbx1[2] = "Qt5_1";
        }
        else if (strbx[3].trim().equals("其他未偿债务10000-30000")) {
          queryx[2] = "select Qt1_3 from Unlrecord";
          strbx1[2] = "Qt1_3";
        }
        else if (strbx[3].trim().equals("其他未偿债务30000以上")) {
          queryx[2] = "select Qt3 from Unlrecord";
          strbx1[2] = "Qt3";
        }

        pstmt5 = con.prepareStatement(queryx[2]);
        rs5 = pstmt5.executeQuery();
        if (rs5.next()) {
          strx0 = rs5.getString(strbx1[2]); //调整分
          sum1 += Integer.parseInt(strx0);
        }
      }
         }
      else System.out.print("此用户无不良记录");
      }
    }

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

  void jButton1_actionPerformed(ActionEvent e) {
    String xz=null;
    String qur=null;
    String sel=null;
    int tzed=0;
    String bdbrdj=null;
    String bdbrxz=null;
    int bdbrtze=0;
    String strup=null;
    str=null;
    str1=null;
    str2=null;
    str3=null;
    str4=null;
    str5=null;
    str6=null;
    str7=null;
    str8=null;
    str9=null;
    a1=0;a2=0;b=0;
    a3=0;b1=0;

    try{
         str=jTextField1.getText();
         String select="select CreditcardId from Creditcard";
         Statement ps1;
         ResultSet rs1;
         ps1=con.createStatement();
         String eq=null;
         rs1=ps1.executeQuery(select);
         while(rs1.next()){
         eq=rs1.getString("CreditcardId");
         if(eq.trim().equals(str)){

         query = "select CreditcardGrade,UserId from Creditcard where CreditcardId=?";
         pstmt = con.prepareStatement(query);
         pstmt.setString(1,str);
         rs=pstmt.executeQuery();
         if(rs.next()){
         str9=rs.getString("UserId");  //用户号
         str1=rs.getString("CreditcardGrade");   //信用等级

          }
         query1 = "select AccountDeposit from Account where CreditcardId=?";
         pstmt1 = con.prepareStatement(query1);
         pstmt1.setString(1,str);
         rs1=pstmt1.executeQuery();
         if(rs1.next()){
         str2=rs1.getString("AccountDeposit");  //存款余额
         a1=Float.parseFloat(str2);   //存款余额

          }
         query2 = "select UseNum,UseMoney,UseState from UseRecord where CreditcardId=?";
         pstmt2 = con.prepareStatement(query2);
         pstmt2.setString(1,str);
         rs2=pstmt2.executeQuery();
         if(rs2.next()){
         str3=rs2.getString("UseNum");  //使用次数
         str4=rs2.getString("UseMoney");  //使用金额
         str5=rs2.getString("UseState");   //使用状态
         a2=Float.parseFloat(str4);    //使用金额
         a3=Integer.parseInt(str3);    //使用次数
         if((a1-a2)<0)
         b=a2-a1;  //月累计透支额
         }
         query3 = "select UserName,CpCredit from Users where UserId=?";
         pstmt3= con.prepareStatement(query3);
         pstmt3.setString(1,str9);
         rs3=pstmt3.executeQuery();
         if(rs3.next()){
         str7=rs3.getString("UserName");//用户名
         str8=rs3.getString("CpCredit"); //初评得分
         b1=Integer.parseInt(str8);//初评得分
        }

        else{
            jTextField1.setText("没有匹配项!");

        }
        b1=b1+this.UseRecordadjust(a1,a2,a3,b,str5)+this.Badrecordadjust(str9);
        jTextField1.setText(Integer.toString(b1));
        if((b1<=120)&&(b1>=100)){
          str1="A";
          tzed=50000;
          xz="金卡";
          bdbrdj="B";
          bdbrxz="金卡";
          bdbrtze=40000;
          }
          else if((b1<100)&&(b1>=90)){
          str1="B";
          tzed=40000;
          xz="金卡";
          bdbrdj="C";
          bdbrxz="普卡";
          bdbrtze=30000;

          }
          else if((b1<90)&&(b1>=80)){
          str1="C";
          tzed=30000;
          xz="普卡";
          bdbrdj="D";
          bdbrxz="普卡";
          bdbrtze=20000;

         }
         else if((b1<80)&&(b1>=70)){
         str1="D";
         tzed=20000;
         xz="普卡";
         bdbrdj="E";
         bdbrxz="普卡";
         bdbrtze=10000;

         }
         else if((b1<70)&&(b1>=60)){
         str1="E";
         tzed=10000;
          xz="普卡";
          bdbrdj="F";
         bdbrxz="普卡";
         bdbrtze=5000;

         }
         else if((b1<60)&&(b1>=50)){
         str1="F";
         tzed=5000;
          xz="普卡";
          bdbrdj="G";
          bdbrxz="普卡";
          bdbrtze=2000;

         }
         else if((b1<50)&&(b1>=35)){
         str1="G";
         tzed=2000;
         xz="普卡";
         bdbrdj="H";
         bdbrxz="普卡";
         bdbrtze=0;

         }
         else {
         str1="H";
         tzed=0;
         xz="普卡";
         }
         jTextField2.setText(str9);
         jTextField3.setText(xz);
         jTextField4.setText(str1);
         jTextField5.setText(Integer.toString(tzed));


         qur="update Creditcard set CreditcardGrade="+"\'"+str1+"\'"+" where CreditcardId="+"\'"+str.trim()+"\'";
         Statement ps;
         ps=con.createStatement();
        // System.out.print(qur);
         ps.execute(qur);

        sel="select UserId from Users where DbrUserId=?";
        pstmt1 = con.prepareStatement(sel);
        pstmt1.setString(1,str9);
        rs1=pstmt1.executeQuery();
         if(rs1.next()){
         str2=rs1.getString("UserId");
          }
        if(str2!=null){
         qur="update Creditcard set CreditcardGrade="+"\'"+ bdbrdj+"\'"+" where UserId="+"\'"+str2.trim()+"\'";
         ps=con.createStatement();
         ps.execute(qur);
         jTextField6.setText(str2);
         jTextField7.setText(bdbrxz);
         jTextField8.setText(bdbrdj);
         jTextField9.setText(Integer.toString(bdbrtze));
       }
        else{
          jTextField6.setText("");
          jTextField7.setText("");
          jTextField8.setText("");
          jTextField9.setText("");

          }
        }
      else{
         jTextField1.setText("该信用卡不存在");
         jTextField2.setText("");
         jTextField3.setText("");
         jTextField4.setText("");
         jTextField5.setText("");
         jTextField6.setText("");
         jTextField7.setText("");
         jTextField8.setText("");
         jTextField9.setText("");


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

  }
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField6 = new JTextField();
  JTextField jTextField7 = new JTextField();
  JTextField jTextField8 = new JTextField();
  JTextField jTextField9 = new JTextField();

}

class FreeHalfAdjust_jButton1_actionAdapter implements java.awt.event.ActionListener {
  FreeHalfAdjust adaptee;

  FreeHalfAdjust_jButton1_actionAdapter(FreeHalfAdjust adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}