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"); } }
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"); } }