1.mysql(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
class.forname("org.gjt.mm.mysql.driver");
cn=drivermanager.getconnection("jdbc:mysql://mydbcomputernameorip:3306/mydatabasename",susr,spwd);
2.postgresql(http://www.de.postgresql.org)pgjdbc2.jar
class.forname("org.postgresql.driver");
cn=drivermanager.getconnection("jdbc:postgresql://mydbcomputernameorip/mydatabasename",susr,spwd);
3.oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
class.forname("oracle.jdbc.driver.oracledriver");
cn=drivermanager.getconnection("jdbc:oracle:thin:@mydbcomputernameorip:1521:orcl",susr,spwd);
4.sybase(http://jtds.sourceforge.net)jconn2.jar
class.forname("com.sybase.jdbc2.jdbc.sybdriver");
cn=drivermanager.getconnection("jdbc:sybase:tds:mydbcomputernameorip:2638",susr,spwd);
//(default-username/password:"dba"/"sql")
5.microsoftsqlserver(http://jtds.sourceforge.net)
class.forname("net.sourceforge.jtds.jdbc.driver");
cn=drivermanager.getconnection("jdbc:jtds:sqlserver://mydbcomputernameorip:1433/master",susr,spwd);
6.microsoftsqlserver(http://www.microsoft.com)
class.forname("com.microsoft.jdbc.sqlserver.sqlserverdriver");
cn=drivermanager.getconnection("jdbc:microsoft:sqlserver://mydbcomputernameorip:1433;databasename=master",susr,spwd);
7.odbc
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connectioncn=drivermanager.getconnection("jdbc:odbc:"+sdsn,susr,spwd);
8.db2
class.forname("com.ibm.db2.jdbc.net.db2driver");
stringurl="jdbc:db2://192.9.200.108:6789/sample"
cn=drivermanager.getconnection(url,susr,spwd);
闽公网安备 35060202000074号