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;
}
}
jdbc获取各种数据库连接
最新推荐文章于 2022-04-12 10:40:11 发布