Java链接几种不同数据库的操作

1.MySQL数据库连接操作：
Class.forName(“com.mysql.jdbc.Driver”);
Connection conn =DriverManager.getConnection(“jdbc:mysql://localhost:3306/database_name”,”数据库名”,”密码”);

2.Oracle数据库连接操作：
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “admin”;
String passwd = “admin”;
Connection conn =DriverManager.getConnection(“url”,”user”,”password”);

3.SQL Server数据库连接操作：
Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”);
String url = “jdbc:microsoft:sqlserver://localhost:1433;DatabasName = test”;
String user = “sa”;
String passwd = “admin”;
Connection conn =DriverManager.getConnection(“url”,”user”,”password”);

4.DB2数据库连接操作：
Class.forName(“com.lim.db2.jdbc.driver.OracleDriver”);
String url = “jdbc:db2://locahhost:5000/sample”;
String user = “admin”;
String passwd = “admin”;
Connection conn =DriverManager.getConnection(“url”,”user”,”password”);