-
大小: 15.08MB文件類型: .zip金幣: 2下載: 1 次發(fā)布日期: 2023-07-31
- 語言: Java
- 標(biāo)簽: mysql??比對??表結(jié)構(gòu)??差異??
資源簡介
!!!!!!!基于JDK1.8編寫的java代碼
相比之前的比對工具性能更加快速,直接運(yùn)行java工程中的代碼即可比對
1. 兩個 MYSQL 數(shù)據(jù)庫對象結(jié)構(gòu)比對工具 (比如:本地測試庫、遠(yuǎn)程運(yùn)維庫表結(jié)構(gòu)、表中列等對比)
2. 比對結(jié)果導(dǎo)出EXCEL 存放于 “工程根目錄”/export/ 目錄下
3. 比對的對象包括 表、表列、表索引、表分區(qū)差異、觸發(fā)器代碼差異、存儲過程代碼差異,函數(shù)代碼差異 和 對象是否存在等信息
4. 運(yùn)行 cn.guzt.test.AppTest 中的 test方法即可(設(shè)置你的JDBC信息) 一般2秒左右即可出比對結(jié)果
5. 工程所需的jar 在 lib目錄下
代碼片段和文件信息
import?cn.guzt.test.AppTest;
public?class?Main?{
????public?static?void?main(String[]?args)?{
????????//?請?jiān)趖est方法中配置你的jdbc信息
????????//?執(zhí)行比對測試
????????//?導(dǎo)出的比對結(jié)果文件在???工程文件根路徑/mysqldiff/export/??路徑下
????????AppTest.test();
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\
?????文件??????????12??2017-10-26?11:11??mysqldiff-master\.gitignore
?????文件?????????563??2017-10-26?11:11??mysqldiff-master\README.md
?????文件?????????393??2017-10-26?11:11??mysqldiff-master\ReadMe.txt
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\lib\
?????文件??????109043??2017-10-26?11:11??mysqldiff-master\lib\commons-io-1.4.jar
?????文件??????434678??2017-10-26?11:11??mysqldiff-master\lib\commons-lang3-3.4.jar
?????文件???????92241??2017-10-26?11:11??mysqldiff-master\lib\curvesapi-1.03.jar
?????文件??????460708??2017-10-26?11:11??mysqldiff-master\lib\fastjson-1.2.29.jar
?????文件??????391834??2017-10-26?11:11??mysqldiff-master\lib\log4j-1.2.15.jar
?????文件?????1623054??2017-10-26?11:11??mysqldiff-master\lib\mybatis-3.4.5.jar
?????文件??????989495??2017-10-26?11:11??mysqldiff-master\lib\mysql-connector-java-5.1.39.jar
?????文件?????2528204??2017-10-26?11:11??mysqldiff-master\lib\poi-3.14-20160307.jar
?????文件??????340081??2017-10-26?11:11??mysqldiff-master\lib\poi-examples-3.14-20160307.jar
?????文件???????30562??2017-10-26?11:11??mysqldiff-master\lib\poi-excelant-3.14-20160307.jar
?????文件?????1286511??2017-10-26?11:11??mysqldiff-master\lib\poi-ooxm
?????文件?????5919795??2017-10-26?11:11??mysqldiff-master\lib\poi-ooxm
?????文件?????1316029??2017-10-26?11:11??mysqldiff-master\lib\poi-scratchpad-3.14-20160307.jar
?????文件?????2730866??2017-10-26?11:11??mysqldiff-master\lib\xm
?????文件????????4004??2017-10-26?11:11??mysqldiff-master\mysqldiff.iml
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\
?????文件?????????308??2017-10-26?11:11??mysqldiff-master\src\Main.java
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\action\
?????文件????????4958??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\action\DiffAction.java
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\mapper\
?????文件?????????668??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\mapper\MysqlMapper.java
?????文件????????2494??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\mapper\MysqlMapper.xm
?????目錄???????????0??2017-10-26?11:11??mysqldiff-master\src\cn\guzt\diff\properties\
............此處省略33個文件信息
評論
共有 條評論