/**
 * Copyright 2007 Adobe Systems Incorporated. All Rights Reserved.
 * NOTICE:  All information contained herein is, and remains
 * the property of Adobe Systems Incorporated and its suppliers,
 * if any.  The intellectual and technical concepts contained
 * herein are proprietary to Adobe Systems Incorporated and its
 * suppliers and may be covered by U.S. and Foreign Patents,
 * patents in process, and are protected by trade secret or copyright law.
 * Dissemination of this information or reproduction of this material
 * is strictly forbidden unless prior written permission is obtained
 * from Adobe Systems Incorporated.
 */

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

import com.mysql.jdbc.Driver;




public class MySqlMain {

    final static String driverClass    = "com.mysql.jdbc.Driver";
    final static String connectionURL="jdbc:mysql://10.60.147.77:3306/cfqa";
        
    
    final static String userID         = "cfqauser";
    final static String userPassword   = "cfqa";
    Connection   con                   = null;

    public MySqlMain() {
        try {
            System.out.print("  Loading JDBC Driver  -> " + driverClass + "\n");
           //MacromediaDriver md  = (MacromediaDriver)Class.forName(driverClass).newInstance();
            Driver driver = (Driver) Class.forName(driverClass).newInstance();
           //MacromediaDriver.setSQLServerID("JRun4u1");    
          
           // Class.forName(driverClass).newInstance();


            System.out.print("  Connecting to        -> " + connectionURL + "\n");
            this.con = DriverManager.getConnection(connectionURL, userID, userPassword);
            System.out.print("  Connected as         -> " + userID + "\n");

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void executeQuery() {
        Statement pstmt      = null;
        try {
            pstmt = con.createStatement();
            boolean flag = pstmt.execute("select * from testdate", Statement.RETURN_GENERATED_KEYS);
            System.out.println("Flag is.................." + flag);
            ResultSet rs = pstmt.getResultSet();
            while(rs.next())
            {
                System.out.println("Values : " + rs.getObject(1));
            }
            pstmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    
    
    public void closeConnection() {

        try {
            System.out.print("\n\n  Closing Connection...\n");
            con.close();
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args)
            throws java.lang.InterruptedException {
        MySqlMain db = new MySqlMain();
        db.executeQuery();
        db.closeConnection();
        
    }

}