jdbc 常用数据库连接字符串

xiaoban0514

这个东西重来就不记的。
 
OracleClass.forName("oracle.jdbc.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:orcl";//orcl is database SIDString user = "username";String password = "password";Connection dbconn = DriverManager.getConnection(url,user,password);  -------------------------------------------------DriverManager.getConnection("jdbc:oracle:thin:@localhost:orcl", "sys as sysdba","sys");=================================================DB2Class.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 2000Class.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/2008Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");String url = "jdbc:sqlserver://localhost:1433;DatabaseName=dbName";=================================================MYSQLClass.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"=================================================SybaseClass.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); =================================================AccessClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection dbconn = DriverManager.getConnection("jdbc:odbc:DatabaseName"); =================================================