项目业务流

excel 文件名编码方式  ISO8859-1

@SuppressWarnings("unchecked")

public String getStat(){

Session session1 = SessionUtil.getSession();

session.beginTransaction();

List list = session.createSQLQuery("select a.id,a.dzzmc from dzzxx a where a.id = 5").list(); 

List list1 =  session.createSQLQuery("select a.id,a.dzzmc from dzzxx a where a.dzzsjid = 5").list();

list.addAll(list1);

List dfList = session.createSQLQuery("select a.id,a.dzzmc ,sum(b.dfs) ,b.nd,b.jd from dzzxx a left join dfgl b on a.id = b.dzzid and b.nd = '2013' where a.id = 5 or a.dzzsjid = 5 group by a.id,b.nd,b.jd order by a.id").list();

List<Map<String,Object>> ss = new ArrayList<Map<String,Object>>();

for(int i = 0 ; i < list.size(); i ++){

Object obj = list.get(i);

Object[] objArray = (Object[]) obj;  

Integer id = (Integer) objArray[0];

Map map = new HashMap();

map.put("dzzmc",objArray[1]);

map.put("1","0");

map.put("2","0");

map.put("3","0");

map.put("4","0");

for(int j = 0 ; j < dfList.size(); j ++){

Object obj1 = dfList.get(j);

Object[] objArray1 = (Object[])obj1;

if(id.equals(objArray1[0])){

String flgString = "0";

if(objArray1[4] != null){

flgString = objArray1[4].toString();

}

switch(flgString){

case "1":{

map.put("1",objArray1[2]);

break;

}

case "2":{

map.put("2",objArray1[2]);

break;

}

case "3":{

map.put("3",objArray1[2]);

break;

}  

case "4":{

map.put("4",objArray1[2]);

break;

}

 

}

}

}

ss .add(map);

}

JSONObject jsonObject1 = new JSONObject();

jsonObject1.put("nd", "2013");

JSONArray jsonArray = new JSONArray();

for (int i = 0; i < ss.size(); i++) {

JSONObject jsonObject = new JSONObject();

Map<String,Object> map = ss.get(i);

jsonObject.put("dzzmc", map.get("dzzmc"));

jsonObject.put("first", map.get("1"));

jsonObject.put("second", map.get("2"));

jsonObject.put("three", map.get("3"));

jsonObject.put("four", map.get("4"));

jsonArray.add(jsonObject);

}

jsonObject1.put("list", jsonArray);

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

return jsonObject1.toString();

}