Programming & Development / April 11, 2025

How to Represent Malaysia’s States and Federal Territories in Java and SQL Using ISO 3166-2 Codes

Malaysia states Malaysia federal territories Java enum Malaysia ISO 3166-2 MY SQL Malaysia states MY state codes Malaysia administrative divisions backend region enum Malaysia Java SQL Spring Boot regions Malaysia

🇲🇾 Java Enum: Malaysia’s States and Federal Territories

Malaysia is made up of 13 states and 3 federal territories. Here's the Java enum using ISO 3166-2:MY codes:

java

public enum MalaysiaStateOrTerritory {
    JOHOR("MY-01"),
    KEDAH("MY-02"),
    KELANTAN("MY-03"),
    MELAKA("MY-04"),
    NEGERI_SEMBILAN("MY-05"),
    PAHANG("MY-06"),
    PERAK("MY-08"),
    PERLIS("MY-09"),
    PENANG("MY-07"),
    SABAH("MY-12"),
    SARAWAK("MY-13"),
    SELANGOR("MY-10"),
    TERENGGANU("MY-11"),
    KUALA_LUMPUR("MY-14"),
    LABUAN("MY-15"),
    PUTRAJAYA("MY-16");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO malaysia_states_and_territories (name, code) VALUES
('Johor', 'MY-01'),
('Kedah', 'MY-02'),
('Kelantan', 'MY-03'),
('Melaka', 'MY-04'),
('Negeri Sembilan', 'MY-05'),
('Pahang', 'MY-06'),
('Penang', 'MY-07'),
('Perak', 'MY-08'),
('Perlis', 'MY-09'),
('Selangor', 'MY-10'),
('Terengganu', 'MY-11'),
('Sabah', 'MY-12'),
('Sarawak', 'MY-13'),
('Kuala Lumpur', 'MY-14'),
('Labuan', 'MY-15'),
('Putrajaya', 'MY-16');

✅ Summary

This setup covers all 13 states and 3 federal territories of Malaysia using ISO 3166-2:MY codes. It’s 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