import java.sql.Connection;
import java.sql.DriverManager;
//获取sqlserver connection
public static Connection getSQLServerConn(){
Connection dbConn = null;
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=jimo";
String userName = "sa";
String userPwd = "123456";
try{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
}catch(Exception e){
e.printStackTrace();
close( dbConn);
}
return dbConn;
}
public static void close(Connection dbConn){
try{
if(dbConn!=null){
dbConn.close();// 关闭Connection
}
}catch(SQLException e){
e.printStackTrace();
}
}
//获取oracle连接Connection
public static Connection getOracleConn(String user,String password){
String driver = "oracle.jdbc.OracleDriver"; //驱动标识符
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; //链接字符串
user = "name"; //数据库的用户名
password = "pwd"; //数据库的密码
Connection con = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url,user, password);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
//java获取mysql连接 Connection
public static Connection getMysqlConn(){
String driver = "com.mysql.jdbc.Driver"; //驱动标识符
String url = "jdbc:mysql://localhost:port/mysqlname"; //链接字符串
String user = "name"; //数据库的用户名
String password = "pwd"; //数据库的密码
Connection con = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url,user, password);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
//达梦数据库
public Connection getDMConnect( {
String driver = "dm.jdbc.driver.DmDriver";
String url = "jdbc:dm:// IP:PORT/DATABASE"; //链接字符串
String user = USER ;
String password = PASSWD ;
Connection con = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url,user, password);
}catch(Exception e){
e.printStackTrace();
}
return con;
}