JDBC Various database connections Summary __ Database

1 , oracle8/8i/9i Database (Thin mode)

Class.forName ("Oracle.jdbc.driver.OracleDriver"). newinstance ();

String url= "Jdbc:oracle:thin: @localhost: 1521:ORCL";

ORCL is the SID of the database

String user= "Test";

String password= "Test";

Connection conn= drivermanager.getconnection (Url,user,password);

2 , DB2 Database

Class.forName ("Com.ibm.db2.jdbc.app.DB2Driver"). newinstance ();

String url= "Jdbc:db2://localhost:5000/sample";

Sample for your database name

String user= "admin";

String password= "";

Connection conn= drivermanager.getconnection (Url,user,password);

3 , SQL server7.0/2000 Database

Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver"). newinstance ();

String url= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=mydb";

MyDB as a database

String user= "SA";

String password= "";

Connection conn= drivermanager.getconnection (Url,user,password);

4 , Sybase Database

Class.forName ("Com.sybase.jdbc.SybDriver"). newinstance ();

String url = "Jdbc:sybase:tds:localhost:5007/mydb";

MyDB for your database name

Properties sysprops = System.getproperties ();

Sysprops.put ("User", "userid");

Sysprops.put ("Password", "User_password");

Connection conn= drivermanager.getconnection (URL, sysprops);

5 , Informix Database

Class.forName ("Com.informix.jdbc.IfxDriver"). newinstance ();

String url = "Jdbc:informix-sqli://123.45.67.89:1533/mydb:informixserver=myserver;

User=testuser;password=testpassword ";

MyDB for Database name

Connection conn= drivermanager.getconnection (URL);

6 , MySQL Database

Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance ();

String url = "Jdbc:mysql://localhost/mydb?user=soft&password=soft1234&useunicod

E=true&characterencoding=8859_1 "

MyDB for Database name

Connection conn= drivermanager.getconnection (URL);

7 , PostgreSQL Database

Class.forName ("Org.postgresql.Driver"). newinstance ();

String url = "Jdbc:postgresql://localhost/mydb"

MyDB for Database name

String user= "MyUser";

String password= "MyPassword";

Connection conn= drivermanager.getconnection (Url,user,password);