62,615
社区成员
发帖
与我相关
我的任务
分享
package zlqrdmjg;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Set;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class Cndata {
/**
* @param args
*/
static ArrayList countrys = new ArrayList();
static ArrayList names_zh = new ArrayList();
static ArrayList names = new ArrayList();
static ArrayList names_en = new ArrayList();
static ArrayList kinds = new ArrayList();
static ArrayList oricodes = new ArrayList();
public static ArrayList cnOricode() {
ArrayList oricode = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"jigedaima.TXT"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
oricode.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return oricode;
}
public static ArrayList cnCountry() {
ArrayList country = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"guobie.TXT"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
country.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return country;
}
public static ArrayList cnName_en() {
ArrayList name_en = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"ywmc.TXT"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
name_en.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return name_en;
}
public static ArrayList cnName_zh() {
ArrayList name_zh = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader("zwmc.TXT"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
name_zh.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return name_zh;
}
public static ArrayList cnKind() {
ArrayList kind = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"leixing.TXT"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
kind.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return kind;
}
public static HashMap getNames(String name_en,String name_zh){
HashMap namemap = new HashMap();
String[] names_en = name_en.split(";");
String[] names_zh = name_zh.split(";");
for(int i = 0;i < names_en.length;i++){
if(!names_en[i].equals(""))
namemap.put(names_en[i],"EN" );
}
for(int i = 0;i < names_zh.length;i++){
if(!names_zh[i].equals(""))
namemap.put(names_zh[i],"ZH" );
}
return namemap;
}
public static ArrayList nameTotals() {
ArrayList nametotals = new ArrayList();
ArrayList nametotal;
HashMap namemap;
String name,oricode, sid, country, lang, type, kind;
//readExcel();
sid = "";
type = "CN";
oricodes = cnOricode();
countrys = cnCountry();
kinds = cnKind();
names_en = cnName_en();
names_zh = cnName_zh();
for (int i = 0; i < oricodes.size(); i++) {
oricode = (String) oricodes.get(i);
country = (String) countrys.get(i);
kind = (String) kinds.get(i);
//namemap = (HashMap) names.get(i);
namemap = getNames((String)names_en.get(i),(String)names_zh.get(i));
Set keyset = namemap.keySet();
Iterator iter = keyset.iterator();
while (iter.hasNext()) {
nametotal = new ArrayList();
name = (String)iter.next();
lang = (String)namemap.get(name);
nametotal.add(name);
nametotal.add(oricode);
nametotal.add(sid);
nametotal.add(country);
nametotal.add(lang);
nametotal.add(type);
nametotal.add(kind);
nametotals.add(nametotal);
}
}
return nametotals;
}
}
package zlqrdmjg;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class C3data {
/**
* @param args
*/
static ArrayList countrys = new ArrayList();
static ArrayList kinds = new ArrayList();
static ArrayList names = new ArrayList();
public static ArrayList c3Country() {
ArrayList country = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"1561C3数据-国别.txt"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
country.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return country;
}
public static ArrayList c3Kind() {
ArrayList kind = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"1561C3数据-机构类型.txt"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
kind.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return kind;
}
public static ArrayList c3Name() {
ArrayList name = new ArrayList();
String line;
try {
BufferedReader reader = new BufferedReader(new FileReader(
"1561C3数据-机构名称.txt"));
while ((line = reader.readLine()) != null) {
// System.out.println(line);
name.add(line.trim());
}
reader.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return name;
}
public static ArrayList nameTotals() {
ArrayList nametotals = new ArrayList();
ArrayList nametotal,nametotalmapping;
String name, oricode, sid, country, lang, type, kind;
readExcel();
if (names.size() != kinds.size()) {
System.out.println("样例DOCDB跟DOCBA数量不一致!");
return null;
}
if (names.size() != countrys.size()) {
System.out.println("样例DOCDB跟DOCBA数量不一致!");
return null;
}
oricode = "";
sid = "";
lang = "ZH";
type = "C3";
nametotalmapping = new ArrayList();
for (int i = 0; i < names.size(); i++) {
name = (String) names.get(i);
if(nametotalmapping.contains(name)){
continue;
}
nametotalmapping.add(name);
nametotal = new ArrayList();
country = (String)countrys.get(i);
kind = (String)kinds.get(i);
nametotal.add(name);
nametotal.add(oricode);
nametotal.add(sid);
nametotal.add(country);
nametotal.add(lang);
nametotal.add(type);
nametotal.add(kind);
nametotals.add(nametotal);
}
return nametotals;
}
}