通过省份和城市获取车籍地(车牌号码前2位)

最新推荐文章于 2024-05-16 10:23:10 发布

L_Desertstorm

最新推荐文章于 2024-05-16 10:23:10 发布

阅读量1.5k

点赞数

分类专栏： Java 文章标签： java intellij idea postgresql sql json

本文链接：https://blog.csdn.net/L_Desertstorm/article/details/107177430

版权

Java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

首先贴上所有省份信息json字符串

[{"Hp":"冀A","city":"石家庄","province":"河北","Pcode":"HB","AreaCode":"130100"},{"Hp":"冀B","city":"唐山","province":"河北","Pcode":"HB","AreaCode":"130200"},{"Hp":"冀C","city":"秦皇岛","province":"河北","Pcode":"HB","AreaCode":"130300"},{"Hp":"冀D","city":"邯郸","province":"河北","Pcode":"HB","AreaCode":"130421"},{"Hp":"冀E","city":"邢台","province":"河北","Pcode":"HB","AreaCode":"130521"},{"Hp":"冀F","city":"保定","province":"河北","Pcode":"HB","AreaCode":"130600"},{"Hp":"冀G","city":"张家口","province":"河北","Pcode":"HB","AreaCode":"130700"},{"Hp":"冀H","city":"承德","province":"河北","Pcode":"HB","AreaCode":"130821"},{"Hp":"冀J","city":"沧州","province":"河北","Pcode":"HB","AreaCode":"130900"},{"Hp":"冀R","city":"廊坊","province":"河北","Pcode":"HB","AreaCode":"131000"},{"Hp":"冀S","city":"沧州","province":"河北","Pcode":"HB","AreaCode":"130900"},{"Hp":"冀T","city":"衡水","province":"河北","Pcode":"HB","AreaCode":"131100"},{"Hp":"辽A","city":"沈阳","province":"辽宁","Pcode":"LN","AreaCode":"210100"},{"Hp":"辽B","city":"大连","province":"辽宁","Pcode":"LN","AreaCode":"231182"},{"Hp":"辽C","city":"鞍山","province":"辽宁","Pcode":"LN","AreaCode":"340500"},{"Hp":"辽D","city":"抚顺","province":"辽宁","Pcode":"LN","AreaCode":"210421"},{"Hp":"辽E","city":"本溪","province":"辽宁","Pcode":"LN","AreaCode":"210521"},{"Hp":"辽F","city":"丹东","province":"辽宁","Pcode":"LN","AreaCode":"210600"},{"Hp":"辽G","city":"锦州","province":"辽宁","Pcode":"LN","AreaCode":"210700"},{"Hp":"辽H","city":"营口","province":"辽宁","Pcode":"LN","AreaCode":"210800"},{"Hp":"辽J","city":"阜新","province":"辽宁","Pcode":"LN","AreaCode":"210921"},{"Hp":"辽K","city":"辽阳","province":"辽宁","Pcode":"LN","AreaCode":"211021"},{"Hp":"辽L","city":"盘锦","province":"辽宁","Pcode":"LN","AreaCode":"211100"},{"Hp":"辽M","city":"铁岭","province":"辽宁","Pcode":"LN","AreaCode":"211221"},{"Hp":"辽N","city":"朝阳","province":"辽宁","Pcode":"LN","AreaCode":"220104"},{"Hp":"辽P","city":"葫芦岛","province":"辽宁","Pcode":"LN","AreaCode":"211400"},{"Hp":"皖A","city":"合肥","province":"安徽","Pcode":"AH","AreaCode":"340100"},{"Hp":"皖B","city":"芜湖","province":"安徽","Pcode":"AH","AreaCode":"340221"},{"Hp":"皖C","city":"蚌埠","province":"安徽","Pcode":"AH","AreaCode":"340300"},{"Hp":"皖D","city":"淮南","province":"安徽","Pcode":"AH","AreaCode":"340400"},{"Hp":"皖E","city":"马鞍山","province":"安徽","Pcode":"AH","AreaCode":"340500"},{"Hp":"皖F","city":"淮北","province":"安徽","Pcode":"AH","AreaCode":"340600"},{"Hp":"皖G","city":"铜陵","province":"安徽","Pcode":"AH","AreaCode":"340700"},{"Hp":"皖H","city":"安庆","province":"安徽","Pcode":"AH","AreaCode":"340800"},{"Hp":"皖J","city":"黄山","province":"安徽","Pcode":"AH","AreaCode":"341003"},{"Hp":"皖K","city":"阜阳","province":"安徽","Pcode":"AH","AreaCode":"341200"},{"Hp":"皖L","city":"宿州","province":"安徽","Pcode":"AH","AreaCode":"341300"},{"Hp":"皖M","city":"滁州","province":"安徽","Pcode":"AH","AreaCode":"341100"},{"Hp":"皖N","city":"六安","province":"安徽","Pcode":"AH","AreaCode":"341500"},{"Hp":"皖P","city":"宣城","province":"安徽","Pcode":"AH","AreaCode":"341800"},{"Hp":"皖Q","city":"巢湖","province":"安徽","Pcode":"AH","AreaCode":"340181"},{"Hp":"皖R","city":"池州","province":"安徽","Pcode":"AH","AreaCode":"341700"},{"Hp":"皖S","city":"亳州","province":"安徽","Pcode":"AH","AreaCode":"341600"},{"Hp":"苏A","city":"南京","province":"江苏","Pcode":"JS","AreaCode":"320100"},{"Hp":"苏B","city":"无锡","province":"江苏","Pcode":"JS","AreaCode":"320200"},{"Hp":"苏C","city":"徐州","province":"江苏","Pcode":"JS","AreaCode":"320300"},{"Hp":"苏D","city":"常州","province":"江苏","Pcode":"JS","AreaCode":"320400"},{"Hp":"苏E","city":"苏州","province":"江苏","Pcode":"JS","AreaCode":"320500"},{"Hp":"苏F","city":"南通","province":"江苏","Pcode":"JS","AreaCode":"320600"},{"Hp":"苏G","city":"连云港","province":"江苏","Pcode":"JS","AreaCode":"320700"},{"Hp":"苏H","city":"淮安","province":"江苏","Pcode":"JS","AreaCode":"320803"},{"Hp":"苏J","city":"盐城","province":"江苏","Pcode":"JS","AreaCode":"320900"},{"Hp":"苏K","city":"扬州","province":"江苏","Pcode":"JS","AreaCode":"321000"},{"Hp":"苏L","city":"镇江","province":"江苏","Pcode":"JS","AreaCode":"321100"},{"Hp":"苏M","city":"泰州","province":"江苏","Pcode":"JS","AreaCode":"321200"},{"Hp":"苏N","city":"宿迁","province":"江苏","Pcode":"JS","AreaCode":"321300"},{"Hp":"鄂A","city":"武汉","province":"湖北","Pcode":"HB","AreaCode":"420100"},{"Hp":"鄂B","city":"黄石","province":"湖北","Pcode":"HB","AreaCode":"420202"},{"Hp":"鄂C","city":"十堰","province":"湖北","Pcode":"HB","AreaCode":"420300"},{"Hp":"鄂D","city":"荆州","province":"湖北","Pcode":"HB","AreaCode":"421003"},{"Hp":"鄂E","city":"宜昌","province":"湖北","Pcode":"HB","AreaCode":"420500"},{"Hp":"鄂F","city":"襄阳","province":"湖北","Pcode":"HB","AreaCode":"420600"},{"Hp":"鄂G","city":"鄂州","province":"湖北","Pcode":"HB","AreaCode":"420700"},{"Hp":"鄂H","city":"荆门 ","province":"湖北","Pcode":"HB","AreaCode":"420800"},{"Hp":"鄂J","city":"黄冈","province":"湖北","Pcode":"HB","AreaCode":"421100"},{"Hp":"鄂K","city":"孝感","province":"湖北","Pcode":"HB","AreaCode":"420900"},{"Hp":"鄂L","city":"咸宁","province":"湖北","Pcode":"HB","AreaCode":"421200"},{"Hp":"鄂M","city":"仙桃","province":"湖北","Pcode":"HB","AreaCode":"429004"},{"Hp":"鄂N","city":"潜江","province":"湖北","Pcode":"HB","AreaCode":"429005"},{"Hp":"鄂P","city":"神农架林区","province":"湖北","Pcode":"HB","AreaCode":"429021"},{"Hp":"鄂Q","city":"恩施土家族苗族自治州","province":"湖北","Pcode":"HB","AreaCode":"422800"},{"Hp":"鄂R","city":"天门","province":"湖北","Pcode":"HB","AreaCode":"429006"},{"Hp":"鄂S","city":"随州","province":"湖北","Pcode":"HB","AreaCode":"421300"},{"Hp":"晋A","city":"太原","province":"山西","Pcode":"SX","AreaCode":"140100"},{"Hp":"晋B","city":"大同","province":"山西","Pcode":"SX","AreaCode":"230606"},{"Hp":"晋C","city":"阳泉","province":"山西","Pcode":"SX","AreaCode":"140300"},{"Hp":"晋D","city":"长治","province":"山西","Pcode":"SX","AreaCode":"140421"},{"Hp":"晋E","city":"晋城","province":"山西","Pcode":"SX","AreaCode":"140500"},{"Hp":"晋F","city":"朔州","province":"山西","Pcode":"SX","AreaCode":"140600"},{"Hp":"晋H","city":"忻州","province":"山西","Pcode":"SX","AreaCode":"140900"},{"Hp":"晋J","city":"吕梁","province":"山西","Pcode":"SX","AreaCode":"141100 "},{"Hp":"晋K","city":"晋中","province":"山西","Pcode":"SX","AreaCode":"140700"},{"Hp":"晋L","city":"临汾","province":"山西","Pcode":"SX","AreaCode":"141000"},{"Hp":"晋M","city":"运城","province":"山西","Pcode":"SX","AreaCode":"140800"},{"Hp":"吉A","city":"长春","province":"吉林","Pcode":"JL","AreaCode":"220100"},{"Hp":"吉B","city":"吉林","province":"吉林","Pcode":"JL","AreaCode":"220200"},{"Hp":"吉C","city":"四平","province":"吉林","Pcode":"JL","AreaCode":"220300"},{"Hp":"吉D","city":"辽源","province":"吉林","Pcode":"JL","AreaCode":"220400"},{"Hp":"吉E","city":"通化","province":"吉林","Pcode":"JL","AreaCode":"220521"},{"Hp":"吉F","city":"白山","province":"吉林","Pcode":"JL","AreaCode":"220600"},{"Hp":"吉G","city":"白城","province":"吉林","Pcode":"JL","AreaCode":"220800"},{"Hp":"吉H","city":"延边朝鲜族自治州","province":"吉林","Pcode":"JL","AreaCode":"222400"},{"Hp":"吉J","city":"松原","province":"吉林","Pcode":"JL","AreaCode":"220700"},{"Hp":"吉K","city":"长白山","province":"吉林","Pcode":"JL","AreaCode":null},{"Hp":"粤A","city":"广州","province":"广东","Pcode":"GD","AreaCode":"440100"},{"Hp":"粤B","city":"深圳","province":"广东","Pcode":"GD","AreaCode":"440300"},{"Hp":"粤C","city":"珠海","province":"广东","Pcode":"GD","AreaCode":"440400"},{"Hp":"粤D","city":"汕头","province":"广东","Pcode":"GD","AreaCode":"440500"},{"Hp":"粤E","city":"佛山","province":"广东","Pcode":"GD","AreaCode":"440600"},{"Hp":"粤F","city":"韶关","province":"广东","Pcode":"GD","AreaCode":"440200"},{"Hp":"粤G","city":"湛江","province":"广东","Pcode":"GD","AreaCode":"440800"},{"Hp":"粤H","city":"肇庆","province":"广东","Pcode":"GD","AreaCode":"441200"},{"Hp":"粤J","city":"江门","province":"广东","Pcode":"GD","AreaCode":"440700"},{"Hp":"粤K","city":"茂名","province":"广东","Pcode":"GD","AreaCode":"440900"},{"Hp":"粤L","city":"惠州","province":"广东","Pcode":"GD","AreaCode":"441300"},{"Hp":"粤M","city":"梅州","province":"广东","Pcode":"GD","AreaCode":"441400"},{"Hp":"粤N","city":"汕尾","province":"广东","Pcode":"GD","AreaCode":"441500"},{"Hp":"粤P","city":"河源","province":"广东","Pcode":"GD","AreaCode":"441600"},{"Hp":"粤Q","city":"阳江","province":"广东","Pcode":"GD","AreaCode":"441700"},{"Hp":"粤R","city":"清远","province":"广东","Pcode":"GD","AreaCode":"441800"},{"Hp":"粤S","city":"东莞","province":"广东","Pcode":"GD","AreaCode":"441900"},{"Hp":"粤T","city":"中山","province":"广东","Pcode":"GD","AreaCode":"442000"},{"Hp":"粤U","city":"潮州","province":"广东","Pcode":"GD","AreaCode":"445100"},{"Hp":"粤V","city":"揭阳","province":"广东","Pcode":"GD","AreaCode":"445200"},{"Hp":"粤W","city":"云浮","province":"广东","Pcode":"GD","AreaCode":"445300"},{"Hp":"粤X","city":"顺德区","province":"广东","Pcode":"GD","AreaCode":"440606"},{"Hp":"粤Y","city":"南海区","province":"广东","Pcode":"GD","AreaCode":"440605"},{"Hp":"粤Z","city":"港澳进入内地车辆","province":"广东","Pcode":"GD","AreaCode":null},{"Hp":"宁A","city":"银川","province":"宁夏","Pcode":"NX","AreaCode":"640100"},{"Hp":"宁B","city":"石嘴山","province":"宁夏","Pcode":"NX","AreaCode":"640200"},{"Hp":"宁C","city":"银南","province":"宁夏","Pcode":"NX","AreaCode":null},{"Hp":"宁D","city":"固原","province":"宁夏","Pcode":"NX","AreaCode":"640400"},{"Hp":"宁E","city":"中卫","province":"宁夏","Pcode":"NX","AreaCode":"640500"},{"Hp":"京A","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京B","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京C","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京D","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京E","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京F","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京G","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京H","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京J","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京K","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京L","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京M","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"京Y","city":"北京","province":"北京","Pcode":"BJ","AreaCode":"110000"},{"Hp":"豫A","city":"郑州","province":"河南","Pcode":"HN","AreaCode":"410100"},{"Hp":"豫B","city":"开封","province":"河南","Pcode":"HN","AreaCode":"410200"},{"Hp":"豫C","city":"洛阳","province":"河南","Pcode":"HN","AreaCode":"410300"},{"Hp":"豫D","city":"平顶山","province":"河南","Pcode":"HN","AreaCode":"410400"},{"Hp":"豫E","city":"安阳","province":"河南","Pcode":"HN","AreaCode":"410522"},{"Hp":"豫F","city":"鹤壁","province":"河南","Pcode":"HN","AreaCode":"410600"},{"Hp":"豫G","city":"新乡","province":"河南","Pcode":"HN","AreaCode":"410721"},{"Hp":"豫H","city":"焦作","province":"河南","Pcode":"HN","AreaCode":"410800"},{"Hp":"豫J","city":"濮阳","province":"河南","Pcode":"HN","AreaCode":"410928"},{"Hp":"豫K","city":"许昌","province":"河南","Pcode":"HN","AreaCode":"411023"},{"Hp":"豫L","city":"漯河","province":"河南","Pcode":"HN","AreaCode":"411100"},{"Hp":"豫M","city":"三门峡","province":"河南","Pcode":"HN","AreaCode":"411200"},{"Hp":"豫N","city":"商丘","province":"河南","Pcode":"HN","AreaCode":"411400"},{"Hp":"豫P","city":"周口","province":"河南","Pcode":"HN","AreaCode":"411600"},{"Hp":"豫Q","city":"驻马店","province":"河南","Pcode":"HN","AreaCode":"411700"},{"Hp":"豫R","city":"南阳","province":"河南","Pcode":"HN","AreaCode":"411300"},{"Hp":"豫S","city":"信阳","province":"河南","Pcode":"HN","AreaCode":"411500"},{"Hp":"豫U","city":"济源","province":"河南","Pcode":"HN","AreaCode":"419001"},{"Hp":"黑A","city":"哈尔滨","province":"黑龙江","Pcode":"HLJ","AreaCode":"230100"},{"Hp":"黑B","city":"齐齐哈尔","province":"黑龙江","Pcode":"HLJ","AreaCode":"230200"},{"Hp":"黑C","city":"牡丹江","province":"黑龙江","Pcode":"HLJ","AreaCode":"231000"},{"Hp":"黑D","city":"佳木斯","province":"黑龙江","Pcode":"HLJ","AreaCode":"230800"},{"Hp":"黑E","city":"大庆","province":"黑龙江","Pcode":"HLJ","AreaCode":"230600"},{"Hp":"黑F","city":"伊春","province":"黑龙江","Pcode":"HLJ","AreaCode":"230702"},{"Hp":"黑G","city":"鸡西","province":"黑龙江","Pcode":"HLJ","AreaCode":"230300"},{"Hp":"黑H","city":"鹤岗","province":"黑龙江","Pcode":"HLJ","AreaCode":"230400"},{"Hp":"黑J","city":"双鸭山","province":"黑龙江","Pcode":"HLJ","AreaCode":"230500"},{"Hp":"黑K","city":"七台河","province":"黑龙江","Pcode":"HLJ","AreaCode":"230900"},{"Hp":"黑L","city":"松花江地区","province":"黑龙江","Pcode":"HLJ","AreaCode":null},{"Hp":"黑M","city":"绥化","province":"黑龙江","Pcode":"HLJ","AreaCode":"231200"},{"Hp":"黑N","city":"黑河","province":"黑龙江","Pcode":"HLJ","AreaCode":"231100"},{"Hp":"黑P","city":"大兴安岭地区","province":"黑龙江","Pcode":"HLJ","AreaCode":"232700"},{"Hp":"黑R","city":"农垦系统","province":"黑龙江","Pcode":"HLJ","AreaCode":null},{"Hp":"鲁A ","city":"济南","province":"山东","Pcode":"SD","AreaCode":"370100"},{"Hp":"鲁B","city":"青岛","province":"山东","Pcode":"SD","AreaCode":"370200"},{"Hp":"鲁C","city":"淄博","province":"山东","Pcode":"SD","AreaCode":"370300"},{"Hp":"鲁D","city":"枣庄","province":"山东","Pcode":"SD","AreaCode":"370400"},{"Hp":"鲁E","city":"东营","province":"山东","Pcode":"SD","AreaCode":"370502"},{"Hp":"鲁F","city":"烟台","province":"山东","Pcode":"SD","AreaCode":"370600"},{"Hp":"鲁G","city":"潍坊","province":"山东","Pcode":"SD","AreaCode":"370700"},{"Hp":"鲁H","city":"济宁","province":"山东","Pcode":"SD","AreaCode":"370800"},{"Hp":"鲁J","city":"泰安","province":"山东","Pcode":"SD","AreaCode":"370900"},{"Hp":"鲁K","city":"威海","province":"山东","Pcode":"SD","AreaCode":"371000"},{"Hp":"鲁L","city":"日照","province":"山东","Pcode":"SD","AreaCode":"371100"},{"Hp":"鲁M","city":"滨州","province":"山东","Pcode":"SD","AreaCode":"371600"},{"Hp":"鲁N","city":"德州","province":"山东","Pcode":"SD","AreaCode":"371400"},{"Hp":"鲁P","city":"聊城","province":"山东","Pcode":"SD","AreaCode":"371500"},{"Hp":"鲁Q","city":"临沂","province":"山东","Pcode":"SD","AreaCode":"371300"},{"Hp":"鲁R","city":"菏泽","province":"山东","Pcode":"SD","AreaCode":"371700"},{"Hp":"鲁S","city":"莱芜","province":"山东","Pcode":"SD","AreaCode":"371200"},{"Hp":"鲁U","city":"青岛","province":"山东","Pcode":"SD","AreaCode":"370200"},{"Hp":"鲁V","city":"潍坊","province":"山东","Pcode":"SD","AreaCode":"370700"},{"Hp":"鲁Y","city":"烟台","province":"山东","Pcode":"SD","AreaCode":"370600"},{"Hp":"浙A","city":"杭州","province":"浙江","Pcode":"ZJ","AreaCode":"330100"},{"Hp":"浙B","city":"宁波","province":"浙江","Pcode":"ZJ","AreaCode":"330200"},{"Hp":"浙C","city":"温州","province":"浙江","Pcode":"ZJ","AreaCode":"330300"},{"Hp":"浙D","city":"绍兴","province":"浙江","Pcode":"ZJ","AreaCode":"330600"},{"Hp":"浙E","city":"湖州","province":"浙江","Pcode":"ZJ","AreaCode":"330500"},{"Hp":"浙F","city":"嘉兴","province":"浙江","Pcode":"ZJ","AreaCode":"330400"},{"Hp":"浙G","city":"金华","province":"浙江","Pcode":"ZJ","AreaCode":"330700"},{"Hp":"浙H","city":"衢州","province":"浙江","Pcode":"ZJ","AreaCode":"330800"},{"Hp":"浙J","city":"台州","province":"浙江","Pcode":"ZJ","AreaCode":"331000"},{"Hp":"浙K","city":"丽水","province":"浙江","Pcode":"ZJ","AreaCode":"331100"},{"Hp":"浙L","city":"舟山","province":"浙江","Pcode":"ZJ","AreaCode":"330900"},{"Hp":"桂A","city":"南宁","province":"广西","Pcode":"GX","AreaCode":"450100"},{"Hp":"桂B","city":"柳州","province":"广西","Pcode":"GX","AreaCode":"450200"},{"Hp":"桂C","city":"桂林","province":"广西","Pcode":"GX","AreaCode":"450300"},{"Hp":"桂D","city":"梧州","province":"广西","Pcode":"GX","AreaCode":"450400"},{"Hp":"桂E","city":"北海","province":"广西","Pcode":"GX","AreaCode":"450500"},{"Hp":"桂F","city":"崇左","province":"广西","Pcode":"GX","AreaCode":"451400"},{"Hp":"桂G","city":"来宾","province":"广西","Pcode":"GX","AreaCode":"451300"},{"Hp":"桂H","city":"桂林地区","province":"广西","Pcode":"GX","AreaCode":null},{"Hp":"桂J","city":"贺州","province":"广西","Pcode":"GX","AreaCode":"451100"},{"Hp":"桂K","city":"玉林","province":"广西","Pcode":"GX","AreaCode":"450900"},{"Hp":"桂L","city":"百色","province":"广西","Pcode":"GX","AreaCode":"451000"},{"Hp":"桂M","city":"河池","province":"广西","Pcode":"GX","AreaCode":"451200"},{"Hp":"桂N","city":"钦州","province":"广西","Pcode":"GX","AreaCode":"450700"},{"Hp":"桂P","city":"防城港","province":"广西","Pcode":"GX","AreaCode":"450600"},{"Hp":"桂R","city":"贵港","province":"广西","Pcode":"GX","AreaCode":"450800"},{"Hp":"蒙A","city":"呼和浩特","province":"内蒙古","Pcode":"NMG","AreaCode":"150100"},{"Hp":"蒙B","city":"包头","province":"内蒙古","Pcode":"NMG","AreaCode":"150200"},{"Hp":"蒙C","city":"乌海","province":"内蒙古","Pcode":"NMG","AreaCode":"150300"},{"Hp":"蒙D","city":"赤峰","province":"内蒙古","Pcode":"NMG","AreaCode":"150400"},{"Hp":"蒙E","city":"呼伦贝尔 ","province":"内蒙古","Pcode":"NMG","AreaCode":"150700"},{"Hp":"蒙F","city":"兴安盟","province":"内蒙古","Pcode":"NMG","AreaCode":"152200"},{"Hp":"蒙G","city":"通辽","province":"内蒙古","Pcode":"NMG","AreaCode":"150500"},{"Hp":"蒙H","city":"锡林郭勒盟","province":"内蒙古","Pcode":"NMG","AreaCode":"152500"},{"Hp":"蒙J","city":"乌兰察布盟","province":"内蒙古","Pcode":"NMG","AreaCode":"150900"},{"Hp":"蒙K","city":"鄂尔多斯 ","province":"内蒙古","Pcode":"NMG","AreaCode":"150600"},{"Hp":"蒙L","city":"巴彦淖尔盟","province":"内蒙古","Pcode":"NMG","AreaCode":"150800"},{"Hp":"蒙M　","city":"　阿拉善盟","province":"内蒙古","Pcode":"NMG","AreaCode":"152900"},{"Hp":"闽A","city":"福州","province":"福建","Pcode":"FJ","AreaCode":"350100"},{"Hp":"闽B","city":"莆田","province":"福建","Pcode":"FJ","AreaCode":"350300"},{"Hp":"闽C","city":"泉州","province":"福建","Pcode":"FJ","AreaCode":"350500"},{"Hp":"闽D","city":"厦门","province":"福建","Pcode":"FJ","AreaCode":"350200"},{"Hp":"闽E","city":"漳州","province":"福建","Pcode":"FJ","AreaCode":"350600"},{"Hp":"闽F","city":"龙岩","province":"福建","Pcode":"FJ","AreaCode":"350800"},{"Hp":"闽G","city":"三明","province":"福建","Pcode":"FJ","AreaCode":"350400"},{"Hp":"闽H","city":"南平","province":"福建","Pcode":"FJ","AreaCode":"350700"},{"Hp":"闽J","city":"宁德","province":"福建","Pcode":"FJ","AreaCode":"350900"},{"Hp":"闽K","city":"直系统","province":"福建","Pcode":"FJ","AreaCode":null},{"Hp":"川A","city":"成都","province":"四川","Pcode":"SC","AreaCode":"510100"},{"Hp":"川B","city":"绵阳","province":"四川","Pcode":"SC","AreaCode":"510700"},{"Hp":"川C","city":"自贡","province":"四川","Pcode":"SC","AreaCode":"510300"},{"Hp":"川D","city":"攀枝花","province":"四川","Pcode":"SC","AreaCode":"510400"},{"Hp":"川E","city":"泸州","province":"四川","Pcode":"SC","AreaCode":"510500"},{"Hp":"川F","city":"德阳","province":"四川","Pcode":"SC","AreaCode":"510600"},{"Hp":"川H","city":"广元","province":"四川","Pcode":"SC","AreaCode":"510800"},{"Hp":"川J","city":"遂宁","province":"四川","Pcode":"SC","AreaCode":"510900"},{"Hp":"川K","city":"内江","province":"四川","Pcode":"SC","AreaCode":"511000"},{"Hp":"川L","city":"乐山","province":"四川","Pcode":"SC","AreaCode":"511100"},{"Hp":"川M","city":"资阳","province":"四川","Pcode":"SC","AreaCode":"512000"},{"Hp":"川Q","city":"宜宾","province":"四川","Pcode":"SC","AreaCode":"511521"},{"Hp":"川R","city":"南充","province":"四川","Pcode":"SC","AreaCode":"511300"},{"Hp":"川S","city":"达州","province":"四川","Pcode":"SC","AreaCode":"511700"},{"Hp":"川T","city":"雅安","province":"四川","Pcode":"SC","AreaCode":"511800"},{"Hp":"川U","city":"阿坝藏族羌族自治州","province":"四川","Pcode":"SC","AreaCode":"513200"},{"Hp":"川V","city":"甘孜藏族自治州","province":"四川","Pcode":"SC","AreaCode":"513300"},{"Hp":"川W","city":"凉山彝族自治州","province":"四川","Pcode":"SC","AreaCode":"513400"},{"Hp":"川X","city":"广安","province":"四川","Pcode":"SC","AreaCode":"511602"},{"Hp":"川Y","city":"巴中","province":"四川","Pcode":"SC","AreaCode":"511900"},{"Hp":"川Z","city":"眉山","province":"四川","Pcode":"SC","AreaCode":"511400"},{"Hp":"渝A","city":"重庆区（江南）","province":"重庆","Pcode":"ZQ","AreaCode":"500100"},{"Hp":"渝B","city":"重庆区（江北）","province":"重庆","Pcode":"ZQ","AreaCode":"500100"},{"Hp":"渝C","city":"永川区","province":"重庆","Pcode":"ZQ","AreaCode":"500118"},{"Hp":"渝F","city":"万州区","province":"重庆","Pcode":"ZQ","AreaCode":"500101"},{"Hp":"渝G","city":"涪陵区","province":"重庆","Pcode":"ZQ","AreaCode":"500102"},{"Hp":"渝H","city":"黔江区","province":"重庆","Pcode":"ZQ","AreaCode":"500114"},{"Hp":"津A","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津B","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津C","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津D","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津E","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津F","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津G","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"津H","city":"天津","province":"天津","Pcode":"TJ","AreaCode":"120000"},{"Hp":"云A","city":"昆明","province":"云南","Pcode":"YN","AreaCode":"530100"},{"Hp":"云A-V","city":"东川","province":"云南","Pcode":"YN","AreaCode":"530113"},{"Hp":"云C","city":"昭通","province":"云南","Pcode":"YN","AreaCode":"530600"},{"Hp":"云D","city":"曲靖","province":"云南","Pcode":"YN","AreaCode":"530300"},{"Hp":"云E","city":"楚雄彝族自治州","province":"云南","Pcode":"YN","AreaCode":"532300"},{"Hp":"云F","city":"玉溪","province":"云南","Pcode":"YN","AreaCode":"530400"},{"Hp":"云G","city":"红河哈尼族彝族自治州","province":"云南","Pcode":"YN","AreaCode":"532500"},{"Hp":"云H","city":"文山壮族苗族自治州","province":"云南","Pcode":"YN","AreaCode":"532600"},{"Hp":"云J","city":"思茅","province":"云南","Pcode":"YN","AreaCode":"530802"},{"Hp":"云K","city":"西双版纳傣族自治州","province":"云南","Pcode":"YN","AreaCode":"532800"},{"Hp":"云L","city":"大理白族自治州","province":"云南","Pcode":"YN","AreaCode":"532900"},{"Hp":"云M","city":"保山","province":"云南","Pcode":"YN","AreaCode":"530500"},{"Hp":"云N","city":"德宏傣族景颇族自治州","province":"云南","Pcode":"YN","AreaCode":"533100"},{"Hp":"云P","city":"丽江","province":"云南","Pcode":"YN","AreaCode":"530700"},{"Hp":"云Q","city":"怒江傈僳族自治州","province":"云南","Pcode":"YN","AreaCode":"533300"},{"Hp":"云R","city":"迪庆藏族自治州","province":"云南","Pcode":"YN","AreaCode":"533400"},{"Hp":"云S","city":"临沧地区","province":"云南","Pcode":"YN","AreaCode":"530900"},{"Hp":"湘A ","city":"长沙","province":"湖南","Pcode":"HN","AreaCode":"430121"},{"Hp":"湘B","city":"株洲","province":"湖南","Pcode":"HN","AreaCode":"430221"},{"Hp":"湘C","city":"湘潭","province":"湖南","Pcode":"HN","AreaCode":"430321"},{"Hp":"湘D","city":"衡阳","province":"湖南","Pcode":"HN","AreaCode":"430421"},{"Hp":"湘E","city":"邵阳","province":"湖南","Pcode":"HN","AreaCode":"430523"},{"Hp":"湘F","city":"岳阳","province":"湖南","Pcode":"HN","AreaCode":"430621"},{"Hp":"湘G","city":"张家界","province":"湖南","Pcode":"HN","AreaCode":"430800"},{"Hp":"湘H","city":"益阳","province":"湖南","Pcode":"HN","AreaCode":"430900"},{"Hp":"湘J","city":"常德","province":"湖南","Pcode":"HN","AreaCode":"430700"},{"Hp":"湘K","city":"娄底","province":"湖南","Pcode":"HN","AreaCode":"431300"},{"Hp":"湘L","city":"郴州","province":"湖南","Pcode":"HN","AreaCode":"431000"},{"Hp":"湘M","city":"永州","province":"湖南","Pcode":"HN","AreaCode":"431100"},{"Hp":"湘N","city":"怀化","province":"湖南","Pcode":"HN","AreaCode":"431200"},{"Hp":"湘U","city":"湘西土家族苗族自治州","province":"湖南","Pcode":"HN","AreaCode":"433100"},{"Hp":"新A","city":"乌鲁木齐","province":"新疆","Pcode":"XJ","AreaCode":"650121"},{"Hp":"新B","city":"昌吉回族自治州","province":"新疆","Pcode":"XJ","AreaCode":"652300"},{"Hp":"新C","city":"石河子","province":"新疆","Pcode":"XJ","AreaCode":"659001"},{"Hp":"新D","city":"奎屯","province":"新疆","Pcode":"XJ","AreaCode":"654003"},{"Hp":"新E","city":"博尔塔拉蒙古自治州","province":"新疆","Pcode":"XJ","AreaCode":"652700"},{"Hp":"新F","city":"伊犁哈萨克自治州直辖县","province":"新疆","Pcode":"XJ","AreaCode":"654000"},{"Hp":"新G","city":"塔城","province":"新疆","Pcode":"XJ","AreaCode":"654201"},{"Hp":"新H","city":"阿勒泰","province":"新疆","Pcode":"XJ","AreaCode":"654301"},{"Hp":"新J","city":"克拉玛依","province":"新疆","Pcode":"XJ","AreaCode":"650203"},{"Hp":"新K","city":"吐鲁番","province":"新疆","Pcode":"XJ","AreaCode":"650400"},{"Hp":"新L","city":"哈密","province":"新疆","Pcode":"XJ","AreaCode":"650500"},{"Hp":"新M","city":"巴音郭愣蒙古自治州","province":"新疆","Pcode":"XJ","AreaCode":"652800"},{"Hp":"新N","city":"阿克苏","province":"新疆","Pcode":"XJ","AreaCode":"652901"},{"Hp":"新P","city":"克孜勒苏柯尔克孜自治州","province":"新疆","Pcode":"XJ","AreaCode":"653000"},{"Hp":"新Q","city":"喀什","province":"新疆","Pcode":"XJ","AreaCode":"653101"},{"Hp":"新R","city":"和田","province":"新疆","Pcode":"XJ","AreaCode":"653221"},{"Hp":"赣A","city":"南昌","province":"江西","Pcode":"JX","AreaCode":"360121"},{"Hp":"赣B","city":"赣州","province":"江西","Pcode":"JX","AreaCode":"360700"},{"Hp":"赣C","city":"宜春","province":"江西","Pcode":"JX","AreaCode":"360900"},{"Hp":"赣D","city":"吉安","province":"江西","Pcode":"JX","AreaCode":"360821"},{"Hp":"赣E","city":"上饶","province":"江西","Pcode":"JX","AreaCode":"361121"},{"Hp":"赣F","city":"抚州","province":"江西","Pcode":"JX","AreaCode":"361000"},{"Hp":"赣G","city":"九江","province":"江西","Pcode":"JX","AreaCode":"360421"},{"Hp":"赣H","city":"景德镇","province":"江西","Pcode":"JX","AreaCode":"360200"},{"Hp":"赣J","city":"萍乡","province":"江西","Pcode":"JX","AreaCode":"360300"},{"Hp":"赣K","city":"新余","province":"江西","Pcode":"JX","AreaCode":"360500"},{"Hp":"赣L","city":"鹰潭","province":"江西","Pcode":"JX","AreaCode":"360600"},{"Hp":"赣M","city":"南昌,直系统","province":"江西","Pcode":"JX","AreaCode":null},{"Hp":"甘A","city":"兰州","province":"甘肃","Pcode":"GS","AreaCode":"620100"},{"Hp":"甘B","city":"嘉峪关","province":"甘肃","Pcode":"GS","AreaCode":"620200"},{"Hp":"甘C","city":"金昌","province":"甘肃","Pcode":"GS","AreaCode":"620300"},{"Hp":"甘D","city":"白银","province":"甘肃","Pcode":"GS","AreaCode":"620402"},{"Hp":"甘E","city":"天水","province":"甘肃","Pcode":"GS","AreaCode":"620500"},{"Hp":"甘F","city":"酒泉","province":"甘肃","Pcode":"GS","AreaCode":"620900"},{"Hp":"甘G","city":"张掖","province":"甘肃","Pcode":"GS","AreaCode":"620700"},{"Hp":"甘H","city":"武威","province":"甘肃","Pcode":"GS","AreaCode":"620600"},{"Hp":"甘J","city":"定西","province":"甘肃","Pcode":"GS","AreaCode":"621100"},{"Hp":"甘K","city":"陇南","province":"甘肃","Pcode":"GS","AreaCode":"621200"},{"Hp":"甘L","city":"平凉","province":"甘肃","Pcode":"GS","AreaCode":"620800"},{"Hp":"甘M","city":"庆阳","province":"甘肃","Pcode":"GS","AreaCode":"621000"},{"Hp":"甘N","city":"临夏回族自治州","province":"甘肃","Pcode":"GS","AreaCode":"622900"},{"Hp":"甘P","city":"甘南藏族自治州","province":"甘肃","Pcode":"GS","AreaCode":"623000"},{"Hp":"陕A","city":"西安","province":"陕西","Pcode":"SX","AreaCode":"610100"},{"Hp":"陕B","city":"铜川","province":"陕西","Pcode":"SX","AreaCode":"610200"},{"Hp":"陕C","city":"宝鸡","province":"陕西","Pcode":"SX","AreaCode":"610300"},{"Hp":"陕D","city":"咸阳","province":"陕西","Pcode":"SX","AreaCode":"610400"},{"Hp":"陕E","city":"渭南","province":"陕西","Pcode":"SX","AreaCode":"610500"},{"Hp":"陕F","city":"汉中","province":"陕西","Pcode":"SX","AreaCode":"610700"},{"Hp":"陕G","city":"安康","province":"陕西","Pcode":"SX","AreaCode":"610900"},{"Hp":"陕H","city":"商洛","province":"陕西","Pcode":"SX","AreaCode":"611000"},{"Hp":"陕J","city":"延安","province":"陕西","Pcode":"SX","AreaCode":"610600"},{"Hp":"陕K","city":"榆林","province":"陕西","Pcode":"SX","AreaCode":"610800"},{"Hp":"陕V","city":"杨凌高新农业示范区","province":"陕西","Pcode":"SX","AreaCode":"610403"},{"Hp":"贵A","city":"贵阳","province":"贵州","Pcode":"GZ","AreaCode":"520100"},{"Hp":"贵B","city":"六盘水","province":"贵州","Pcode":"GZ","AreaCode":"520200"},{"Hp":"贵C","city":"遵义","province":"贵州","Pcode":"GZ","AreaCode":"520300"},{"Hp":"贵D","city":"铜仁","province":"贵州","Pcode":"GZ","AreaCode":"520600"},{"Hp":"贵E","city":"黔西南布依族苗族自治州","province":"贵州","Pcode":"GZ","AreaCode":"522300"},{"Hp":"贵F","city":"毕节","province":"贵州","Pcode":"GZ","AreaCode":"520500"},{"Hp":"贵G","city":"安顺","province":"贵州","Pcode":"GZ","AreaCode":"520400"},{"Hp":"贵H","city":"黔东南苗族侗族自治州","province":"贵州","Pcode":"GZ","AreaCode":"522600"},{"Hp":"贵J","city":"黔南布依族苗族自治州","province":"贵州","Pcode":"GZ","AreaCode":"522700"},{"Hp":"青A","city":"西宁","province":"青海","Pcode":"QH","AreaCode":"630100"},{"Hp":"青B","city":"海东","province":"青海","Pcode":"QH","AreaCode":"630200"},{"Hp":"青C","city":"海北藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632200"},{"Hp":"青D","city":"黄南藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632300"},{"Hp":"青E","city":"藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632800"},{"Hp":"青F","city":"果洛藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632600"},{"Hp":"青G","city":"玉树藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632700"},{"Hp":"青H","city":"海西蒙古族藏族自治州","province":"青海","Pcode":"QH","AreaCode":"632800"},{"Hp":"藏A","city":"拉萨","province":"西藏","Pcode":"XC","AreaCode":"540100"},{"Hp":"藏B","city":"昌都地区","province":"西藏","Pcode":"XC","AreaCode":"540300"},{"Hp":"藏C","city":"山南地区","province":"西藏","Pcode":"XC","AreaCode":"542200"},{"Hp":"藏D","city":"日喀则地区","province":"西藏","Pcode":"XC","AreaCode":"540200"},{"Hp":"藏E","city":"那曲地区","province":"西藏","Pcode":"XC","AreaCode":"542400"},{"Hp":"藏F","city":"阿里地区","province":"西藏","Pcode":"XC","AreaCode":"542500"},{"Hp":"藏G","city":"林芝地区","province":"西藏","Pcode":"XC","AreaCode":"540400"},{"Hp":"藏H","city":"天全县车辆管理所","province":"西藏","Pcode":"XC","AreaCode":null},{"Hp":"藏J","city":"格尔木车辆管理所","province":"西藏","Pcode":"XC","AreaCode":null},{"Hp":"琼A","city":"海口","province":"海南","Pcode":"HN","AreaCode":"460100"},{"Hp":"琼B","city":"三亚","province":"海南","Pcode":"HN","AreaCode":"460200"},{"Hp":"琼C","city":"琼海","province":"海南","Pcode":"HN","AreaCode":"469002"},{"Hp":"琼D","city":"五指山","province":"海南","Pcode":"HN","AreaCode":"469001"},{"Hp":"琼E","city":"洋浦开发区","province":"海南","Pcode":"HN","AreaCode":""},{"Hp":"沪A","city":"上海","province":"上海","Pcode":"SH","AreaCode":"310000"},{"Hp":"沪B","city":"上海","province":"上海","Pcode":"SH","AreaCode":"310000"},{"Hp":"沪C","city":"上海","province":"上海","Pcode":"SH","AreaCode":"310000"},{"Hp":"沪D","city":"上海","province":"上海","Pcode":"SH","AreaCode":"310000"},{"Hp":"沪R","city":"崇明","province":"上海","Pcode":"SH","AreaCode":"310151"}]

这是在网上找到的json，基本能够满足我的需求了。我们就是需要将这个json添加到数据库中。

创建数据库的表tbl_province_car
我这边有用的是postgresql，mysql可以适当调整sql

CREATE TABLE "public"."tbl_province_car" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "hp" varchar(32) COLLATE "pg_catalog"."default",
  "city" varchar(32) COLLATE "pg_catalog"."default",
  "province" varchar(32) COLLATE "pg_catalog"."default",
  "p_code" varchar(32) COLLATE "pg_catalog"."default",
  "area_code" varchar(32) COLLATE "pg_catalog"."default",
  CONSTRAINT "tbl_province_car_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "public"."tbl_province_car" 
  OWNER TO "postgres";

COMMENT ON COLUMN "public"."tbl_province_car"."hp" IS '车牌前两位';

COMMENT ON COLUMN "public"."tbl_province_car"."city" IS '城市';

COMMENT ON COLUMN "public"."tbl_province_car"."province" IS '省份';

COMMENT ON COLUMN "public"."tbl_province_car"."p_code" IS '首字母简写';

COMMENT ON COLUMN "public"."tbl_province_car"."area_code" IS '地区编码';

创建实体类TblProvinceCar(mybatis生成)

public class TblProvinceCar {
    
    private String id;

    
    private String hp;

    
    private String city;

    
    private String province;

   
    private String pCode;

    
    private String areaCode;

    
    public String getId() {
        return id;
    }

   
    public void setId(String id) {
        this.id = id == null ? null : id.trim();
    }

    
    public String getHp() {
        return hp;
    }

    
    public void setHp(String hp) {
        this.hp = hp == null ? null : hp.trim();
    }

    
    public String getCity() {
        return city;
    }

   
    public void setCity(String city) {
        this.city = city == null ? null : city.trim();
    }

    
    public String getProvince() {
        return province;
    }

    
    public void setProvince(String province) {
        this.province = province == null ? null : province.trim();
    }

    
    public String getpCode() {
        return pCode;
    }

    
    public void setpCode(String pCode) {
        this.pCode = pCode == null ? null : pCode.trim();
    }

    
    public String getAreaCode() {
        return areaCode;
    }

    
    public void setAreaCode(String areaCode) {
        this.areaCode = areaCode == null ? null : areaCode.trim();
    }
}

通过java插入到数据库中

@Autowired
private TblProvinceCarMapper tblProvinceCarMapper;

@Test
public void insert(){
  String json = "上面的json";
  List<TblProvinceCar> tblProvinceCars = JSONArray.parseArray(json, TblProvinceCar.class);
        for (TblProvinceCar tblProvinceCar : tblProvinceCars) {
            tblProvinceCar.setId(UUID.randomUUID());
            tblProvinceCarMapper.insert(tblProvinceCar);
        }
}