-
大小: 401KB文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2021-01-04
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: Mysql表轉(zhuǎn)??Oracle表??單表轉(zhuǎn)??簡單復(fù)制??
資源簡介
Mysql的表對象Sql語句轉(zhuǎn)換單表，轉(zhuǎn)換成Oracle創(chuàng)建表sql，在樣本.txt粘貼Mysql的單表所有字段信息，輸入表名。就會在控件臺輸出轉(zhuǎn)換后的Oracle語句。
代碼片段和文件信息
package?com.test;
import?java.io.File;
import?java.io.IOException;
import?java.util.ArrayList;
import?java.util.List;
import?org.apache.commons.io.FileUtils;
import?org.apache.commons.lang.StringUtils;
public?class?CommonUtil_test2?{
/**
?*?轉(zhuǎn)換字符串，數(shù)據(jù)字段與對象屬性的轉(zhuǎn)換
?*/
public?static?void?convertData（String?tableName?String?filePath）?{
try?{
List?lines?=?FileUtils.readLines（new?File（filePath）“utf-8“）;
System.out.println（lines.size（）+“個“）;
//?后面需要添加的數(shù)據(jù)
List?tempList?=?new?ArrayList（）;
System.out.println（“create?table?“+tableName+“（“）;
for?（int?i=0;i
????????????if（StringUtils.isBlank（s））?{
???????????? continue;
????????????}
????????????
????????????s?=?s.t ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????2289??2017-12-30?17:35??MysqlObjToOracle\樣本文件.txt
?????目錄???????????0??2017-12-31?13:07??MysqlObjToOracle\
?????文件?????????426??2017-12-31?13:12??MysqlObjToOracle\.classpath
?????文件?????????392??2017-12-31?13:04??MysqlObjToOracle\.project
?????目錄???????????0??2017-12-31?13:05??MysqlObjToOracle\.settings\
?????文件??????????88??2017-12-31?13:05??MysqlObjToOracle\.settings\org.eclipse.core.resources.prefs
?????目錄???????????0??2017-12-31?13:12??MysqlObjToOracle\bin\
?????目錄???????????0??2017-12-31?13:12??MysqlObjToOracle\bin\com\
?????目錄???????????0??2017-12-31?13:12??MysqlObjToOracle\bin\com\test\
?????文件????????3659??2017-12-31?13:12??MysqlObjToOracle\bin\com\test\CommonUtil_test2.class
?????目錄???????????0??2017-12-31?13:10??MysqlObjToOracle\lib\
?????文件??????173587??2017-12-31?13:10??MysqlObjToOracle\lib\commons-io-2.2.jar
?????文件??????261809??2017-12-31?13:07??MysqlObjToOracle\lib\commons-lang-2.4.jar
?????目錄???????????0??2017-12-31?13:05??MysqlObjToOracle\src\
?????目錄???????????0??2017-12-31?13:05??MysqlObjToOracle\src\com\
?????目錄???????????0??2017-12-31?13:05??MysqlObjToOracle\src\com\test\
?????文件????????3003??2017-12-31?13:12??MysqlObjToOracle\src\com\test\CommonUtil_test2.java
評論
共有 條評論