import java.sql.*;
import java.util.*;

public class Ex1
{
    Connection mainConnection = null;
    Statement mainStatement = null;

    ResultSet mainResultSet = null;

    public static void main(String args[])
    {
 Ex1 e = new Ex1();
    }

    public Ex1()
    {
        ConnectToDB();
    }
    public void ConnectToDB()
    {
 // loading Informix driver
 try
 {
         System.out.print("Looking for Informix's jdbc-odbc driver ... ");
            Class.forName("com.informix.jdbc.IfxDriver");
            System.out.println("loaded.\n");
 
     String URL = "jdbc:informix-sqli://esfahaan.usc.edu:1425";

            Properties p = new Properties();
            p.put("INFORMIXSERVER", "dimlab");
            p.put("database", "temp585");
            p.put("user", "temp585");
            p.put("password", "temp585");
 
     System.out.print( "Connecting to DB ..." );
            Connection mainConnection = DriverManager.getConnection(URL, p);
     System.out.println(" Connected" );

     mainStatement = mainConnection.createStatement();
 

       }
       catch( Exception e )
       {
     System.out.println( "Error connecting to DB: "+ e.toString() );
     System.exit(-1);
       }
    }

}