jbxxdialog.java~63~

银行信用评估系统

    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);
  }

  void jComboBox16_actionPerformed(ActionEvent e) {

  }

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

  void jComboBox3_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e) {

    Connection con;
    String query;
    String query2;
    ResultSet rs;
    ResultSet rs2;
    PreparedStatement pstmt;
    PreparedStatement pstmt2;
    try{
    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);
    int intYHworkerID=Integer.parseInt(YHworkerID);
   //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("")

        )
   {
        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,DbrUserId,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() + "\'" +
         "," + "\'" + danBaoRenID + "\'" +
         "," + "\'" + 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);
      String newUID="";
      rs = pstmt.executeQuery();
      while(rs.next() ) {
       newUID=rs.getString("UserId");
}

if(myflag!=9)
{

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




     //写入帐号表
     //先获得信用卡号
     String query9 = "select * from Creditcard  ";
     pstmt = con.prepareStatement(query9);

     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);


}//end of if



    //写入使用职业表
    String SQL23 = "Insert Into Profession(ProfessionTypes) Values("+"\'"+(String) jComboBox3.getSelectedItem()+"\'"+")";
     Statement stmt23 = con.createStatement();
    stmt23.executeUpdate(SQL23);





     //写入工作情况表
     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("
         +"\'"+Integer.parseInt(ProfessionId)+"\'"+","+"\'"+newUID+"\'"+","+"\'"+(String) jComboBox7.getSelectedItem()+"\'"+","+"\'"+(String) jComboBox8.getSelectedItem()+"\'"+","+"\'"+(String) jComboBox9.getSelectedItem()+"\'"+ ")";
     Statement stmt4 = con.createStatement();
     stmt4.executeUpdate(SQL4);

     if(myflag!=9)
{


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

}
   else
   {
     CheckDialog CheckDialogSuccess=new CheckDialog("用户办卡成功！ ","用户帐号：         "+ newUID ," ","  ");
   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();


    }


  }

  void jTextField3_actionPerformed(ActionEvent e) {

  }


}

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

  JbxxDialog_jComboBox16_actionAdapter(JbxxDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox16_actionPerformed(e);
  }
}

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

  JbxxDialog_jButton2_actionAdapter(JbxxDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

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

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

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

  JbxxDialog_jButton1_actionAdapter(JbxxDialog 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);
  }
}