Programming & Development / April 11, 2025

How to Represent Caribbean Countries and Territories in Java and SQL with ISO Country Codes

Caribbean islands Java enum SQL Caribbean countries ISO 3166 codes Caribbean territories Spring Boot enum address validation Latin America West Indies island nations ISO country codes Caribbean integration

🏝️ Java Enum: Caribbean Countries and Territories (ISO Alpha-2)

This enum includes sovereign states and major dependent territories in the Caribbean, using their ISO 3166-1 alpha-2 codes:

java

public enum CaribbeanCountry {
    ANTIGUA_AND_BARBUDA("AG"),
    ARUBA("AW"),
    BAHAMAS("BS"),
    BARBADOS("BB"),
    BONAIRE_SINT_EUSTATIUS_SABA("BQ"),
    BRITISH_VIRGIN_ISLANDS("VG"),
    CAYMAN_ISLANDS("KY"),
    CUBA("CU"),
    CURACAO("CW"),
    DOMINICA("DM"),
    DOMINICAN_REPUBLIC("DO"),
    GRENADA("GD"),
    GUADELOUPE("GP"),
    HAITI("HT"),
    JAMAICA("JM"),
    MARTINIQUE("MQ"),
    MONTSERRAT("MS"),
    PUERTO_RICO("PR"),
    SAINT_BARTHELEMY("BL"),
    SAINT_KITTS_AND_NEVIS("KN"),
    SAINT_LUCIA("LC"),
    SAINT_MARTIN("MF"),
    SAINT_VINCENT_AND_GRENADINES("VC"),
    SINT_MAARTEN("SX"),
    TRINIDAD_AND_TOBAGO("TT"),
    TURKS_AND_CAICOS_ISLANDS("TC"),
    US_VIRGIN_ISLANDS("VI");

    private final String code;

    CaribbeanCountry(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Version: Caribbean Countries Table

SQL schema for storing Caribbean nations and territories with ISO codes:

sql

CREATE TABLE caribbean_countries (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code CHAR(2) NOT NULL UNIQUE
);

Insert Statements:

sql

INSERT INTO caribbean_countries (name, code) VALUES
('Antigua and Barbuda', 'AG'),
('Aruba', 'AW'),
('Bahamas', 'BS'),
('Barbados', 'BB'),
('Bonaire, Sint Eustatius and Saba', 'BQ'),
('British Virgin Islands', 'VG'),
('Cayman Islands', 'KY'),
('Cuba', 'CU'),
('Curaçao', 'CW'),
('Dominica', 'DM'),
('Dominican Republic', 'DO'),
('Grenada', 'GD'),
('Guadeloupe', 'GP'),
('Haiti', 'HT'),
('Jamaica', 'JM'),
('Martinique', 'MQ'),
('Montserrat', 'MS'),
('Puerto Rico', 'PR'),
('Saint Barthélemy', 'BL'),
('Saint Kitts and Nevis', 'KN'),
('Saint Lucia', 'LC'),
('Saint Martin (French part)', 'MF'),
('Saint Vincent and the Grenadines', 'VC'),
('Sint Maarten (Dutch part)', 'SX'),
('Trinidad and Tobago', 'TT'),
('Turks and Caicos Islands', 'TC'),
('United States Virgin Islands', 'VI');

✅ Summary

This list provides a reliable structure for handling address or region data for Caribbean-based systems. It includes both independent nations and overseas territories (Dutch, French, British, and U.S.).


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex