panel.java~4~

银行信用评估系统

    column109.setDataType(com.borland.dx.dataset.Variant.INT);
    column109.setSchemaName("dbo");
    column109.setTableName("ProfessionThing");
    column109.setServerColumnName("Ysr1000");
    column109.setSqlType(4);
    column110.setCaption("31\t个人月收入1000以下");
    column110.setColumnName("Ysrxy1000");
    column110.setDataType(com.borland.dx.dataset.Variant.INT);
    column110.setSchemaName("dbo");
    column110.setTableName("ProfessionThing");
    column110.setServerColumnName("Ysrxy1000");
    column110.setSqlType(4);
    queryDataSet2.setColumns(new Column[] {column24, column26, column28, column30, column32, column34, column36, column38, column40, column42, column44,
        column46, column48, column50, column52, column94, column95, column96, column97, column98, column99, column100, column101, column102,
        column103, column104, column105, column106, column107, column108, column109, column110});
    column57.setCaption("家庭人均月收入5000以上");
    column57.setColumnName("Rjsr5q");
    column57.setDataType(com.borland.dx.dataset.Variant.INT);
    column57.setSchemaName("dbo");
    column57.setTableName("FamilyThing");
    column57.setServerColumnName("Rjsr5q");
    column57.setSqlType(4);
    //Rjsr3_5q.setCalcType(com.borland.dx.dataset.CalcType.NO_CALC);
    column61.setCaption("家庭人均月收入2000-3000");
    column61.setColumnName("Rjsr2_3q");
    column61.setDataType(com.borland.dx.dataset.Variant.INT);
    column61.setSchemaName("dbo");
    column61.setTableName("FamilyThing");
    column61.setServerColumnName("Rjsr2_3q");
    column61.setSqlType(4);
    column111.setCaption("家庭人均月收入500-1000");
    column111.setColumnName("Rjsr5b_1q");
    column111.setDataType(com.borland.dx.dataset.Variant.INT);
    column111.setSchemaName("dbo");
    column111.setTableName("FamilyThing");
    column111.setServerColumnName("Rjsr5b_1q");
    column111.setSqlType(4);
    column113.setCaption("家庭人均固定支出500以下");
    column113.setColumnName("Rjzc5b");
    column113.setDataType(com.borland.dx.dataset.Variant.INT);
    column113.setSchemaName("dbo");
    column113.setTableName("FamilyThing");
    column113.setServerColumnName("Rjzc5b");
    column113.setSqlType(4);
    //Rjzc5b_1q.setCurrency(false);
    column115.setCaption("家庭人均固定支出1000-3000");
    column115.setColumnName("Rjzc1_3q");
    column115.setDataType(com.borland.dx.dataset.Variant.INT);
    column115.setSchemaName("dbo");
    column115.setTableName("FamilyThing");
    column115.setServerColumnName("Rjzc1_3q");
    column115.setSqlType(4);
    column59.setCaption("家庭人均月收入5000以上");
    column59.setColumnName("Rjsr5q");
    column59.setDataType(com.borland.dx.dataset.Variant.INT);
    column59.setSchemaName("dbo");
    column59.setTableName("FamilyThing");
    column59.setServerColumnName("Rjsr5q");
    column59.setSqlType(4);
    //queryDataSet3.setColumns(new Column[] {column59, column61, column111, column113, column115});
    database3.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryResolver3.setDatabase(database3);
    dBDisposeMonitor3.setDataAwareComponentContainer(jPanel3);
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database3, "SELECT FamilyThing.ID,FamilyThing.Rjsr5q,FamilyThing.Rjsr3_5q,FamilyThing.Rjsr2_3q,FamilyThing.Rjsr1_" +
      "2q,FamilyThing.Rjsr5b_1q,FamilyThing.Rjsr5b,FamilyThing.Rjzc5b,FamilyThing.Rjzc5b_1q,FamilyThing.Rjzc" +
      "1_3q,FamilyThing.Rjzc3q FROM CCES.dbo.FamilyThing", null, true, Load.ALL));
    column55.setCaption("家庭人均月收入5000以上");
    column55.setColumnName("Rjsr5q");
    column55.setDataType(com.borland.dx.dataset.Variant.INT);
    column55.setSchemaName("dbo");
    column55.setTableName("FamilyThing");
    column55.setServerColumnName("Rjsr5q");
    column55.setSqlType(4);
    column63.setCaption("家庭人均月收入3000-5000");
    column63.setColumnName("Rjsr3_5q");
    column63.setDataType(com.borland.dx.dataset.Variant.INT);
    column63.setSchemaName("dbo");
    column63.setTableName("FamilyThing");
    column63.setServerColumnName("Rjsr3_5q");
    column63.setSqlType(4);
    column112.setCaption("家庭人均月收入2000-3000");
    column112.setColumnName("Rjsr2_3q");
    column112.setDataType(com.borland.dx.dataset.Variant.INT);
    column112.setSchemaName("dbo");
    column112.setTableName("FamilyThing");
    column112.setServerColumnName("Rjsr2_3q");
    column112.setSqlType(4);
    column114.setColumnName("ID");
    column114.setDataType(com.borland.dx.dataset.Variant.INT);
    column114.setRowId(true);
    column114.setSchemaName("dbo");
    column114.setTableName("FamilyThing");
    column114.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column114.setServerColumnName("ID");
    column114.setSqlType(4);
    column116.setCaption("家庭人均月收入1000-2000");
    column116.setColumnName("Rjsr1_2q");
    column116.setDataType(com.borland.dx.dataset.Variant.INT);
    column116.setSchemaName("dbo");
    column116.setTableName("FamilyThing");
    column116.setServerColumnName("Rjsr1_2q");
    column116.setSqlType(4);
    column117.setCaption("家庭人均月收入500-1000");
    column117.setColumnName("Rjsr5b_1q");
    column117.setDataType(com.borland.dx.dataset.Variant.INT);
    column117.setSchemaName("dbo");
    column117.setTableName("FamilyThing");
    column117.setServerColumnName("Rjsr5b_1q");
    column117.setSqlType(4);
    column118.setCaption("家庭人均月收入500以下");
    column118.setColumnName("Rjsr5b");
    column118.setDataType(com.borland.dx.dataset.Variant.INT);
    column118.setSchemaName("dbo");
    column118.setTableName("FamilyThing");
    column118.setServerColumnName("Rjsr5b");
    column118.setSqlType(4);
    column119.setCaption("家庭人均固定支出500以下");
    column119.setColumnName("Rjzc5b");
    column119.setDataType(com.borland.dx.dataset.Variant.INT);
    column119.setSchemaName("dbo");
    column119.setTableName("FamilyThing");
    column119.setServerColumnName("Rjzc5b");
    column119.setSqlType(4);
    column120.setCaption("家庭人均固定支出500-1000");
    column120.setColumnName("Rjzc5b_1q");
    column120.setDataType(com.borland.dx.dataset.Variant.INT);
    column120.setSchemaName("dbo");
    column120.setTableName("FamilyThing");
    column120.setServerColumnName("Rjzc5b_1q");
    column120.setSqlType(4);
    column121.setCaption("家庭人均固定支出1000-3000");
    column121.setColumnName("Rjzc1_3q");
    column121.setDataType(com.borland.dx.dataset.Variant.INT);
    column121.setSchemaName("dbo");
    column121.setTableName("FamilyThing");
    column121.setServerColumnName("Rjzc1_3q");
    column121.setSqlType(4);
    column122.setCaption("家庭人均固定支出3000以上");
    column122.setColumnName("Rjzc3q");
    column122.setDataType(com.borland.dx.dataset.Variant.INT);
    column122.setSchemaName("dbo");
    column122.setTableName("FamilyThing");
    column122.setServerColumnName("Rjzc3q");
    column122.setSqlType(4);
    queryDataSet3.setColumns(new Column[] {column114, column55, column63, column112, column116, column117, column118, column119, column120, column121,
        column122});
    queryDataSet4.setColumns(new Column[] {column64, column66, column68, column70, column72, column74, column76, column78, column80});
    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database4, "SELECT UserBank.ID,UserBank.Bhyg,UserBank.Fbhyg,UserBank.Dqhyhk,UserBank.Dq,UserBank.Yhk,UserBank.Jkh" +
      "qzh,UserBank.Wzh,UserBank.Ck3w,UserBank.Ck1_3w,UserBank.Ck1w,UserBank.Ywmq,UserBank.Ywyb,UserBank.Ywj" +
      "s,UserBank.Yjkyh,UserBank.Yyqjl,UserBank.Cwjk,UserBank.Y_ywdqjk,UserBank.W_ywdqjk " +
      "FROM CCES.dbo.UserBank", null, true, Load.ALL));
    column65.setColumnName("ID");
    column65.setDataType(com.borland.dx.dataset.Variant.INT);
    column65.setRowId(true);
    column65.setSchemaName("dbo");
    column65.setTableName("UserBank");
    column65.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column65.setServerColumnName("ID");
    column65.setSqlType(4);
    column67.setCaption("本行员工");
    column67.setColumnName("Bhyg");
    column67.setDataType(com.borland.dx.dataset.Variant.INT);
    column67.setSchemaName("dbo");
    column67.setTableName("UserBank");
    column67.setServerColumnName("Bhyg");
    column67.setSqlType(4);
    column69.setCaption("非本行员工");
    column69.setColumnName("Fbhyg");
    column69.setDataType(com.borland.dx.dataset.Variant.INT);
    column69.setSchemaName("dbo");
    column69.setTableName("UserBank");
    column69.setServerColumnName("Fbhyg");
    column69.setSqlType(4);
    column71.setCaption("定期以及银行卡");
    column71.setColumnName("Dqhyhk");
    column71.setDataType(com.borland.dx.dataset.Variant.INT);
    column71.setSchemaName("dbo");
    column71.setTableName("UserBank");
    column71.setServerColumnName("Dqhyhk");
    column71.setSqlType(4);
    column73.setCaption("定期");
    column73.setColumnName("Dq");
    column73.setDataType(com.borland.dx.dataset.Variant.INT);
    column73.setSchemaName("dbo");
    column73.setTableName("UserBank");
    column73.setServerColumnName("Dq");
    column73.setSqlType(4);
    column75.setCaption("银行卡");
    column75.setColumnName("Yhk");
    column75.setDataType(com.borland.dx.dataset.Variant.INT);
    column75.setSchemaName("dbo");
    column75.setTableName("UserBank");
    column75.setServerColumnName("Yhk");
    column75.setSqlType(4);
    column77.setCaption("活期存折帐户");
    column77.setColumnName("Jkhqzh");
    column77.setDataType(com.borland.dx.dataset.Variant.INT);
    column77.setSchemaName("dbo");
    column77.setTableName("UserBank");
    column77.setServerColumnName("Jkhqzh");
    column77.setSqlType(4);
    column79.setCaption("无帐户");
    column79.setColumnName("Wzh");
    column79.setDataType(com.borland.dx.dataset.Variant.INT);
    column79.setSchemaName("dbo");
    column79.setTableName("UserBank");
    column79.setServerColumnName("Wzh");
    column79.setSqlType(4);
    column81.setCaption("存款30000以上");
    column81.setColumnName("Ck3w");
    column81.setDataType(com.borland.dx.dataset.Variant.INT);
    column81.setSchemaName("dbo");
    column81.setTableName("UserBank");
    column81.setServerColumnName("Ck3w");
    column81.setSqlType(4);
    column123.setCaption("存款10000-30000");
    column123.setColumnName("Ck1_3w");
    column123.setDataType(com.borland.dx.dataset.Variant.INT);
    column123.setSchemaName("dbo");
    column123.setTableName("UserBank");
    column123.setServerColumnName("Ck1_3w");
    column123.setSqlType(4);
    column124.setCaption("存款10000以下");
    column124.setColumnName("Ck1w");
    column124.setDataType(com.borland.dx.dataset.Variant.INT);
    column124.setSchemaName("dbo");
    column124.setTableName("UserBank");
    column124.setServerColumnName("Ck1w");
    column124.setSqlType(4);
    column125.setCaption("业务往来密切");
    column125.setColumnName("Ywmq");
    column125.setDataType(com.borland.dx.dataset.Variant.INT);
    column125.setSchemaName("dbo");
    column125.setTableName("UserBank");
    column125.setServerColumnName("Ywmq");
    column125.setSqlType(4);
    column126.setCaption("业务往来一般");
    column126.setColumnName("Ywyb");
    column126.setDataType(com.borland.dx.dataset.Variant.INT);
    column126.setSchemaName("dbo");
    column126.setTableName("UserBank");
    column126.setServerColumnName("Ywyb");
    column126.setSqlType(4);
    column127.setCaption("业务往来较少");
    column127.setColumnName("Ywjs");
    column127.setDataType(com.borland.dx.dataset.Variant.INT);
    column127.setSchemaName("dbo");
    column127.setTableName("UserBank");
    column127.setServerColumnName("Ywjs");
    column127.setSqlType(4);
    column128.setCaption("有借款已还清");
    column128.setColumnName("Yjkyh");
    column128.setDataType(com.borland.dx.dataset.Variant.INT);
    column128.setSchemaName("dbo");
    column128.setTableName("UserBank");
    column128.setServerColumnName("Yjkyh");
    column128.setSqlType(4);
    column129.setCaption("有逾期记录");
    column129.setColumnName("Yyqjl");
    column129.setDataType(com.borland.dx.dataset.Variant.INT);
    column129.setSchemaName("dbo");
    column129.setTableName("UserBank");
    column129.setServerColumnName("Yyqjl");
    column129.setSqlType(4);
    column130.setCaption("从未借款");
    column130.setColumnName("Cwjk");
    column130.setDataType(com.borland.dx.dataset.Variant.INT);
    column130.setSchemaName("dbo");
    column130.setTableName("UserBank");
    column130.setServerColumnName("Cwjk");
    column130.setSqlType(4);
    column131.setCaption("有借款还清记录但尚有未到期借款");
    column131.setColumnName("Y_ywdqjk");
    column131.setDataType(com.borland.dx.dataset.Variant.INT);
    column131.setSchemaName("dbo");
    column131.setTableName("UserBank");
    column131.setServerColumnName("Y_ywdqjk");
    column131.setSqlType(4);
    column132.setCaption("无借款还清记录但尚有未到期借款");
    column132.setColumnName("W_ywdqjk");
    column132.setDataType(com.borland.dx.dataset.Variant.INT);
    column132.setSchemaName("dbo");
    column132.setTableName("UserBank");
    column132.setServerColumnName("W_ywdqjk");
    column132.setSqlType(4);
    queryDataSet4.setColumns(new Column[] {column65, column67, column69, column71, column73, column75, column77, column79, column81, column123, column124,
        column125, column126, column127, column128, column129, column130, column131, column132});
    jPanel1.setBackground(new Color(217, 230, 236));
    this.add(jTabbedPane1, BorderLayout.CENTER);
    jTabbedPane1.add(jPanel1,   "自然情况");
    jPanel1.add(jdbNavToolBar1, null);
    jPanel1.add(tableScrollPane1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jTabbedPane1.add(jPanel2,   "职业情况");
    jPanel2.add(jdbNavToolBar2, null);
    jPanel2.add(tableScrollPane2, null);
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jTabbedPane1.add(jPanel3,  "家庭情况");
    jPanel3.add(tableScrollPane3, null);
    jPanel3.add(jdbNavToolBar3, null);
    jTabbedPane1.add(jPanel4,  "与本行关系");
    jPanel4.add(tableScrollPane4, null);
    jPanel4.add(jdbNavToolBar4, null);
    tableScrollPane4.getViewport().add(jdbTable4, null);
    tableScrollPane3.getViewport().add(jdbTable3, null);
  }
}