jdbc 常用数据库连接字符串

最新推荐文章于 2025-08-11 10:39:51 发布

最新推荐文章于 2025-08-11 10:39:51 发布 · 167 阅读

文章标签：

#JDBC #DB2 #Sybase #MySQL #Oracle

javaSE 专栏收录该内容

7 篇文章

订阅专栏

本文提供了多种常见数据库（包括Oracle、DB2、SQL Server、MySQL、Sybase和Access）的Java连接配置示例，涵盖不同版本间的细微差别，帮助开发者快速建立数据库连接。

这个东西重来就不记的。

Oracle
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";//orcl is database SID
String user = "username";
String password = "password";
Connection dbconn = DriverManager.getConnection(url,user,password);  

-------------------------------------------------
DriverManager.getConnection("jdbc:oracle:thin:@localhost:orcl", "sys as sysdba","sys");
=================================================

DB2
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
String url = "jdbc:db2://localhost:5000/DatabaseName";
String user = "username";
String password = "password";
Connection dbconn = DriverManager.getConnection(url,user,password); 

=================================================

SQL Server 2000
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname";
String user = "username";
String password = "password";
Connection dbconn = DriverManager.getConnection(url,user,password); 
-------------------------------------------------
SQL Server 2005/2008
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=dbName";

=================================================

MYSQL
Class.forName("org.gjt.mm.mysql.Driver");
String url = "jdbc:mysql://localhost:3306/DatabaseName?useUnicode=true&characterEncoding=UTF-8";
String user = "username";
String password = "password";
Connection dbconn = DriverManager.getConnection(url,user,password); 
-------------------------------------------------
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/dbName"

=================================================

Sybase
Class.forName("com.sybase.jdbc.SybDriver");
String url = "jdbc:sybase:Tds:localhost:5007/DatabaseName";
Properties sysProps = System.getProperties();
SysProps.put("user","admin"):
SysProps.put("password","123456"):
Connection dbconn = DriverManager.getConnection(url,user,password); 

=================================================

Access
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbconn = DriverManager.getConnection("jdbc:odbc:DatabaseName"); 

=================================================