以下是从网上复制下来的一段代码，它展示了在Java中连接不同的数据库所需要的URL格式。非常全面，供参考。另，最新的JDBC规范已不再要求程序必须创建驱动的实例（即类似Class.forName这样的语句在新版的JDBC下不是必需了），所以各位只需要关注URL即可。
1. switch (type) {
2. case SQLSERVER: // 该分支对应SQLSERVER 2000。SQLSERVER 2005与之不完全相同
3. String url = "jdbc:sqlserver://" + host + ":" + port + ";" + "dataBaseName=" + dbName;
4.// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();//method1(the way of load Driver
5.// DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());//method2
6. com.microsoft.jdbc.sqlserver.SQLServerDriver sql = new com.microsoft.jdbc.sqlserver.SQLServerDriver();//method3
7. con = (Connection) DriverManager.getConnection(url, userName, password);
8. break;
9. case MYSQL:
10. String url1 = "jdbc:mysql://" + host + "/" + dbName + "?characterEncoding=utf-8&user=";
11.// String url1 = "jdbc:mysql://" + host + "?&useUnicode=true&characterEncoding=8859_1";
12. //following way is the first way to load driver
13.// Class.forName("com.mysql.jdbc.Driver").newInstance();
14. //the dirver is also could be the following
15. Class.forName("org.gjt.mm.mysql.Driver").newInstance();
16. con = (Connection) DriverManager.getConnection(url1, userName, password);
17. break;
18. case ORACLE:
19. String url2 = "jdbc:oracle:thin:@" + host + ":" + port + ":" + dbName;
20. Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
21. con = DriverManager.getConnection(url2, userName, password);
22. break;
23. case DB2:
24. Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
25. String url4 = "jdbc:db2://" + host + ":" + port + "/" + dbName; //sample为你的数据库名
26. con = DriverManager.getConnection(url4, userName, password);
27. break;
28. case SYBASE:
29. Class.forName("com.sybase.jdbc.SybDriver").newInstance();
30. String url5 = " jdbc:sybase:Tds:" + host + ":" + port + "/" + dbName;//myDB为你的数据库名
31. Properties sysProps = System.getProperties();
32. sysProps.put("user", "userid");
33. sysProps.put("password", "user_password");
34.
con = DriverManager.getConnection(url5, sysProps);
35. break;
36. case SYSPROPS:
37. Class.forName("https://www.doczj.com/doc/3417891035.html,rmix.jdbc.IfxDriver").newInstance();
38. String url6 = "jdbc:informix-sqli://" + host + ":" + port + "/" + dbName;
39. con = DriverManager.getConnection(url6, userName, password);
40. break;
41. case POSTGRESQL:
42. Class.forName("org.postgresql.Driver").newInstance();
43. String url7 = "jdbc:postgresql://" + host + "/" + dbName; //myDB为数据库名
44. con = DriverManager.getConnection(url7, userName, password);
45. break;
46. case ACCESS:
47. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
48. String url8 = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=" + dbName;
49. con = DriverManager.getConnection(url8, userName, password);
50. break;
51. }