当前位置:Gxlcms > mysql > 二维报表数据表设计

二维报表数据表设计

时间:2021-07-01 10:21:17 帮助过:19人阅读

报表原型: 这里随便挑了一个二维报表 二维报表设计分析: 上面的报表原型行和列都有数据项,我们可以根据地理位置的经纬度定坐标点的思想来进行设计 这里使用列行来表示 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 setYear(String year) {
		this.year = year;
	}
	public String getMonth() {
		return month;
	}
	public void setMonth(String month) {
		this.month = month;
	}
	public String getDay() {
		return day;
	}
	public void setDay(String day) {
		this.day = day;
	}
	public String getYearmonth() {
		return yearmonth;
	}
	public void setYearmonth(String yearmonth) {
		this.yearmonth = yearmonth;
	}
	public int getReport_id() {
		return report_id;
	}
	public void setReport_id(int report_id) {
		this.report_id = report_id;
	}
	
	
	public float getSum() {
		return sum;
	}
	public void setSum(float sum) {
		this.sum = sum;
	}
	public float getR1_sum() {
		return r1_sum;
	}
	public void setR1_sum(float r1_sum) {
		this.r1_sum = r1_sum;
	}
	public float getR2_sum() {
		return r2_sum;
	}
	public void setR2_sum(float r2_sum) {
		this.r2_sum = r2_sum;
	}
	public float getR3_sum() {
		return r3_sum;
	}
	public void setR3_sum(float r3_sum) {
		this.r3_sum = r3_sum;
	}
	public float getR4_sum() {
		return r4_sum;
	}
	public void setR4_sum(float r4_sum) {
		this.r4_sum = r4_sum;
	}
	public float getR5_sum() {
		return r5_sum;
	}
	public void setR5_sum(float r5_sum) {
		this.r5_sum = r5_sum;
	}
	public float getR6_sum() {
		return r6_sum;
	}
	public void setR6_sum(float r6_sum) {
		this.r6_sum = r6_sum;
	}
	public float getR7_sum() {
		return r7_sum;
	}
	public void setR7_sum(float r7_sum) {
		this.r7_sum = r7_sum;
	}
	public float getR8_sum() {
		return r8_sum;
	}
	public void setR8_sum(float r8_sum) {
		this.r8_sum = r8_sum;
	}
	public float getR9_sum() {
		return r9_sum;
	}
	public void setR9_sum(float r9_sum) {
		this.r9_sum = r9_sum;
	}
	public float getR10_sum() {
		return r10_sum;
	}
	public void setR10_sum(float r10_sum) {
		this.r10_sum = r10_sum;
	}
	public float getR11_sum() {
		return r11_sum;
	}
	public void setR11_sum(float r11_sum) {
		this.r11_sum = r11_sum;
	}
	public float getR12_sum() {
		return r12_sum;
	}
	public void setR12_sum(float r12_sum) {
		this.r12_sum = r12_sum;
	}
	public float getR13_sum() {
		return r13_sum;
	}
	public void setR13_sum(float r13_sum) {
		this.r13_sum = r13_sum;
	}
	public float getR14_sum() {
		return r14_sum;
	}
	public void setR14_sum(float r14_sum) {
		this.r14_sum = r14_sum;
	}
	public float getR15_sum() {
		return r15_sum;
	}
	public void setR15_sum(float r15_sum) {
		this.r15_sum = r15_sum;
	}
	public float getR16_sum() {
		return r16_sum;
	}
	public void setR16_sum(float r16_sum) {
		this.r16_sum = r16_sum;
	}
	public float getR17_sum() {
		return r17_sum;
	}
	public void setR17_sum(float r17_sum) {
		this.r17_sum = r17_sum;
	}
	public float getR18_sum() {
		return r18_sum;
	}
	public void setR18_sum(float r18_sum) {
		this.r18_sum = r18_sum;
	}
	public float getR19_sum() {
		return r19_sum;
	}
	public void setR19_sum(float r19_sum) {
		this.r19_sum = r19_sum;
	}
	public float getC1_sum() {
		return c1_sum;
	}
	public void setC1_sum(float c1_sum) {
		this.c1_sum = c1_sum;
	}
	public float getC2_sum() {
		return c2_sum;
	}
	public void setC2_sum(float c2_sum) {
		this.c2_sum = c2_sum;
	}
	public float getC3_sum() {
		return c3_sum;
	}
	public void setC3_sum(float c3_sum) {
		this.c3_sum = c3_sum;
	}
	public float getC4_sum() {
		return c4_sum;
	}
	public void setC4_sum(float c4_sum) {
		this.c4_sum = c4_sum;
	}
	public float getC5_sum() {
		return c5_sum;
	}
	public void setC5_sum(float c5_sum) {
		this.c5_sum = c5_sum;
	}
	public float getC1r1() {
		return c1r1;
	}
	public void setC1r1(float c1r1) {
		this.c1r1 = c1r1;
	}
	public float getC1r2() {
		return c1r2;
	}
	public void setC1r2(float c1r2) {
		this.c1r2 = c1r2;
	}
	public float getC1r3() {
		return c1r3;
	}
	public void setC1r3(float c1r3) {
		this.c1r3 = c1r3;
	}
	public float getC1r4() {
		return c1r4;
	}
	public void setC1r4(float c1r4) {
		this.c1r4 = c1r4;
	}
	public float getC1r5() {
		return c1r5;
	}
	public void setC1r5(float c1r5) {
		this.c1r5 = c1r5;
	}
	public float getC1r6() {
		return c1r6;
	}
	public void setC1r6(float c1r6) {
		this.c1r6 = c1r6;
	}
	public float getC1r7() {
		return c1r7;
	}
	public void setC1r7(float c1r7) {
		this.c1r7 = c1r7;
	}
	public float getC1r8() {
		return c1r8;
	}
	public void setC1r8(float c1r8) {
		this.c1r8 = c1r8;
	}
	public float getC1r9() {
		return c1r9;
	}
	public void setC1r9(float c1r9) {
		this.c1r9 = c1r9;
	}
	public float getC1r10() {
		return c1r10;
	}
	public void setC1r10(float c1r10) {
		this.c1r10 = c1r10;
	}
	public float getC1r11() {
		return c1r11;
	}
	public void setC1r11(float c1r11) {
		this.c1r11 = c1r11;
	}
	public float getC1r12() {
		return c1r12;
	}
	public void setC1r12(float c1r12) {
		this.c1r12 = c1r12;
	}
	public float getC1r13() {
		return c1r13;
	}
	public void setC1r13(float c1r13) {
		this.c1r13 = c1r13;
	}
	public float getC1r14() {
		return c1r14;
	}
	public void setC1r14(float c1r14) {
		this.c1r14 = c1r14;
	}
	public float getC1r15() {
		return c1r15;
	}
	public void setC1r15(float c1r15) {
		this.c1r15 = c1r15;
	}
	public float getC1r16() {
		return c1r16;
	}
	public void setC1r16(float c1r16) {
		this.c1r16 = c1r16;
	}
	public float getC1r17() {
		return c1r17;
	}
	public void setC1r17(float c1r17) {
		this.c1r17 = c1r17;
	}
	public float getC1r18() {
		return c1r18;
	}
	public void setC1r18(float c1r18) {
		this.c1r18 = c1r18;
	}
	public float getC1r19() {
		return c1r19;
	}
	public void setC1r19(float c1r19) {
		this.c1r19 = c1r19;
	}
	public float getC2r1() {
		return c2r1;
	}
	public void setC2r1(float c2r1) {
		this.c2r1 = c2r1;
	}
	public float getC2r2() {
		return c2r2;
	}
	public void setC2r2(float c2r2) {
		this.c2r2 = c2r2;
	}
	public float getC2r3() {
		return c2r3;
	}
	public void setC2r3(float c2r3) {
		this.c2r3 = c2r3;
	}
	public float getC2r4() {
		return c2r4;
	}
	public void setC2r4(float c2r4) {
		this.c2r4 = c2r4;
	}
	public float getC2r5() {
		return c2r5;
	}
	public void setC2r5(float c2r5) {
		this.c2r5 = c2r5;
	}
	public float getC2r6() {
		return c2r6;
	}
	public void setC2r6(float c2r6) {
		this.c2r6 = c2r6;
	}
	public float getC2r7() {
		return c2r7;
	}
	public void setC2r7(float c2r7) {
		this.c2r7 = c2r7;
	}
	public float getC2r8() {
		return c2r8;
	}
	public void setC2r8(float c2r8) {
		this.c2r8 = c2r8;
	}
	public float getC2r9() {
		return c2r9;
	}
	public void setC2r9(float c2r9) {
		this.c2r9 = c2r9;
	}
	public float getC2r10() {
		return c2r10;
	}
	public void setC2r10(float c2r10) {
		this.c2r10 = c2r10;
	}
	public float getC2r11() {
		return c2r11;
	}
	public void setC2r11(float c2r11) {
		this.c2r11 = c2r11;
	}
	public float getC2r12() {
		return c2r12;
	}
	public void setC2r12(float c2r12) {
		this.c2r12 = c2r12;
	}
	public float getC2r13() {
		return c2r13;
	}
	public void setC2r13(float c2r13) {
		this.c2r13 = c2r13;
	}
	public float getC2r14() {
		return c2r14;
	}
	public void setC2r14(float c2r14) {
		this.c2r14 = c2r14;
	}
	public float getC2r15() {
		return c2r15;
	}
	public void setC2r15(float c2r15) {
		this.c2r15 = c2r15;
	}
	public float getC2r16() {
		return c2r16;
	}
	public void setC2r16(float c2r16) {
		this.c2r16 = c2r16;
	}
	public float getC2r17() {
		return c2r17;
	}
	public void setC2r17(float c2r17) {
		this.c2r17 = c2r17;
	}
	public float getC2r18() {
		return c2r18;
	}
	public void setC2r18(float c2r18) {
		this.c2r18 = c2r18;
	}
	public float getC2r19() {
		return c2r19;
	}
	public void setC2r19(float c2r19) {
		this.c2r19 = c2r19;
	}
	public float getC3r1() {
		return c3r1;
	}
	public void setC3r1(float c3r1) {
		this.c3r1 = c3r1;
	}
	public float getC3r2() {
		return c3r2;
	}
	public void setC3r2(float c3r2) {
		this.c3r2 = c3r2;
	}
	public float getC3r3() {
		return c3r3;
	}
	public void setC3r3(float c3r3) {
		this.c3r3 = c3r3;
	}
	public float getC3r4() {
		return c3r4;
	}
	public void setC3r4(float c3r4) {
		this.c3r4 = c3r4;
	}
	public float getC3r5() {
		return c3r5;
	}
	public void setC3r5(float c3r5) {
		this.c3r5 = c3r5;
	}
	public float getC3r6() {
		return c3r6;
	}
	public void setC3r6(float c3r6) {
		this.c3r6 = c3r6;
	}
	public float getC3r7() {
		return c3r7;
	}
	public void setC3r7(float c3r7) {
		this.c3r7 = c3r7;
	}
	public float getC3r8() {
		return c3r8;
	}
	public void setC3r8(float c3r8) {
		this.c3r8 = c3r8;
	}
	public float getC3r9() {
		return c3r9;
	}
	public void setC3r9(float c3r9) {
		this.c3r9 = c3r9;
	}
	public float getC3r10() {
		return c3r10;
	}
	public void setC3r10(float c3r10) {
		this.c3r10 = c3r10;
	}
	public float getC3r11() {
		return c3r11;
	}
	public void setC3r11(float c3r11) {
		this.c3r11 = c3r11;
	}
	public float getC3r12() {
		return c3r12;
	}
	public void setC3r12(float c3r12) {
		this.c3r12 = c3r12;
	}
	public float getC3r13() {
		return c3r13;
	}
	public void setC3r13(float c3r13) {
		this.c3r13 = c3r13;
	}
	public float getC3r14() {
		return c3r14;
	}
	public void setC3r14(float c3r14) {
		this.c3r14 = c3r14;
	}
	public float getC3r15() {
		return c3r15;
	}
	public void setC3r15(float c3r15) {
		this.c3r15 = c3r15;
	}
	public float getC3r16() {
		return c3r16;
	}
	public void setC3r16(float c3r16) {
		this.c3r16 = c3r16;
	}
	public float getC3r17() {
		return c3r17;
	}
	public void setC3r17(float c3r17) {
		this.c3r17 = c3r17;
	}
	public float getC3r18() {
		return c3r18;
	}
	public void setC3r18(float c3r18) {
		this.c3r18 = c3r18;
	}
	public float getC3r19() {
		return c3r19;
	}
	public void setC3r19(float c3r19) {
		this.c3r19 = c3r19;
	}
	public float getC4r1() {
		return c4r1;
	}
	public void setC4r1(float c4r1) {
		this.c4r1 = c4r1;
	}
	public float getC4r2() {
		return c4r2;
	}
	public void setC4r2(float c4r2) {
		this.c4r2 = c4r2;
	}
	public float getC4r3() {
		return c4r3;
	}
	public void setC4r3(float c4r3) {
		this.c4r3 = c4r3;
	}
	public float getC4r4() {
		return c4r4;
	}
	public void setC4r4(float c4r4) {
		this.c4r4 = c4r4;
	}
	public float getC4r5() {
		return c4r5;
	}
	public void setC4r5(float c4r5) {
		this.c4r5 = c4r5;
	}
	public float getC4r6() {
		return c4r6;
	}
	public void setC4r6(float c4r6) {
		this.c4r6 = c4r6;
	}
	public float getC4r7() {
		return c4r7;
	}
	public void setC4r7(float c4r7) {
		this.c4r7 = c4r7;
	}
	public float getC4r8() {
		return c4r8;
	}
	public void setC4r8(float c4r8) {
		this.c4r8 = c4r8;
	}
	public float getC4r9() {
		return c4r9;
	}
	public void setC4r9(float c4r9) {
		this.c4r9 = c4r9;
	}
	public float getC4r10() {
		return c4r10;
	}
	public void setC4r10(float c4r10) {
		this.c4r10 = c4r10;
	}
	public float getC4r11() {
		return c4r11;
	}
	public void setC4r11(float c4r11) {
		this.c4r11 = c4r11;
	}
	public float getC4r12() {
		return c4r12;
	}
	public void setC4r12(float c4r12) {
		this.c4r12 = c4r12;
	}
	public float getC4r13() {
		return c4r13;
	}
	public void setC4r13(float c4r13) {
		this.c4r13 = c4r13;
	}
	public float getC4r14() {
		return c4r14;
	}
	public void setC4r14(float c4r14) {
		this.c4r14 = c4r14;
	}
	public float getC4r15() {
		return c4r15;
	}
	public void setC4r15(float c4r15) {
		this.c4r15 = c4r15;
	}
	public float getC4r16() {
		return c4r16;
	}
	public void setC4r16(float c4r16) {
		this.c4r16 = c4r16;
	}
	public float getC4r17() {
		return c4r17;
	}
	public void setC4r17(float c4r17) {
		this.c4r17 = c4r17;
	}
	public float getC4r18() {
		return c4r18;
	}
	public void setC4r18(float c4r18) {
		this.c4r18 = c4r18;
	}
	public float getC4r19() {
		return c4r19;
	}
	public void setC4r19(float c4r19) {
		this.c4r19 = c4r19;
	}
	public float getC5r1() {
		return c5r1;
	}
	public void setC5r1(float c5r1) {
		this.c5r1 = c5r1;
	}
	public float getC5r2() {
		return c5r2;
	}
	public void setC5r2(float c5r2) {
		this.c5r2 = c5r2;
	}
	public float getC5r3() {
		return c5r3;
	}
	public void setC5r3(float c5r3) {
		this.c5r3 = c5r3;
	}
	public float getC5r4() {
		return c5r4;
	}
	public void setC5r4(float c5r4) {
		this.c5r4 = c5r4;
	}
	public float getC5r5() {
		return c5r5;
	}
	public void setC5r5(float c5r5) {
		this.c5r5 = c5r5;
	}
	public float getC5r6() {
		return c5r6;
	}
	public void setC5r6(float c5r6) {
		this.c5r6 = c5r6;
	}
	public float getC5r7() {
		return c5r7;
	}
	public void setC5r7(float c5r7) {
		this.c5r7 = c5r7;
	}
	public float getC5r8() {
		return c5r8;
	}
	public void setC5r8(float c5r8) {
		this.c5r8 = c5r8;
	}
	public float getC5r9() {
		return c5r9;
	}
	public void setC5r9(float c5r9) {
		this.c5r9 = c5r9;
	}
	public float getC5r10() {
		return c5r10;
	}
	public void setC5r10(float c5r10) {
		this.c5r10 = c5r10;
	}
	public float getC5r11() {
		return c5r11;
	}
	public void setC5r11(float c5r11) {
		this.c5r11 = c5r11;
	}
	public float getC5r12() {
		return c5r12;
	}
	public void setC5r12(float c5r12) {
		this.c5r12 = c5r12;
	}
	public float getC5r13() {
		return c5r13;
	}
	public void setC5r13(float c5r13) {
		this.c5r13 = c5r13;
	}
	public float getC5r14() {
		return c5r14;
	}
	public void setC5r14(float c5r14) {
		this.c5r14 = c5r14;
	}
	public float getC5r15() {
		return c5r15;
	}
	public void setC5r15(float c5r15) {
		this.c5r15 = c5r15;
	}
	public float getC5r16() {
		return c5r16;
	}
	public void setC5r16(float c5r16) {
		this.c5r16 = c5r16;
	}
	public float getC5r17() {
		return c5r17;
	}
	public void setC5r17(float c5r17) {
		this.c5r17 = c5r17;
	}
	public float getC5r18() {
		return c5r18;
	}
	public void setC5r18(float c5r18) {
		this.c5r18 = c5r18;
	}
	public float getC5r19() {
		return c5r19;
	}
	public void setC5r19(float c5r19) {
		this.c5r19 = c5r19;
	}	
}

人气教程排行