JDBC Code to connect to DB2 Database

JDBC Code to connect to DB2 Database


Java code to connect to DB2 database through JDBC

DB2Connect .java


import java.sql.PreparedStatement;


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

public class DB2Connect {
  public static void main(String[] argv) {
    try {
   Class.forName("com.ibm.db2.jcc.DB2Driver");
     } catch (ClassNotFoundException e) {
      System.out.println("Please include Classpath  Where your DB2 Driver is located");
      e.printStackTrace();
      return;
      }
  System.out.println("DB2 driver is loaded successfully");
  Connection conn = null;
 PreparedStatement pstmt = null;
 ResultSet rset=null;
 boolean found=false;
    try {
   conn = DriverManager.getConnection("jdbc:db2://localhost:50000/DATABASE","USER_ID","PWD");
         if (conn != null)
  {
    System.out.println("DB2 Database Connected");
  }
        else
  {
           System.out.println("Db2 connection Failed ");
        }
  pstmt=conn.prepareStatement("Select count(*) from SCHEMA.TABLE");
  rset=pstmt.executeQuery();
       if(rset!=null)
  {

  while(rset.next())
   {
   found=true;
   System.out.println("Record Count: "+rset.getInt(1));

   }
   }
  if (found ==false)
  {
   System.out.println("No Information Found");
  }
   } catch (SQLException e) {
     System.out.println("DB2 Database connection Failed");
     e.printStackTrace();
     return;
     }
}
}