基于JDBC同步Oracle到MySQL

上传者: u010636072 | 上传时间: 2021-06-10 19:57:53 | 文件大小: 3.54MB | 文件类型: RAR
主程序位置:com.database.main.com.database.main 直接运行main方法即可,使用线程同步,间隔5分钟同步一次 分别有:数据源配置、数据表结构转换、字段更新、数据迁移、根据oracle SQL的UPDATE DELETE 事物执行记录转为Mysql可执行SQL,同步执行到MySql数据库,此项目为个人兴趣爱好练手项目,项目问题欢迎留言,共同进步成长。 说明文档:https://blog.csdn.net/u010636072/article/details/109147827

文件下载

资源详情

[{"title":"( 33 个子文件 3.54MB ) 基于JDBC同步Oracle到MySQL","children":[{"title":"OracleDataSyncToMySqlData","children":[{"title":".project <span style='color:#111;'> 401B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"database","children":[{"title":"utils","children":[{"title":"JdbcDataBaseUtils.class <span style='color:#111;'> 13.30KB </span>","children":null,"spread":false},{"title":"PublicFun.class <span style='color:#111;'> 2.17KB </span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"FunTest.class <span style='color:#111;'> 1.81KB </span>","children":null,"spread":false}],"spread":true},{"title":"main","children":[{"title":"GenerateMysqlUpdateTabelSqlByOracleTableInfo.class <span style='color:#111;'> 6.87KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro.class <span style='color:#111;'> 3.44KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro$4.class <span style='color:#111;'> 1.95KB </span>","children":null,"spread":false},{"title":"SyncMySqlInsertDataByOracleData.class <span style='color:#111;'> 9.49KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro$2.class <span style='color:#111;'> 2.01KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro$3.class <span style='color:#111;'> 1.83KB </span>","children":null,"spread":false},{"title":"GenerateMySqlCreateTableSqlByOracleTableInfo.class <span style='color:#111;'> 8.84KB </span>","children":null,"spread":false},{"title":"OracleSqlLogAnalysisSyncToMySql.class <span style='color:#111;'> 4.51KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro$1.class <span style='color:#111;'> 2.08KB </span>","children":null,"spread":false}],"spread":true},{"title":"datasource","children":[{"title":"JDBC_DataSourceConfig.class <span style='color:#111;'> 1.83KB </span>","children":null,"spread":false}],"spread":true},{"title":"constant","children":[{"title":"Constants.class <span style='color:#111;'> 463B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.core.runtime.prefs <span style='color:#111;'> 52B </span>","children":null,"spread":false},{"title":"org.eclipse.core.resources.prefs <span style='color:#111;'> 57B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 646B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"database","children":[{"title":"utils","children":[{"title":"JdbcDataBaseUtils.java <span style='color:#111;'> 19.77KB </span>","children":null,"spread":false},{"title":"PublicFun.java <span style='color:#111;'> 1.52KB </span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"FunTest.java <span style='color:#111;'> 1.47KB </span>","children":null,"spread":false}],"spread":true},{"title":"main","children":[{"title":"OracleSqlLogAnalysisSyncToMySql.java <span style='color:#111;'> 4.94KB </span>","children":null,"spread":false},{"title":"GenerateMysqlUpdateTabelSqlByOracleTableInfo.java <span style='color:#111;'> 9.09KB </span>","children":null,"spread":false},{"title":"GenerateMySqlCreateTableSqlByOracleTableInfo.java <span style='color:#111;'> 12.01KB </span>","children":null,"spread":false},{"title":"OracleToMysqlDataSynchro.java <span style='color:#111;'> 9.61KB </span>","children":null,"spread":false},{"title":"SyncMySqlInsertDataByOracleData.java <span style='color:#111;'> 13.02KB </span>","children":null,"spread":false}],"spread":true},{"title":"datasource","children":[{"title":"JDBC_DataSourceConfig.java <span style='color:#111;'> 2.61KB </span>","children":null,"spread":false}],"spread":true},{"title":"constant","children":[{"title":"Constants.java <span style='color:#111;'> 291B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'> 489B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"commons-lang3-3.1.jar <span style='color:#111;'> 308.40KB </span>","children":null,"spread":false},{"title":"fastjson-1.2.58.jar <span style='color:#111;'> 624.53KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.18-bin.jar <span style='color:#111;'> 771.37KB </span>","children":null,"spread":false},{"title":"ojdbc6.jar <span style='color:#111;'> 2.01MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明