本文共 1261 字，大约阅读时间需要 4 分钟。

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;	}

转载地址：http://bwnpi.baihongyu.com/