Programming & Development / April 11, 2025

How to Represent Jordan’s Governorates in Java and SQL Using ISO 3166-2 Codes

Jordan governorates Java enum Jordan ISO 3166-2 JO SQL Jordan governorates JO governorate codes Jordan administrative divisions backend region enum Jordan governorates Java SQL Spring Boot regions Jordan

🇯🇴 Java Enum: Jordan’s Governorates

Jordan is divided into 12 governorates. Here’s the Java enum using ISO 3166-2:JO codes:

java

public enum JordanGovernorate {
    AMMAN("JO-AM"),
    AJLUN("JO-AJ"),
    AL_BALQA("JO-BA"),
    AL_KARAK("JO-KA"),
    AL_MAFRAQ("JO-MF"),
    AL_ZARQA("JO-ZA"),
    IRBID("JO-IR"),
    JERASH("JO-JA"),
    MAAN("JO-MA"),
    MADABA("JO-MD"),
    TAFILEH("JO-TA"),
    AQABA("JO-AQ");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO jordan_governorates (name, code) VALUES
('Amman', 'JO-AM'),
('Ajlun', 'JO-AJ'),
('Al Balqa', 'JO-BA'),
('Al Karak', 'JO-KA'),
('Al Mafraq', 'JO-MF'),
('Al Zarqa', 'JO-ZA'),
('Irbid', 'JO-IR'),
('Jerash', 'JO-JA'),
('Maan', 'JO-MA'),
('Madaba', 'JO-MD'),
('Tafileh', 'JO-TA'),
('Aqaba', 'JO-AQ');

✅ Summary

This setup covers all 12 governorates of Jordan using ISO 3166-2:JO codes, ideal for backend services, Java applications, and SQL databases.



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