Java中使用JSON,首先需要json-lib-2.4-jdk15.jar,但是如果只有这一个jar包还不行,它需要依赖以下几个包:
commons-beanutils.jar
commons-collections-3.2.jar
commons-lang.jar
commons-logging.jar
ezmorph-1.0.6.jar
- /**
- * 统计访问次数
- * @param startDay
- * @param endDay
- * @return JSON 例:[["2011-10-01",23],["2011-10-02",29],["2011-10-03",48],["2011-10-04",88]]
- */
- public JSONArray selectVisitsJSON(String startDay, String endDay){
- JSONArray finalJson = new JSONArray();
- //如果起止时间均为空,则统计10天内的信息
- if(startDay.trim().length()==0||endDay.trim().length()==0){
- endDay = now.plusDays(-2).format("YYYY-MM-DD").toString();
- startDay = now.plusDays(-11).format("YYYY-MM-DD").toString();
- }
- try{
- conn=db.getConn();
- //String sql = "SELECT time,pageviews,visits,visitors FROM analytics WHERE time<=? AND time>=?";
- String sql = "SELECT time,visits FROM analytics WHERE time<=? AND time>=? ORDER BY time ASC";
- pStatement = conn.prepareStatement(sql);
- pStatement.setString(1, endDay);
- pStatement.setString(2, startDay);
- rs = pStatement.executeQuery();
- while(rs.next()){
- JSONArray json = new JSONArray();
- json.add(rs.getString("time"));
- json.add(rs.getInt("visits"));
- finalJson.add(json);
- }
- db.closeAll(conn);
- }catch(Exception e){
- log.error(e.getMessage());
- }
- return finalJson;
- }