Java數(shù)據(jù)統(tǒng)計(jì)的實(shí)現(xiàn)方法是什么？動(dòng)力節(jié)點(diǎn)小編來告訴大家。

1. 創(chuàng)建對(duì)應(yīng)的表

CREATE TABLE "NETPORTVIEW"
("GRP" CHAR(5),
"VIEWDATE" CHAR(10),
"PORT" CHAR(4),
"NUM1" NUMBER(10,2),
"NUM2" NUMBER(10,2),
"NUM3" NUMBER(10,2)
)

2. 插入數(shù)據(jù)

insert into netportview (GRP, VIEWDATE, PORT, NUM1, NUM2, NUM3)
values ('pvc  ', '2011-02-12', '5200', 50000.00, 1000.00, 10.00);
insert into netportview (GRP, VIEWDATE, PORT, NUM1, NUM2, NUM3)
values ('pvc  ', '2011-02-03', '6969', 100000.00, 2000.00, 10.00);
insert into netportview (GRP, VIEWDATE, PORT, NUM1, NUM2, NUM3)
values ('pvc  ', '2011-02-09', '6969', 50000.00, 1000.00, 10.00);
insert into netportview (GRP, VIEWDATE, PORT, NUM1, NUM2, NUM3)
values ('pvc  ', '2011-02-01', '5200', 80000.00, 2000.00, 8.00);

3. 查詢

select * from (
select t.grp,t.viewdate,t.port,t.num1,   t.num2,   t.num3    from netportview t
union
select '小計(jì)' as GRP,null,t.port,sum(num1),null,sum(num3) from netportview t group by t.grp,port
union
select '總計(jì)' as GRP,null,'9999',sum(num1),null,sum(num3) from netportview t
)
order by port,viewdate