如何使用Java编写CMS系统的数据同步模块

import org.apache.commons.dbcp2.BasicDataSource;

// 源数据源配置
BasicDataSource sourceDataSource = new BasicDataSource();
sourceDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
sourceDataSource.setUrl("jdbc:mysql://localhost:3306/source_database");
sourceDataSource.setUsername("source_user");
sourceDataSource.setPassword("source_password");

// 目标数据源配置
BasicDataSource targetDataSource = new BasicDataSource();
targetDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
targetDataSource.setUrl("jdbc:mysql://localhost:3306/target_database");
targetDataSource.setUsername("target_user");
targetDataSource.setPassword("target_password");

import java.sql.*;

public class DataSync {
    public void syncData() {
        Connection sourceConn = null;
        Connection targetConn = null;

        try {
            // 建立源数据源和目标数据源的连接
            sourceConn = sourceDataSource.getConnection();
            targetConn = targetDataSource.getConnection();

            // 执行源数据源的查询操作
            Statement stmt = sourceConn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM source_table");

            // 执行目标数据源的更新操作
            PreparedStatement pstmt = targetConn.prepareStatement("INSERT INTO target_table (col1, col2) VALUES (?, ?)");

            while (rs.next()) {
                // 读取源数据源中的数据
                int col1 = rs.getInt("col1");
                String col2 = rs.getString("col2");

                // 插入数据到目标数据源
                pstmt.setInt(1, col1);
                pstmt.setString(2, col2);
                pstmt.executeUpdate();
            }

            // 关闭数据库连接
            rs.close();
            stmt.close();
            pstmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            try {
                if (sourceConn != null) sourceConn.close();
                if (targetConn != null) targetConn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

DataSync dataSync = new DataSync();
dataSync.syncData();