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; }
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow