SSH环境下的销售“3-1分栏报表”生成技术与算法研究

摘要

The train of thought of solution was given to the problem of the frequent data operation and the high algorithm complexity met by a ERP of the group when researching sales "3-1 Split Report" in SSH.That is to produce the collection the clerk using "Group by" List HQL statement by regional,customer,product series of 4 columns,and then to convert to only two string array,and then to give the algorithm assumptions,design and implementation,finally to generate data matrix,which resulting in algorithm complexity reduction.According to the test,the method is 19 times faster than the "usually way" approximately.%针对某集团ERP系统SSH（Strust,Spring,Hibernate）环境下需要研发销售＂3-1分栏报表＂时遇到的数据操作过于频繁和算法复杂度太高的问题,给出了解决问题的思路,以业务员、区域、客户、产品系列4个分栏使用＂Groupby＂HQL语句生成List集合,再转换为二维字符串数组,进而给出了算法假设、设计和实现,最终生成数据矩阵,使复杂度降低为O（n3）,经测试该方法比＂通常方法＂约快19倍。