findMsgFluxByCp备忘

 public List<MsgFlux> findMsgFluxByCp(String cp,String startime,String endtime) {
  
        String sql = "select cp,count(*) from history group by cp";
        List<MsgFlux> list = new ArrayList<MsgFlux>();
        Iterator it = getHibernateTemplate().find(sql).iterator();
        while(it.hasNext()){
         Object[] params = (Object[]) it.next();
         MsgFlux msgFlux = new MsgFlux();
         msgFlux.setSavetime(params[0].toString());
         msgFlux.setMo(Integer.valueOf(params[1].toString()));
         msgFlux.setMtsucceed(Integer.valueOf(params[2].toString()));
   list.add(msgFlux);
        }
        return list;
 }