Programming & Development / April 11, 2025

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

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

🇮🇹 Java Enum: Italy’s Regions

Italy is divided into 20 regions. Here’s the Java enum using ISO 3166-2:IT codes:

java

public enum ItalyRegion {
    ABRUZZO("IT-65"),
    BASILICATA("IT-77"),
    CALABRIA("IT-78"),
    CAMPANIA("IT-72"),
    EMILIA_ROMAGNA("IT-45"),
    FRIULI_VENEZIA_GIULIA("IT-36"),
    LAZIO("IT-62"),
    LIGURIA("IT-42"),
    LOMBARDY("IT-25"),
    MARCHE("IT-57"),
    MOLISE("IT-67"),
    PIEDMONT("IT-21"),
    PUGLIA("IT-75"),
    SARDINIA("IT-88"),
    SICILY("IT-82"),
    TRENTO("IT-32"),
    UMBRIA("IT-55"),
    AOSTA_VALLEY("IT-23"),
    VENETO("IT-34");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO italy_regions (name, code) VALUES
('Abruzzo', 'IT-65'),
('Basilicata', 'IT-77'),
('Calabria', 'IT-78'),
('Campania', 'IT-72'),
('Emilia-Romagna', 'IT-45'),
('Friuli Venezia Giulia', 'IT-36'),
('Lazio', 'IT-62'),
('Liguria', 'IT-42'),
('Lombardy', 'IT-25'),
('Marche', 'IT-57'),
('Molise', 'IT-67'),
('Piedmont', 'IT-21'),
('Puglia', 'IT-75'),
('Sardinia', 'IT-88'),
('Sicily', 'IT-82'),
('Trentino-Alto Adige/Südtirol', 'IT-32'),
('Umbria', 'IT-55'),
('Aosta Valley', 'IT-23'),
('Veneto', 'IT-34');

✅ Summary

This setup covers all 20 regions of Italy using ISO 3166-2:IT 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