Programming & Development / April 11, 2025

How to Represent Indonesia’s Provinces in Java and SQL Using ISO 3166-2 Codes

Indonesia provinces Java enum Indonesia ISO 3166-2 ID SQL Indonesia provinces ID province codes Indonesia administrative divisions backend region enum Indonesia provinces Java SQL Spring Boot regions Indonesia

🇮🇩 Java Enum: Indonesia’s Provinces

Indonesia is divided into 34 provinces. Here’s the Java enum using ISO 3166-2:ID codes:

java

public enum IndonesiaProvince {
    ACEH("ID-AC"),
    BALI("ID-BA"),
    BANTEN("ID-BT"),
    BEKASI("ID-BE"),
    BENGKULU("ID-BE"),
    GORONTALO("ID-GO"),
    JAMBI("ID-JA"),
    JAWA_BARAT("ID-JB"),
    JAWA_TENGAH("ID-JT"),
    JAWA_TIMUR("ID-JI"),
    KALIMANTAN_BARAT("ID-KB"),
    KALIMANTAN_SELATAN("ID-KS"),
    KALIMANTAN_TENGAH("ID-KT"),
    KALIMANTAN_TIMUR("ID-KI"),
    KALIMANTAN_UTARA("ID-KU"),
    LAMPUNG("ID-LA"),
    MALUKU("ID-MA"),
    MALUKU_UTARA("ID-MU"),
    NUSA_TENGGARA_BARAT("ID-NT"),
    NUSA_TENGGARA_TIMUR("ID-NTT"),
    PAPUA("ID-PA"),
    PAPUA_BARAT("ID-PB"),
    RIAU("ID-RI"),
    SULAWESI_BARAT("ID-SB"),
    SULAWESI_SELATAN("ID-SU"),
    SULAWESI_TENGAH("ID-ST"),
    SULAWESI_TENGGARA("ID-SE"),
    SULAWESI_UTARA("ID-SA"),
    SUMATERA_BARAT("ID-SB"),
    SUMATERA_SELATAN("ID-SS"),
    SUMATERA_UTARA("ID-SU"),
    YOGYAKARTA("ID-YO");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO indonesia_provinces (name, code) VALUES
('Aceh', 'ID-AC'),
('Bali', 'ID-BA'),
('Banten', 'ID-BT'),
('Bekasi', 'ID-BE'),
('Bengkulu', 'ID-BE'),
('Gorontalo', 'ID-GO'),
('Jambi', 'ID-JA'),
('Jawa Barat', 'ID-JB'),
('Jawa Tengah', 'ID-JT'),
('Jawa Timur', 'ID-JI'),
('Kalimantan Barat', 'ID-KB'),
('Kalimantan Selatan', 'ID-KS'),
('Kalimantan Tengah', 'ID-KT'),
('Kalimantan Timur', 'ID-KI'),
('Kalimantan Utara', 'ID-KU'),
('Lampung', 'ID-LA'),
('Maluku', 'ID-MA'),
('Maluku Utara', 'ID-MU'),
('Nusa Tenggara Barat', 'ID-NT'),
('Nusa Tenggara Timur', 'ID-NTT'),
('Papua', 'ID-PA'),
('Papua Barat', 'ID-PB'),
('Riau', 'ID-RI'),
('Sulawesi Barat', 'ID-SB'),
('Sulawesi Selatan', 'ID-SU'),
('Sulawesi Tengah', 'ID-ST'),
('Sulawesi Tenggara', 'ID-SE'),
('Sulawesi Utara', 'ID-SA'),
('Sumatera Barat', 'ID-SB'),
('Sumatera Selatan', 'ID-SS'),
('Sumatera Utara', 'ID-SU'),
('Yogyakarta', 'ID-YO');

✅ Summary

This setup covers all 34 provinces of Indonesia using ISO 3166-2:ID 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