JDBC Tutorial

• Table of contents
  
  
  1. All JavaEE viedos and code in Youtube | Facebook | Google plus | GitHub | BitBucket
  2. JDBC Tutorial - Playlists
  3. Mysql & Oracle
  4. JDBC Basics
  5. JDBC Driver Types
  6. JDBC Statement & PreparedStatement
  7. JDBC ResultSet
  8. JDBC ResultSetMetadata
  9. JDBC DatabaseMetadata
  10. JDBC Create|Read|Update|Delete Records
  11. JDBC Batch Processing
  12. JDBC Transaction Management
  13. JDBC Store Image & File
  14. JDBCRowSet
  15. JDBC DataSource
  16. Java Database Connection Pooling
  17. JDBC Stored Procedure


• All JavaEE viedos and code in Youtube | Facebook | Google plus | GitHub | BitBucket
  
  
  1. All JavaEE Viedos Playlist
  2. All JavaEE Viedos
  3. JavaEE - Facebook Page
  4. JAVA & JAVA EE - Facebook Group
  5. Java - Google Plus Page
  6. JavaEE By Ram - Google Community
  7. GitHub
  8. BitBucket


• JDBC Tutorial - Playlists
  
  
  1. JDBC Tutorial - Playlist
  2. Mysql Tutorial - Playlist
  3. JDBC : Steps to Connect to the Database and Demo - Playlist
  4. JDBC ResultSetMetadata - Playlist
  5. JDBC DatabaseMetadata - Playlist
  6. JDBC Statement - Playlist
  7. JDBC Connection - Playlist
  8. JDBC PreparedStatement - Playlist
  9. JDBC ResultSet - Playlist
  10. JDBC Create|Read|Update|Delete Records - Playlist
  11. JDBC Create|Drop Database - Playlist
  12. JDBC Create|Drop Table - Playlist
  13. JDBC Batch Processing - Playlist
  14. JDBC Scrollable ResultSet - Playlist
  15. JDBC DriverManager and JDBC Driver - Playlist
  16. Java Decompiler - Playlist
  17. JDBC Basics - Playlist
  18. JDBC Driver Types - Playlist
  19. JDBC Store and Retrieve Image - Playlist
  20. JDBC Store and Retrieve File - Playlist
  21. JDBC Transaction Management - Playlist
  22. JDBCRowSet - Playlist
  23. JDBC Mysql - Playlist
  24. JDBC Oracle - Playlist
  25. JDBC DataSource - Playlist
  26. JDBC DBCP DataSource - Playlist
  27. JDBC : Java Database Connection Pooling - Playlist
  28. Oracle Database & SqlDeveloper Tutorial - Playlist
  29. Bone CP Connection Pooling - Playlist
  30. DBCP Connection Pooling - Playlist
  31. C3PO Connection Pooling - Playlist
  32. JDBC Stored Procedure (Mysql) - Playlist
  33. JDBC Stored Procedure (Oracle) - Playlist


• Mysql & Oracle
  
  
  1. MySQL Installation
  2. MySQL Workbench
  3. Oracle Database Server Installation
  4. Oracle Sql Developer Installation
  5. Oracle Sql Developer - Connect to the User


• JDBC Basics
  
  
  1. JDBC Introduction
  2. JDBC Architecture
  3. JDBC : Steps to Connect to the Database
  4. How the JDBC Application works
  5. JDBC Demo
  6. JDBC : DriverManager
  7. Java Decompiler
  8. JDBC Driver Details
  9. Load JDBC Driver
  10. JDBC Connection
  11. JDBC : Connection URL
  12. JDBC Connection Demo
  13. JDBC Demo - Connect to Oracle Database


• JDBC Driver Types
  
  
  1. JDBC Driver Types
  2. Type 1 JDBC Driver : JDBC-ODBC Bridge Driver (Bridge Driver)
  3. Type 2 JDBC Driver: Native-API driver/Partly Java driver(Native Driver)
  4. Type 3 Driver : AllJava/Net-protocol driver or Network Protocol Driver(Middleware Driver)
  5. Type 4 Driver : All Java/Native-protocol driver or Thin Driver (Pure Java Driver)
  6. JDBC : Which Driver Should be used


• JDBC Statement & PreparedStatement
  
  
  1. JDBC Statement
  2. JDBC PreparedStatement
  3. JDBC PreparedStatement Demo
  4. JDBC : Statement vs PreparedStatement


• JDBC ResultSet
  
  
  1. JDBC ResultSet
  2. JDBC ResultSet Demo
  3. JDBC Scrollable ResultSet
  4. JDBC Scrollable ResultSet Demo
  5. JDBC Updatable ResultSet
  6. JDBC Updatable ResultSet Demo
  7. JDBC : TYPE_SCROLL_INSENSITIVE Vs. TYPE_SCROLL_SENSITIVE ResultSet


• JDBC ResultSetMetadata
  
  
  1. JDBC ResultSetMetadata
  2. JDBC ResultSetMetadata Demo


• JDBC DatabaseMetadata
  
  
  1. JDBC DatabaseMetadata
  2. JDBC DatabaseMetadata Demo


• JDBC Create|Read|Update|Delete Records
  
  
  1. JDBC Insert Record Demo
  2. JDBC Update Records Demo
  3. JDBC Read Records Demo
  4. JDBC Delete Records Demo
  5. JDBC Where Clause Demo
  6. JDBC Like Clause Demo
  7. JDBC Sorting Data Demo
  8. JDBC Create Database Demo
  9. JDBC Drop Database Demo
  10. JDBC Create Table Demo
  11. JDBC Drop Table Demo


• JDBC Batch Processing
  
  
  1. JDBC Batch Processing - Introduction
  2. JDBC Batch Processing [Statement] Demo
  3. JDBC Batch Processing [PreparedStatement] Demo


• JDBC Transaction Management
  
  
  1. JDBC Transaction Management
  2. JDBC Transaction Management Demo
  3. JDBC : Transaction Management - Why do we need ?


• JDBC Store Image & File
  
  
  1. JDBC : Store Image
  2. JDBC : Retrieve Image
  3. JDBC : Store File
  4. JDBC : Retrieve File


• JDBCRowSet
  
  
  1. JDBCRowSet
  2. JDBCRowSet Demo
  3. JDBCRowSet Update- Insert-Delete Demo
  4. JDBCRowSet Event Handling
  5. JDBCRowSet Event Handling Demo


• JDBC DataSource
  
  
  1. JDBC DataSource - Introduction
  2. JDBC DataSource [Mysql DB]
  3. JDBC DataSource [Oracle DB]
  4. JDBC DBCP DataSource - MySQL
  5. JDBC DBCP DataSource - Oracle


• Java Database Connection Pooling
  
  
  1. JDBC : Java Database Connection Pooling [BoneCP vs DBPool vs C3PO]
  2. JDBC|Servlets : BoneCP Connection Pooling - Oracle - Tomcat
  3. JDBC|Servlets : BoneCP Connection Pooling - Mysql- Tomcat
  4. JDBC|Servlets : BoneCP DataSource Oracle - Tomcat
  5. JDBC|Servlets : BoneCP DataSource Mysql - Tomcat
  6. JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle
  7. JDBC|Servlets : Tomcat Connection Pooling - DBCP - Mysql
  8. JDBC|Servlets : Tomcat C3PO Connection Pooling - Mysql
  9. JDBC|Servlets : Tomcat C3PO Connection Pooling - Oracle
  10. Object Pool Design Pattern - Introduction
  11. Object Pool Design Pattern - Implementation
  12. Connection Pooling [Example of Object Pool Design Pattern]
  13. Object Pool Design Pattern - KeyPoints


• JDBC Stored Procedure
  
  
  1. JDBC : CallableStatement Introduction.
  2. Mysql - Simple Stored Procedure
  3. Mysql - Stored Procedure with Input Parameter
  4. Mysql - Stored Procedure with multiple Input Parameters
  5. Mysql - Stored Procedure with Input and Output Parameters
  6. JDBC - CallableStatement with Input and Output Parameters(Mysql)
  7. JDBC - CallableStatement (Mysql)
  8. JDBC - CallableStatement with Input Parameter(Mysql)
  9. JDBC - CallableStatement Multiple In Out Parameters (Mysql)
  10. Oracle : Stored Procedure with Input and Output Parameters
  11. Oracle : Stored Procedure Cursor
  12. JDBC - CallableStatement In Out Parameters (Oracle)
  13. JDBC - CallableStatement Cursor(Oracle)
  14. JDBC - CallableStatement Cursor and multiple out param(Oracle)

JDBC : Steps to Connect to the Database

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

Click the below Image to Enlarge

JDBC : Steps to Connect to the Database

JDBC : Steps to Connect to the Database

JDBC : Steps to Connect to the Database

JDBC : Steps to Connect to the Database

JDBC : Steps to Connect to the Database

JDBC : Steps to Connect to the Database

See also:

Servlets Tutorial

All Design Patterns Links

JDBC Tutorial

Servlets : HTTP Status Codes

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

Click the below Image to Enlarge

HTTP Status Codes

HTTP Status Codes

HTTP Status Codes

HTTP Status Codes

HTTP Status Codes

HTTP Status Codes

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : SingleThreadModel

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

 Click the below Image to Enlarge

SingleThreadModel

SingleThreadModel

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : Hidden Form Field

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

Click the below Image to Enlarge

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : URL Rewriting

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

Click the below Image to Enlarge

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : User Authorization

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

Click the below Image to Enlarge

User Authorization

User Authorization

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : HttpSession Listener Demo [Count logged in Users]

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

Click the below Image to Enlarge

HttpSessionListenerDemo Project Dir Structure

LoginServlet.java

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginServlet extends HttpServlet
{
    
    private static final long serialVersionUID = 1L;

    public void init() throws ServletException
    {
        System.out.println("-----------------------------------------");
        System.out.println(" Init method is called in "
                + this.getClass().getName());
        System.out.println("--------------------------------------");
    }
    
    public void doGet( HttpServletRequest request, HttpServletResponse response )
            throws ServletException, IOException
    {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        String userName = request.getParameter("username");
        out.print("Welcome " + userName);

        HttpSession session = request.getSession();
        session.setAttribute("uname", userName);

        ServletContext ctx = getServletContext();
        int totalUsers = (Integer) ctx.getAttribute("totalusers");
        int currentUsers = (Integer) ctx.getAttribute("currentusers");
        
        out.print("<br>total users= " + totalUsers);
        out.print("<br>current users= " + currentUsers);

        out.print("<br><a href='logout'>logout</a>");

        out.close();
    }
    
    public void destroy()
    {
        System.out.println("-----------------------------------------");
        System.out.println(" destroy method is called in "
                + this.getClass().getName());
        System.out.println("-----------------------------------------");
    }

}

LogoutServlet.java

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LogoutServlet extends HttpServlet
{

    private static final long serialVersionUID = 1L;

    public void doGet( HttpServletRequest request, HttpServletResponse response )
            throws ServletException, IOException
    {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        HttpSession session = request.getSession(false);
        session.invalidate();

        out.print("You are successfully logged out");

        out.close();
    }

}

CountUserListener.java

import javax.servlet.ServletContext;
import javax.servlet.http.HttpSessionEvent;
import javax.servlet.http.HttpSessionListener;

public class CountUserListener implements HttpSessionListener
{
    ServletContext ctx = null;
    static int     totalUserCount = 0, currentUserCount = 0;

    public void sessionCreated( HttpSessionEvent httpSessionEvent )
    {
        System.out.println("sessionCreated method has been called in "
                + this.getClass().getName());

        
        totalUserCount++;
        currentUserCount++;

        ctx = httpSessionEvent.getSession().getServletContext();
        
        ctx.setAttribute("totalusers", totalUserCount);
        ctx.setAttribute("currentusers", currentUserCount);

    }

    public void sessionDestroyed( HttpSessionEvent httpSessionEvent )
    {
        
        System.out.println("sessionDestroyed method has been called in "
                + this.getClass().getName());       
        currentUserCount--;
        ctx.setAttribute("currentusers", currentUserCount);
    }

}

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    metadata-complete="true" version="3.0">
    <display-name>HttpSessionListenerDemo</display-name>
    <description>
        This is a simple web application with a source code organization
        based on the recommendations of the Application Developer's Guide.
    </description>


    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>LoginServlet</servlet-class>
    </servlet>
    
    <servlet>
        <servlet-name>LogoutServlet</servlet-name>
        <servlet-class>LogoutServlet</servlet-class>
    </servlet>


    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
    
    <servlet-mapping>
        <servlet-name>LogoutServlet</servlet-name>
        <url-pattern>/logout</url-pattern>
    </servlet-mapping>


    <listener>
        <listener-class>CountUserListener</listener-class>
    </listener>
    
</web-app>

index.html

<form action="login">
    Name:<input type="text" name="username"><br> 
    
    Password:<input type="password" name="password"><br> 
    
    <input type="submit" value="login" />
    
</form>

Environment Used 

JDK version :1.7.0_51
Tomcat version : 7.0.50 

To Download HttpSessionListenerCountUserDemoApp Project Click the below link

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

See also:

Servlets Tutorial

All Design Patterns Links

Servlets Listeners

Click here to watch in Youtube : https://www.youtube.com/watch?v=7NtVn1_TSAg

Click the below Image to Enlarge

Servlets Listeners

Servlets Listeners

See also:

Servlets Tutorial

All Design Patterns Links

Servlets : HttpSessionBindinglistener Demo

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

Click the below Image to Enlarge

HttpSessionBindingListenerDemo Project Dir Structure

HttpSessionAttributeTestServlet.java

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class HttpSessionAttributeTestServlet extends HttpServlet
{
    private static final long serialVersionUID = 1L;

    public void init() throws ServletException
    {
        System.out.println("-----------------------------------------");
        System.out.println(" Init method is called in "
                + this.getClass().getName());
        System.out.println("--------------------------------------");
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException
    {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        HttpSession httpSession = request.getSession();

        sleep();

        User user = new User("Ram", 43);
        httpSession.setAttribute("userinfo", user);

        sleep();

        httpSession.invalidate();

        out.println("This is the example of HttpSessionBindingListener");

    }

    private void sleep()
    {
        try
        {
            Thread.sleep(10000);
        }
        catch (InterruptedException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public void destroy()
    {
        System.out.println("-----------------------------------------");
        System.out.println(" destroy method is called in "
                + this.getClass().getName());
        System.out.println("-----------------------------------------");
    }

}

User.java

import javax.servlet.http.HttpSessionBindingEvent;
import javax.servlet.http.HttpSessionBindingListener;

public class User implements HttpSessionBindingListener
{

    private String name;
    private int age;

    public User(String name, int age)
    {
        super();
        this.name = name;
        this.age = age;
    }

    public User(String name)
    {
        this.name = name;
    }

    public String getName()
    {
        return name;
    }

    public void setName(String name)
    {
        this.name = name;
    }

    public int getAge()
    {
        return age;
    }

    public void setAge(int age)
    {
        this.age = age;
    }

    @Override
    public void valueBound(HttpSessionBindingEvent httpSessionBindingEvent)
    {
        System.out.println("\n###################################\n");

        System.out.println("valueBound method has been called in "
                + this.getClass().getName());

        System.out.println("Added/Replaced Attribute Name ="
                + httpSessionBindingEvent.getName() + ",value = "
                + httpSessionBindingEvent.getValue());

        System.out.println("\n#####################################\n");

        /*
         * if particular Attribute is added/replaced, based on that if you want
         * to perform any operation then you can do it here.
         */

    }

    @Override
    public void valueUnbound(HttpSessionBindingEvent httpSessionBindingEvent)
    {
        System.out.println("\n###################################\n");

        System.out.println("valueUnbound method has been called in "
                + this.getClass().getName());

        System.out.println("Removed Attribute Name ="
                + httpSessionBindingEvent.getName() + ",value = "
                + httpSessionBindingEvent.getValue());

        System.out.println("\n#####################################\n");

        /*
         * if particular Attribute is removed, based on that if you want to
         * perform any operation then you can do it here.
         */

    }

    @Override
    public String toString()
    {
        return "User [name=" + name + ", age=" + age + "]";
    }

}

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    metadata-complete="true" version="3.0">

    <display-name>HttpSessionBindingListenerDemo</display-name>

    <description>
        This is a simple web application with a source code organization
        based on the recommendations of the Application Developer's Guide.
    </description>

    <servlet>
        <servlet-name>HttpSessionAttributeTestServlet</servlet-name>
        <servlet-class>HttpSessionAttributeTestServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>HttpSessionAttributeTestServlet</servlet-name>
        <url-pattern>/listenerTest</url-pattern>
    </servlet-mapping>

</web-app>

index.html

<html>
<body>
    <a href="listenerTest">listenerTest</a>
</body>
</html>

Environment Used 

JDK version :1.7.0_51
Tomcat version : 7.0.50 

To Download HttpSessionBindingListenerDemoApp Project Click the below link

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

See also:

Servlets Tutorial

All Design Patterns Links