Common Methods for connecting to a database through JDBC are summarized as follows:
I. DB2
Class. forname ("com.ibm.db2.jdbc.net. db2driver ");
String url = "JDBC: DB2: // dburl: Port/dbname"
CN = drivermanager. getconnection (URL, username, password );
2. Microsoft sqlserver (Microsoft)
Class. forname ("com. Microsoft. JDBC. sqlserver. sqlserverdriver ");
CN = drivermanager. getconnection ("JDBC: Microsoft: sqlserver: // dbserverip: 1433; databasename = Master", username, password );
Iii. Sybase (jconn2.jar)
Class. forname ("com. Sybase. jdbc2.jdbc. sybdriver ");
CN = drivermanager. getconnection ("JDBC: Sybase: TDS: dbserverip: 2638", username, password );
4. MySQL (Mm. mysql-3.0.2-bin.jar)
Class. forname ("org. gjt. Mm. MySQL. Driver ");
CN = drivermanager. getconnection ("JDBC: mysql: // dbserverip: 3306/mydatabasename", username, password );
V. PostgreSQL (pgjdbc2.jar)
Class. forname ("org. PostgreSQL. Driver ");
CN = drivermanager. getconnection ("JDBC: PostgreSQL: // dbserverip/mydatabasename", username, password );
6. Oracle (classes12.jar)
Class. forname ("oracle. JDBC. Driver. oracledriver ");
CN = drivermanager. getconnection ("JDBC: oracle: thin: @ mydbcomputernameorip: 1521: orcl", username, password );
VII. ODBC
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
Connection Cn = drivermanager. getconnection ("JDBC: ODBC:" + sdsn, username, password );