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 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;
}
}
本文原創發布php中文網，轉載請注明出處，感謝您的尊重！
總結
以上是生活随笔為你收集整理的mysql 二维表 查询_二维报表数据表设计的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： mysql 2.71828_数学中的e=
- 下一篇： 蟑螂有没有价值？