Programming & Development / April 11, 2025

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

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

🇰🇼 Java Enum: Kuwait’s Governorates

Kuwait is divided into 6 governorates. Here’s the Java enum using ISO 3166-2:KW codes:

java

public enum KuwaitGovernorate {
    AL_ASIMAH("KW-AH"),
    AL_JAHRAH("KW-JA"),
    AL_FARWANIYA("KW-FA"),
    AHMEDI("KW-AH"),
    MUHARRAQ("KW-MH"),
    AL_HAWALLY("KW-HA");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO kuwait_governorates (name, code) VALUES
('Al Asimah', 'KW-AH'),
('Al Jahrah', 'KW-JA'),
('Al Farwaniya', 'KW-FA'),
('Ahmed', 'KW-AH'),
('Muharraq', 'KW-MH'),
('Al Hawally', 'KW-HA');

✅ Summary

This setup covers all 6 governorates of Kuwait using ISO 3166-2:KW codes, ideal for backend systems, 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