各种数据库连接jdbc
鏈接數據庫是很容易突然腦子短路忘掉，轉來備用：
Microsoft?SQL?Server?series?(6.5,?7.x?and?2000)?and?Sybase?10??
??
JDBC?Name:?jTDS??
URL:?http://jtds.sourceforge.net/??
Version:?0.5.1??
Download?URL:?http://sourceforge.net/project/showfiles.php?group_id=33291??
??
語法:???
Class.forName("net.sourceforge.jtds.jdbc.Driver?");??
Connection?con?=?DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");??
or??
Connection?con?=?DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");??
??
??
MySQL??
??
JDBC?Name:?Connector/J?3.0??
URL:?http://www.mysql.com/??
Version:?3.0.8-stable??
Download?URL:?http://www.mysql.com/downloads/api-jdbc-stable.html??
??
語法:??
Download?URL:?http://www.mysql.com/downloads/api-jdbc-stable.html??
??
語法:???
Class.forName("com.mysql.jdbc.Driver");??
Connection?con?=?DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");??
??
??
Oracle??
??
JDBC?Name:?Connector/J?3.0??
URL:?http://otn.oracle.com/??
Version:?3.0.8-stable??
Download?URL:?http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html??
??
語法:??
Download?URL:?http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html??
??
語法:???
Class.forName("oracle.jdbc.driver.OracleDriver");??
Connection?con?=?DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");??
??
??
Sybase??
??
Driver:?jConnect?4.5/5.5?(JDBC?2.0?請使用5.5)???
??
語法:??
??
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();??
DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+數據庫名稱,"賬號","密碼");??
??
??
Postgresql??
??
JDBC?Name:?PostgreSQL?JDBC??
URL:?http://jdbc.postgresql.org/??
Version:?7.3.3?build?110??
Download?URL:?http://jdbc.postgresql.org/download.html??
??
語法:??
Download?URL:?http://jdbc.postgresql.org/download.html??
??
語法:???
Class.forName("org.postgresql.Driver");???
Connection?con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");??
??
??
IBM?AS400主機在用的JDBC語法??
??
有裝V4R4以上版本的Client?Access?Express??
可以在C:Program?FilesIBMClient?Accessjt400lib??
找到?driver?檔案?jt400.zip，并更改擴展名成為?jt400.jar??
??
語法語法:??
Class.forName("net.sourceforge.jtds.jdbc.Driver?");??
Connection?con?=?DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");??
or??
Connection?con?=?DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");??
??
??
MySQL??
??
JDBC?Name:?Connector/J?3.0??
URL:?http://www.mysql.com/??
Version:?3.0.8-stable??
Download?URL:?http://www.mysql.com/downloads/api-jdbc-stable.html??
??
語法:??
Download?URL:?http://www.mysql.com/downloads/api-jdbc-stable.html??
??
語法:???
Class.forName("com.mysql.jdbc.Driver");??
Connection?con?=?DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");??
??
??
Oracle??
??
JDBC?Name:?Connector/J?3.0??
URL:?http://otn.oracle.com/??
Version:?3.0.8-stable??
Download?URL:?http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html??
??
語法:??
Download?URL:?http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html??
??
語法:???
Class.forName("oracle.jdbc.driver.OracleDriver");??
Connection?con?=?DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");??
??
??
Sybase??
??
Driver:?jConnect?4.5/5.5?(JDBC?2.0?請使用5.5)???
??
語法:??
??
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();??
DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+數據庫名稱,"賬號","密碼");??
??
??
Postgresql??
??
JDBC?Name:?PostgreSQL?JDBC??
URL:?http://jdbc.postgresql.org/??
Version:?7.3.3?build?110??
Download?URL:?http://jdbc.postgresql.org/download.html??
??
語法:??
Download?URL:?http://jdbc.postgresql.org/download.html??
??
語法:???
Class.forName("org.postgresql.Driver");???
Connection?con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");??
??
??
IBM?AS400主機在用的JDBC語法??
??
有裝V4R4以上版本的Client?Access?Express??
可以在C:Program?FilesIBMClient?Accessjt400lib??
找到?driver?檔案?jt400.zip，并更改擴展名成為?jt400.jar??
??
語法??
java.sql.DriverManager.registerDriver?(new?com.ibm.as400.access.AS400JDBCDriver?());??
Class.forName("com.ibm.as400.access.AS400JDBCConnection");??
con?=?DriverManager.getConnection("jdbc:as400://IP","user","passwor");???
??
1．Oracle8/8i/9i數據庫（thin模式）??
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();???
String?url="jdbc:oracle:thin:@localhost:1521:orcl";?//orcl為數據庫的SID???
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:db2://localhost:5000/sample";?//sample為你的數據庫名???
String?user="admin";???
String?password="";???
Connection?conn=?DriverManager.getConnection(url,user,password);??
3．Sql?Server7.0/2000數據庫??
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();???
String?url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";???
//mydb為數據庫???
String?user="sa";???
String?password="";???
Connection?conn=?DriverManager.getConnection(url,user,password);??
4．Sybase數據庫??
Class.forName("com.sybase.jdbc.SybDriver").newInstance();???
String?url?="?jdbc:sybase:Tds:localhost:5007/myDB";//myDB為你的數據庫名???
Properties?sysProps?=?System.getProperties();???
SysProps.put("user","userid");???
SysProps.put("password","user_password");???
Connection?conn=?DriverManager.getConnection(url,?SysProps);??
5．Informix數據庫??
Class.forName("com.informix.jdbc.IfxDriver").newInstance();???
String?url?=?"jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;???
user=testuser;password=testpassword";?//myDB為數據庫名???
Connection?conn=?DriverManager.getConnection(url);??
6．MySQL數據庫??
Class.forName("org.gjt.mm.mysql.Driver").newInstance();???
String?url?="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"???
//myDB為數據庫名???
Connection?conn=?DriverManager.getConnection(url);??
7．PostgreSQL數據庫??
Class.forName("org.postgresql.Driver").newInstance();???
String?url?="jdbc:postgresql://localhost/myDB"?//myDB為數據庫名???
String?user="myuser";???
String?password="mypassword";???
Connection?conn=?DriverManager.getConnection(url,user,password);??
8．access數據庫直連用ODBC的??
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")?;??
String?url="jdbc:odbc:Driver={MicroSoft?Access?Driver?(*.mdb)};DBQ="+application.getRealPath("/Data/ReportDemo.mdb");??
Connection?conn?=?DriverManager.getConnection(url,"","");??
Statement?stmtNew=conn.createStatement()?; ?
與50位技術專家面對面20年技術見證，附贈技術全景圖
總結
以上是生活随笔為你收集整理的各种数据库连接jdbc的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 常用的类型转换
- 下一篇： java 根据当前时间获得一周日期