Simple Java Program to get Database ( ORACLE / MYSQL / DB2 ) Connection

//  DBConnect.java     -   DataBase ( ORACLE / MYSQL / DB2 ) Connection Sample Program   


import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConnect
{

       public static void main(String args[])
       {

Connection con = null;
Statement stmt = null;
   PreparedStatement pstmt = null;
ResultSet res = null;
   boolean found=false;

try
{

                    //          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");     // Oracle
           // Class.forName("org.gjt.mm.mysql.Driver");
Class.forName("com.mysql.jdbc.Driver");                                 //  My SQL
           //  Class.forName("com.ibm.db2.jcc.DB2Driver");             //  DB2

//      con = DriverManager.getConnection("jdbc:odbc:DataSourceName","scott","tiger");
// con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?user=root&password=");
// con = DriverManager.getConnection("jdbc:db2://localhost:50000/db2db", "db2", "db2");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");

  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                ResultSet.CONCUR_UPDATABLE);
res = stmt.executeQuery("select sysdate from dual");


// pstmt=conn.prepareStatement("select sysdate from dual",
//                      ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY );
// rset=pstmt.executeQuery();

if(rset!=null)
{

if(rset.next())
{

found=true;
System.out.println("System Date: "+rset.getString(1));
}

rset.beforeFirst();

if(rset.next())
{

found=true;
System.out.println("System Date: "+rset.getString(1));
}
}

if (found ==false)
{

System.out.println("No Information Found");
}
}
catch(Exception e)
{

System.out.println(e);

    e.printStackTrace();

}

finally
{

try
{

res.close();
stmt.close();
con.close();
}
catch(Exception e)
{

System.out.println(e);
}

res = null;
stmt = null;
con = null;
}
}
}

Commands to execute the program:

MYSQL:

PATH=%PATH%;C:\Java\jdk1.6.0_11\bin
set CLASSPATH=%CLASSPATH%;mysql-connector-java-3.0.15-ga-bin.jar
javac  DBConnect.java
java    DBConnect


DB2:


javac -classpath .;db2jcc.jar;db2jcc_license_cu.jar DBConnect.java
java -classpath .;db2jcc.jar;db2jcc_license_cu.jar DBConnect