连接数据库的方式

各种数据库连接 URL 关键代码

通过 JDBC 连接数据库时，各个数据库有着不同的 URL 格式，为了方便大家使用，我在以下提供了常见的 7 种数据库连接示例代码，请根据实际需要进行相应的更改。

1.Oracle 数据库

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

String url = "jdbc:oracle:thin:@localhost:1521:orcle";

String user = "test";

String password = "test";

Connection conn = DriverManager.getConnection(url, user, password);

2.DB2 数据库

Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();

String url = "jdbc:

String user = "admin";

String password = "test";

Connection conn = DriverManager.getConnection(url, user, password);

3.SQL Server 数据库

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url = "jdbc:microsoft:;DatabaseName=testDB";

String user = "sa";

String password = "test";

Connection conn = DriverManager.getConnection(url, user, password);

4. Sybase 数据库

Class.forName("com.sybase.jdbc.SybDriver").newInstance();

String url = "jdbc:sybase:Tds:localhost:5007/testDB";

Properties sysProps = System.getProperties();

sysProps.put("user", "userid");

sysProps.put("password", "user_password");

Connection conn = DriverManager.getConnection(url, sysProps);

5.Informix 数据库

Class.forName("com.infoxmix.jdbc.IfxDriver").newInstance();

String url = "jdbc:infoxmix-

Connection conn = DriverManager.getConnection(url);

6.MySQL 数据库

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

String url = "jdbc:

Connection conn = DriverManager.getConnection(url);

7.PostgreSQL 数据库

Class.forName("org.postgresql.Driver").newInstance();

String url = "jdbc:

String user = "myuser";

String password = "test";

Connection conn = DriverManager.getConnection(url, user, password);