MySQL转数据到Oracle(二)

public static void main(String[] args) {
new TestMysql();
}

public TestMysql() {

//刪除文件
deleteFile();

if (!connectionMethod()) {
System.out.println("鏈接錯誤");
return;
}

Vector table = queryAllTable(DBSCHEMA);
if (table.size() == 0) {
System.out.println("沒有找到表");
return;
}

for (int i = 0; i < table.size(); i++) { //得到數據
hashtable.put(table.get(i), handle_table(table.get(i)));
}

// hashtable.put(table.get(0).toString(),handle_table(table.get(0)));
System.out.println("操作正在進行中,請耐心等待......");
generatorString(hashtable); //產生字符串

close();//關閉連接
System.out.println("finish");
}

public void generatorString(Hashtable hashtable) {
Iterator iter = hashtable.keySet().iterator();
while (iter.hasNext()) {
String tablescript = ""; // 創表語句
String tablesequence = ""; // 建立sequence
String tabletrigger = ""; // 建立trigger
String tableprimarykey = "";// 建立主鍵
String tableindex = "";// 建立索引
String primarkeyColumn = "";
String indexColumn = "";

int primarykey = 0;
int index = 0;

String tablename = (String) iter.next();
Vector valall = (Vector) hashtable.get(tablename);
tablescript = "create table " + tablename + "(";
for (int i = 0; i < valall.size(); i++) {
Vector val = (Vector) valall.get(i);
String column_name = val.get(0).toString();// 列名
String is_nullable = val.get(1).toString();// 是否為空，如果不允許NO,允許為YES
String data_type = val.get(2).toString();// int,varchar,text,timestamp,date
String character_maximun_length = val.get(3).toString();// 長度大小
String column_key = val.get(4).toString();// 是否主鍵 是的話為PRI
// MUL(index)
// 有兩個PRI說明是複合index
String extra = val.get(5).toString(); // 是否自動增長列 是的話
// auto_increment
String column_default = val.get(6).toString();// 是否有默認值

if (data_type.equals("varchar") || data_type.equals("char")) { // 驗證是否有中文字符
if (judge_china(tablename, column_name)) {
character_maximun_length = Integer
.parseInt(character_maximun_length)
* 3 + "";
}
}

tablescript = tablescript + column_name + " ";
if (data_type.equals("int")) {
tablescript = tablescript + "NUMBER" + " ";
} else if (data_type.equals("mediumint")) {
tablescript = tablescript + "NUMBER" + " ";
} else if (data_type.equals("char")) {
tablescript = tablescript + "varchar2("
+ character_maximun_length + ")" + " ";
} else if (data_type.equals("varchar")) {
tablescript = tablescript + "varchar2("
+ character_maximun_length + ")" + " ";
} else if (data_type.equals("text")) {
tablescript = tablescript + "varchar2(4000) ";
} else if (data_type.equals("timestamp")) {
tablescript = tablescript + "date" + " ";
} else if (data_type.equals("date")) {
tablescript = tablescript + "date" + " ";
} else if (data_type.equals("float")) {
tablescript = tablescript + "NUMBER" + " ";
} else if (data_type.equals("longtext")) {
tablescript = tablescript + "varchar2(4000) ";
} else if (data_type.equals("smallint")) {
tablescript = tablescript + "NUMBER" + " ";
} else if (data_type.equals("double")) {
tablescript = tablescript + "NUM