Audience

People who need to use IBM DB2 Connect with JDBC

Purpose

Illustrate a sample Java class that uses JDBC with db2Connect.

Sample

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

public class TestSQL {
    public static void main(String[] args) {
        System.out.println("Connection/SQL test starting in TestSQL.java...");

        String driver = "com.ibm.db2.jcc.DB2Driver";
        String url = "jdbc:db2:inyodb2y";
        String userid = USER_ID;
        String password = PASSWORD;

        Connection connection = null;

        try { // load the driver
            Class.forName(driver);
        } catch (Exception e) {
            System.out.println("error loading driver");
            e.printStackTrace();

            return;
        }

        try {
            connection = DriverManager.getConnection(url, userid, password);
            System.out.println("Connection successful!");

            Statement statement =
                connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

            ResultSet rs = statement.executeQuery(
                    "select * from stutstb.tstu_student where stu_name like 'Z%'");

            boolean b = rs.first();
            String stuName;
            String stuId;
            while (b) {
                stuName = rs.getString("stu_name");
                stuId = rs.getString("stu_id");
                System.out.println("stu_id: " + stuId + " stu_name: " + stuName);
                b = rs.next();
            }


        } catch (SQLException e) {
            System.out.println("Caught SQLException: " + e.getMessage());
            e.printStackTrace();
        } finally {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}