Programming & Development / April 11, 2025

How to Represent Austria’s States in Java and SQL Using ISO 3166-2 Codes

Austria states Java enum Austria ISO 3166-2 AT SQL Austria regions Austria administrative divisions Spring Boot enum Austrian states list AT region codes Austria regions states of Austria

🇦🇹 Java Enum: Austria’s States (Bundesländer)

Austria is divided into 9 states (Bundesländer). Here’s the Java enum using the ISO 3166-2:AT codes.

java

public enum AustriaState {
    BURGENLAND("AT-1"),
    CARINTHIA("AT-2"),
    LOWER_AUSTRIA("AT-3"),
    UPPER_AUSTRIA("AT-4"),
    SALZBURG("AT-5"),
    STYRIA("AT-6"),
    TYROL("AT-7"),
    UPPER_AUSTRIA("AT-8"),
    VIENNA("AT-9");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO austria_states (name, code) VALUES
('Burgenland', 'AT-1'),
('Carinthia', 'AT-2'),
('Lower Austria', 'AT-3'),
('Upper Austria', 'AT-4'),
('Salzburg', 'AT-5'),
('Styria', 'AT-6'),
('Tyrol', 'AT-7'),
('Upper Austria', 'AT-8'),
('Vienna', 'AT-9');

✅ Summary

This setup represents Austria’s 9 states (Bundesländer) using ISO 3166-2:AT codes. It's ideal for geographical, regional filtering, or administrative applications.


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