Programming & Development / April 11, 2025

How to Represent Brunei’s Districts in Java and SQL Using ISO 3166-2 Codes

Brunei districts Java enum Brunei ISO 3166-2 BN SQL Brunei regions Brunei administrative divisions Spring Boot enum Brunei districts list BN region codes districts of Brunei

🇧🇳 Java Enum: Brunei’s Districts

Brunei is divided into 4 districts. Here’s the Java enum using the ISO 3166-2:BN codes.

java

public enum BruneiDistrict {
    BRUNEI_MUARA("BN-BM"),
    BELAIT("BN-BA"),
    TEMBURONG("BN-TE"),
    LUMUT("BN-LU");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO brunei_districts (name, code) VALUES
('Brunei Muara', 'BN-BM'),
('Belait', 'BN-BA'),
('Temburong', 'BN-TE'),
('Lumut', 'BN-LU');

✅ Summary

This setup represents Brunei’s 4 districts using the ISO 3166-2:BN codes. This structure is perfect for managing geographical regions, administrative divisions, or location-based functionalities in 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