Code for JDBC Common Database Connection
1. MySQL (http://www.mysql.com/mysql-connector-java-2.0.14-bin.jar)
Class. forname ("org. gjt. Mm. MySQL. Driver ");
CN = drivermanager. getconnection (
"JDBC: mysql: // mydbcomputernameorip: 3306/mydatabasename", susr, spwd
);
1. 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. Microsoft sqlserver (http://jtds.sourceforge.net)
Class. forname ("net. SourceForge. jtds. JDBC. Driver ");
CN = drivermanager. getconnection (
"JDBC: jtds: sqlserver: // mydbcomputernameorip: 1433/master", susr, spwd
);
6. Microsoft sqlserver (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 = "JDBC: DB2: // mydbcomputernameorip: 6789/sample"
CN = drivermanager. getconnection (URL, susr, spwd );