Programming & Development / April 11, 2025

How to Represent Cyprus’ Districts in Java and SQL Using ISO 3166-2 Codes

Cyprus districts Java enum Cyprus ISO 3166-2 CY SQL Cyprus districts CY district codes Cyprus administrative divisions Spring Boot enum Cyprus region list backend district enum

🇨🇾 Java Enum: Cyprus’ Districts

Cyprus is divided into 6 districts. Here's the Java enum:

java

public enum CyprusDistrict {
    FAMAGUSTA("CY-04"),
    KYRENIA("CY-05"),
    LARNACA("CY-06"),
    LIMASSOL("CY-07"),
    NICOSIA("CY-01"),
    PAPHOS("CY-03");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO cyprus_districts (name, code) VALUES
('Famagusta', 'CY-04'),
('Kyrenia', 'CY-05'),
('Larnaca', 'CY-06'),
('Limassol', 'CY-07'),
('Nicosia', 'CY-01'),
('Paphos', 'CY-03');

✅ Summary

This Java enum and SQL table setup accurately represent the 6 districts of Cyprus using their respective ISO 3166-2:CY codes.


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