Programming & Development / April 11, 2025

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

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

🇱🇧 Java Enum: Lebanon’s Governorates

Lebanon is divided into 8 governorates. Here’s the Java enum using ISO 3166-2:LB codes:

java

public enum LebanonGovernorate {
    BEIRUT("LB-BI"),
    MOUNT_LEBANON("LB-MN"),
    NORTH("LB-N"),
    SOUTH("LB-S"),
    BEKAA("LB-BA"),
    NORTHEAST("LB-NW"),
    SOUTHWEST("LB-SS"),
    NABATIEH("LB-NB");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO lebanon_governorates (name, code) VALUES
('Beirut', 'LB-BI'),
('Mount Lebanon', 'LB-MN'),
('North Lebanon', 'LB-N'),
('South Lebanon', 'LB-S'),
('Bekaa', 'LB-BA'),
('Northeast Lebanon', 'LB-NW'),
('Southwest Lebanon', 'LB-SS'),
('Nabatieh', 'LB-NB');

✅ Summary

This setup covers all 8 governorates of Lebanon using ISO 3166-2:LB 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