import java.io.*;
import java.sql.*;
import java.net.URL;
import java.util.*;
//import com.mysql.jdbc.*;

public class MysqlConnect
{
	public void Connect ()
	{
		try
		{
			com.mysql.jdbc.Driver d = (com.mysql.jdbc.Driver) Class.forName ("com.mysql.jdbc.Driver").newInstance ();
			Enumeration e = DriverManager.getDrivers();
			while (e.hasMoreElements() ) {
				Driver d1 = (Driver)e.nextElement();
				 System.out.println(d1.acceptsURL("jdbc:mysql://localhost:3306/test?"));
			
			}
			
			String serverName = "localhost";
			String myDatabase = "test";
			String url = "jdbc:mysql://" + serverName + "/" + myDatabase;
			
			String username = "root";
			String password = "jayant123";
			
			Connection newCon = DriverManager.getConnection (url,username,password);
		//	Connection newCon = DriverManager.getConnectiom ("jdbc:mysql://localhost:3306/test?user=root&password=jayant123");
		
			
			Statement stmt = newCon.createStatement ();
			ResultSet rs = stmt.executeQuery
				       ("SELECT BJSEL, z FROM tdf");
				       
			while (rs.next())
			{
				double appMag = rs.getDouble (1);
				double z = rs.getDouble (2);
				
				Magnitude.setParameters (100.0,0.5,0.5); // set the parameters for the Magnitude class
				double absMag = Magnitude.getAbsoluteMagnitude (appMag, z);
				
				System.out.println (" Appmag = " + appMag);
				System.out.println (" z = " + z);
				System.out.println (" absMag = " + absMag);
			}
		}
		catch (SQLException ex) 
		{
		    // handle any errors
		    ex.printStackTrace();
		    System.out.println("SQLException: " + ex.getMessage()); 
		    System.out.println("SQLState: " + ex.getSQLState()); 
		    System.out.println("VendorError: " + ex.getErrorCode()); 
		}
		catch (Exception e)
		{
			System.out.println(e); 
			e.printStackTrace();
		}
	}
	
	public static void main (String[] args)
	{
		MysqlConnect tdfData = new  MysqlConnect ();
		tdfData.Connect ();
	}
}