panel.java~4~

银行信用评估系统

    column25.setDataType(com.borland.dx.dataset.Variant.INT);
    column25.setSchemaName("dbo");
    column25.setTableName("ProfessionThing");
    column25.setServerColumnName("Jrhls");
    column25.setSqlType(4);
    database2.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    database2.setDatabaseName("");
    column41.setCaption("企业其他干部");
    column41.setColumnName("Qtqyzy");
    column41.setDataType(com.borland.dx.dataset.Variant.INT);
    column41.setSchemaName("dbo");
    column41.setTableName("ProfessionThing");
    column41.setServerColumnName("Qtqyzy");
    column41.setSqlType(4);
    column47.setCaption("个人月收入8000-10000");
    column47.setColumnName("Ysr8000");
    column47.setDataType(com.borland.dx.dataset.Variant.INT);
    column47.setSchemaName("dbo");
    column47.setTableName("ProfessionThing");
    column47.setServerColumnName("Ysr8000");
    column47.setSqlType(4);
    column45.setCaption("无职称");
    column45.setColumnName("Mei");
    column45.setDataType(com.borland.dx.dataset.Variant.INT);
    column45.setSchemaName("dbo");
    column45.setTableName("ProfessionThing");
    column45.setServerColumnName("Mei");
    column45.setSqlType(4);
    column53.setCaption("个人月收入1000以下");
    column53.setColumnName("Ysrxy1000");
    column53.setDataType(com.borland.dx.dataset.Variant.INT);
    column53.setSchemaName("dbo");
    column53.setTableName("ProfessionThing");
    column53.setServerColumnName("Ysrxy1000");
    column53.setSqlType(4);
    column23.setCaption("公务员");
    column23.setColumnName("Gwy");
    column23.setDataType(com.borland.dx.dataset.Variant.INT);
    column23.setSchemaName("dbo");
    column23.setTableName("ProfessionThing");
    column23.setServerColumnName("Gwy");
    column23.setSqlType(4);
    column31.setCaption("现单位1-3年");
    column31.setColumnName("Gz1_3n");
    column31.setDataType(com.borland.dx.dataset.Variant.INT);
    column31.setSchemaName("dbo");
    column31.setTableName("ProfessionThing");
    column31.setServerColumnName("Gz1_3n");
    column31.setSqlType(4);
    column39.setCaption("企业部门经理");
    column39.setColumnName("Bmjl");
    column39.setDataType(com.borland.dx.dataset.Variant.INT);
    column39.setSchemaName("dbo");
    column39.setTableName("ProfessionThing");
    column39.setServerColumnName("Bmjl");
    column39.setSqlType(4);
    column51.setCaption("个人月收入2000-3000");
    column51.setColumnName("Ysr2000");
    column51.setDataType(com.borland.dx.dataset.Variant.INT);
    column51.setSchemaName("dbo");
    column51.setTableName("ProfessionThing");
    column51.setServerColumnName("Ysr2000");
    column51.setSqlType(4);
    dBDisposeMonitor2.setDataAwareComponentContainer(jPanel2);
    column37.setCaption("机关其他干部");
    column37.setColumnName("Qtgjgb");
    column37.setDataType(com.borland.dx.dataset.Variant.INT);
    column37.setSchemaName("dbo");
    column37.setTableName("ProfessionThing");
    column37.setServerColumnName("Qtgjgb");
    column37.setSqlType(4);
    column29.setCaption("现单位5年以上");
    column29.setColumnName("Gz5n");
    column29.setDataType(com.borland.dx.dataset.Variant.INT);
    column29.setSchemaName("dbo");
    column29.setTableName("ProfessionThing");
    column29.setServerColumnName("Gz5n");
    column29.setSqlType(4);
    column43.setCaption("职称中级");
    column43.setColumnName("Zj");
    column43.setDataType(com.borland.dx.dataset.Variant.INT);
    column43.setSchemaName("dbo");
    column43.setTableName("ProfessionThing");
    column43.setServerColumnName("Zj");
    column43.setSqlType(4);
    column35.setCaption("机关科级");
    column35.setColumnName("Kj");
    column35.setDataType(com.borland.dx.dataset.Variant.INT);
    column35.setSchemaName("dbo");
    column35.setTableName("ProfessionThing");
    column35.setServerColumnName("Kj");
    column35.setSqlType(4);
    queryResolver2.setDatabase(database2);
    queryResolver2.setUpdateMode(com.borland.dx.dataset.UpdateMode.ALL_COLUMNS);
    queryResolver2.setResolverQueryTimeout(0);
    jdbTable2.setSelectionBackground(Color.white);
    jdbTable2.setSelectionForeground(Color.black);
    jdbTable2.setDataSet(queryDataSet2);
    jdbNavToolBar1.setBackground(new Color(217, 230, 236));
    jdbNavToolBar1.setButtonStateSave(JdbNavToolBar.AUTO_ENABLED);
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jdbNavToolBar1.setBounds(new Rectangle(8, 7, 362, 42));
    jdbNavToolBar2.setDataSet(queryDataSet2);
    jdbNavToolBar2.setBounds(new Rectangle(8, 7, 362, 42));
    column62.setCaption("家庭人均固定支出1000-3000");
    column62.setColumnName("Rjzc1_3q");
    column62.setDataType(com.borland.dx.dataset.Variant.INT);
    column62.setSchemaName("dbo");
    column62.setTableName("FamilyThing");
    column62.setServerColumnName("Rjzc1_3q");
    column62.setSqlType(4);
    column60.setCaption("家庭人均固定支出500以下");
    column60.setColumnName("Rjzc5b");
    column60.setDataType(com.borland.dx.dataset.Variant.INT);
    column60.setSchemaName("dbo");
    column60.setTableName("FamilyThing");
    column60.setServerColumnName("Rjzc5b");
    column60.setSqlType(4);
    column54.setCaption("人均月收入5000以上");
    column54.setColumnName("Rjsr5q");
    column54.setDataType(com.borland.dx.dataset.Variant.INT);
    column54.setSchemaName("dbo");
    column54.setTableName("FamilyThing");
    column54.setServerColumnName("Rjsr5q");
    column54.setSqlType(4);
    column56.setCaption("家庭人均月收入2000-3000");
    column56.setColumnName("Rjsr2_3q");
    column56.setDataType(com.borland.dx.dataset.Variant.INT);
    column56.setSchemaName("dbo");
    column56.setTableName("FamilyThing");
    column56.setServerColumnName("Rjsr2_3q");
    column56.setSqlType(4);
    column58.setCaption("家庭人均月收入500-1000");
    column58.setColumnName("Rjsr5b_1q");
    column58.setDataType(com.borland.dx.dataset.Variant.INT);
    column58.setSchemaName("dbo");
    column58.setTableName("FamilyThing");
    column58.setServerColumnName("Rjsr5b_1q");
    column58.setSqlType(4);
    jPanel3.setLayout(null);
    tableScrollPane3.setBounds(new Rectangle(2, 60, 612, 88));
    jdbTable3.setSelectionBackground(Color.white);
    jdbTable3.setSelectionForeground(Color.black);
    jdbTable3.setDataSet(queryDataSet3);
    jPanel4.setLayout(null);
    tableScrollPane4.setBounds(new Rectangle(2, 60, 612, 88));
    column74.setCaption("业务往来密切");
    column74.setColumnName("Ywmq");
    column74.setDataType(com.borland.dx.dataset.Variant.INT);
    column74.setSchemaName("dbo");
    column74.setTableName("UserBank");
    column74.setServerColumnName("Ywmq");
    column74.setSqlType(4);
    dBDisposeMonitor4.setDataAwareComponentContainer(jPanel4);
    queryResolver4.setDatabase(database4);
    column64.setCaption("本行员工");
    column64.setColumnName("Bhyg");
    column64.setDataType(com.borland.dx.dataset.Variant.INT);
    column64.setSchemaName("dbo");
    column64.setTableName("UserBank");
    column64.setServerColumnName("Bhyg");
    column64.setSqlType(4);
    database4.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    column76.setCaption("业务往来较少");
    column76.setColumnName("Ywjs");
    column76.setDataType(com.borland.dx.dataset.Variant.INT);
    column76.setSchemaName("dbo");
    column76.setTableName("UserBank");
    column76.setServerColumnName("Ywjs");
    column76.setSqlType(4);
    column70.setCaption("无帐户");
    column70.setColumnName("Wzh");
    column70.setDataType(com.borland.dx.dataset.Variant.INT);
    column70.setSchemaName("dbo");
    column70.setTableName("UserBank");
    column70.setServerColumnName("Wzh");
    column70.setSqlType(4);
    column66.setCaption("定期以及银行卡");
    column66.setColumnName("Dqhyhk");
    column66.setDataType(com.borland.dx.dataset.Variant.INT);
    column66.setSchemaName("dbo");
    column66.setTableName("UserBank");
    column66.setServerColumnName("Dqhyhk");
    column66.setSqlType(4);
    column72.setCaption("存款10000-30000");
    column72.setColumnName("Ck1_3w");
    column72.setDataType(com.borland.dx.dataset.Variant.INT);
    column72.setSchemaName("dbo");
    column72.setTableName("UserBank");
    column72.setServerColumnName("Ck1_3w");
    column72.setSqlType(4);
    column80.setCaption("有借款还清记录但尚有未到期借款");
    column80.setColumnName("Y_ywdqjk");
    column80.setDataType(com.borland.dx.dataset.Variant.INT);
    column80.setSchemaName("dbo");
    column80.setTableName("UserBank");
    column80.setServerColumnName("Y_ywdqjk");
    column80.setSqlType(4);
    column68.setCaption("银行卡");
    column68.setColumnName("Yhk");
    column68.setDataType(com.borland.dx.dataset.Variant.INT);
    column68.setSchemaName("dbo");
    column68.setTableName("UserBank");
    column68.setServerColumnName("Yhk");
    column68.setSqlType(4);
    column78.setCaption("有逾期记录");
    column78.setColumnName("Yyqjl");
    column78.setDataType(com.borland.dx.dataset.Variant.INT);
    column78.setSchemaName("dbo");
    column78.setTableName("UserBank");
    column78.setServerColumnName("Yyqjl");
    column78.setSqlType(4);
    jdbTable4.setSelectionBackground(Color.white);
    jdbTable4.setSelectionForeground(Color.black);
    jdbTable4.setDataSet(queryDataSet4);
    jdbNavToolBar3.setDebugGraphicsOptions(0);
    jdbNavToolBar3.setDataSet(queryDataSet3);
    jdbNavToolBar3.setBounds(new Rectangle(8, 7, 362, 42));
    jdbNavToolBar4.setDataSet(queryDataSet4);
    jdbNavToolBar4.setBounds(new Rectangle(8, 7, 362, 42));
    queryResolver1.setDatabase(database1);
    queryResolver1.setUpdateMode(com.borland.dx.dataset.UpdateMode.UNASSIGNED);
    queryResolver1.setResolverQueryTimeout(0);
    this.setFont(new java.awt.Font("宋体", 0, 13));
    this.setForeground(Color.black);
    jTabbedPane1.setBackground(new Color(217, 230, 236));
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 13));
    queryDataSet1.setColumns(new Column[] {column1, column3, column5, column7, column9, column11, column13, column15, column17, column19, column21});
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT UserList.ID,UserList.Callan,UserList.Youth,UserList.Midlife,UserList.Adiaphorous,UserList.Aged" +
      "ness,UserList.Male,UserList.Female,UserList.MarriedBaby,UserList.MarriedNoBaby,UserList.Nomarry,UserL" +
      "ist.OtherMarry,UserList.GraduateS,UserList.UnGraduateS,UserList.Junior,UserList.Intermediate,UserList" +
      ".OtherKnowledge,UserList.Cregistered,UserList.Lregistere,UserList.HaveHouse,UserList.LoanBuyHouse,Use" +
      "rList.RentHouse,UserList.OtherHouse FROM CCES.dbo.UserList", null, true, Load.ALL));
    column2.setColumnName("ID");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setRowId(true);
    column2.setSchemaName("dbo");
    column2.setTableName("UserList");
    column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column2.setServerColumnName("ID");
    column2.setSqlType(4);
    column4.setCaption("18-22岁");
    column4.setColumnName("Callan");
    column4.setDataType(com.borland.dx.dataset.Variant.INT);
    column4.setSchemaName("dbo");
    column4.setTableName("UserList");
    column4.setServerColumnName("Callan");
    column4.setSqlType(4);
    column6.setCaption("23-34岁");
    column6.setColumnName("Youth");
    column6.setDataType(com.borland.dx.dataset.Variant.INT);
    column6.setSchemaName("dbo");
    column6.setTableName("UserList");
    column6.setServerColumnName("Youth");
    column6.setSqlType(4);
    column8.setCaption("35-40岁");
    column8.setColumnName("Midlife");
    column8.setDataType(com.borland.dx.dataset.Variant.INT);
    column8.setSchemaName("dbo");
    column8.setTableName("UserList");
    column8.setServerColumnName("Midlife");
    column8.setSqlType(4);
    column10.setCaption("41-60岁");
    column10.setColumnName("Adiaphorous");
    column10.setDataType(com.borland.dx.dataset.Variant.INT);
    column10.setSchemaName("dbo");
    column10.setTableName("UserList");
    column10.setServerColumnName("Adiaphorous");
    column10.setSqlType(4);
    column12.setCaption("61岁以上");
    column12.setColumnName("Agedness");
    column12.setDataType(com.borland.dx.dataset.Variant.INT);
    column12.setSchemaName("dbo");
    column12.setTableName("UserList");
    column12.setServerColumnName("Agedness");
    column12.setSqlType(4);
    column14.setCaption("男");
    column14.setColumnName("Male");
    column14.setDataType(com.borland.dx.dataset.Variant.INT);
    column14.setSchemaName("dbo");
    column14.setTableName("UserList");
    column14.setServerColumnName("Male");
    column14.setSqlType(4);
    column16.setCaption("女");
    column16.setColumnName("Female");
    column16.setDataType(com.borland.dx.dataset.Variant.INT);
    column16.setSchemaName("dbo");
    column16.setTableName("UserList");
    column16.setServerColumnName("Female");
    column16.setSqlType(4);
    column18.setCaption("已婚有子女");
    column18.setColumnName("MarriedBaby");
    column18.setDataType(com.borland.dx.dataset.Variant.INT);
    column18.setSchemaName("dbo");
    column18.setTableName("UserList");
    column18.setServerColumnName("MarriedBaby");
    column18.setSqlType(4);
    column20.setCaption("已婚无子女");
    column20.setColumnName("MarriedNoBaby");
    column20.setDataType(com.borland.dx.dataset.Variant.INT);
    column20.setSchemaName("dbo");
    column20.setTableName("UserList");
    column20.setServerColumnName("MarriedNoBaby");
    column20.setSqlType(4);
    column22.setCaption("未婚");
    column22.setColumnName("Nomarry");
    column22.setDataType(com.borland.dx.dataset.Variant.INT);
    column22.setSchemaName("dbo");
    column22.setTableName("UserList");
    column22.setServerColumnName("Nomarry");