利用Java技術搞定兩個不同資料庫之間的資料交換

 1、建立遠端資料庫的串連：

    public static synchronized Connection getConFromRemote() {        Connection con = null;        String url = "jdbc:sqlserver://admin.xxx.xxx.comdbo:1436;databaseName=remote_jadepool";        String userName = "hkm12345";        String password = "pwd12345";        try {            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");            con = DriverManager.getConnection(url, userName, password);        } catch (SQLException ex1) {            ex1.printStackTrace();        } catch (ClassNotFoundException ex) {            ex.printStackTrace();        }        return con;    }

2、建立本機資料庫的串連

    public static synchronized Connection getConFromLocal() {        Connection con = null;        String url = "jdbc:sqlserver://127.0.0.1dbo:1436;databaseName=jadepool";        String userName = "hkm123";        String password = "pwd123";        try {            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");            con = DriverManager.getConnection(url, userName, password);        } catch (SQLException ex1) {            ex1.printStackTrace();        } catch (ClassNotFoundException ex) {            ex.printStackTrace();        }        return con;    }

3、將遠端資料庫的資料儲存到本機資料庫中

    public void backupDB() {        Jade j0 = new Jade(getConFromRemote(), cn.jadepool.sql.DbConnectionType.USING_DB_01);        List<Map> v0 = j0.query("select * from jade_book");        List<Map> v1 = j0.query("select * from jade_book_cs");        j0.commit();                Jade j1 = new Jade(getConFromLocal(), cn.jadepool.sql.DbConnectionType.USING_DB_02);        j1.delete("delete from jade_book");        j1.insert("jade_book", v0);        j1.delete("delete from jade_book_cs");        j1.insert("jade_book_cs", v1);        j1.commit();    }    

這裡示範的是兩相同的資料庫，使用不同的資料庫不影響結果，但兩者表的結構一定要一致。