Two-dimensional report data table Design

Report prototype: here we randomly select a two-dimensional report design analysis: the preceding report prototype has data items in rows and columns, we can design the coordinate point based on the geographical longitude and latitude. Here we use the column row to represent c1r1 to represent the first column, the first line, c1r2 to represent the first column, and the second row ..... c2r1 indicates the first row of the second column c2r2 indicates the second

Report prototype: here we randomly select a two-dimensional report design analysis: the preceding report prototype has data items in rows and columns, we can design the coordinate point based on the geographical longitude and latitude. Here we use the column row to represent c1r1 to represent the first column, the first line, c1r2 to represent the first column, and the second row ..... c2r1 indicates the first row of the second column c2r2 indicates the second

Report prototype:

A two-dimensional report is selected here.

Two-dimensional report design analysis:

The preceding reports both have data items in the prototype row and column. We can design them based on the idea of coordinate points based on the geographical longitude and latitude.

The column is used for representation.

C1r1 indicates the first row of the first column

C1r2 indicates the second row in the first column

.....

C2r1 indicates the first row of the second column

C2r2 indicates the second row of the second column

......

And so on

Report Bean Information

/*** @ Author xiaoqun. yi * mineral processing technical and economic indicator report * R: Report * r: rows expandable * c: * r * c = The number of metric value items that can be expanded in the column is equivalent to the dikar product */public class RxkjsjjzbBean {private int id; // The primary key private int report_id; // report id, foreign key/* statistical date indicator */private String year; // yyyy length: 4 private String month; // If monthly mm is used as the monthly report, this field length: 2 private String day is required; // if it is a daily report, this field dd length: 2 private String yearmonth is required; // yyyymm, the monthly report query condition is lenght: 6/* calculate the total of all data items. If necessary, use */private float sum;/* to calculate the value and number of each column, not as the data table field */private float c1_sum; // The sum of the c1r1-c1r19 private float c2_sum; // The sum of the c2r1-c2r19 private float c3_sum; // The sum of the c3r1-c3r19 private float c4_sum; // The sum of the c4r1-c4r19 private float c5_sum; // The sum of the c5r1-c5r19/* calculate the value and of each row, not as the data table field */private float r1_sum; // The sum of the r1c1-r1c5, and so on private float r2_sum; private float r3_sum; private float tables; private float r6_sum; private float r7_sum; private float tables; 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-N rows in column 1st */private float c1r1; 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;/* 2nd rows in column 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; /* 3rd columns of 1-N rows */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;/* 4th columns of 1-N rows */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;/* 1-N rows in column 5th */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 ;}}