Java Program to Connect Database using JDBC API

import java.sql.*;
class Test
{
  public static void main(String args[]) throws SQLException
{
    try{
         Class.forName("sun.Jdbc.OdbcDriver");
       } catch(ClassNotException e) {};
     Connection conn;
     Statement stmt;
     ResultSet rs;
     String op="jdbc:odbc:JavaTest";
     conn=DriverManager.getConnection(op, "Admin", "");
     stmt=conn.createStatement();
     String sql;
     sql="SELECT *FROM SupplierMaster"+"WHERE SupplierCode IN
("+"SELECT SCode"+"FROM Relation"+"WHERE PCode IN
("+"SELECT ProductCode"+"FROM ProductMaster"+"WHERE ProductCatg IN
("+"SELECT CatgID"+"FROM CategoryMaster"+"WHERE CategoryName='Eatables')))";
     rs=stmt.executeQuery(sql);
     System.out.println(" "+"Sup Code"+" "+"Sup Name"+" "+"Sup Address");
     System.out.println("___________________________________________");
     String name, add;
     int code;
     while(rs.next())
      {
        code=rs.getInt("SupplierCode");
        name=rs.getString("SupplierName");
        add=rs.getString("SupplierAddress");
        System.out.println(" "+code+" "+name+" "+add);
      }
  }
}