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