JDBC连接数据库大全

JDBC里统一的使用方法 
(jdbcDriverName); 
Connection conn= (url,user,password); 
这里的接口是统一的，不同的是每种数据库提供的jdbcDriver和Url不同 

我们一起来看看吧 

MySQL  

(""); 
Connection con = ("jdbc:mysql://host:port/database","user","password"); 

Oracle数据库（thin模式） 

(""); 
Connection con = ("jdbc:oracle:thin:@host:port:databse","user","password"); 

Timesten数据库（thin模式） 

(""); 
Connection con = ("jdbc:timesten:client:dsn=dsnname") 

Microsoft SQL Server  
(" "); 
Connection con = ("jdbc:jtds:sqlserver://host:port/database","user","password"); 
or 
Connection con = ("jdbc:jtds:sybase://host:port/database","user","password"); 

DB2  
("..DB2Driver "); 
Connection conn= ("jdbc:db2://localhost:5000/sample",user,password); 

Firebird  
(""); 
Connection con = ("jdbc:firebirdsql://host:port/fdb_file_path","user","password"); 

PointBase(Server)  
(""); 
Connection con = ("jdbc:pointbase:server://host:port/databasename","user","password"); 

HSQLDB(Server)  
(""); 
Connection con = ("jdbc:hsqldb:hsql://localhost:port/mydb","user","password"); 

Derby  
这个少有人听说吧，cloudscape 应该听说过吧，该项目由此衍生 
(""); 
Connection con = ("jdbc:derby://host:port//mydb","user","password"); 

(""); 
Connection conn = ("jdbc:derby:mynewDB", p); 

cloudscape 
(""); 
Connection conn = ("jdbc:cloudscape:<DB>"); 

(""); 
Connection conn = ("jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>", user, passoword); 

Postgresql  
(""); 
Connection con=("jdbc:postgresql://host:port/database","user","password"); 

Informix  
("").newInstance(); 
Connection con=("jdbc:informix-sqli://host:port/myDB:INFORMIXSERVER=myserver","user","password"); 

Access  
("") ; 
Connection con=("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=mdb的文件路径","user","password"); 

Sybase  
(".").newInstance(); 
Connection con=("jdbc:sybase:Tds:host:port?ServiceName=databasename","user","password"); 

==================附加======================  
IBM AS400主机在用的JDBC语法 
("..AS400JDBCConnection"); 
Connection con = ("jdbc:as400://IP","user","passwor"); 

Sapdb  
(""); 
Connection con = ("jdbc:sapdb://host:port/DB_NAME","user","passwor"); 

Progress  
(""); 
Connection con = ("jdbc:JdbcProgress:T:dbserver:3305:liveappl","user","passwor"); 

Mimer SQL Local  
(""); 
Connection con = ("jdbc:mimer:multi1","user","passwor"); 

Altibase  
内存数据库 
(""); 
Connection con = ("jdbc:Altibase://host:port/dbname","user","passwor"); 

solid DB  
上面还有这个有没有印象呀，如果持续关注我的文章的话，在我讲Timesten提到过这两个，还有一个eXtremeDB没有JDBC的支持 
(""); 
Connection con = ("jdbc:solid://yourdbhost:1964/yourdbusername/yourdbpassword");