mysql 二维表 查询_二维报表数据表设计

报表原型: 这里随便挑了一个二维报表 二维报表设计分析: 上面的报表原型行和列都有数据项，我们可以根据地理位置的经纬度定坐标点的思想来进行设计 这里使用列行来表示 c1r1表示第一列第一行 c1r2表示第一列第二行 ..... c2r1表示第二列第一行 c2r2表示第二

报表原型:

这里随便挑了一个二维报表

二维报表设计分析:

上面的报表原型行和列都有数据项，我们可以根据地理位置的经纬度定坐标点的思想来进行设计

这里使用列行来表示

c1r1表示第一列第一行

c1r2表示第一列第二行

.....

c2r1表示第二列第一行

c2r2表示第二列第二行

......

以此类推

报表Bean信息

/**

*@author xiaoqun.yi

*选矿技术经济指标报表

*R:报表

*r:行 可扩展

*c:列 可扩展

*r*c====指标值项数即相当于数据库中的迪卡尔积

*/

public class RxkjsjjzbBean {

private int id;//主键

private int report_id;//报表id,外键

/*统计日期指标*/

private String year;//年 yyyy length:4

private String month;//月mm 如果是月报，必用此字段 length:2

private String day;//如果是日报，必用此字段dd length:2

private String yearmonth;//yyyymm,月报查询条件用 lenght:6

/*计算所有数据项的总和，若有需要可使用*/

private float sum;

/*计算每列的数值和,不作为数据表字段*/

private float c1_sum;//c1r1-c1r19之和

private float c2_sum;//c2r1-c2r19之和

private float c3_sum;//c3r1-c3r19之和

private float c4_sum;//c4r1-c4r19之和

private float c5_sum;//c5r1-c5r19之和

/*计算每行的数值和,不作为数据表字段*/

private float r1_sum;//r1c1-r1c5之和,其下以此类推

private float r2_sum;

private float r3_sum;

private float r4_sum;

private float r5_sum;

private float r6_sum;

private float r7_sum;

private float r8_sum;

private float r9_sum;

private float r10_sum;

private float r11_sum;

private float r12_sum;

private float r13_sum;

private float r14_sum;

private float r15_sum;

private float r16_sum;

private float r17_sum;

private float r18_sum;

private float r19_sum;

/*第1列1-n行*/

private float c1r1;

private float c1r2;

private float c1r3;

private float c1r4;

private float c1r5;

private float c1r6;

private float c1r7;

private float c1r8;

private float c1r9;

private float c1r10;

private float c1r11;

private float c1r12;

private float c1r13;

private float c1r14;

private float c1r15;

private float c1r16;

private float c1r17;

private float c1r18;

private float c1r19;

/*第2列1-n行*/

private float c2r1;

private float c2r2;

private float c2r3;

private float c2r4;

private float c2r5;

private float c2r6;

private float c2r7;

private float c2r8;

private float c2r9;

private float c2r10;

private float c2r11;

private float c2r12;

private float c2r13;

private float c2r14;

private float c2r15;

private float c2r16;

private float c2r17;

private float c2r18;

private float c2r19;

/*第3列1-n行*/

private float c3r1;

private float c3r2;

private float c3r3;

private float c3r4;

private float c3r5;

private float c3r6;

private float c3r7;

private float c3r8;

private float c3r9;

private float c3r10;

private float c3r11;

private float c3r12;

private float c3r13;

private float c3r14;

private float c3r15;

private float c3r16;

private float c3r17;

private float c3r18;

private float c3r19;

/*第4列1-n行*/

private float c4r1;

private float c4r2;

private float c4r3;

private float c4r4;

private float c4r5;

private float c4r6;

private float c4r7;

private float c4r8;

private float c4r9;

private float c4r10;

private float c4r11;

private float c4r12;

private float c4r13;

private float c4r14;

private float c4r15;

private float c4r16;

private float c4r17;

private float c4r18;

private float c4r19;

/*第5列1-n行*/

private float c5r1;

private float c5r2;

private float c5r3;

private float c5r4;

private float c5r5;

private float c5r6;

private float c5r7;

private float c5r8;

private float c5r9;

private float c5r10;

private float c5r11;

private float c5r12;

private float c5r13;

private float c5r14;

private float c5r15;

private float c5r16;

private float c5r17;

private float c5r18;

private float c5r19;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getYear() {

return year;

}

public void s