DB2 Database Connection With Examples

An Example of connecting to DB2 Database using JDBC Driver.

A typical example code of connect to database will look like this

package com.knowledgewala.database.mysql;

import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.SQLException;
 import java.util.logging.Logger;

/**
 * This class helps to establish database connection with db2 database server.
 *
 * @author dknitk
 *
 */
 public class KWDB2SqlJDBC1 {

// Instantiate Logger Object
 private static final Logger LOGGER = Logger.getLogger(KWMySqlJDBC1.class
 .getName());

/**
 * This method helps to execute java program.
 * @param args
 */
 public static void main(String[] args) {
 // Assign JDBC Driver
 String jdbcClassName = "com.ibm.db2.jcc.DB2Driver";
 // Assign JDBC url
 String url = "jdbc:db2://localhost:50000/exampledb";
 // Assign Database user name
 String user = "db2inst1";
 // Assign Database password
 String password = "password";

Connection connection = null;
 try {
 // Load class into memory
 Class.forName(jdbcClassName);
 // Establish connection
 connection = DriverManager.getConnection(url, user, password);

} catch (ClassNotFoundException e) {
 e.printStackTrace();
 } catch (SQLException e) {
 e.printStackTrace();
 } finally {
 if (connection != null) {
 LOGGER.info("Connected successfully.");
 try {
 connection.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 }
}
}

package com.knowledgewala.database.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Logger;

/**
 * This class helps to establish database connection with db2 database server.
 * 
 * @author dknitk
 *
 */
public class KWDB2SqlJDBC2 {

    // Instantiate Logger Object
    private static final Logger LOGGER = Logger.getLogger(KWMySqlJDBC1.class
            .getName());
    // Instantiate Statement Object
    private static Statement statement = null;
    // Instantiate PreparedStatement Object
    private static PreparedStatement preparedStatement = null;
    // Instantiate ResultSet Object
    private static ResultSet resultSet = null;

    /**
     * This method helps to execute java program.
     * 
     * @param args
     */
    public static void main(String[] args) {
        // Assign JDBC Driver
        String jdbcClassName = "com.ibm.db2.jcc.DB2Driver";
        // Assign JDBC url
        String url = "jdbc:db2://localhost:50000/exampledb";
        // Assign Database user name
        String user = "db2inst1";
        // Assign Database password
        String password = "password";

        Connection connection = null;
        try {
            // Load class into memory
            Class.forName(jdbcClassName);
            // Establish connection
            connection = DriverManager.getConnection(url, user, password);

            statement = connection.createStatement();

            preparedStatement = connection
                    .prepareStatement("SELECT * FROM Employee" + " order by 1");

            resultSet = preparedStatement.executeQuery();

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (connection != null) {
                LOGGER.info("Connected successfully.");
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}