sql server com.microsoft.jdbc.sqlserver.sqlserverdriver jdbc:microsoft:sqlserver://localhost:1433;databasename=dbname ? oracle oracle.jdbc.driver.oracledriver jdbc:oracle:thin:@localhost:1521:dbname mysql com.mysql.jdbc.driver jdbc:mysql:/
sql server
com.microsoft.jdbc.sqlserver.sqlserverdriver
jdbc:microsoft:sqlserver://localhost:1433;databasename=dbname
?
oracle
oracle.jdbc.driver.oracledriver
jdbc:oracle:thin:@localhost:1521:dbname
mysql
com.mysql.jdbc.driver
jdbc:mysql://localhost:3306/dbname
?
ms sqlserver
com.microsoft.sqlserver.jdbc.sqlserverdriver
jdbc:sqlserver:localhost:1433;databasename=dbname
?
sybase
com.p6spy.engine.spy.p6spydriver
jdbc:sybase:tds:localhost:5000/dbname?charset=cp936&jconnect_version=5&language=us_english
?
odbc-jdbc桥
sun.jdbc.odbc.jdbcodbcdriver
jdbc:odbc:ds_name
?
一、jdbc连接db2
java代码 ?
class.forname(com.ibm.db2.jdbc.net.db2driver);? string?url=jdbc:db2://dburl:port/dbname? cn?=?drivermanager.getconnection(?url,?susr,?spwd?);class.forname(com.ibm.db2.jdbc.net.db2driver); string url=jdbc:db2://dburl:port/dbname cn = drivermanager.getconnection( url, susr, spwd );
二、jdbc连接microsoft sqlserver(microsoft)
java代码 ?
class.forname(?com.microsoft.jdbc.sqlserver.sqlserverdriver?);? cn?=?drivermanager.getconnection(?jdbc:microsoft:sqlserver://dbserverip:1433;databasename=master,?susr,?spwd?);?
class.forname( com.microsoft.jdbc.sqlserver.sqlserverdriver ); cn = drivermanager.getconnection( jdbc:microsoft:sqlserver://dbserverip:1433;databasename=master, susr, spwd );
三、jdbc连接sybase(jconn2.jar)
java代码 ?
class.forname(?com.sybase.jdbc2.jdbc.sybdriver?);? cn?=?drivermanager.getconnection(?jdbc:sybase:tds:dbserverip:2638,?susr,?spwd?);?
class.forname( com.sybase.jdbc2.jdbc.sybdriver ); cn = drivermanager.getconnection( jdbc:sybase:tds:dbserverip:2638, susr, spwd );
四、jdbc连接mysql(mm.mysql-3.0.2-bin.jar)
java代码 ?
class.forname(?org.gjt.mm.mysql.driver?);? cn?=?drivermanager.getconnection(?jdbc:mysql://dbserverip:3306/mydatabasename,?susr,?spwd?);?
class.forname( org.gjt.mm.mysql.driver ); cn = drivermanager.getconnection( jdbc:mysql://dbserverip:3306/mydatabasename, susr, spwd );
五、jdbc连接postgresql(pgjdbc2.jar)
java代码 ?
class.forname(?org.postgresql.driver?);? cn?=?drivermanager.getconnection(?jdbc:postgresql://dbserverip/mydatabasename,?susr,?spwd?);?
class.forname( org.postgresql.driver ); cn = drivermanager.getconnection( jdbc:postgresql://dbserverip/mydatabasename, susr, spwd );
六、jdbc连接oracle(classes12.jar)
java代码 ?
class.forname(?oracle.jdbc.driver.oracledriver?);? cn?=?drivermanager.getconnection(?jdbc:oracle:thin:@mydbcomputernameorip:1521:orcl,?susr,?spwd?);?
class.forname( oracle.jdbc.driver.oracledriver ); cn = drivermanager.getconnection( jdbc:oracle:thin:@mydbcomputernameorip:1521:orcl, susr, spwd );
七、jdbc连接odbc
java代码 ?
class.forname(?sun.jdbc.odbc.jdbcodbcdriver?);? connection?cn?=?drivermanager.getconnection(?jdbc:odbc:?+?sdsn,?susr,?spwd?);?