testpanel.java~65~
来自「银行信用评估系统」· JAVA~65~ 代码 · 共 888 行 · 第 1/3 页
JAVA~65~
888 行
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()){
strbl=rs5.getString("AccountType");
}
if(strbl!=null) {
if (strbl.equals("定期以及银行卡")) {
queryx[0] = "select Dqhyhk from UserBank ";
strbx1[0] = "Dqhyhk";
}
else if (strbl.equals("定期")) {
queryx[0] = "select Dq from UserBank";
strbx1[0] = "Dq";
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?