Programming & Development / April 11, 2025

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

Germany states Java enum Germany ISO 3166-2 DE SQL Germany states DE state codes Germany administrative divisions backend region enum Germany provinces Java SQL Spring Boot regions Germany

🇩🇪 Java Enum: Germany’s States (Bundesländer)

Germany is divided into 16 states (Bundesländer). Here’s the Java enum using ISO 3166-2:DE codes:

java

public enum GermanyState {
    BADEN_WUERTTEMBERG("DE-BW"),
    BAVARIA("DE-BY"),
    BERLIN("DE-BE"),
    BRANDENBURG("DE-BB"),
    BREMEN("DE-HB"),
    HAMBURG("DE-HH"),
    HESSE("DE-HE"),
    LOWER_SAXONY("DE-NI"),
    MECKLENBURG_VORPOMMERN("DE-MV"),
    NORTH_RHINE_WESTPHALIA("DE-NW"),
    RHINELAND_PALATINATE("DE-RP"),
    SAARLAND("DE-SL"),
    SAXONY("DE-SN"),
    SAXONY_ANHALT("DE-ST"),
    SCHLESWIG_HOLSTEIN("DE-SH"),
    THURINGIA("DE-TH");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO germany_states (name, code) VALUES
('Baden-Württemberg', 'DE-BW'),
('Bavaria', 'DE-BY'),
('Berlin', 'DE-BE'),
('Brandenburg', 'DE-BB'),
('Bremen', 'DE-HB'),
('Hamburg', 'DE-HH'),
('Hesse', 'DE-HE'),
('Lower Saxony', 'DE-NI'),
('Mecklenburg-Vorpommern', 'DE-MV'),
('North Rhine-Westphalia', 'DE-NW'),
('Rhineland-Palatinate', 'DE-RP'),
('Saarland', 'DE-SL'),
('Saxony', 'DE-SN'),
('Saxony-Anhalt', 'DE-ST'),
('Schleswig-Holstein', 'DE-SH'),
('Thuringia', 'DE-TH');

✅ Summary

This setup covers all 16 states (Bundesländer) of Germany using ISO 3166-2:DE codes, ready for backend systems, 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