java oracle 统计代码,java 实现类似于oracle分组统计的功能

根据employeeId分组，并统计totalNum和totalGoodsPrice

public static void groupCount2(){

MainJavaLK mainJava = new MainJavaLK();

List list = mainJava.initList();

List mainList = new ArrayList();

Map map = new HashMap();

MainBean totalBean = null;

String employeeId = null;

for(MainBean mainBean : list) {

employeeId = mainBean.getEmployeeId();

if (!map.containsKey(employeeId)) {

totalBean = new MainBean();

totalBean.setEmployeeId(employeeId);

totalBean.setBuyNum(mainBean.getBuyNum());

totalBean.setGoodsPrice(mainBean.getGoodsPrice());

totalBean.setTotalBuyNum(mainBean.getTotalBuyNum());

totalBean.setFreight(mainBean.getFreight());

totalBean.setTotalGoodsPrice(mainBean.getGoodsPrice() * mainBean.getBuyNum());

totalBean.setTotalPrice(mainBean.getGoodsPrice() * mainBean.getBuyNum() + mainBean.getFreight());

mainList.add(totalBean);

map.put(employeeId, totalBean);

} else {

totalBean = map.get(employeeId);

totalBean.setTotalBuyNum(totalBean.getTotalBuyNum() + mainBean.getTotalBuyNum());

totalBean.setFreight(totalBean.getFreight() + mainBean.getFreight());

totalBean.setTotalGoodsPrice(totalBean.getTotalGoodsPrice() + mainBean.getGoodsPrice() * mainBean.getBuyNum());

totalBean.setTotalPrice(totalBean.getTotalPrice() +

mainBean.getGoodsPrice() * mainBean.getBuyNum() + mainBean.getFreight());

}

}

for(MainBean mainBean : mainList) {

System.out.println(mainBean.toString());

}

}

public List initList(){

List goodsCarVoList = new ArrayList();

MainBean bean1 = new MainBean();

bean1.setEmployeeId("1");

bean1.setGoodsId("101");

bean1.setBuyNum(1);

bean1.setTotalBuyNum(1);

bean1.setGoodsPrice(1.0d);

bean1.setFreight(1.0);

goodsCarVoList.add(bean1);

MainBean bean2 = new MainBean();

bean2.setEmployeeId("2");

bean2.setGoodsId("102");

bean2.setBuyNum(2);

bean2.setTotalBuyNum(2);

bean2.setGoodsPrice(2.0d);

bean2.setFreight(2.0);

goodsCarVoList.add(bean2);

MainBean bean3 = new MainBean();

bean3.setEmployeeId("1");

bean3.setGoodsId("103");

bean3.setBuyNum(3);

bean3.setTotalBuyNum(3);

bean3.setGoodsPrice(3.0d);

bean3.setFreight(3.0);

goodsCarVoList.add(bean3);

MainBean bean4 = new MainBean();

bean4.setEmployeeId("2");

bean4.setGoodsId("104");

bean4.setBuyNum(4);

bean4.setTotalBuyNum(4);

bean4.setGoodsPrice(4.0d);

bean4.setFreight(4.0);

goodsCarVoList.add(bean4);

MainBean bean5 = new MainBean();

bean5.setEmployeeId("1");

bean5.setGoodsId("105");

bean5.setBuyNum(5);

bean5.setTotalBuyNum(5);

bean5.setGoodsPrice(5.0d);

bean5.setFreight(5.0);

goodsCarVoList.add(bean5);

MainBean bean6 = new MainBean();

bean6.setEmployeeId("2");

bean6.setGoodsId("106");

bean6.setBuyNum(6);

bean6.setTotalBuyNum(6);

bean6.setGoodsPrice(6.0d);

bean6.setFreight(6.0);

goodsCarVoList.add(bean6);

MainBean bean7 = new MainBean();

bean7.setEmployeeId("1");

bean7.setGoodsId("107");

bean7.setBuyNum(7);

bean7.setTotalBuyNum(7);

bean7.setGoodsPrice(7.0d);

bean7.setFreight(7.0);

goodsCarVoList.add(bean7);

MainBean bean8 = new MainBean();

bean8.setEmployeeId("2");

bean8.setGoodsId("108");

bean8.setBuyNum(8);

bean8.setTotalBuyNum(8);

bean8.setGoodsPrice(8.0d);

bean8.setFreight(8.0);

goodsCarVoList.add(bean8);

return goodsCarVoList;

}

public class MainBean {

/**

* 话务购物车Id

*/

private String employeeId;

/**

* 商品ID

*/

private String goodsId;

private Double goodsPrice;

private Double totalGoodsPrice;

private Double totalPrice;

/**

* 订购数量

*/

private Integer buyNum;

private Integer totalBuyNum;

/**

* 运费

*/

private Double freight;

private Double totalFreight;

public String getEmployeeId() {

return employeeId;

}

public void setEmployeeId(String employeeId) {

this.employeeId = employeeId;

}

public String getGoodsId() {

return goodsId;

}

public void setGoodsId(String goodsId) {

this.goodsId = goodsId;

}

public Double getGoodsPrice() {

return goodsPrice;

}

public void setGoodsPrice(Double goodsPrice) {

this.goodsPrice = goodsPrice;

}

public Double getTotalGoodsPrice() {

return totalGoodsPrice;

}

public void setTotalGoodsPrice(Double totalGoodsPrice) {

this.totalGoodsPrice = totalGoodsPrice;

}

public Double getTotalPrice() {

return totalPrice;

}

public void setTotalPrice(Double totalPrice) {

this.totalPrice = totalPrice;

}

public Integer getBuyNum() {

return buyNum;

}

public void setBuyNum(Integer buyNum) {

this.buyNum = buyNum;

}

public Integer getTotalBuyNum() {

return totalBuyNum;

}

public void setTotalBuyNum(Integer totalBuyNum) {

this.totalBuyNum = totalBuyNum;

}

public Double getFreight() {

return freight;

}

public void setFreight(Double freight) {

this.freight = freight;

}

public Double getTotalFreight() {

return totalFreight;

}

public void setTotalFreight(Double totalFreight) {

this.totalFreight = totalFreight;

}

}