Suit

package ClothingItemShop;

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

public class Suit extends ClothingItemShop {
    private static float box_price;

    public Suit(float price_param, float weight_param, String color_param, String colorPattern_param, String size_param,
            String fabric_param) {
        super(price_param, weight_param, color_param, colorPattern_param, size_param, fabric_param);

    }

    static {
        try {
            Connection connection = null;
            Statement statement = null;

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

            statement = connection.createStatement();
            ResultSet result = statement
                    .executeQuery("SELECT container_price FROM containers WHERE item_type = 'Suite'");

            while (result.next()) {
                box_price = result.getFloat("container_price");
                System.out.println("The box price for the Suite is: " + box_price);
            }
            result.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            System.out.print(e);
        }
    }

    public float getContainerPrice() {
        return box_price;
    }

    public float getWeight() {
        return weight;
    }

    public float getPrice() {
        if (size.equals("L") || size.equals("XXL") || size.equals("XL")) {
            return super.getItemPrice() * (float) 1.2;
        } else {
            return super.getItemPrice();
        }
    }

}