Programming & Development / April 11, 2025

How to Represent Albania’s Counties in Java and SQL Using ISO 3166-2 Codes

Albania counties Albania provinces Java enum Albania ISO 3166-2 AL SQL Albania counties Albanian administrative divisions Spring Boot enum address validation Albania ISO AL codes Albania region codes

🇦🇱 Java Enum: Albania’s Counties with ISO Codes

Albania is divided into 12 counties. Here’s a Java enum using ISO 3166-2:AL codes:

java

public enum AlbaniaCounty {
    BERAT("AL-01"),
    DIBER("AL-09"),
    DURRES("AL-02"),
    ELBASAN("AL-03"),
    FIER("AL-04"),
    GJIROKASTER("AL-05"),
    KORCE("AL-06"),
    KUKES("AL-07"),
    LEZHE("AL-08"),
    SHKODER("AL-10"),
    TIRANE("AL-11"),
    VLORE("AL-12");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table for Albania’s Counties

sql

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

Insert Statements:

sql

INSERT INTO albania_counties (name, code) VALUES
('Berat', 'AL-01'),
('Dibër', 'AL-09'),
('Durrës', 'AL-02'),
('Elbasan', 'AL-03'),
('Fier', 'AL-04'),
('Gjirokastër', 'AL-05'),
('Korçë', 'AL-06'),
('Kukës', 'AL-07'),
('Lezhë', 'AL-08'),
('Shkodër', 'AL-10'),
('Tiranë', 'AL-11'),
('Vlorë', 'AL-12');

✅ Summary

This setup ensures reliable regional referencing using ISO 3166-2:AL standards—ideal for government apps, address forms, or analytics by region in Albania.


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