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

public class MysqlConnect2
{
	public void Connect ()
	{
		try
		{
			Class.forName ("com.mysql.jdbc.Driver").newInstance ();
			
			String serverName = "localhost";
			String myDatabase = "test";
			String url = "jdbc:mysql://" + serverName + "/" + myDatabase;
			
			String username = "gupchup";
			String password = "gupchup";
			String attrList = "";
			attrList ="BJSEL" + "," + "z";
			
			
			Connection newCon = DriverManager.getConnection (url,username,password);
		
			
			Statement stmt = newCon.createStatement ();
			ResultSet rs = stmt.executeQuery
				       ("SELECT " + attrList + " FROM tdf");
				       
			while (rs.next())
			{
				double appMag = rs.getDouble (1);
				double z = rs.getDouble (2);
				
				System.out.println (" Appmag = " + appMag + "\n");
				System.out.println (" z = " + z + "\n");
			}
		}
		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)
	{
		MysqlConnect2 tdfData = new  MysqlConnect2 ();
		tdfData.Connect ();
	}
}