将表中的数据复制到另一个数据库的表中

1. 在 src 目录下创建 jdbc.properties

#Oracle
oracle.driver=oracle.jdbc.driver.OracleDriver
oracle.jdbcUrl=jdbc:oracle:thin:@localhost:1521:orcl
oracle.user=scott
oracle.password=tiger

#MySQL
mysql.driver=com.mysql.jdbc.Driver
mysql.jdbcUrl=jdbc:mysql://localhost:3306/test
mysql.user=root
mysql.password=root

#SQL Server
sqlserver.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver.jdbcUrl=jdbc:sqlserver://localhost:1433;DatabaseName=tempdb
sqlserver.user=sa
sqlserver.password=123456

2. 编写 JdbcUtils 工具类

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;

public class JdbcUtils {
	
	public static enum DatabaseType {
		Oracle("oracle"), 
		SQL_Server("sqlserver"), 
		MySQL("mysql");
		
		private String name;
		private DatabaseType(String name) {
			this.name = name;
		}
		public String getName() {
			return name;
		}
	};

	private static Properties props;
	
	static {
		try {
			InputStream in = Thread.currentThread()
					.getContextClassLoader()
					.getResourceAsStream("jdbc.properties");
			props = new Properties();
			props.load(in);
		} catch (IOException e) {
			throw new ExceptionInInitializerError(e);
		}
	}
	
	/**
	 *  获取数据库连接
	 * @param type 要操作的数据库
	 * @return
	 * @throws Exc