Java Connection driver and URLs for various databases

summed up the Java connection to the various databases to use the driver name and URL:

1, Oracle

Driver:oracle.jdbc.driver.OracleDriver

URL: "Jdbc:oracle:thin: @localhost:" +port+ ":" +databasename;

2, SQL server7.0/2000

Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver

URL: "Jdbc:microsoft:sqlserver://localhost:" +port+ ";D atabasename=" +databasename;

3, DB2

Driver:com.ibm.db2.jdbc.app.DB2Driver

Url:jdbc:db2://localhost: "+port+"/"+databasename";

4, Informix

Driver:com.informix.jdbc.IfxDriver

URL: "jdbc:informix-sqli://"/"+url+"/"+databasename+": informixserver=myserver;

User= "+user+";p assword= "+password;

5. Sybase

Driver:com.sybase.jdbc.SybDriver

URL: "Jdbc:sybase:Tds:localhost:" +port+ "/" +databasename;

6, MYSQL

Driver:org.gjt.mm.mysql.Driver or Com.mysql.jdbc.Driver

Url:jdbc:mysql://localhost: "+port+"/"+databasename";

7, PostgreSQL

Driver:org.postgresql.Driver

URL: "jdbc:postgresql://localhost/" +databasename;

8. Visual Foxpro

Driver:sun.jdbc.odbc.JdbcOdbcDriver

URL: "Jdbc:odbc:driver={microsoft Visual FoxPro driver}; SOURCETYPE=DBF; sourcedb= "+ (full path name of your DBF datasheet, including filename);