jbxxdialog_xzt.java~7~

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

    jComboBox3.addItem("");
    jComboBox3.addItem("公务员");
    jComboBox3.addItem("教师、医生、");
    jComboBox3.addItem("金融、律师");
     jComboBox3.addItem("军人、记者");
    jComboBox3.addItem("企业主、公司职员");
     jComboBox3.addItem("其它职业");


   jComboBox2.addItem("");
   jComboBox2.addItem("男");
   jComboBox2.addItem("女");
   jComboBox12.addItem("");

   jComboBox12.addItem("定期以及银行卡");
    jComboBox12.addItem("定期");
    jComboBox12.addItem("银行卡");
    jComboBox12.addItem("仅开立活期存折帐户");
     jComboBox12.addItem("无帐户");

     jComboBox1.addItem("");
    jComboBox1.addItem("研究生生以上");
    jComboBox1.addItem("本科");
    jComboBox1.addItem("大专");
    jComboBox1.addItem("高中，中专");
    jComboBox1.addItem("其他");

    jComboBox4.addItem("");
    jComboBox4.addItem("已婚有子女");
    jComboBox4.addItem("已婚无子女");
    jComboBox4.addItem("未婚");
    jComboBox4.addItem("其他");

    jComboBox14.addItem("");
    jComboBox14.addItem("密切");
    jComboBox14.addItem("一般");
    jComboBox14.addItem("较少");

    jComboBox16.addItem("");
    jComboBox16.addItem("有借款已还清");
    jComboBox16.addItem("有逾期记录");
    jComboBox16.addItem("从未借款");
    jComboBox16.addItem("曾还款，但尚有借款");
    jComboBox16.addItem("不曾还款，但尚有借款");

    jComboBox8.addItem("");
    jComboBox8.addItem("高级");
    jComboBox8.addItem("中级");
    jComboBox8.addItem("初级");
    jComboBox8.addItem("无");

    jComboBox11.addItem("");
    jComboBox11.addItem("自有住房");
    jComboBox11.addItem("贷款购房");
    jComboBox11.addItem("租用公房");
    jComboBox11.addItem("其他");

    jComboBox5.addItem("");
    jComboBox5.addItem("常住户口");
    jComboBox5.addItem("临时户口");

    jComboBox10.addItem("");
    jComboBox10.addItem("500元以下");
    jComboBox10.addItem("500-1000元");
    jComboBox10.addItem("1000-3000元");
    jComboBox10.addItem("3000元以上");

    jComboBox17.addItem("");
    jComboBox17.addItem("10000元以上");
    jComboBox17.addItem("8000-10000元");
    jComboBox17.addItem("5000-8000元");
    jComboBox17.addItem("4000-5000元 ");
    jComboBox17.addItem("3000-4000元");
    jComboBox17.addItem("2000-3000元");
    jComboBox17.addItem("1000-2000元");
    jComboBox17.addItem("1000元以下");

    jComboBox18.addItem("");
    jComboBox18.addItem("是");
    jComboBox18.addItem("否");

    jTextField1.setText(username);
    jTextField2.setText(usercard);


    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   String url =
       "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES";

   String username = "sa";
   String password = "";
   con = DriverManager.getConnection(url, username, password);




  }

  void jComboBox16_actionPerformed(ActionEvent e) {

  }

  void jButton2_actionPerformed(ActionEvent e) {
        this.dispose();
  }

  void jComboBox3_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e) {




   int intYHworkerID=Integer.parseInt(YHworkerID);




    try{

   //String SQL = "Insert Into rejecttable(UserName,UserCard,Datet,Rejectexcuse) Values("+"\'"+Username+"\'"+ ","+"\'"+UserPID+"\'"+","+"\'"+sdf.format(today)+"\'"+","+"\'"+reason+"\'"+")";



  // String SQL = "Insert Into Users(UserName,UserCard,YHworkerID,UserSex) Values("+"\'"+jTextField1.getText() +"\'"+ ","+"\'"+jTextField2.getText() +"\'"+","+"\'"+intYHworkerID +"\'"+","+"\'"+(String)jComboBox2.getSelectedItem()+"\'"+")";


   if ( /*
        (jTextField3.getText()).equals("")||
        (jTextField4.getText()).equals("")||
        ((String) jComboBox3.getSelectedItem()).equals("")||
        ((String) jComboBox1.getSelectedItem()).equals("")||
        ((String) jComboBox7.getSelectedItem()).equals("")||
        ((String) jComboBox9.getSelectedItem()).equals("")||
        ((String) jComboBox18.getSelectedItem()).equals("")||
        ((String) jComboBox4.getSelectedItem()).equals("")||
        ((String) jComboBox14.getSelectedItem()).equals("")||
        ((String) jComboBox16.getSelectedItem()).equals("")||
        ((String) jComboBox5.getSelectedItem()).equals("") ||
        ((String) jComboBox8.getSelectedItem()).equals("")||
        ((String) jComboBox13.getSelectedItem()).equals("")||
        ((String) jComboBox10.getSelectedItem()).equals("")||
        ((String) jComboBox17.getSelectedItem()).equals("")||
        ((String) jComboBox11.getSelectedItem()).equals("")||
        ((String) jComboBox12.getSelectedItem()).equals("")
*/
      (jTextField3.getText()).equals("")
        )
   {
        CheckDialog CheckDialog3=new CheckDialog("请正确填写所有资料！");
        CheckDialog3.setBounds(300,200,300,200);
        CheckDialog3.show();

   }
   else
   {
         String SQL = "Insert Into Users(UserName,UserCard,UserSex,UserAge,MarriageState,CultureState,RegistereState,IndividualIcome,AverageIcome,AverageExpend,HouseState,YHworkerID)" +
         " Values(" + "\'" + jTextField1.getText() + "\'" + "," + "\'" +
         jTextField2.getText() + "\'" + "," + "\'"
         + (String) jComboBox2.getSelectedItem() + "\'" + "," + "\'" +
         Integer.parseInt(jTextField3.getText())
         + "\'" + "," + "\'" + (String) jComboBox4.getSelectedItem() + "\'" +
         "," + "\'" +
         (String) jComboBox1.getSelectedItem() + "\'" + "," + "\'" +
         (String) jComboBox5.getSelectedItem()
         + "\'" + "," + "\'" + (String) jComboBox17.getSelectedItem() + "\'" +
         "," + "\'" + (String) jComboBox13.getSelectedItem()
         + "\'" + "," + "\'" + (String) jComboBox10.getSelectedItem() + "\'" +
         "," + "\'" + (String) jComboBox11.getSelectedItem() + "\'" +
         "," + "\'" + intYHworkerID + "\'" +
         ")";

     // String SQL = "Insert Into Users(UserName,UserCard,YHworkerID) Values('a','b','1000')";
     Statement stmt = con.createStatement();
     stmt.executeUpdate(SQL);

     this.dispose() ;

     String query3 = "select * from Users  ";
      pstmt = con.prepareStatement(query3);

      rs = pstmt.executeQuery();
      while(rs.next() ) {
       newUID=rs.getString("UserId");
}

/*

     //写入信用卡表
     String SQL2 = "Insert Into Creditcard(UserId,CreditcardGrade,CreditcardCode) Values("+"\'"+newUID+"\'"+ ","+"\'"+newGrade+"\'"+","+"\'"+"000000"+"\'"+")";
      Statement stmt2 = con.createStatement();
     stmt2.executeUpdate(SQL2);

*/



/*
     CheckDialog CheckDialogSuccess=new CheckDialog("用户办卡成功！ ","用户帐号：         "+ newUID ,"用户信用卡号： "+ newCardID,"用户初始密码:    000000  ");
     CheckDialogSuccess.setBounds(300,200,300,200);
     CheckDialogSuccess.show();

*/






   }

    }
    catch(Exception eee)
    {
      /*
         eee.printStackTrace();
         CheckDialog CheckDialog3=new CheckDialog("填写错误！请正确填写各个选项！");
         CheckDialog3.setBounds(300,200,300,200);
         CheckDialog3.show();
      */

    }
    finally
    {
      try{
/*
        //写入帐号表
        //先获得信用卡号
        String query9 = "select * from Creditcard  ";
        pstmt = con.prepareStatement(query9);
        String newCardID = "";
        rs = pstmt.executeQuery();
        while (rs.next()) {
          newCardID = rs.getString("CreditcardID");
        }
        int zero = Integer.parseInt(jTextField4.getText());
        String SQL9 =
            "Insert Into Account(CreditcardId,AccountType,AccountDeposit) Values(" +
            "\'" + Integer.parseInt(newCardID) + "\'" + "," + "\'" +
            (String) jComboBox12.getSelectedItem() + "\'" + "," + "\'" + zero +
            "\'" + ")";
        Statement stmt9 = con.createStatement();
        stmt9.executeUpdate(SQL9);



        //写入使用记录表
        String SQL22 = "Insert Into UseRecord(CreditcardId,UseState) Values(" +
            "\'" + Integer.parseInt(newCardID) + "\'" + "," + "\'" +
            (String) jComboBox16.getSelectedItem() + "\'" + ")";
        Statement stmt22 = con.createStatement();
        stmt22.executeUpdate(SQL22);
*/
        //写入工作情况表
        String query5 = "select * from Profession  "; //获得用户职业情况，即上面刚写入的最户一条记录
        pstmt = con.prepareStatement(query5);
        String ProfessionId = "";
        rs = pstmt.executeQuery();
        while (rs.next()) {
          ProfessionId = rs.getString("ProfessionId");
        }

        String SQL4 = "Insert Into WorkInstance(ProfessionId,UserId,WorkingState,WorkingPost,WorkingFirm) Values("
            + "\'" + ProfessionId + "\'" + "," + "\'" + newUID + "\'" + "," +
            "\'" + (String) jComboBox7.getSelectedItem() + "\'" + "," + "\'" +
            (String) jComboBox8.getSelectedItem() + "\'" + "," + "\'" +
            (String) jComboBox9.getSelectedItem() + "\'" + ")";
        Statement stmt4 = con.createStatement();
        stmt4.executeUpdate(SQL4);

      }
      catch(Exception exx)
      {}
    }


  }

  void jTextField3_actionPerformed(ActionEvent e) {

  }


}
/*
class JbxxDialog_jComboBox16_actionAdapter implements java.awt.event.ActionListener {
  JbxxDialog_XZT adaptee;

  JbxxDialog_jComboBox16_actionAdapter(JbxxDialog_XZT adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox16_actionPerformed(e);
  }
}
*/
class JbxxDialog_jButton2_actionAdapter implements java.awt.event.ActionListener {
  JbxxDialog_XZT adaptee;

  JbxxDialog_jButton2_actionAdapter(JbxxDialog_XZT adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}
/*
class JbxxDialog_jComboBox3_actionAdapter implements java.awt.event.ActionListener {
  JbxxDialog_XZT adaptee;

  JbxxDialog_jComboBox3_actionAdapter(JbxxDialog_XZT adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox3_actionPerformed(e);
  }
}

class JbxxDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  JbxxDialog_XZT adaptee;

  JbxxDialog_jButton1_actionAdapter(JbxxDialog_XZT adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class JbxxDialog_jTextField3_actionAdapter implements java.awt.event.ActionListener {
  JbxxDialog adaptee;

  JbxxDialog_jTextField3_actionAdapter(JbxxDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField3_actionPerformed(e);
  }
}


*/