Programming & Development / April 11, 2025

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

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

🇱🇦 Java Enum: Laos’ Provinces

Laos is divided into 18 provinces and 1 capital city (Vientiane). Here’s the Java enum using ISO 3166-2:LA codes:

java

public enum LaosProvince {
    ATTAPEU("LA-AT"),
    BOKEO("LA-BK"),
    CHAMPASAK("LA-CH"),
    HUAPHAN("LA-HU"),
    KHAMMOUANE("LA-KH"),
    LUANG_PRABANG("LA-LP"),
    LUANG_NAMTHA("LA-LN"),
    OUDOMXAI("LA-OU"),
    PHONGSALI("LA-PL"),
    SALAVAN("LA-SA"),
    SAVANNAKHET("LA-SK"),
    XAIYABOURY("LA-XB"),
    XEPHONE("LA-XS"),
    VIENTIANE("LA-VT"),
    VIENTIANE_CAPITAL("LA-VI"),
    VIENTIANE_PROVINCE("LA-VP"),
    XAYABOURY("LA-XY"),
    VANGVIENG("LA-VV");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO laos_provinces (name, code) VALUES
('Attapeu', 'LA-AT'),
('Bokeo', 'LA-BK'),
('Champasak', 'LA-CH'),
('Huaphan', 'LA-HU'),
('Khammouane', 'LA-KH'),
('Luang Prabang', 'LA-LP'),
('Luang Namtha', 'LA-LN'),
('Oudomxai', 'LA-OU'),
('Phongsali', 'LA-PL'),
('Salavan', 'LA-SA'),
('Savannakhet', 'LA-SK'),
('Xayaboury', 'LA-XB'),
('Xephone', 'LA-XS'),
('Vientiane', 'LA-VT'),
('Vientiane Capital', 'LA-VI'),
('Vientiane Province', 'LA-VP'),
('Xayaboury', 'LA-XY'),
('Vangvieng', 'LA-VV');

✅ Summary

This setup covers all 18 provinces and 1 capital city of Laos using ISO 3166-2:LA 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