testpanel.java~65~
来自「银行信用评估系统」· JAVA~65~ 代码 · 共 888 行 · 第 1/3 页
JAVA~65~
888 行
}
else if (strbl.equals("银行卡")) {
queryx[0] = "select Yhk from UserBank";
strbx1[0] = "Yhk";
}
else if (strbl.equals("仅开立活期存折帐户")) {
queryx[0] = "select Jkhqzh from UserBank";
strbx1[0] = "Jkhqzh";
}
else if (strbl.equals("无帐户")) {
queryx[0] = "select Wzh from UserBank";
strbx1[0] = "Wzh";
}
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("UserAge");
}
if(strbl!=null) {
int a=Integer.parseInt(strbl);
if (18<=a && 22>=a) {
queryx[0] = "select Callan from userlist ";
strbx1[0] = "Callan";
}
else if (23<=a && 34>=a) {
queryx[0] = "select Youth from userlist";
strbx1[0] = "Youth";
}
else if (35<=a && 40>=a) {
queryx[0] = "select Midlife from userlist";
strbx1[0] = "Midlife";
}
else if (41<=a && 60>=a) {
queryx[0] = "select Adiaphorous from userlist";
strbx1[0] = "Adiaphorous";
}
else if (61<=a ) {
queryx[0] = "select Agedness from userlist";
strbx1[0] = "Agedness";
}
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 view5 where userid=?";
pstmt5 = con.prepareStatement(queryb);
strx0="1000";
pstmt5.setString(1,strx0);
rs5=pstmt5.executeQuery();
if(rs5.next()){
strbl=rs5.getString("UseNum");
}
if(strbl!=null) {
int a=Integer.parseInt(strbl);
if (2>a) {
queryx[0] = "select Ywjs from UserBank ";
strbx1[0] = "Ywjs";
}
else if (6>=a && 2<=a) {
queryx[0] = "select Ywyb from UserBank ";
strbx1[0] = "Ywyb";
}
else if (6<a ) {
queryx[0] = "select Ywmq from UserBank";
strbx1[0] = "Ywmq";
}
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("UserCard");
strbl=strbl.trim();
}
if(strbl!=null) {
queryx[0] = "select * from YHworker where YHworkerCard=?";
strbx1[0] = "YHworkerCard";
pstmt5 = con.prepareStatement(queryx[0]);
pstmt5.setString(1,strbl);
rs5 = pstmt5.executeQuery();
if (rs5.next()) {
sum1 +=2;
}
else {
sum1 +=0;
}
jTextField1.setText(sum1+" ");
}
else sum1 += 0;
//借款情况
queryb= "select * from view6 where userid=?";
pstmt5 = con.prepareStatement(queryb);
strx0="1000";
pstmt5.setString(1,strx0);
rs5=pstmt5.executeQuery();
if(rs5.next()){
strbl=rs5.getString("UseState");
}
if(strbl!=null) {
if (strbl.equals("有借款已还清")) {
queryx[0] = "select Yjkyh from UserBank ";
strbx1[0] = "Yjkyh";
}
else if (strbl.equals("有逾期记录")) {
queryx[0] = "select Yyqjl from UserBank";
strbx1[0] = "Yyqjl";
}
else if (strbl.equals("从未借款")) {
queryx[0] = "select Cwjk from UserBank";
strbx1[0] = "Cwjk";
}
else if (strbl.equals("有借款还清记录，但尚有未到期借款")) {
queryx[0] = "select Y_ywdqjk from UserBank";
strbx1[0] = "Y_ywdqjk";
}
else if (strbl.equals("无借款还清记录，但尚有未到期借款")) {
queryx[0] = "select W_ywdqjk from UserBank";
strbx1[0] = "W_ywdqjk";
}
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 view7 where userid=?";
pstmt5 = con.prepareStatement(queryb);
strx0="1000";
pstmt5.setString(1,strx0);
rs5=pstmt5.executeQuery();
if(rs5.next()){
strbl=rs5.getString("AccountDeposit");
}
if(strbl!=null) {
int a=Integer.parseInt(strbl);
if (10000>a) {
queryx[0] = "select Ck1w from UserBank ";
strbx1[0] = "Ck1w";
}
else if (30000>=a && 10000<=a) {
queryx[0] = "select Ck1_3w from UserBank ";
strbx1[0] = "Ck1_3w";
}
else if (30000<a ) {
queryx[0] = "select Ck3w from UserBank";
strbx1[0] = "Ck3w";
}
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;
}
catch(Exception ef)
{ System.out.print("系统错误，请重新运行。"+ef.getClass().getName());
ef.printStackTrace();
}
return sum1;
}
void jButton1_actionPerformed(ActionEvent e) {
String m=jTextField1.getText();
String c=m;
try
{
int i = Integer.parseInt(m);
if (i <= 20 && 0 <= i) {
i = i + this.Badrecordadjust();
jLabel7.setText(i + " ");
if (120 >= i && 100 <= i) {
jLabel4.setText("A");
jLabel6.setText("50000元");
}
else if (100 > i && 90 <= i) {
jLabel4.setText("B");
jLabel6.setText("40000元");
}
else if (90 > i && 80 <= i) {
jLabel4.setText("C");
jLabel6.setText("30000元");
}
else if (80 > i && 70 <= i) {
jLabel4.setText("D");
jLabel6.setText("20000元");
}
else if (70 > i && 60 <= i) {
jLabel4.setText("E");
jLabel6.setText("10000元");
}
else if (60 > i && 50 <= i) {
jLabel4.setText("F");
jLabel6.setText("5000元");
}
else if (50 > i && 35 <= i) {
jLabel4.setText("G");
jLabel6.setText("2000元");
}
else {
jLabel4.setText("H");
jLabel6.setText("0元");
}
jTextField1.setText(c);
c = "1000";
String qur =
"insert into Creditcard(UserId,CreditcardGrade,CreditcardCode) values('" +
c + "\'" + "," + "\'" + jLabel4.getText() + "\'" + ",'000')";
Statement ps;
ps = con.createStatement();
ps.execute(qur);
String qur1 = "update Users set CpCredit='" + jLabel7.getText() +
"' where UserId=" + "\'" + c + "\'";
ps = con.createStatement();
ps.execute(qur1);
}
else jTextField1.setText("请输入小于20的正整数");
}
catch(Exception eff)
{ jTextField1.setText("请输入数字，谢谢合作！");
}
}
void jButton2_actionPerformed(ActionEvent e) {
eventFrame.jSplitPane1.remove(eventFrame.jSplitPane1.getRightComponent());
eventFrame.jSplitPane1.add(new helloPanel(),eventFrame.jSplitPane1.RIGHT);
}
}
class testPanel_jButton1_actionAdapter implements java.awt.event.ActionListener {
testPanel adaptee;
testPanel_jButton1_actionAdapter(testPanel adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class testPanel_jButton2_actionAdapter implements java.awt.event.ActionListener {
testPanel adaptee;
testPanel_jButton2_actionAdapter(testPanel adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?