testpanel.java~62~

来自「银行信用评估系统」· JAVA~62~ 代码 · 共 881 行 · 第 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();

  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("");
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(286, 35, 143, 23));
    this.setLayout(null);
    jLabel1.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel1.setText("请输入自主分(<=20分)：");
    jLabel1.setBounds(new Rectangle(15, 29, 258, 30));
    jButton1.setBounds(new Rectangle(84, 81, 73, 25));
    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("该用户的信用等级为：");
    jLabel3.setBounds(new Rectangle(12, 173, 235, 40));
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel4.setBorder(titledBorder2);
    jLabel4.setDebugGraphicsOptions(0);
    jLabel4.setText("");
    jLabel4.setBounds(new Rectangle(264, 183, 153, 24));
    jLabel5.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel5.setText("该用户的透支额为：");
    jLabel5.setBounds(new Rectangle(13, 231, 214, 25));
    jLabel6.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel6.setBorder(titledBorder4);
    jLabel6.setText("");
    jLabel6.setBounds(new Rectangle(263, 235, 153, 24));

      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
       String url = "jdbc:microsoft:sqlserver://huadi-1k32:1433;DatabaseName=CCES";
       String username= "sa";
       String password= "";
       con = DriverManager.getConnection(url,username,password);

    jLabel2.setFont(new java.awt.Font("宋体", 1, 22));
    jLabel2.setText("该用户的初评分为：");
    jLabel2.setBounds(new Rectangle(13, 133, 229, 26));
    jLabel7.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel7.setBorder(titledBorder5);
    jLabel7.setText("");
    jLabel7.setBounds(new Rectangle(263, 137, 154, 25));
    jButton2.setBounds(new Rectangle(223, 80, 73, 25));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setToolTipText("");
    jButton2.setText("返回");
    jButton2.addActionListener(new testPanel_jButton2_actionAdapter(this));
    this.add(jLabel1, null);
    this.add(jTextField1, null);
    this.add(jLabel4, null);
    this.add(jLabel6, null);
    this.add(jLabel5, null);
    this.add(jLabel3, null);
    this.add(jLabel2, null);
    this.add(jLabel7, null);
    this.add(jButton1, null);
    this.add(jButton2, null);
  }
  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="1000";
         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="1000";
     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="1000";
       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="1000";
            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="1000";
              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="1000";
            pstmt5.setString(1,strx0);
             rs5=pstmt5.executeQuery();
             if(rs5.next()){
             strbl=rs5.getString("ProfessionTypes");
             }
          if(strbl!=null) {
             if (strbl.equals("公务员")) {
               queryx[0] = "select Gwy from ProfessionThing ";
               strbx1[0] = "Gwy";
            }
             else if (strbl.equals("教师、医生")) {
               queryx[0] = "select Jshys from ProfessionThing";
               strbx1[0] = "Jshys";