Programming & Development / April 11, 2025

How to Represent Gabon’s Provinces in Java and SQL Using ISO 3166-2 Codes

Gabon provinces Java enum Gabon ISO 3166-2 GA SQL Gabon provinces GA province codes Gabon administrative divisions backend region enum Gabon regions Java SQL Spring Boot regions Gabon

🇬🇦 Java Enum: Gabon’s Provinces

Gabon is divided into 9 provinces. Here’s the Java enum using ISO 3166-2:GA codes:

java

public enum GabonProvince {
    ESTUAIRE("GA-1"),
    HAUT_OGOOUE("GA-2"),
    OGOOUE_IVINDO("GA-3"),
    WOGOUMI("GA-4"),
    NYANGA("GA-5"),
    MOUHOUNGOU("GA-6"),
    NGOUNIE("GA-7"),
    OGOOUE_LABS("GA-8"),
    CAVALLERES("GA-9");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE gabon_provinces (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO gabon_provinces (name, code) VALUES
('Estuaire', 'GA-1'),
('Haut-Ogooué', 'GA-2'),
('Ogooué-Ivindo', 'GA-3'),
('Wogoum', 'GA-4'),
('Nyanga', 'GA-5'),
('Mouhounou', 'GA-6'),
('Ngounie', 'GA-7'),
('Ogooué-Labs', 'GA-8'),
('Cavallères', 'GA-9');

✅ Summary

This setup covers all 9 provinces of Gabon using ISO 3166-2:GA codes. It's ready for backend systems, Java applications, and SQL databases to implement region-based features.


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