Programming & Development / April 11, 2025

How to Represent Bangladesh’s Divisions in Java and SQL Using ISO 3166-2 Codes

Bangladesh divisions Java enum Bangladesh ISO 3166-2 BD SQL Bangladesh regions Bangladesh administrative divisions Spring Boot enum Bangladesh divisions list BD region codes divisions of Bangladesh

🇧🇩 Java Enum: Bangladesh’s Divisions

Bangladesh is divided into 8 administrative divisions. Here’s the Java enum using the ISO 3166-2:BD codes.

java

public enum BangladeshDivision {
    DHAKA("BD-13"),
    CHITTAGONG("BD-22"),
    KHULNA("BD-40"),
    RAJSHAHI("BD-41"),
    BARISAL("BD-43"),
    SYLHET("BD-44"),
    RANGPUR("BD-46"),
    MYMENSINGH("BD-50");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO bangladesh_divisions (name, code) VALUES
('Dhaka', 'BD-13'),
('Chittagong', 'BD-22'),
('Khulna', 'BD-40'),
('Rajshahi', 'BD-41'),
('Barisal', 'BD-43'),
('Sylhet', 'BD-44'),
('Rangpur', 'BD-46'),
('Mymensingh', 'BD-50');

✅ Summary

This setup represents Bangladesh’s 8 divisions using the ISO 3166-2:BD codes. It's ideal for handling geographical data, administrative tasks, or region-based processing 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