package MyEclipseRegister;
import java.sql.Connection;
import java.sql.DriverManager;
public class GetconnectionByNumber {
public static Connection connection = null;
public static String URL = null;
public static String USER = null;
public static String PASSWORD = null;
/***
- 常见JDBC数据连接操作
- @param args
- @author xiezepeng
*/
public static void main(String[] args) {
//调用方式
GetconnectionByNumber.getConnectionByNumber(1);
}
/***
- 根据不同数字获取不同连接
- @param Number
- 1: Access数据库
- 2:sqlServer数据库
- 3:MySQL数据库
- 4:Oracle数据库
- 5:DB2数据库
- 6: Sybase数据库
- @return connection
/
public static Connection getConnectionByNumber(int Number)
{
try {
switch (Number) {
case 1:
//加载驱动
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”).newInstance();
//获取数据库
String DB_DataBase = “D:\db1.mdb”;
//获取连接字符串
URL = "jdbc:odbc:driver={Microsoft Access Driver (.mdb)};DBQ="+ DB_DataBase;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
case 2:
//加载驱动
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”).newInstance();
//获取连接字符串
URL = “jdbc:sqlserver://localhost:1433;DatabaseName=tempdb”;
//用户名
USER = “sa”;
//密码
PASSWORD = “123456”;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
case 3:
//加载驱动
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
//获取连接字符串
URL = “jdbc:mysql://localhost:3306/Company”;
//用户名
USER = “xiezepeng”;
//密码
PASSWORD = “suenpeng”;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
case 4:
//加载驱动
Class.forName(“oracle.jdbc.driver.OracleDriver”).newInstance();
//获取连接字符串
URL = “jdbc:oracle:thin:@192.168.0.1:1521:myOracel”;
//用户名
USER = “manager”;
//密码
PASSWORD = “suenpeng”;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
case 5:
//加载驱动
Class.forName(“Com.ibm.db2.jdbc.net.DB2Driver”).newInstance();
//获取连接串
URL = “jdbc:db2://192.9.200.108:6789/My_DB2”;
//用户名
USER =“xiezepeng”;
//密码
PASSWORD =“suenpneg”;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
case 6:
//加载驱动
Class.forName(“com.sybase.jdbc2.jdbc.SybDriver”).newInstance();
//获取连接串
URL = “jdbc:sybase:Tds:MyDbComputerNameOrIP:2638”;
//用户名
USER =“xiezepeng”;
//密码
PASSWORD =“suenpneg”;
//获取连接
connection = DriverManager.getConnection(URL, USER, PASSWORD);
return connection;
default:
System.err.println(“Default------Not Connection null”);
return null;
}
} catch (ClassNotFoundException e1) {
System.err.println(“无法获取数据库驱动文件信息!”);
e1.printStackTrace();
} catch (Exception e2) {
System.err.println(“连接数据驱动异常!”);
e2.printStackTrace();
}
return null;
}
}