Exemplo n.º 1
0
 private void batchDeleteParameter(String table, List<Parameter> data) {
   for (Parameter p : data) {
     int c = baseService.dao.clear(table, Cnd.where("srcTimestr", "=", p.getSrcTimestr()));
   }
   /*if(null != data || data.size() > 0){
   }*/
 }
Exemplo n.º 2
0
  @POST
  @At("/ht/pamsave")
  @Ok("json")
  public JSONObject save(@Param("..") Parameter params) {
    JSONObject json = new JSONObject();
    json.put(Constant.SUCCESS, false);
    try {
      if (StringUtil.checkNotNull(params.getStationID())) {
        baseService.dao.insert(params.getStationID(), cov(params, true));
        // baseService.dao.insert(params) ;
        json.put(Constant.SUCCESS, true);

        dls.insert("01", tableName, getHTLoginUserName());
        dls.insertNDY(tableName, params.getStationID(), null, params.getCreateDate());
        json.put(Constant.INFO, "操作成功");
      } else {
        json.put(Constant.INFO, "请选择观测站或观测站ID错误");
      }

    } catch (Exception e) {
      // TODO: handle exception
      e.printStackTrace();
      json.put(Constant.INFO, e.getMessage());
    } finally {
      return json;
    }
  }
Exemplo n.º 3
0
  @POST
  @At("/ht/pamget")
  @Ok("json")
  public Parameter get(String table, long id) {
    Parameter para = null;
    if (id > 0 && StringUtil.checkNotNull(table)) {
      Record rd = baseService.dao.fetch(table, Cnd.where("parameterID", "=", id));
      para = this.record2Object(rd);
      para.setStationID(table);
      para.setParameterID(id);
    }

    return para;
  }
Exemplo n.º 4
0
  @POST
  @At("/ht/pamdel")
  @Ok("json")
  public JSONObject deleteParameter(@Param("..") Parameter params) {
    JSONObject json = new JSONObject();
    json.put(Constant.SUCCESS, false);

    if (StringUtil.checkNotNull(params.getIds())) {
      String[] ids = params.getIds().split(";");

      // List<Parameter> igs = new ArrayList<Parameter>() ;
      for (String id : ids) {
        if (null != this.get(params.getStationID(), id)) {
          baseService.dao.clear(params.getStationID(), Cnd.where("parameterID", "=", id));
        }
        // Parameter sa = new Parameter();
        // sa.setParameterID(id) ;

        /*sa = baseService.dao.fetch(sa) ;

        if(null != sa){
        	igs.add(sa) ;
        }*/
      }

      json.put(Constant.SUCCESS, true);
      dls.insert("03", tableName, getHTLoginUserName());

      /*if(null != igs && igs.size() > 0 ){
      	if( baseService.dao.delete(igs) == igs.size() ){

      	}else{
      		json.put(Constant.INFO, error1) ;
      	}
      }else{
      	json.put(Constant.INFO, error2) ;
      }*/

    } else {
      json.put(Constant.INFO, error3);
    }

    return json;
  }
Exemplo n.º 5
0
 private Parameter record2Object(Record rd) {
   Parameter p = new Parameter();
   p.setParameterID((Long) rd.get("parameterID"));
   p.setCreateDate((Date) rd.get("createDate"));
   p.setFmin(rd.getString("Fmin"));
   p.setM3000F(rd.getString("M3000F"));
   p.setM3000F1(rd.getString("M3000F1"));
   p.setM3000F2(rd.getString("M3000F2"));
   p.setM1500F2(rd.getString("M1500F2"));
   p.setMUF3000F1(rd.getString("MUF3000F1"));
   p.setMUF3000F2(rd.getString("MUF3000F2"));
   for (String fie : paField) {
     try {
       BeanUtils.setProperty(p, fie, rd.get(fie));
     } catch (IllegalAccessException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     } catch (InvocationTargetException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return p;
 }
Exemplo n.º 6
0
  @POST
  @At("/ht/pamupdate")
  @Ok("json")
  public JSONObject update(@Param("..") Parameter params) {
    JSONObject json = new JSONObject();
    json.put(Constant.SUCCESS, false);

    if (params.getParameterID() > 0
        && null != this.get(params.getStationID(), params.getParameterID())) {
      int i =
          baseService.dao.update(
              params.getStationID(),
              cov(params, false),
              Cnd.where("parameterID", "=", params.getParameterID()));
      //			int  i = baseService.dao.update(params) ;

      json.put(Constant.SUCCESS, true);

      dls.insert("02", tableName, getHTLoginUserName());
    } else {
      json.put(Constant.INFO, error2);
    }
    return json;
  }
Exemplo n.º 7
0
  @POST
  @At("/ht/pamlist")
  @Ok("json")
  public JSONObject list(@Param("..") Pages page, String sid) {
    JSONObject json = new JSONObject();
    json.put(Constant.SUCCESS, true);

    List<Record> list = baseService.dao.query(sid + ":parameterID", null, page.getNutzPager());

    json.put(Constant.TOTAL, baseService.dao.count(sid));

    JsonConfig cfg = new JsonConfig();
    cfg.setExcludes(new String[] {"station", "createDate"});
    JSONArray array = new JSONArray();

    Station sa = new Station();
    sa.setId(sid);
    sa = baseService.dao.fetch(sa);
    for (Record rd : list) {
      Parameter pm = this.record2Object(rd);
      JSONObject item = JSONObject.fromObject(pm, cfg);

      if (null != sa) {
        item.put("stationName", sa.getName());
      } else {
        item.put("stationName", "无");
      }

      item.put("ID", pm.getParameterID());
      item.put(
          "createDate",
          null != pm.getCreateDate()
              ? DateUtil.convertDateToString(pm.getCreateDate(), DateUtil.pattern2)
              : "");

      item.put("Es", pm.getEs());
      item.put("Fmin", pm.getFmin());
      item.put("M3000F1", pm.getM3000F1());
      item.put("M3000F2", pm.getM3000F2());

      array.add(item);
    }
    json.put(Constant.ROWS, array);
    return json;
  }
Exemplo n.º 8
0
  @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;
    }
  }