s12panel.java~1~

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

        cGrade=s12rs.getString(2);
        s12sql="select UserName,UserCard from Users where UserId=?";
        s12sql2="select ZdId from ZDthing where UserId=?";
        s12stmt1 = s12con.prepareStatement(s12sql);
        s12stmt2=s12con.prepareStatement(s12sql2);
        s12stmt1.setString(1,uid);
        s12stmt2.setString(1,uid);
        s12rs=s12stmt1.executeQuery();
        s12rs2=s12stmt2.executeQuery();
        if(s12rs.next()){
          uname=s12rs.getString(1);
          ucard=s12rs.getString(2);
          jLabel01.setText(uid);
          jLabel02.setText(uname);
          jLabel03.setText(ucard);
          jLabel04.setText(cGrade);
        }
        else{
          JOptionPane.showMessageDialog(this,"系统出错，请重新输入！","错误",JOptionPane.WARNING_MESSAGE);
          //set focus=textfield1;
          return;
        }
        if(s12rs2.next()){
          islie=true;
          zid=s12rs2.getString(1);
          jTextField5.setText(zid);
          int y=java.util.Calendar.getInstance().get(java.util.Calendar.YEAR);
          int m=java.util.Calendar.getInstance().get(java.util.Calendar.MONTH)+1;
          int d= java.util.Calendar.getInstance().get( java.util.Calendar.DATE);
          String dd=String.valueOf(y)+"-"+String.valueOf(m)+"-"+String.valueOf(d);
          jTextField4.setText(dd);
        }
        else{
          islie=false;
          JOptionPane.showMessageDialog(this,"该用户尚无抵押物，请为其设置新的抵押物编号！","通知",JOptionPane.WARNING_MESSAGE);
          int y=java.util.Calendar.getInstance().get(java.util.Calendar.YEAR);
          int m=java.util.Calendar.getInstance().get(java.util.Calendar.MONTH)+1;
          int d= java.util.Calendar.getInstance().get( java.util.Calendar.DATE);
          String dd=String.valueOf(y)+"-"+String.valueOf(m)+"-"+String.valueOf(d);
          jTextField4.setText(dd);
          return;
        }
      }
      else {
        JOptionPane.showMessageDialog(this,"信用卡号或密码错误！","警告",JOptionPane.ERROR_MESSAGE);
      //set focus
        return;
      }
  }catch(SQLException ee){System.out.println("1   "+ee.getMessage());}
  catch(Exception ep){System.out.println("2  "+ep.getMessage());}
  }

  void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText(null);
    jPasswordField1.setText(null);
  }

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

  void jButton4_actionPerformed(ActionEvent e) {
    try{
      if(jTextField5.getText().length()==0){
        JOptionPane.showMessageDialog(this,"抵押物编号不能为空！","警告",JOptionPane.WARNING_MESSAGE);
        //set focus
        return;
      }
      else if(jTextField2.getText().length()==0){
        JOptionPane.showMessageDialog(this,"抵押物名称不能为空！","警告",JOptionPane.WARNING_MESSAGE);
        //set focus
        return;
      }
      else if(jTextField3.getText().length()==0){
        JOptionPane.showMessageDialog(this,"日期不能为空！","警告",JOptionPane.WARNING_MESSAGE);
        //set focus
        return;
      }
      if(islie==false)
        zid=jTextField5.getText();
      zname=jTextField2.getText();
      zprice=jTextField3.getText();
      zkind=(String)jComboBox1.getSelectedItem();
      zvariety=(byte)jComboBox1.getSelectedIndex();
      zdate=jTextField4.getText();
      zvalue=Double.parseDouble(zprice);
      java.sql.Date zday=java.sql.Date.valueOf(zdate);
      dmoney=zvalue*0.6;
      zmoney=zvalue*0.9;

      String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES";
      String username= "sa";
      String password= "";
      s12con = DriverManager.getConnection(url,username,password);
      if(islie==true){//geng xin
          s12sql="update ZDthing set Zdname=?,Zdprice=?,Zddate=?,Zdstate=? where ZdId=?";
          s12stmt1 = s12con.prepareStatement(s12sql);
          s12stmt1.setString(1,zname);
          s12stmt1.setDouble(2,zvalue);
          s12stmt1.setDate(3,zday);
          s12stmt1.setString(4,zkind);
          s12stmt1.setString(5,zid);
          s12stmt1.executeUpdate();
      }
      else{
        s12sql="insert into ZDthing values(?,?,?,?,?,?)";
        s12stmt1 = s12con.prepareStatement(s12sql);
        s12stmt1.setString(1,zid);
        s12stmt1.setString(2,uid);
        s12stmt1.setString(3,zname);
        s12stmt1.setDouble(4,zvalue);
        s12stmt1.setDate(5,zday);
        s12stmt1.setString(6,zkind);
        s12stmt1.executeUpdate();
      }
      switch(zvariety){
        case 0 :
          countCGrade(zmoney);
          s12sql="update Creditcard set CreditcardGrade=? where CreditcardId=?";
          s12stmt1 = s12con.prepareStatement(s12sql);
          s12stmt1.setString(1,cGrade);
          s12stmt1.setString(2,cid);
          s12stmt1.executeUpdate();
          JOptionPane.showMessageDialog(this,"调整成功\n"+"信用等级已调整为： "+cGrade+"\n信用额度已调整为： "+getmoney(cGrade.toCharArray()[0])+" 元","通知",JOptionPane.INFORMATION_MESSAGE);
          setempty();
          break;
        case 1 :
          countCGrade(dmoney);
          s12sql="update Creditcard set CreditcardGrade=? where CreditcardId=?";
          s12stmt1 = s12con.prepareStatement(s12sql);
          s12stmt1.setString(1,cGrade);
          s12stmt1.setString(2,cid);
          s12stmt1.executeUpdate();
          JOptionPane.showMessageDialog(this,"调整成功\n"+"信用等级已调整为： "+cGrade+"\n信用额度已调整为： "+getmoney(cGrade.toCharArray()[0])+" 元","通知",JOptionPane.INFORMATION_MESSAGE);
          setempty();
          break;
      }
    }catch(SQLException ee){//数据库出错
      JOptionPane.showMessageDialog(this,"数据库出错，请检查！","错误",JOptionPane.ERROR_MESSAGE);
    }
    catch(Exception ep){//以外错误
      String errmsg=ep.getMessage();
      System.out.println(errmsg);
      JOptionPane.showMessageDialog(this,"意外错误","错误",JOptionPane.ERROR_MESSAGE);
    }
  }

  void jButton5_actionPerformed(ActionEvent e) {
    setempty();
  }

  void jPasswordField1_actionPerformed(ActionEvent e) {
    jButton1_actionPerformed(e);
  }

  void jTextField1_actionPerformed(ActionEvent e) {
    jButton1_actionPerformed(e);
  }

  void jTextField2_actionPerformed(ActionEvent e) {
    jButton4_actionPerformed(e);
  }

  void jTextField5_actionPerformed(ActionEvent e) {
    jButton4_actionPerformed(e);
  }

  void jTextField3_actionPerformed(ActionEvent e) {
    jButton4_actionPerformed(e);
  }

  void jTextField4_actionPerformed(ActionEvent e) {
    jButton4_actionPerformed(e);
  }

}

class s12Panel_jButton1_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jButton1_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class s12Panel_jButton2_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jButton2_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class s12Panel_jButton3_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jButton3_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class s12Panel_jButton4_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jButton4_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class s12Panel_jButton5_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jButton5_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class s12Panel_jPasswordField1_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jPasswordField1_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jPasswordField1_actionPerformed(e);
  }
}

class s12Panel_jTextField1_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jTextField1_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField1_actionPerformed(e);
  }
}

class s12Panel_jTextField2_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jTextField2_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField2_actionPerformed(e);
  }
}

class s12Panel_jTextField5_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jTextField5_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField5_actionPerformed(e);
  }
}

class s12Panel_jTextField3_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jTextField3_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField3_actionPerformed(e);
  }
}

class s12Panel_jTextField4_actionAdapter implements java.awt.event.ActionListener {
  s12Panel adaptee;

  s12Panel_jTextField4_actionAdapter(s12Panel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField4_actionPerformed(e);
  }
}