Programming & Development / April 11, 2025

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

Cambodia provinces Java enum Cambodia ISO 3166-2 KH SQL Cambodia provinces Cambodia administrative divisions Spring Boot enum Cambodia provinces list KH region codes provinces of Cambodia

🇰🇭 Java Enum: Cambodia’s Provinces

Cambodia is divided into 25 provinces (including the autonomous municipality of Phnom Penh). Below is the Java enum using the official ISO 3166-2:KH codes:

java

public enum CambodiaProvince {
    BANTEAY_MEANCHEY("KH-1"),
    BATTAMBANG("KH-2"),
    KAMPONG_CHAM("KH-3"),
    KAMPONG_CHHNANG("KH-4"),
    KAMPONG_SPEU("KH-5"),
    KAMPONG_THOM("KH-6"),
    KAMPOT("KH-7"),
    KANDAL("KH-8"),
    KOH_KONG("KH-9"),
    KRATIE("KH-10"),
    MONDULKIRI("KH-11"),
    PHNOM_PENH("KH-12"),
    PREAH_VIHEAR("KH-13"),
    PREY_VENG("KH-14"),
    PURSAT("KH-15"),
    RATTANAKIRI("KH-16"),
    SIEM_REAP("KH-17"),
    PREAH_SIHANOUK("KH-18"),
    STUNG_TRENG("KH-19"),
    SVAY_RIENG("KH-20"),
    TAKEO("KH-21"),
    ODDAR_MEANCHEY("KH-22"),
    KEP("KH-23"),
    PAILIN("KH-24"),
    TBOUNG_KHMUM("KH-25");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO cambodia_provinces (name, code) VALUES
('Banteay Meanchey', 'KH-1'),
('Battambang', 'KH-2'),
('Kampong Cham', 'KH-3'),
('Kampong Chhnang', 'KH-4'),
('Kampong Speu', 'KH-5'),
('Kampong Thom', 'KH-6'),
('Kampot', 'KH-7'),
('Kandal', 'KH-8'),
('Koh Kong', 'KH-9'),
('Kratie', 'KH-10'),
('Mondulkiri', 'KH-11'),
('Phnom Penh', 'KH-12'),
('Preah Vihear', 'KH-13'),
('Prey Veng', 'KH-14'),
('Pursat', 'KH-15'),
('Ratanakiri', 'KH-16'),
('Siem Reap', 'KH-17'),
('Preah Sihanouk', 'KH-18'),
('Stung Treng', 'KH-19'),
('Svay Rieng', 'KH-20'),
('Takeo', 'KH-21'),
('Oddar Meanchey', 'KH-22'),
('Kep', 'KH-23'),
('Pailin', 'KH-24'),
('Tboung Khmum', 'KH-25');

✅ Summary

This setup represents Cambodia’s 25 provinces, including Phnom Penh, using the official ISO 3166-2:KH region codes. It’s ideal for integrating standardized geographic data into your 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