Example #1
0
  public void updateTacTerminal() {
    /**
     * List<String[]> list = CvsFileParser.getCSV("厂商数据_01.csv"); for(String[] ss:list){
     * if(ss.length < 3){ System.out.println(" >> "+ss[0]+"|"+ss[1]); } }
     */
    Cnd condition = Cnd.where("d_status", "=", "1");
    List<Tac> tlist = dao.search(Tac.class, condition.orderBy().asc("d_hsman_name"));
    for (Tac t : tlist) {
      List<String[]> list = CvsFileParser.getCSV("厂商数据_01.csv");
      for (String[] str : list) {
        if (t.getHsmanName().toLowerCase().equals(str[0].toLowerCase())) {
          if (!"0".equals(str[1])) {
            t.setHsmanNameEn(str[1].toLowerCase());
          }
          if (!"0".equals(str[2])) {
            t.setHsmanName(str[2].toLowerCase());
          }

          if (dao.update(t)) {
            System.out.println(
                " >> 更新成功["
                    + t.getId()
                    + "|"
                    + t.getTac()
                    + "|"
                    + t.getHsmanName()
                    + "|"
                    + t.getHsmanNameEn()
                    + "]");
            break;
          }
        }
      }
    }
  }
Example #2
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);
 }
Example #3
0
 public void test2() {
   Cnd condition = Cnd.where("d_hsman_name", "=", "apple");
   List<Tac> list = dao.search(Tac.class, condition);
   StringBuffer sb = new StringBuffer(" in (\t");
   for (Tac tac : list) {
     sb.append("\'" + tac.getTac() + "\'").append(",");
   }
   sb.append("\t)");
   //		ViewTerminal v = dao.findByCondition(ViewTerminal.class, condition);
   //		System.out.println(" >> "+Json.toJson(v));
   System.out.println("" + sb.toString());
 }
Example #4
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");
    }
  }
Example #5
0
 public void test6() {
   Cnd condition = Cnd.where("d_status", "=", "1");
   List<Tac> tlist = dao.search(Tac.class, condition.orderBy().asc("d_hsman_name"));
   for (Tac t : tlist) {
     //			System.out.print(" >
     // "+t.getHsmanName()+"|"+t.getHsmanNameEn()+"|"+t.getHstypeName()+"|"+t.getHstypeNameEn());
     // 如果是英文,则将中文名称制空,然后修改英文
     /**
      * if(t.getHsmanName().matches("^[a-zA-Z]*")){ t.setHsmanName("暂无"); t.setCreatetime(new
      * Date()); }
      */
     if (null != t.getHsmanNameEn()
         && !"".equals(t.getHsmanNameEn())
         && t.getHstypeName().toLowerCase().startsWith(t.getHsmanNameEn().toLowerCase())) {
       String hstypename =
           t.getHstypeName().toLowerCase().replace(t.getHsmanNameEn().toLowerCase(), "");
       if (null != hstypename) {
         t.setHstypeName(hstypename.trim());
         System.out.println(" -> 1:" + hstypename.trim());
       }
     }
     if (null != t.getHsmanName()
         && !"".equals(t.getHsmanName())
         && t.getHstypeName().toLowerCase().startsWith(t.getHsmanName().toLowerCase())) {
       String hstypename =
           t.getHstypeName().toLowerCase().replace(t.getHsmanName().toLowerCase(), "");
       if (null != hstypename) {
         t.setHstypeName(hstypename.trim());
         System.out.println(" -> 2:" + hstypename.trim());
       }
     }
     if (t.getHstypeName().startsWith("one touch ")) {
       String hstypename = t.getHstypeName().toLowerCase().replace("one touch ", "");
       t.setHstypeName(hstypename);
     }
     String[] strs = t.getHstypeName().toLowerCase().split(" ");
     if (strs.length > 2) {
       String hsman = strs[0];
       String hstype = strs[1];
       System.out.println(
           " > [" + t.getHsmanName() + "|" + t.getHstypeName() + "] " + hsman + "|" + hstype);
     }
     /** */
     //			if(dao.update(t)){
     //				System.out.println(" >> 更新厂商名称为英文的厂商名称成功!");
     //			}
   }
 }
Example #6
0
  public void t20110514() throws Exception {
    List<String[]> list = CvsFileParser.getCSV("input_2011-05-14.csv");
    StringBuffer sb = new StringBuffer();
    int i = 0;
    HashMap map = new HashMap();
    for (String[] s : list) {
      sb.append(s[0])
          .append(",")
          .append(s[1])
          .append(",")
          .append(s[2])
          .append(",")
          .append(s[3])
          .append(",")
          .append(s[4])
          .append(",")
          .append(s[5])
          .append(",")
          .append(s[6])
          .append(",");
      String tac = s[2];
      if (null != tac && !"".equals(tac)) {
        Tac tmp = dao.findByCondition(Tac.class, Cnd.where("d_tac", "=", tac));
        try {
          if (null != tmp.getHsmanName()) {
            map.put(tmp.getHstypeName(), tmp);
          } else {
            map.put(tmp.getHstypeNameEn(), tmp);
          }
          //						System.out.println(" >> "+tmp.getHsmanName()+"|"+tmp.getHstypeName());
          //						if(GoogleSearchTools.process(tmp.getHsmanName(), tmp.getHstypeName())){
          //							System.out.println(" >> 支持GPRS");
          //							sb.append("支持");
          //							i++;
          //						}else{
          //							sb.append("不支持");
          //						}
          //					}else{
          //						System.out.println(" >> "+tmp.getHsmanNameEn()+"|"+tmp.getHstypeNameEn());
          //						if(GoogleSearchTools.process(tmp.getHsmanNameEn(), tmp.getHstypeNameEn())){
          //							System.out.println(">> 支持GPRS");
          //							sb.append("支持");
          //							i++;
          //						}else{
          //							sb.append("不支持");
          //						}
          //					}
        } catch (Exception e) {
          sb.append("不支持");
        }
        //				Thread.sleep(50);
      }
      //			sb.append("\r\n");
    }
    Iterator it = map.keySet().iterator();
    while (it.hasNext()) {
      String key = (String) it.next();
      Object obj = map.get(key);
      //			System.out.println(" >> key:"+key);
      if (null != obj) {
        Tac value = (Tac) obj;
        System.out.println(
            " >> 该手机号在成功终端中已经存在:"
                + key
                + "|"
                + value.getHsmanName()
                + "|"
                + value.getHsmanNameEn()
                + "|"
                + value.getHstypeName()
                + "|"
                + value.getHstypeNameEn());
      }
    }
    //		System.out.println(sb.toString());
    //		IOUtil.createFile(sb.toString(), "2011-05-13-1052.csv");
    System.out.println(" >> 机型数量:" + map.size());

    System.gc();
  }
Example #7
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");
    }
  }
Example #8
0
  public void waplogPatch() throws ClassNotFoundException {
    if (null != dao) {
      System.out.println(" >> dao is not null");
      List<Tac> tlist = dao.search(Tac.class, Cnd.orderBy().asc("d_id"));
      int fo = 0;
      int offset = 0;
      for (Tac s : tlist) {
        if (!s.getHsmanName().equals("参照机型名称(英文)")) {
          continue;
        }
        if (null == s.getHstypeName() || s.getHstypeName().equals("")) {
          continue;
        }
        String info = s.getHstypeName().split("/")[0];
        info = info.replace("\"", "").replace("_CMCC", "").trim();
        if (info.startsWith("Nokia")) {
          int start = info.lastIndexOf("a");
          if (start > 0) {
            s.setHsmanName("Nokia");
            s.setHsmanNameEn("Nokia");
            s.setHstypeName(info.substring(start + 1, info.length()));
            s.setHstypeNameEn(info.substring(start + 1, info.length()));
          }
        } else if (info.startsWith("SonyEricsson")) {
          int start = info.lastIndexOf("n");
          if (start > 0) {
            s.setHsmanName("SonyEricsson");
            s.setHsmanNameEn("SonyEricsson");
            s.setHstypeName(info.substring(start + 1, info.length()));
            s.setHstypeNameEn(info.substring(start + 1, info.length()));
          }
        } else {
          String[] hs = info.split("-");
          int length = hs.length;
          if (length < 2) {
            System.out.println(" >> info:" + info);
          } else {
            if (length == 2) {
              s.setHsmanName(hs[0]);
              s.setHsmanNameEn(hs[0]);
              s.setHstypeName(hs[1]);
              s.setHstypeNameEn(hs[1]);
            } else if (length == 3) {
              s.setHsmanName(hs[0] + "-" + hs[1]);
              s.setHsmanNameEn(hs[0] + "-" + hs[1]);
              s.setHstypeName(hs[2]);
              s.setHstypeNameEn(hs[2]);
            } else {
              fo++;
            }
          }
        }

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