Esempio n. 1
0
 public void find() {
   String tac = "01058001";
   int c = 0;
   IndexParser.init();
   HashMap<String, String[]> map = IndexParser.getTacMap();
   Iterator it = map.keySet().iterator();
   while (it.hasNext()) {
     String key = (String) it.next();
     Tac t = dao.getByTac(key);
     String[] str = map.get(key);
     if (null != t) {
       t.setTac(key);
       t.setHsmanNameEn(str[1]);
       t.setHsmanName(str[1]);
       t.setHstypeNameEn(str[2]);
       t.setHstypeName(str[2]);
       t.setModifytime(new Date());
       if (dao.update(t)) {
         System.out.println(" >> Update Success!");
       }
     } else {
       t = new Tac();
       t.setTac(key);
       t.setHsmanNameEn(str[1]);
       t.setHstypeNameEn(str[2]);
       System.out.println(" >> 添加数据:" + Json.toJson(t));
       t = dao.save(t);
       if (t.getId() > 0) {
         c++;
         System.out.println(Json.toJson(t));
       }
     }
   }
   System.out.println(" >> c:" + c);
 }
Esempio n. 2
0
  public void test() throws ClassNotFoundException {
    if (null != dao) {
      System.out.println(" >> dao is not null");
      List<String[]> list = IMEIParser.getCSV("IMEI终端型号统计.csv");
      Tac tac = null;
      for (String[] s : list) {
        tac = new Tac();
        tac.setTac(s[0]);
        tac.setHsmanName(s[1]);
        tac.setHstypeName(s[2]);

        Tac tmp = dao.findByCondition(Tac.class, Cnd.where("d_tac", "=", tac.getTac()));
        if (null == tmp) {
          tac = dao.save(tac);
          System.out.println(" >> " + tac.getId());
        } else {
          System.out.println(" >> 已存在tac[" + tmp.getTac() + "]");
        }
        break;
      }
    } else {
      System.out.println(" >> dao is null");
    }
  }
Esempio n. 3
0
  public void waplog() throws ClassNotFoundException {
    if (null != dao) {
      System.out.println(" >> dao is not null");
      List<String[]> list = IMEIParser.getCSV("wap19.csv");
      List<Tac> tlist = dao.search(Tac.class, Cnd.orderBy().asc("d_id"));
      Tac tac = null;
      int fo = 0;
      int offset = 0;
      for (String[] s : list) {
        tac = new Tac();
        try {
          if (null == s[2] || "".equals(s[2])) {
            continue;
          }
        } catch (Exception e) {
          continue;
        }
        tac.setTac(s[2]);
        String info = s[3].split("/")[0];
        info = info.replace("\"", "").replace("_CMCC", "").trim();
        if (info.startsWith("Nokia")) {
          int start = info.lastIndexOf("a");
          if (start > 0) {
            tac.setHsmanName("Nokia");
            tac.setHstypeName(info.substring(start + 1, info.length()));
          }
        } else if (info.startsWith("SonyEricsson")) {
          int start = info.lastIndexOf("n");
          if (start > 0) {
            tac.setHsmanName("SonyEricsson");
            tac.setHstypeName(info.substring(start + 1, info.length()));
          }
        } else if (info.startsWith("OPPO")) {

        } else {
          String[] hs = info.split("-");
          int length = hs.length;
          if (length < 2) {
            System.out.println(" >> info:" + info);
          } else {
            if (length == 2) {
              tac.setHsmanName(hs[0]);
              tac.setHstypeName(hs[1]);
            } else if (length == 3) {
              tac.setHsmanName(hs[0] + "-" + hs[1]);
              tac.setHstypeName(hs[2]);
            } else {
              fo++;
            }
          }
        }

        if (null == tac.getHsmanName() || "".equals(tac.getHsmanName())) {
          continue;
        }
        if (null == tac.getHstypeName() || "".equals(tac.getHstypeName())) {
          continue;
        }
        Tac tmp = dao.findByCondition(Tac.class, Cnd.where("d_tac", "=", tac.getTac()));
        if (null == tmp) {
          tac = dao.save(tac);
          //					System.out.println(" >> "+tac.getId());
          offset++;
        } else {
          //					System.out.println(" >> 已存在tac["+tmp.getTac()+"]");
        }
      }
      System.out.println(" >> fo:" + fo);
      System.out.println(" >> offset:" + offset);
    } else {
      System.out.println(" >> dao is null");
    }
  }