import java.sql.DriverManager;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class ConnectionJob implements Job {
	
	public void execute(JobExecutionContext context) throws JobExecutionException {
		// TODO Auto-generated method stub
		System.out.println("Job name: " + context.getJobDetail().getName());
		System.out.println("Group name: " + context.getJobDetail().getGroup());
		System.out.println("Trigger name: " + context.getTrigger().getName());
		System.out.println("Firing Time : " + context.getFireTime());
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException c){
			System.out.println("Class not found!");
		}
		try{
			String url = "jdbc:mysql://localhost/JDBCquartz?user=root&password=root";
			Connection con = (Connection)DriverManager.getConnection(url);
			System.out.println("Connection :"+con);
			System.out.println("Connection is created!");
			con.close();
			System.exit(0);
		}
		catch(Exception s){
			System.out.println("Doesn't establish the connection!");
			System.exit(0);
		}
	}
}