Java Database Conntectivity

Stages in JDBC Porgram:

1. Registering the Driver
2. Connecting to the Database
3. Preparing SQL Statements in java
4. Executing the SQL Statements on the Database
5. Retrieving the Results.
6. Closing the Connections.

A List of JDBC Drivers: 

If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them.

IBM DB2
        jdbc:db2://<HOST>:<PORT>/<DB>
        com.ibm.db2.jdbc.app.DB2Driver

JDBC-ODBC Bridge
        jdbc:odbc:<DB>
        sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Server
        jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
        weblogic.jdbc.mssqlserver4.Driver
Oracle Thin
        jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
        oracle.jdbc.driver.OracleDriver
PointBase Embedded Server
        jdbc:pointbase://embedded[:<PORT>]/<DB>
        com.pointbase.jdbc.jdbcUniversalDriver
Cloudscape
        jdbc:cloudscape:<DB>
        COM.cloudscape.core.JDBCDriver
Cloudscape RMI
        jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>
        RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver)
        jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>
        org.firebirdsql.jdbc.FBDriver
IDS Server
        jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'
        ids.sql.IDSDriver
Informix Dynamic Server
        jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
        com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier)
        jdbc:idb:<DB>
        jdbc.idbDriver
InstantDB (v3.14 and later)
        jdbc:idb:<DB>
        org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver)
        jdbc:interbase://<HOST>/<DB>
        interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier)
        jdbc:HypersonicSQL:<DB>
        hSql.hDriver
Hypersonic SQL (v1.3 and later)
        jdbc:HypersonicSQL:<DB>
        org.hsql.jdbcDriver
Microsoft SQL Server (JTurbo Driver)
        jdbc:JTurbo://<HOST>:<PORT>/<DB>
        com.ashna.jturbo.driver.Driver
Microsoft SQL Server (Sprinta Driver)
        jdbc:inetdae:<HOST>:<PORT>?database=<DB>
        com.inet.tds.TdsDriver
Microsoft SQL Server 2000 (Microsoft Driver)
        jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
        com.microsoft.sqlserver.jdbc.SQLServerDriver
MySQL (MM.MySQL Driver)
        jdbc:mysql://<HOST>:<PORT>/<DB>
        com.mysql.jdbc.Driver
Oracle OCI 8i
        jdbc:oracle:oci8:@<SID>
        oracle.jdbc.driver.OracleDriver
Oracle OCI 9i
        jdbc:oracle:oci:@<SID>
        oracle.jdbc.driver.OracleDriver
PostgreSQL (v6.5 and earlier)
        jdbc:postgresql://<HOST>:<PORT>/<DB>
        postgresql.Driver
PostgreSQL (v7.0 and later)
        jdbc:postgresql://<HOST>:<PORT>/<DB>
        org.postgresql.Driver
Sybase (jConnect 4.2 and earlier)
        jdbc:sybase:Tds:<HOST>:<PORT>
        com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2)
        jdbc:sybase:Tds:<HOST>:<PORT>
        com.sybase.jdbc2.jdbc.SybDriver

----------------------------------------------
 
Here i am writing a sample code for JDBC.

try

{
  Class.forName("Driver name");

  // DriverManager.registerDriver(new Drivername()); 
   Connection con = DriverManager.getConnenction("jdbcurl","username","password");
   Statement st = con.createStatement();

  ResultSet rs= st.executeQuery("select * from Tablename");

  While(){}

  rs.close();

  st.close(); 

  conn.close(); 
}
catch(Exception e)
{
}

Thanks 

Vinay Guntaka