package SQLconnection;

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


public class SQLconnection
{
    public static void main(String args[])
    {

    	Connection connection = null;
    	Statement statement = null;

    	try {
    		  Class.forName("com.mysql.jdbc.Driver");
			  connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ClothingItem", "root", "");

    	      System.out.println("Success");
    	      statement = connection.createStatement();
    	      ResultSet result = statement.executeQuery(" SELECT * FROM ClothingItem; ");

    	      while (result.next())
    	      {
    	    	  int id = result.getInt("id");
    	    	  String type = result.getString("type");
    	    	  float price = result.getFloat("price");
    	    	  float weight = result.getFloat("weight");
    	    	  String size = result.getString("size");
    	    	  String color = result.getString("color");
    	    	  String colorPattern = result.getString("color_pattern");
    	    	  String fabric = result.getString("fabric");
    	    	  System.out.println( "ID = " + id );
    	    	  System.out.println( "Type = " + type );
    	    	  System.out.println( "Price = " + price );
    	    	  System.out.println( "Weight = " + weight );
    	    	  System.out.println( "Size = " + size );
    	    	  System.out.println( "Color = " + color );
    	    	  System.out.println( "Color Pattern = " + colorPattern );
    	    	  System.out.println( "Fabric = " + fabric  );

    	      }
    	      result.close();
    	      statement.close();
    	      connection.close();
    		}
    	catch (SQLException ex)
    	{
    	    System.out.println("No success");
    	    System.out.println("SQLException: " + ex.getMessage());
    	    System.out.println("SQLState: " + ex.getSQLState());
    	    System.out.println("VendorError: " + ex.getErrorCode());
    	}
    	catch (ClassNotFoundException x_not_found)
    	{
    		System.out.println("Class not found");
    	}
    }
}