guaranteebetimesadjust.java

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

              txtinfo1.setEditable(false);

//              JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("B")) {
              gradechange = "C";
              money = "30000元";
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(true);
              txtinfo2.setEditable(true);
              cmdfind.setEnabled(false);
              txtinfo1.setEditable(false);
//              JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("C")) {
              gradechange = "D";
              money = "20000元";
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(true);
              txtinfo2.setEditable(true);
              cmdfind.setEnabled(false);
              txtinfo1.setEditable(false);
//              JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("D")) {
              gradechange = "E";
              money = "10000元";
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(true);
              txtinfo2.setEditable(true);
              cmdfind.setEnabled(false);
              txtinfo1.setEditable(false);
 //             JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("E")) {
              gradechange = "F";
              money = "5000元";
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(true);
              txtinfo2.setEditable(true);
              cmdfind.setEnabled(false);
              txtinfo1.setEditable(false);
 //             JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("F")) {
              gradechange = "G";
              money = "2000元";
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(true);
              txtinfo2.setEditable(true);
              cmdfind.setEnabled(false);
              txtinfo1.setEditable(false);
//              JOptionPane.showMessageDialog(this,"可以让此用户成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("G")) {
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(false);
              txtinfo2.setEditable(false);
              JOptionPane.showMessageDialog(this,"此用户信用等级不够，不能成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
            else if (grade.equals("H")) {
              txtinfo2.setText("");
              labshow2.setText("");
              labshow3.setText("");

              cmdchange.setEnabled(false);
              txtinfo2.setEditable(false);
              JOptionPane.showMessageDialog(this,"此用户信用等级不够，不能成为申请人的担保人。","确认信息",JOptionPane.YES_OPTION);
            }
          }
      }
      else{
        txtinfo1.setText("");
        txtinfo2.setText("");
        labshow1.setText("");
        labshow2.setText("");
        labshow3.setText("");
        cmdchange.setEnabled(false);
        txtinfo2.setEditable(false);

        JOptionPane.showMessageDialog(this,"无此用户！","确认信息",JOptionPane.YES_OPTION);


        }
      }
    }
    catch(Exception em)
    {
       JOptionPane.showMessageDialog(this,"系统错误，请重新运行！","确认信息",JOptionPane.YES_OPTION);
    }

  }

  void cmdchange_actionPerformed(ActionEvent e) {
//修改申请人等级

try {
      String url =
          "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES";
      String username = "sa";
      String password = "";
      con = DriverManager.getConnection(url, username, password);

      if (txtinfo2.getText().length() == 0) {
       JOptionPane.showMessageDialog(this,"请输入申请人号！","确认信息",JOptionPane.YES_OPTION);
      }
      else {
        String sql = "select UserID from Users where UserID=?";
        sqlcheck = con.prepareStatement(sql);
        String check = (txtinfo2.getText()).trim();
        sqlcheck.setString(1, check);
        sqlrs = sqlcheck.executeQuery();
        if (sqlrs.next()) {
          query2 = "update Users set DbrUserID=? where UserID=?";
          pstmt2 = con.prepareStatement(query2);
          String str2 = (txtinfo2.getText()).trim();
          String str1 = (txtinfo1.getText()).trim();
          pstmt2.setString(1, str1);
          pstmt2.setString(2, str2);
          pstmt2.executeUpdate();

          query22 = "update Creditcard set CreditcardGrade=? where UserID=?";
          pstmt22 = con.prepareStatement(query22);
          pstmt22.setString(1, gradechange);
          pstmt22.setString(2, str2);
          pstmt22.executeUpdate();

          labshow3.setText(gradechange);
          labshow2.setText(money);
          cmdchange.setEnabled(false);
          txtinfo2.setEditable(false);
          cmdfind.setEnabled(true);
          txtinfo1.setEditable(true);

          JOptionPane.showMessageDialog(this, "更改成功！", "确认信息",
                                        JOptionPane.INFORMATION_MESSAGE);
        }
        else{
          txtinfo2.setText("");
          JOptionPane.showMessageDialog(this, "无此用户！", "确认信息",JOptionPane.YES_OPTION);
        }
      }
    }
    catch(Exception em)
       {
         JOptionPane.showMessageDialog(this,"系统错误，请重新运行！","确认信息",JOptionPane.YES_OPTION);
       }

  }

  void cmdcancel_actionPerformed(ActionEvent e) {
    txtinfo1.setText("");
    txtinfo2.setText("");
    labshow1.setText("");
    labshow2.setText("");
    labshow3.setText("");
    cmdchange.setEnabled(false);
    txtinfo2.setEditable(false);
    cmdfind.setEnabled(true);
    txtinfo1.setEditable(true);

    eventFrame.jSplitPane1.remove(eventFrame.jSplitPane1.getRightComponent());
    eventFrame.jSplitPane1.add(new helloPanel(),JSplitPane.RIGHT);
  }

}

class GuaranteeBetimesAdjust_cmdfind_actionAdapter implements java.awt.event.ActionListener {
  GuaranteeBetimesAdjust adaptee;

  GuaranteeBetimesAdjust_cmdfind_actionAdapter(GuaranteeBetimesAdjust adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cmdfind_actionPerformed(e);
  }
}

class GuaranteeBetimesAdjust_cmdchange_actionAdapter implements java.awt.event.ActionListener {
  GuaranteeBetimesAdjust adaptee;

  GuaranteeBetimesAdjust_cmdchange_actionAdapter(GuaranteeBetimesAdjust adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cmdchange_actionPerformed(e);
  }
}

class GuaranteeBetimesAdjust_cmdcancel_actionAdapter implements java.awt.event.ActionListener {
  GuaranteeBetimesAdjust adaptee;

  GuaranteeBetimesAdjust_cmdcancel_actionAdapter(GuaranteeBetimesAdjust adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cmdcancel_actionPerformed(e);
  }
}