@Async(ThreadPoolConfig.EXECUTOR_NAME)
public void transferData() throws SQLException, CloneNotSupportedException {
String srcUrl = DBURL.getURL(DBURL.DBTYPE_SQLSERVER, "10.10.1.47", "1433", "srcdbname");
String srcUser = "sa";
String srcPasswd = "123456";
String targetUrl = DBURL.getURL(DBURL.DBTYPE_MYSQL, "10.10.1.47", "3306", "targetdbname");
String targetUser = "root";
String targetPasswd = "123456";
DruidDataSource srcDataSource = createDataSource(DBURL.DBTYPE_SQLSERVER, srcUrl, srcUser, srcPasswd);
SqlRunner srcSqlRunner = SqlRunner.create(srcDataSource);
DruidDataSource targetDataSource = createDataSource(DBURL.DBTYPE_MYSQL, targetUrl, targetUser, targetPasswd);
SqlRunner targetSqlRunner = SqlRunner.create(targetDataSource);
List<Entity> dictionaryWordList = srcSqlRunner.findAll("srctbnam
线程池 抓取数据库信息
本文详细介绍了如何使用线程池技术来优化数据库信息的抓取过程,通过合理调度并发线程,提高数据获取效率,同时有效管理和控制资源消耗。
摘要由CSDN通过智能技术生成