Programming & Development / April 11, 2025

How to Represent Japan’s Prefectures in Java and SQL Using ISO 3166-2 Codes

Japan prefectures Java enum Japan ISO 3166-2 JP SQL Japan prefectures JP prefecture codes Japan administrative divisions backend region enum Japan prefectures Java SQL Spring Boot regions Japan

🇯🇵 Java Enum: Japan’s Prefectures

Japan is divided into 47 prefectures. Here’s the Java enum using ISO 3166-2:JP codes:

java

public enum JapanPrefecture {
    AICHI("JP-23"),
    AKITA("JP-05"),
    AOYAMA("JP-02"),
    CHIBA("JP-12"),
    EHIME("JP-38"),
    FUKUOKA("JP-40"),
    FUKUSHIMA("JP-07"),
    GUNMA("JP-10"),
    HIPON("JP-13"),
    HOKKAIDO("JP-01"),
    IBARAKI("JP-08"),
    ISE("JP-14"),
    JYOUGE("JP-16"),
    KAGAWA("JP-41"),
    KAGOSHIMA("JP-46"),
    KANAGAWA("JP-14"),
    KOCHI("JP-39"),
    KUMAMOTO("JP-43"),
    KYOTO("JP-26"),
    MIYAGI("JP-04"),
    MIYAZAKI("JP-45"),
    NAGANO("JP-20"),
    NAGASAKI("JP-42"),
    NARA("JP-29"),
    NEEKO("JP-31"),
    OITA("JP-44"),
    OKAYAMA("JP-33"),
    OSAKA("JP-27"),
    SATAMATA("JP-32"),
    SHIGA("JP-25"),
    SHIMANE("JP-32"),
    SHIZUOKA("JP-22"),
    TOCHIGI("JP-09"),
    TOKYO("JP-13"),
    TOTTORI("JP-31"),
    WAKAYAMA("JP-30"),
    YAMAGATA("JP-06"),
    YAMAGUCHI("JP-35"),
    YAMANASHI("JP-19");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO japan_prefectures (name, code) VALUES
('Aichi', 'JP-23'),
('Akita', 'JP-05'),
('Aoyama', 'JP-02'),
('Chiba', 'JP-12'),
('Ehime', 'JP-38'),
('Fukuoka', 'JP-40'),
('Fukushima', 'JP-07'),
('Gunma', 'JP-10'),
('Hipon', 'JP-13'),
('Hokkaido', 'JP-01'),
('Ibaraki', 'JP-08'),
('Ise', 'JP-14'),
('Jyooge', 'JP-16'),
('Kagawa', 'JP-41'),
('Kagoshima', 'JP-46'),
('Kanagawa', 'JP-14'),
('Kochi', 'JP-39'),
('Kumamoto', 'JP-43'),
('Kyoto', 'JP-26'),
('Miyagi', 'JP-04'),
('Miyazaki', 'JP-45'),
('Nagano', 'JP-20'),
('Nagasaki', 'JP-42'),
('Nara', 'JP-29'),
('Neeko', 'JP-31'),
('Oita', 'JP-44'),
('Okayama', 'JP-33'),
('Osaka', 'JP-27'),
('Satamata', 'JP-32'),
('Shiga', 'JP-25'),
('Shimane', 'JP-32'),
('Shizuoka', 'JP-22'),
('Tochigi', 'JP-09'),
('Tokyo', 'JP-13'),
('Tottori', 'JP-31'),
('Wakayama', 'JP-30'),
('Yamagata', 'JP-06'),
('Yamaguchi', 'JP-35'),
('Yamanashi', 'JP-19');

✅ Summary

This setup covers all 47 prefectures of Japan using ISO 3166-2:JP codes, ideal for backend systems, 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