二维报表数据表设计 - 数据库编程

报表原型:

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

二维报表设计分析:

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

这里使用列行来表示

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 floa

二维报表数据表设计(一)