Programming & Development / April 11, 2025

How to Represent Eswatini’s Regions in Java and SQL Using ISO 3166-2 Codes

Eswatini regions Java enum Eswatini ISO 3166-2 SZ SQL Eswatini regions SZ region codes Eswatini administrative divisions backend region enum Eswatini provinces Java SQL Spring Boot regions Eswatini

🇸🇿 Java Enum: Eswatini’s Regions

Eswatini is divided into 4 regions. Here’s the Java enum using ISO 3166-2:SZ codes:

java

public enum EswatiniRegion {
    HHOHHO("SZ-HH"),
    MANZINI("SZ-MN"),
    SHISELWENI("SZ-SH"),
    Lubombo("SZ-LB");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO eswatini_regions (name, code) VALUES
('Hhohho', 'SZ-HH'),
('Manzini', 'SZ-MN'),
('Shiselweni', 'SZ-SH'),
('Lubombo', 'SZ-LB');

✅ Summary

This setup covers all 4 regions of Eswatini using ISO 3166-2:SZ codes. It's ready for use in Java applications, SQL databases, and regional data handling systems.


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