Common Database JDBC Connection Writing 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: // MYDBComputername", SUSR, SPWD); 2. PostgreSQL (http://www.de.postgreSql.org) pgjdbc2.jar class.Forname ("Org.postgreSQL. Driver "); CN = DriverManager.getConnection (" JDBC: PostgreSQL: // MYDBComputernameorip / MyDatabaseName ", SUSR, SUSR, SPWD); 3. Oracle (http://www.racle.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) ; // (DBA "/" sql ") 5. Microsoft SQLServer (http://jtds.sourceforge.net) Class.Forname (" Net.SourceForge.jtds.jdbc.driver "); CN = driverman Ager.getConnection ("JDBC: JTDS: SQLServer: // MYDBComputernameorip: 1433 / Master", SUSR, SPWD); 6. Microsoft SQL Server (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 "); Connection CN = DriverManager.getConnection (" JDBC: ODBC: " SDSN, SUSR, SPWD); 8.DB2 Class.Forname (" com.ibm.db2.jdbc.net.db2driver "); string URL = "
