JDBC连接数据库大全

JDBC里统一的使用方法 
 Class.for(jdbcDriverName); 
 Connection conn= DriverManager.getConnection(url,user,password); 
 这里的接口是统一的，不同的是每种数据库提供的jdbcDriver和Url不同 
 
我们一起来看看吧 
 
MySQL  
 
Class.forName("com.mysql.jdbc.Driver"); 
 Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password"); 
 
Oracle数据库（thin模式） 
 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password"); 
 
Timesten数据库（thin模式） 
 
Class.forName("com.timesten.jdbc.TimesTenDriver"); 
 Connection con = DriverManager.getConnection("jdbc:timesten:client:dsn=dsnname") 
 
Microsoft SQL Server  
 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"); 
 
DB2  
 Class.forName("com.ibm.db2.jdbc.app.DB2Driver ");