testpanel.java~59~

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

             else if (strbl.equals("教师、医生")) {
               queryx[0] = "select Jshys from ProfessionThing";
               strbx1[0] = "Jshys";
             }
             else if (strbl.equals("金融、律师")) {
              queryx[0] = "select Jrhls from ProfessionThing";
              strbx1[0] = "Jrhls";
            }
            else if (strbl.equals("军人、记者")) {
              queryx[0] = "select Jrhjz from ProfessionThing";
              strbx1[0] = "Jrhjz";
              }
           else if (strbl.equals("企业主、公司职员")) {
              queryx[0] = "select Qyzhgszy from ProfessionThing";
              strbx1[0] = "Qyzhgszy";
             }
          else if (strbl.equals("其它职业")) {
             queryx[0] = "select Qtzy from ProfessionThing";
             strbx1[0] = "Qtzy";
            }
             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 view3 where userid=?";
               pstmt5 = con.prepareStatement(queryb);
              strx0="1000";
              pstmt5.setString(1,strx0);
               rs5=pstmt5.executeQuery();
               if(rs5.next()){
               strbl=rs5.getString("WorkingFirm");
               }
            if(strbl!=null) {
               if (strbl.equals("5年以上")) {
                 queryx[0] = "select Gz5n from ProfessionThing ";
                 strbx1[0] = "Gz5n";
              }
               else if (strbl.equals("3-5年")) {
                 queryx[0] = "select Gz3_5n from ProfessionThing";
                 strbx1[0] = "Gz3_5n";
               }
               else if (strbl.equals("1-3年")) {
                queryx[0] = "select Gz1_3n from ProfessionThing";
                strbx1[0] = "Gz1_3n";
              }
              else if (strbl.equals("1年以内")) {
                queryx[0] = "select Gzxy1n from ProfessionThing";
                strbx1[0] = "Gzxy1n";
                }
               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 view3 where userid=?";
            pstmt5 = con.prepareStatement(queryb);
           strx0="1000";
           pstmt5.setString(1,strx0);
            rs5=pstmt5.executeQuery();
            if(rs5.next()){
            strbl=rs5.getString("WorkingState");
            }
         if(strbl!=null) {
            if (strbl.equals("厅局级以上")) {
              queryx[0] = "select Tjys from ProfessionThing ";
              strbx1[0] = "Tjys";
           }
            else if (strbl.equals("处级")) {
              queryx[0] = "select Cj from ProfessionThing";
              strbx1[0] = "Cj";
            }
            else if (strbl.equals("科级")) {
             queryx[0] = "select Kj from ProfessionThing";
             strbx1[0] = "Kj";
           }
           else if (strbl.equals("一般机关干部")) {
             queryx[0] = "select Ybgjgb from ProfessionThing";
             strbx1[0] = "Ybgjgb";
             }
          else if (strbl.equals("其他机关员工")) {
           queryx[0] = "select Qtgjgb from ProfessionThing";
           strbx1[0] = "Qtgjgb";
           }
           else if (strbl.equals("正副总经理")) {
            queryx[0] = "select Zfzjl from ProfessionThing";
            strbx1[0] = "Zfzjl";
            }
          else if (strbl.equals("部门经理")) {
              queryx[0] = "select Bmjl from ProfessionThing";
              strbx1[0] = "Bmjl";
            }
         else if (strbl.equals("一般企业干部")) {
               queryx[0] = "select Ybqygb from ProfessionThing";
               strbx1[0] = "Ybqygb";
            }
         else if (strbl.equals("其他企业员工")) {
          queryx[0] = "select Qtqyzy from ProfessionThing";
          strbx1[0] = "Qtqyzy";
      }
            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 view3 where userid=?";
                pstmt5 = con.prepareStatement(queryb);
               strx0="1000";
               pstmt5.setString(1,strx0);
                rs5=pstmt5.executeQuery();
                if(rs5.next()){
                strbl=rs5.getString("IndividualIcome");
                }
             if(strbl!=null) {
                if (strbl.equals("10000元以上")) {
                  queryx[0] = "select Ysr10000 from ProfessionThing ";
                  strbx1[0] = "Ysr10000";
               }
                else if (strbl.equals("8000-10000元")) {
                  queryx[0] = "select Ysr8000 from ProfessionThing";
                  strbx1[0] = "Ysr8000";
                }
                else if (strbl.equals("5000-8000元")) {
                 queryx[0] = "select Ysr5000 from ProfessionThing";
                 strbx1[0] = "Ysr5000";
               }
               else if (strbl.equals("4000-5000元")) {
                 queryx[0] = "select Ysr4000 from ProfessionThing";
                 strbx1[0] = "Ysr4000";
                 }
                 else if (strbl.equals("3000-4000元")) {
                queryx[0] = "select Ysr3000 from ProfessionThing";
                strbx1[0] = "Ysr3000";
                }
                else if (strbl.equals("2000-3000元")) {
              queryx[0] = "select Ysr2000 from ProfessionThing";
              strbx1[0] = "Ysr2000";
              }
              else if (strbl.equals("1000-2000元")) {
             queryx[0] = "select Ysr1000 from ProfessionThing";
             strbx1[0] = "Ysr1000";
             }
             else if (strbl.equals("1000元以下")) {
             queryx[0] = "select Ysrxy1000 from ProfessionThing";
              strbx1[0] = "Ysrxy1000";
            }

                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 view3 where userid=?";
                   pstmt5 = con.prepareStatement(queryb);
                  strx0="1000";
                  pstmt5.setString(1,strx0);
                   rs5=pstmt5.executeQuery();
                   if(rs5.next()){
                   strbl=rs5.getString("WorkingPost");
                   }
                if(strbl!=null) {
                   if (strbl.equals("高级")) {
                     queryx[0] = "select Gj from ProfessionThing ";
                     strbx1[0] = "Gj";
                  }
                   else if (strbl.equals("中级")) {
                     queryx[0] = "select Zj from ProfessionThing";
                     strbx1[0] = "Zj";
                   }
                   else if (strbl.equals("初级")) {
                    queryx[0] = "select Cjj from ProfessionThing";
                    strbx1[0] = "Cjj";
                  }
                  else if (strbl.equals("无")) {
                    queryx[0] = "select Mei from ProfessionThing";
                    strbx1[0] = "Mei";
                    }
                   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("AverageIcome");
                        }
                     if(strbl!=null) {
                        if (strbl.equals("5000元以上")) {
                          queryx[0] = "select Rjsr5q from FamilyThing ";
                          strbx1[0] = "Rjsr5q";
                       }
                        else if (strbl.equals("3000-5000元")) {
                          queryx[0] = "select Rjsr3_5q from FamilyThing";
                          strbx1[0] = "Rjsr3_5q";
                        }
                        else if (strbl.equals("2000-3000元")) {
                         queryx[0] = "select Rjsr2_3q from FamilyThing";
                         strbx1[0] = "Rjsr2_3q";
                       }
                       else if (strbl.equals("1000-2000元")) {
                         queryx[0] = "select Rjsr1_2q from FamilyThing";
                         strbx1[0] = "Rjsr1_2q";
                         }
                        else if (strbl.equals("500-1000元")) {
                           queryx[0] = "select Rjsr5b_1q from FamilyThing";
                           strbx1[0] = "Rjsr5b_1q";
                           }
                        else if (strbl.equals("500元以下")) {
                             queryx[0] = "select Rjsr5b from FamilyThing";
                             strbx1[0] = "Rjsr5b";
                             }
                        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("AverageExpend");
                                 }
                              if(strbl!=null) {
                                 if (strbl.equals("500元以下")) {
                                   queryx[0] = "select Rjzc5b from FamilyThing ";
                                   strbx1[0] = "Rjzc5b";
                                }
                                 else if (strbl.equals("500-1000元")) {
                                   queryx[0] = "select Rjzc5b_1q from FamilyThing";
                                   strbx1[0] = "Rjzc5b_1q";
                                 }
                                 else if (strbl.equals("1000-3000元")) {
                                  queryx[0] = "select Rjzc1_3q from FamilyThing";
                                  strbx1[0] = "Rjzc1_3q";
                                }
                                else if (strbl.equals("3000元以上")) {
                                  queryx[0] = "select Rjzc3q from FamilyThing";
                                  strbx1[0] = "Rjzc3q";
                                  }
                                 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 view4 where userid=?";
                                          pstmt5 = con.prepareStatement(queryb);
                                         strx0="1000";
                                         pstmt5.setString(1,strx0);
                                          rs5=pstmt5.executeQuery();
                                          if(rs5.next()){