爬虫行政区号并获取电话区号和邮编
1、mysql建表语句
CREATE TABLE `his_sys_plat_region` (
`Id` bigint(20) NOT NULL AUTO_INCREMENT,
`RegionId` bigint(20) NOT NULL DEFAULT '0' COMMENT '地区ID',
`ParentRegionId` bigint(20) NOT NULL DEFAULT '0' COMMENT '上级地区ID',
`RegionName` varchar(50) DEFAULT NULL COMMENT '地区名称',
`RegionNameEN` varchar(50) DEFAULT NULL COMMENT '英文地区名称',
`Depth` int(11) NOT NULL DEFAULT '0' COMMENT '地区层级',
`IdPath` varchar(255) DEFAULT NULL COMMENT '地区ID路径',
`NamePath` varchar(255) DEFAULT NULL COMMENT '地区名称路径',
`PostCode` varchar(20) DEFAULT NULL COMMENT '邮政编码',
`TelephoneCode` varchar(20) DEFAULT NULL COMMENT '电话区号',
`OrderNum` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
`Lat` varchar(60) DEFAULT NULL COMMENT '地区中心经度',
`Lng` varchar(60) DEFAULT NULL COMMENT '地区中心纬度',
`Active` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否有效',
`QueryStr` varchar(8000) DEFAULT NULL COMMENT '查询字符串',
`CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`UpdateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`Id`),
KEY `idx_his_sys_plat_region_rid` (`RegionId`),
KEY `idx_his_sys_plat_region_pid` (`ParentRegionId`),
KEY `idx_his_sys_plat_region_idp` (`IdPath`)
) ENGINE=InnoDB AUTO_INCREMENT=3194 DEFAULT CHARSET=utf8mb4;
2、对应的实体类
import java.util.Date;
import java.util.Map;
import yb.common.util.InitListMap;
import yb.core.tablemodel.annotation.Column;
import yb.core.tablemodel.annotation.Table;
import yz.his.model.BaseModel;
@Table(name = "his_sys_plat_region")
public class HisSysPlatRegionModel extends BaseModel {
protected transient Map<String, String> fieldDictTypes = InitListMap.toHashMap(new String[] {
});
@Column(name = "Id", primaryKey = true, insertable = false)
private long Id;
@Column(name = "RegionId")
private long RegionId = 0L;
@Column(name = "ParentRegionId")
private long ParentRegionId = 0L;
@Column(name = "RegionName")
private String RegionName;
@Column(name = "RegionNameEN")
private String RegionNameEN;
@Column(name = "Depth")
private int Depth = 0;
@Column(name = "IdPath")
private String IdPath;
@Column(name = "NamePath")
private String NamePath;
@Column(name = "PostCode")
private String PostCode;
@Column(name = "TelephoneCode")
private String TelephoneCode;
@Column(name = "OrderNum")
private int OrderNum = 0;
@Column(name = "Lat")
private String Lat;
@Column(name = "Lng")
private String Lng;
@Column(name = "Active")
private int Active = 1;
@Column(name = "QueryStr")
private String QueryStr;
@Column(name = "CreateTime", insertable = false, updateable