JDBC : JDBC Driver Details

Click here to watch in Youtube : https://www.youtube.com/watch?v=KbAo5Ii-QLk

Click the below Image to Enlarge

JDBC Driver Details

JDBC Driver Details

JDBC Driver Details

JDBC Driver Details

JDBC Driver Details

JDBC Driver Details

JDBC Driver Details

JDBCDriverDetailsDemo.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDriverDetailsDemo
{
    // JDBC driver name and database URL
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL      = "jdbc:mysql://localhost:3306/world";

    // Database credentials
    static final String USERNAME    = "root";
    static final String PASSWORD    = "root";

    public static void main( String[] args )
    {

        JDBCDriverDetailsDemo jdbcDriverDetailsDemo = new JDBCDriverDetailsDemo();
        jdbcDriverDetailsDemo.getCityInformation();

    }

    private void getCityInformation()
    {
        Connection connection = null;
        Statement stmt = null;
        try
        {
            /*
             * Register the JDBC driver in DriverManager
             */

            Class.forName(JDBC_DRIVER);

            /*
             * Establish connection to the Database using DriverManager
             */

            connection = DriverManager
                    .getConnection(DB_URL, USERNAME, PASSWORD);

            System.out.println("Connection Object : "
                    + connection.getClass().getName());

            stmt = connection.createStatement();

            System.out.println("Statement Object : "
                    + stmt.getClass().getName());

            String sql = "select ID,Name,CountryCode,District,Population from city";

            /*
             * Execute a query
             */

            ResultSet rs = stmt.executeQuery(sql);

            System.out.println("ResultSet Object : " + rs.getClass().getName());

            rs.close();
            stmt.close();
            connection.close();
        }
        catch( SQLException se )
        {
            /*
             * Handle errors for JDBC
             */
            se.printStackTrace();
        }
        catch( ClassNotFoundException e )
        {
            /*
             * Handle errors for Class.forName
             */
            e.printStackTrace();
        }
        finally
        {
            /*
             * finally block used to close resources
             */
            try
            {
                if( stmt != null )
                {
                    stmt.close();
                }
            }
            catch( SQLException sqlException )
            {
                sqlException.printStackTrace();
            }
            try
            {
                if( connection != null )
                {
                    connection.close();
                }
            }
            catch( SQLException sqlException )
            {
                sqlException.printStackTrace();
            }
        }

    }

}

Output

Connection Object : com.mysql.jdbc.JDBC4Connection
Statement Object : com.mysql.jdbc.StatementImpl
ResultSet Object : com.mysql.jdbc.JDBC4ResultSet

Environment Used 

JDK version : 1.7.0_51
Mysql Server version : 5.6.19 

To Download JDBCDriverDetailsDemoApp Project Click the below link

https://sites.google.com/site/javaee4321/jdbc/JDBCDriverDetailsDemoApp.zip?attredirects=0&d=1

See also:

Servlets Tutorial

All Design Patterns Links

JDBC Tutorial