public void process(ActionContext ac) throws Throwable { try { if (pool == null) pool = Mvcs.getIoc().get(JedisPool.class); int uid = Toolkit.uid(); if (uid > 0) { try (Jedis jedis = pool.getResource()) { Pipeline pipe = jedis.pipelined(); pipe.setbit(RKEY_ONLINE_DAY + Toolkit.today_yyyyMMdd(), uid, true); pipe.setbit(RKEY_ONLINE_HOUR + Toolkit.today_yyyyMMddHH(), uid, true); pipe.sync(); } } } catch (Exception e) { if (e instanceof JedisConnectionException) { log.debug("jedis is down? ignore error"); } else { log.debug("something wrong? ignore error", e); } } doNext(ac); }
public void init() { try { super.init(); } catch (Exception e) { throw new RuntimeException(e); } // 添加全局变量 Map<String, Object> share = groupTemplate.getSharedVars(); if (share == null) { share = new NutMap(); groupTemplate.setSharedVars(share); } Ioc ioc = Mvcs.getIoc(); share.put("ioc", ioc); PropertiesProxy conf = ioc.get(PropertiesProxy.class, "conf"); share.put("conf", conf.toMap()); if (!conf.getBoolean("cdn.enable", false) || Strings.isBlank(conf.get("cdn.urlbase"))) { share.put("cdnbase", ""); } else { share.put("cdnbase", conf.get("cdn.urlbase")); MarkdownFunction.cdnbase = conf.get("cdn.urlbase"); } }
@POST @At("/ht/savepamdata") @Ok("json") public JSONObject saveParameterDataFromAccess( String mdbPath, String stationId, String mdbTableName, String dateField, ServletContext context) { JSONObject json = new JSONObject(); json.put(Constant.SUCCESS, false); // log.info("tableName:"+ mdbTableName + " timefield:" + dateField + " station:" +stationId) ; try { long start = System.currentTimeMillis(); AccessUtil au = new AccessUtil(this.getAppRealPath(context) + mdbPath); Ioc ioc = Mvcs.getIoc(); if (null != ioc) { PropertiesProxy prop = ioc.get(PropertiesProxy.class, "config"); if (StringUtil.checkNotNull(prop.get("accessdriver"))) { au.setDburl(prop.get("accessdriver")); } } log.info(au.getDburl()); Connection con = au.getConnection(); Statement stat = con.createStatement(); total = au.getTotalRowNumber(stat, mdbTableName); long pageTotal = au.getTotalPageNumber(total); long insertdb = 0; String tmpl = "select top PAGESPEED * from TABLENAME where ID >(select top 1 max(ID) from (select top BEFOREROW ID from TABLENAME order by ID asc)) order by ID asc "; tmpl = tmpl.replaceAll("ID", dateField) .replaceAll("PAGESPEED", String.valueOf(au.pageSpeed)) .replaceAll("TABLENAME", mdbTableName); for (int i = 1; i <= pageTotal; i++) { int ii = (i - 1) * au.pageSpeed; String sql = tmpl.replaceAll("BEFOREROW", String.valueOf(ii)); if (i == 1) { sql = sql.substring(0, sql.indexOf("where")); sql += "order by ID asc".replace("ID", dateField); } ResultSet rset = au.execSQL(stat, sql); if (null != rset) { // 把当前结果集中存在的fieldsName找出来 List<String> available = new ArrayList<String>(); List<String> list = au.getAllColumnName(rset.getMetaData()); for (String str : au.fieldsName) { if (au.isExistString(list, str)) { available.add(str); } } List<Parameter> data = new ArrayList(); while (rset.next()) { Parameter p = new Parameter(); String time = rset.getString(dateField); p.setSrcTimestr(time); p.setCreateDate(DateUtil.convertStringToDate(time, DateUtil.pattern5)); p.setStationID(stationId); // StringBuilder ss = new StringBuilder(rset.getString("mytime")).append("\t"); // 遍历全部字段并存到java object 中 for (String fn : available) { // ss.append(rset.getString(fn)).append("\t") ; BeanUtils.setProperty(p, fn, String.valueOf(rset.getString(fn))); } data.add(p); dls.insertNDY(tableName, p.getStationID(), null, p.getCreateDate()); } // log.info("得到: " + data.size()) ; if (null != data && data.size() > 0) { // 把已经存在的对象删除掉 batchDeleteParameter(stationId, data); insertdb += data.size(); for (Parameter pa : data) { baseService.dao.insert(stationId, cov(pa, true)); } // baseService.dao.insert(data) ; dls.insert("01", tableName, getHTLoginUserName()); courr = insertdb; } } } // log.info("共得到: " + insertdb) ; long end = System.currentTimeMillis(); json.put(Constant.SUCCESS, true); json.put("usetime", (end - start) / 1000 + " 秒"); json.put("insertRow", insertdb + " 条"); // log.debug(json.get("usetime")) ; } catch (Exception e) { // e.printStackTrace(); json.put(Constant.INFO, e.getLocalizedMessage()); } finally { return json; } }