jdbc獲取各種資料庫連線

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectionsManager {
	Connection conn;
	String user = "dada";
	String password = "dandan";

	/**
	 * 獲取對oracle連線
	 * @return
	 * @throws Exception
	 */
	public Connection getOracleConn() throws Exception {
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:dandan";
		Class.forName("oracle.jdbc.driver.OracleDriver");
		conn = DriverManager.getConnection(url, user, password);
		return conn;
	}

	/**
	 * 獲取mysql連線
	 * @return
	 * @throws Exception
	 */
	public Connection getMysqlConn() throws Exception {
		String url = "jdbc:mysql://127.0.0.1/dandan";
		Class.forName("org.gjt.mm.mysql.Driver");
		conn = DriverManager.getConnection(url, user, password);
		return conn;
	}

	/**
	 * 獲取sqlServer連線
	 * @return
	 * @throws Exception
	 */
	public Connection getSqlServerConn() throws Exception {
		String url = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		conn = DriverManager.getConnection(url, user, password);

		return conn;
	}

	/**
	 * 獲取Odbc連線
	 * @return
	 * @throws Exception
	 */
	public Connection getOdbcConn() throws Exception {
		String url = "jdbc:odbc:ExcelODBC1";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn = DriverManager.getConnection(url, user, password);
		return conn;

		// 需要注意的是,在使用ODBC進行查詢的時候,跟標準的sql有一些不同
		// 需要使用"[]"把要查詢的表名字給括起來
		// Statement stmt=con.createStatement();
		// ResultSet rs=stmt.executeQuery("select * from [Sheet1$]");
	}

	/**
	 * 獲取Access連線
	 * @return
	 * @throws Exception
	 */
	public Connection getAccessConn() throws Exception {
		String url = "jdbc:odbc:test";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn = DriverManager.getConnection(url, user, password);
		return conn;
	}

	/**
	 * 通過Odbc獲取sqlServer連線
	 * @return
	 * @throws Exception
	 */
	public Connection getSqlServerConn1() throws Exception {
		String url = "jdbc:odbc:mydb1";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn = DriverManager.getConnection(url, user, password);
		// Connection con =
		// DriverManager.getConnection("jdbc:odbc:mydb1;database=pubs", "", "");
		return conn;
	}

	/**
	 * 通過OCI的方式獲取連線***這種方式只能夠獲取對oracle的連線
	 * @return
	 * @throws Exception
	 */
	public Connection getConnByOci() throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		// Connection conn =
		// DriverManager.getConnection("jdbc:oracle:oci:@dandan","root","dada");
		Connection conn = DriverManager
				.getConnection(
						"jdbc:oracle:oci:@(description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=ora9)))",
						"scott", "tiger");
		return conn;
	}
}