testpanel.java~68~

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

package management;

import java.awt.*;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.event.*;
import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class testPanel extends JPanel {
  JTextField jTextField1 = new JTextField();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  TitledBorder titledBorder3;
  TitledBorder titledBorder4;
  Connection con;
  JLabel jLabel2 = new JLabel();
  JLabel jLabel7 = new JLabel();
  TitledBorder titledBorder5;
  JButton jButton2 = new JButton();
  JLabel jLabel8 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  TitledBorder titledBorder6;
  GridBagLayout gridBagLayout1 = new GridBagLayout();

  public testPanel() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder("");
    jTextField1.setText("");
    this.setLayout(gridBagLayout1);
    jLabel1.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel1.setText("请输入自主分(<=20分)：");
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("确定");
    jButton1.addActionListener(new testPanel_jButton1_actionAdapter(this));
    jLabel3.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel3.setText("该用户的信用等级为：");
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel4.setBorder(titledBorder2);
    jLabel4.setDebugGraphicsOptions(0);
    jLabel4.setText("");
    jLabel5.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel5.setText("该用户的透支额为：");
    jLabel6.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel6.setBorder(titledBorder4);
    jLabel6.setText("");

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

    jLabel2.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel2.setText("该用户的初评分为：");
    jLabel7.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel7.setBorder(titledBorder5);
    jLabel7.setText("");
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setToolTipText("");
    jButton2.setText("返回");
    jButton2.addActionListener(new testPanel_jButton2_actionAdapter(this));
    jLabel8.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel8.setText("请输入用户号：");
    jLabel9.setFont(new java.awt.Font("Dialog", 1, 22));
    jLabel9.setText("该用户的信用卡卡号：");
    jLabel10.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel10.setBorder(titledBorder6);
    jLabel10.setRequestFocusEnabled(true);
    jLabel10.setText("");
    this.add(jLabel1,  new GridBagConstraints(0, 1, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(14, 13, 0, 0), 2, 4));
    this.add(jTextField1,  new GridBagConstraints(2, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(19, 14, 0, 8), 137, 1));
    this.add(jTextField2,  new GridBagConstraints(2, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(12, 14, 0, 8), 135, 2));
    this.add(jLabel8,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(12, 13, 0, 39), 43, -2));
    this.add(jLabel5,  new GridBagConstraints(0, 6, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(10, 13, 22, 29), 7, -1));
    this.add(jLabel6,  new GridBagConstraints(1, 6, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(12, 8, 22, 18), 141, 12));
    this.add(jLabel3,  new GridBagConstraints(0, 5, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(6, 13, 0, 9), 5, 14));
    this.add(jLabel2,  new GridBagConstraints(0, 4, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(10, 13, 0, 16), 22, 0));
    this.add(jLabel9,  new GridBagConstraints(0, 3, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(15, 13, 0, 0), 12, -5));
    this.add(jButton1,  new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(14, 126, 0, 59), 12, -4));
    this.add(jButton2,  new GridBagConstraints(1, 2, 2, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(14, 0, 0, 105), 12, -4));
    this.add(jLabel7,  new GridBagConstraints(1, 4, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(12, 8, 0, 17), 142, 13));
    this.add(jLabel10,  new GridBagConstraints(1, 3, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(18, 8, 0, 18), 141, 12));
    this.add(jLabel4,  new GridBagConstraints(1, 5, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(14, 8, 8, 18), 141, 12));
  }
  public int Badrecordadjust(){
     PreparedStatement pstmt5;
     ResultSet rs5;
     String strx0 = "";
     String queryb;
     String queryx[] = new String[3];
     String strbl = "";
     String strbx1[] = new String[3];
     int sum1=0;
    try{
           //婚姻状况
          queryb= "select * from Users where userid=?";
          pstmt5 = con.prepareStatement(queryb);
         strx0=jTextField2.getText();
         pstmt5.setString(1,strx0);
          rs5=pstmt5.executeQuery();
          if(rs5.next()){
          strbl=rs5.getString("MarriageState");
          }
       if(strbl!=null) {
          if (strbl.equals("未婚")) {
            queryx[0] = "select Nomarry from userlist ";
            strbx1[0] = "Nomarry";
         }
          else if (strbl.equals("已婚有子女")) {
            queryx[0] = "select MarriedBaby from userlist";
            strbx1[0] = "MarriedBaby";
          }
          else if (strbl.equals("已婚无子女")) {
            queryx[0] = "select MarriedNoBaby from userlist";
            strbx1[0] = "MarriedNoBaby";
          }
          else if (strbl.equals("其他")) {
            queryx[0] = "select OtherMarry from userlist";
            strbx1[0] = "OtherMarry";
          }
          pstmt5 = con.prepareStatement(queryx[0]);
          rs5 = pstmt5.executeQuery();
          if (rs5.next()) {
            strx0 = rs5.getString(strbx1[0]); //调整分
           sum1 += Integer.parseInt(strx0);
           jTextField1.setText(sum1+" ");
          }
        }
        else  sum1 += 0;
        // 性别
      queryb= "select * from Users where userid=?";
      pstmt5 = con.prepareStatement(queryb);
     strx0=jTextField2.getText();
     pstmt5.setString(1,strx0);
      rs5=pstmt5.executeQuery();
      if(rs5.next()){
      strbl=rs5.getString("UserSex");
      }
   if(strbl!=null) {
      if (strbl.equals("男")) {
        queryx[0] = "select Male from userlist ";
        strbx1[0] = "Male";
     }
      else if (strbl.equals("女")) {
        queryx[0] = "select Female from userlist";
        strbx1[0] = "Female";
      }
      pstmt5 = con.prepareStatement(queryx[0]);
      rs5 = pstmt5.executeQuery();
      if (rs5.next()) {
        strx0 = rs5.getString(strbx1[0]); //调整分
        sum1 += Integer.parseInt(strx0);
        jTextField1.setText(sum1+" ");
      }
    }
    else  sum1 += 0;
    // 文化程度
        queryb= "select * from Users where userid=?";
        pstmt5 = con.prepareStatement(queryb);
       strx0=jTextField2.getText();
       pstmt5.setString(1,strx0);
        rs5=pstmt5.executeQuery();
        if(rs5.next()){
        strbl=rs5.getString("CultureState");
        }
     if(strbl!=null) {
        if (strbl.equals("研究生以上")) {
          queryx[0] = "select GraduateS from userlist ";
          strbx1[0] = "GraduateS";
       }
        else if (strbl.equals("本科")) {
          queryx[0] = "select UnGraduateS from userlist";
          strbx1[0] = "UnGraduateS";
        }
        else if (strbl.equals("大专")) {
         queryx[0] = "select Junior from userlist";
         strbx1[0] = "Junior";
       }
       else if (strbl.equals("中专、高中")) {
         queryx[0] = "select Intermediate from userlist";
         strbx1[0] = "Intermediate";
         }
      else if (strbl.equals("其他")) {
         queryx[0] = "select OtherKnowledge from userlist";
         strbx1[0] = "OtherKnowledge";
        }
        pstmt5 = con.prepareStatement(queryx[0]);
        rs5 = pstmt5.executeQuery();
        if (rs5.next()) {
          strx0 = rs5.getString(strbx1[0]); //调整分
          sum1 += Integer.parseInt(strx0);
          jTextField1.setText(sum1+" ");
        }
      }
      else  sum1 += 0;
      // 住宅性质
             queryb= "select * from Users where userid=?";
             pstmt5 = con.prepareStatement(queryb);
            strx0=jTextField2.getText();
            pstmt5.setString(1,strx0);
             rs5=pstmt5.executeQuery();
             if(rs5.next()){
             strbl=rs5.getString("HouseState");
             }
          if(strbl!=null) {
             if (strbl.equals("自有住房")) {
               queryx[0] = "select HaveHouse from userlist ";
               strbx1[0] = "HaveHouse";
            }
             else if (strbl.equals("贷款购房")) {
               queryx[0] = "select LoanBuyHouse from userlist";
               strbx1[0] = "LoanBuyHouse";
             }
             else if (strbl.equals("租用公房")) {
              queryx[0] = "select RentHouse from userlist";
              strbx1[0] = "RentHouse";
            }
            else if (strbl.equals("其它")) {
              queryx[0] = "select OtherHouse from userlist";
              strbx1[0] = "OtherHouse";
              }
             pstmt5 = con.prepareStatement(queryx[0]);
             rs5 = pstmt5.executeQuery();
             if (rs5.next()) {
               strx0 = rs5.getString(strbx1[0]); //调整分
               sum1 += Integer.parseInt(strx0);
               jTextField1.setText(sum1+" ");
             }
           }
           else  sum1 += 0;
           //户口性质
               queryb= "select * from Users where userid=?";
               pstmt5 = con.prepareStatement(queryb);
              strx0=jTextField2.getText();
              pstmt5.setString(1,strx0);
               rs5=pstmt5.executeQuery();
               if(rs5.next()){
               strbl=rs5.getString("RegistereState");
               }
            if(strbl!=null) {
               if (strbl.equals("常住户口")) {
                 queryx[0] = "select Cregistered from userlist ";
                 strbx1[0] = "Cregistered";
              }
               else if (strbl.equals("临时户口")) {
                 queryx[0] = "select Lregistere from userlist";
                 strbx1[0] = "Lregistere";
               }
               pstmt5 = con.prepareStatement(queryx[0]);
               rs5 = pstmt5.executeQuery();
               if (rs5.next()) {
                 strx0 = rs5.getString(strbx1[0]); //调整分
                 sum1 += Integer.parseInt(strx0);
                 jTextField1.setText(sum1+" ");
               }
             }
             else  sum1 += 0;
          // 职业类别
             queryb= "select * from view2 where userid=?";
             pstmt5 = con.prepareStatement(queryb);
            strx0=jTextField2.getText();
            pstmt5.setString(1,strx0);
             rs5=pstmt5.executeQuery();
             if(rs5.next()){
             strbl=rs5.getString("ProfessionTypes");
             }