{"id":55801,"date":"2025-08-14T08:35:05","date_gmt":"2025-08-14T00:35:05","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/55801.html"},"modified":"2025-08-14T08:35:05","modified_gmt":"2025-08-14T00:35:05","slug":"%e5%9f%ba%e4%ba%8e-mybatisplus-%e5%b0%86%e7%99%be%e5%ba%a6%e5%a4%a9%e6%b0%94%e6%95%b0%e6%8d%ae%e5%ad%98%e5%82%a8%e8%87%b3-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e5%ae%9e%e8%b7%b5","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/55801.html","title":{"rendered":"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5"},"content":{"rendered":"

\u76ee\u5f55<\/p>\n

\n

\u524d\u8a00<\/p>\n

\u4e00\u3001PG\u6570\u636e\u5e93\u8bbe\u8ba1\u4e0e\u5b9e\u73b0<\/p>\n

1\u3001PG\u6570\u636e\u5e93\u6a21\u578b\u8bbe\u8ba1<\/p>\n

2\u3001\u5b58\u50a8\u5929\u6c14\u7269\u7406\u8868\u7ed3\u6784<\/p>\n

\u4e8c\u3001MybatisPlus\u4e2d\u5b9e\u4f53\u5b9e\u73b0<\/p>\n

1\u3001MybatisPlus\u5b9e\u4f53\u7c7b\u56fe\u8bbe\u8ba1<\/p>\n

2\u3001MybatisPlus\u4e2d\u76f8\u5173\u7c7b\u5b9e\u73b0<\/p>\n

\u4e09\u3001PostgreSQL\u6301\u4e45\u5316\u5b9e\u73b0<\/p>\n

1\u3001\u5929\u6c14\u6570\u636e\u5165\u5e93\u65f6\u5e8f\u56fe<\/p>\n

2\u3001\u8c03\u7528\u7a0b\u5e8f\u6267\u884c<\/p>\n

3\u3001\u6570\u636e\u5165\u5e93\u7ed3\u679c<\/p>\n

\u56db\u3001\u603b\u7ed3<\/p>\n

\n

\u524d\u8a00<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5728\u5f53\u4eca\u6570\u5b57\u5316\u65f6\u4ee3，\u6570\u636e\u7684\u83b7\u53d6\u3001\u5b58\u50a8\u4e0e\u5206\u6790\u5df2\u6210\u4e3a\u63a8\u52a8\u4f17\u591a\u9886\u57df\u53d1\u5c55\u7684\u91cd\u8981\u9a71\u52a8\u529b\u3002\u5929\u6c14\u6570\u636e\u4f5c\u4e3a\u4e00\u79cd\u6781\u5177\u4ef7\u503c\u7684\u516c\u5171\u8d44\u6e90，\u5e7f\u6cdb\u5e94\u7528\u4e8e\u519c\u4e1a\u3001\u4ea4\u901a\u3001\u65c5\u6e38\u3001\u80fd\u6e90\u7b49\u8bf8\u591a\u884c\u4e1a\u3002\u767e\u5ea6\u5929\u6c14\u4f5c\u4e3a\u56fd\u5185\u77e5\u540d\u7684\u5929\u6c14\u4fe1\u606f\u670d\u52a1\u5e73\u53f0，\u63d0\u4f9b\u4e86\u4e30\u5bcc\u4e14\u5b9e\u65f6\u7684\u5929\u6c14\u6570\u636e，\u82e5\u80fd\u5c06\u5176\u6709\u6548\u5b58\u50a8\u5e76\u52a0\u4ee5\u5229\u7528，\u5c06\u4e3a\u76f8\u5173\u4e1a\u52a1\u51b3\u7b56\u3001\u7814\u7a76\u5206\u6790\u7b49\u63d0\u4f9b\u6709\u529b\u652f\u6301\u3002\u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93，\u8fd9\u4e00\u8fc7\u7a0b\u6d89\u53ca\u6570\u636e\u7684\u83b7\u53d6\u3001\u89e3\u6790\u3001\u8f6c\u6362\u4ee5\u53ca\u6700\u7ec8\u7684\u5b58\u50a8\u7b49\u591a\u4e2a\u73af\u8282\u3002\u901a\u8fc7 MybatisPlus \u6846\u67b6\u6765\u5b9e\u73b0\u8fd9\u4e00\u76ee\u6807，\u4e0d\u4ec5\u53ef\u4ee5\u5145\u5206\u5229\u7528\u5176\u5f3a\u5927\u7684 ORM（\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04）\u80fd\u529b，\u5c06\u5929\u6c14\u6570\u636e\u7684\u5b9e\u4f53\u7c7b\u4e0e\u6570\u636e\u5e93\u8868\u7ed3\u6784\u8fdb\u884c\u9ad8\u6548\u6620\u5c04，\u8fd8\u80fd\u501f\u52a9\u5176\u63d0\u4f9b\u7684\u4fbf\u6377\u64cd\u4f5c\u63a5\u53e3，\u8f7b\u677e\u5b8c\u6210\u6570\u636e\u7684\u589e\u5220\u6539\u67e5\u7b49\u64cd\u4f5c\u3002\u6b64\u5916，MybatisPlus \u7684\u5206\u9875\u63d2\u4ef6\u3001\u7f13\u5b58\u673a\u5236\u7b49\u7279\u6027，\u4e5f\u80fd\u591f\u5728\u5904\u7406\u5927\u91cf\u5929\u6c14\u6570\u636e\u65f6，\u6709\u6548\u63d0\u5347\u7cfb\u7edf\u7684\u6027\u80fd\u548c\u54cd\u5e94\u901f\u5ea6，\u786e\u4fdd\u6570\u636e\u5b58\u50a8\u8fc7\u7a0b\u7684\u9ad8\u6548\u4e0e\u7a33\u5b9a\u3002<\/p>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u8fd9\u4e00\u5b9e\u8df5\u8fc7\u7a0b\u4e0d\u4ec5\u6d89\u53ca\u5230\u6280\u672f\u5c42\u9762\u7684\u591a\u79cd\u77e5\u8bc6\u878d\u5408，\u5982\u7f51\u7edc\u7f16\u7a0b\u3001JSON \u6570\u636e\u5904\u7406\u3001\u6570\u636e\u5e93\u64cd\u4f5c\u4ee5\u53ca\u6846\u67b6\u5e94\u7528\u7b49，\u8fd8\u9762\u4e34\u7740\u8bf8\u5982\u6570\u636e\u51c6\u786e\u6027\u3001\u5b58\u50a8\u6548\u7387\u3001\u7cfb\u7edf\u7a33\u5b9a\u6027\u7b49\u8bf8\u591a\u6311\u6218\u3002\u901a\u8fc7\u5bf9\u6574\u4e2a\u6d41\u7a0b\u7684\u6df1\u5165\u7814\u7a76\u548c\u5b9e\u8df5\u63a2\u7d22，\u6211\u4eec\u5e0c\u671b\u80fd\u591f\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e00\u5957\u5b8c\u6574\u3001\u9ad8\u6548\u4e14\u53ef\u9760\u7684\u89e3\u51b3\u65b9\u6848，\u52a9\u529b\u5927\u5bb6\u66f4\u597d\u5730\u5229\u7528\u767e\u5ea6\u5929\u6c14\u6570\u636e，\u6316\u6398\u5176\u6f5c\u5728\u4ef7\u503c，\u540c\u65f6\u4e5f\u4e3a\u7c7b\u4f3c\u7684\u6570\u636e\u5b58\u50a8\u9879\u76ee\u63d0\u4f9b\u6709\u76ca\u7684\u53c2\u8003\u548c\u501f\u9274\u3002\u529b\u6c42\u4ee5\u6e05\u6670\u3001\u6613\u61c2\u7684\u65b9\u5f0f，\u5e26\u9886\u8bfb\u8005\u9010\u6b65\u6df1\u5165\u8fd9\u4e00\u5b9e\u8df5\u8fc7\u7a0b，\u5171\u540c\u63a2\u7d22\u6570\u636e\u5b58\u50a8\u4e0e\u5e94\u7528\u7684\u65e0\u9650\u53ef\u80fd\u3002\u672c\u6587\u91cd\u70b9\u5728\u4e8e\u8be6\u7ec6\u5f97\u4ecb\u7ecd\u5728MybatisPlus\u6846\u67b6\u4e2d\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d，\u9996\u5148\u4ecb\u7ecd\u5177\u4f53\u7684PG\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0，\u7136\u540e\u8be6\u7ec6\u4ecb\u7ecdMybatisPlus\u7684\u5b9e\u4f53\u8bbe\u8ba1，\u6700\u540e\u4ee5\u6e90\u4ee3\u7801\u7684\u5f62\u5f0f\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u8fdb\u884c\u6301\u4e45\u5316，\u671f\u5f85\u4e3a\u5927\u5bb6\u63d0\u4f9b\u4e00\u79cd\u826f\u597d\u7684\u89e3\u51b3\u65b9\u6848\u548c\u53c2\u8003\u3002<\/p>\n

\u4e00\u3001PG\u6570\u636e\u5e93\u8bbe\u8ba1\u4e0e\u5b9e\u73b0<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PostgreSQL \u4f5c\u4e3a\u4e00\u79cd\u529f\u80fd\u5f3a\u5927\u7684\u5f00\u6e90\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf，\u4ee5\u5176\u51fa\u8272\u7684\u6027\u80fd\u3001\u9ad8\u5ea6\u7684\u53ef\u6269\u5c55\u6027\u4ee5\u53ca\u5bf9\u590d\u6742\u6570\u636e\u7c7b\u578b\u7684\u826f\u597d\u652f\u6301，\u53d7\u5230\u8d8a\u6765\u8d8a\u591a\u5f00\u53d1\u8005\u7684\u9752\u7750\u3002\u5b83\u80fd\u591f\u9ad8\u6548\u5730\u5b58\u50a8\u548c\u7ba1\u7406\u5927\u89c4\u6a21\u6570\u636e，\u4e3a\u6570\u636e\u7684\u67e5\u8be2\u3001\u5206\u6790\u4e0e\u6316\u6398\u63d0\u4f9b\u4e86\u575a\u5b9e\u57fa\u7840\u3002\u672c\u8282\u9996\u5148\u5c06\u4ee5\u5b58\u50a8\u767e\u5ea6\u5929\u6c14\u6570\u636e\u4e3a\u80cc\u666f，\u4ecb\u7ecd\u5982\u4f55\u8fdb\u884c\u6570\u636e\u5e93\u7684\u7269\u7406\u8868\u8bbe\u8ba1，\u4e3a\u4e86\u65b9\u4fbf\u5927\u5bb6\u5b66\u4e60，\u8fd9\u91cc\u53ef\u4ee5\u5206\u4eab\u76f8\u5173\u7684\u5efa\u8868\u8bed\u53e5\u3002<\/p>\n

1\u3001PG\u6570\u636e\u5e93\u6a21\u578b\u8bbe\u8ba1<\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5728\u524d\u4e00\u7bc7\u7684\u5185\u5bb9\u4e2d，\u6211\u4eec\u8be6\u7ec6\u7684\u4ecb\u7ecd\u4e86\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u7684\u8fd4\u56de\u6570\u636e\u8f6c\u6362\u4e3aJavaBean，GSON \u6846\u67b6\u4e0b\u767e\u5ea6\u5929\u6c14 JSON \u6570\u636e\u8f6c JavaBean \u7684\u5b9e\u6218\u653b\u7565\u3002\u5728\u5b9e\u9645\u5e94\u7528\u7cfb\u7edf\u67e5\u8be2\u8fc7\u7a0b\u4e2d，\u6211\u4eec\u9664\u4e86\u8981\u5b9a\u4e49JavaBean，\u4e5f\u9700\u8981\u5b9a\u4e49\u7528\u6765\u4fdd\u5b58\u5929\u6c14\u6570\u636e\u7684\u6570\u636e\u5e93\u6a21\u578b\u3002\u6839\u636e\u63a5\u53e3\u6587\u6863，\u6211\u4eec\u53ef\u4ee5\u6309\u7167\u4e1a\u52a1\u7ef4\u5ea6\u8bbe\u8ba1\u4ee5\u4e0b\u6570\u636e\u5e93\u6a21\u578b，\u5206\u522b\u7528\u6765\u5b58\u50a8\u5929\u6c14\u63a5\u53e3\u8fd4\u56de\u7684\u6570\u636e：<\/p>\n

\"\"<\/p>\n

2\u3001\u5b58\u50a8\u5929\u6c14\u7269\u7406\u8868\u7ed3\u6784<\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u8fd9\u91cc\u5c06\u6839\u636e\u4e0a\u9762\u7684\u7269\u7406\u6a21\u578b\u521b\u5efa\u76f8\u5e94\u7684\u5929\u6c14\u4fe1\u606f\u8868，\u8fd9\u91cc\u5c06\u5206\u522b\u7ed9\u51fa\u8fd9\u4e94\u5f20\u8868\u7684\u7269\u7406\u7ed3\u6784\u8bed\u53e5\u3002\u5b58\u50a8\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f：<\/p>\n

create table biz_weather_now (
\n pk_id INT8 not null,
\n location_code VARCHAR(6) not null default '',
\n temp DECIMAL(8,2) not null default 999999,
\n feels_like DECIMAL(8,2) not null default 999999,
\n rh DECIMAL(8,2) not null default 999999,
\n wind_class VARCHAR(10) null,
\n wind_dir VARCHAR(10) null,
\n text VARCHAR(50) null,
\n prec_1h DECIMAL(8,2) null default 999999,
\n clouds DECIMAL(8,2) null default 999999,
\n vis DECIMAL(8,2) null default 999999,
\n aqi DECIMAL(8,2) null default 999999,
\n pm25 DECIMAL(8,2) null default 999999,
\n pm10 DECIMAL(8,2) null default 999999,
\n no2 DECIMAL(8,2) null default 999999,
\n so2 DECIMAL(8,2) null default 999999,
\n o3 DECIMAL(8,2) null default 999999,
\n co DECIMAL(8,2) null default 999999,
\n uptime TIMESTAMP null,
\n constraint PK_BIZ_WEATHER_NOW primary key (pk_id)
\n);
\ncomment on table biz_weather_now is
\n'\u5b58\u50a8\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f';
\ncomment on column biz_weather_now.pk_id is
\n'\u4e3b\u952e';
\ncomment on column biz_weather_now.location_code is
\n'\u884c\u653f\u533a\u5212code';
\ncomment on column biz_weather_now.temp is
\n'\u6e29\u5ea6（\u2103）';
\ncomment on column biz_weather_now.feels_like is
\n'\u4f53\u611f\u6e29\u5ea6(\u2103)';
\ncomment on column biz_weather_now.rh is
\n'\u76f8\u5bf9\u6e7f\u5ea6(%)';
\ncomment on column biz_weather_now.wind_class is
\n'\u98ce\u529b\u7b49\u7ea7';
\ncomment on column biz_weather_now.wind_dir is
\n'\u98ce\u5411\u63cf\u8ff0';
\ncomment on column biz_weather_now.text is
\n'\u5929\u6c14\u73b0\u8c61';
\ncomment on column biz_weather_now.prec_1h is
\n'1\u5c0f\u65f6\u7d2f\u8ba1\u964d\u6c34\u91cf(mm)';
\ncomment on column biz_weather_now.clouds is
\n'\u4e91\u91cf(%)';
\ncomment on column biz_weather_now.vis is
\n'\u80fd\u89c1\u5ea6(m)';
\ncomment on column biz_weather_now.aqi is
\n'\u7a7a\u6c14\u8d28\u91cf\u6307\u6570\u6570\u503c';
\ncomment on column biz_weather_now.pm25 is
\n'pm2.5\u6d53\u5ea6(\u03bcg\/m3)';
\ncomment on column biz_weather_now.pm10 is
\n'pm10\u6d53\u5ea6(\u03bcg\/m3)';
\ncomment on column biz_weather_now.no2 is
\n'\u4e8c\u6c27\u5316\u6c2e\u6d53\u5ea6(\u03bcg\/m3)';
\ncomment on column biz_weather_now.so2 is
\n'\u4e8c\u6c27\u5316\u786b\u6d53\u5ea6(\u03bcg\/m3)';
\ncomment on column biz_weather_now.o3 is
\n'\u81ed\u6c27\u6d53\u5ea6(\u03bcg\/m3)';
\ncomment on column biz_weather_now.co is
\n'\u4e00\u6c27\u5316\u78b3\u6d53\u5ea6(mg\/m3)';
\ncomment on column biz_weather_now.uptime is
\n'\u6570\u636e\u66f4\u65b0\u65f6\u95f4，\u5317\u4eac\u65f6\u95f4'; <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u8fd9\u91cc\u9700\u8981\u6ce8\u610f\u7684\u662f，\u5728\u4fdd\u5b58\u76f8\u5e94\u7684\u5982\u6c14\u6e29\u6216\u8005\u6307\u6570\u65f6，\u91c7\u7528\u7684\u6570\u636e\u5e93\u7c7b\u578b\u4e0d\u662fInt，\u8fd9\u4e5f\u662f\u4e3a\u4e86\u517c\u5bb9\u53ef\u80fd\u7684\u51fa\u73b0\u6d6e\u70b9\u6570\u7684\u60c5\u51b5，\u800c\u5c0f\u6570\u4f4d，\u8fd9\u91cc\u521d\u6b65\u8bbe\u8ba1\u62102\u4f4d，\u5927\u5bb6\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u9700\u6c42\u8fdb\u884c\u8c03\u6574\u3002<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5929\u6c14\u8b66\u62a5\u4fe1\u606f\u8868：<\/p>\n

create table biz_weather_alerts (
\n pk_id INT8 not null,
\n weather_pk_id INT8 null,
\n type VARCHAR(20) null,
\n level VARCHAR(10) null,
\n title VARCHAR(128) null,
\n desc_info VARCHAR(512) null,
\n constraint PK_BIZ_WEATHER_ALERTS primary key (pk_id)
\n);
\ncomment on table biz_weather_alerts is
\n'\u5929\u6c14\u8b66\u62a5\u4fe1\u606f\u8868';
\ncomment on column biz_weather_alerts.pk_id is
\n'\u4e3b\u952e';
\ncomment on column biz_weather_alerts.weather_pk_id is
\n'\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e';
\ncomment on column biz_weather_alerts.type is
\n'\u9884\u8b66\u4e8b\u4ef6\u7c7b\u578b,\u53c2\u8003 \u5929\u6c14\u53d6\u503c\u5bf9\u7167\u8868\u4e2d\u7684\u9884\u8b66\u7c7b\u578b';
\ncomment on column biz_weather_alerts.level is
\n'\u9884\u8b66\u4e8b\u4ef6\u7b49\u7ea7';
\ncomment on column biz_weather_alerts.title is
\n'\u9884\u8b66\u6807\u9898';
\ncomment on column biz_weather_alerts.desc_info is
\n'\u9884\u8b66\u8be6\u7ec6\u63d0\u793a\u4fe1\u606f';<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0\u9700\u8981\u6ce8\u610f\u7684\u662f，\u5728\u8b66\u62a5\u4fe1\u606f\u4e2d，desc\u5b57\u6bb5\u7531\u4e8e\u662f\u6570\u636e\u5e93\u7684\u5173\u952e\u5b57，\u5728\u539f\u59cb\u63a5\u53e3\u4e2d\u8fd4\u56de\u7684desc\u6211\u4eec\u9700\u8981\u53d8\u6210desc_info\u5b57\u6bb5，\u5929\u6c14\u6307\u6570\u4fe1\u606f\u8868：<\/p>\n

create table biz_weather_indexes (
\n pk_id INT8 not null,
\n weather_pk_id INT8 null,
\n name VARCHAR(10) null,
\n brief VARCHAR(10) null,
\n detail VARCHAR(128) null,
\n constraint PK_BIZ_WEATHER_INDEXES primary key (pk_id)
\n);
\ncomment on column biz_weather_indexes.pk_id is
\n'\u4e3b\u952e';
\ncomment on column biz_weather_indexes.weather_pk_id is
\n'\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e';
\ncomment on column biz_weather_indexes.name is
\n'\u751f\u6d3b\u6307\u6570\u4e2d\u6587\u540d\u79f0';
\ncomment on column biz_weather_indexes.brief is
\n'\u751f\u6d3b\u6307\u6570\u6982\u8981\u8bf4\u660e';
\ncomment on column biz_weather_indexes.detail is
\n'\u751f\u6d3b\u6307\u6570\u8be6\u7ec6\u8bf4\u660e'; <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5929\u6c14\u9884\u62a5\u4fe1\u606f\u8868：<\/p>\n

create table biz_weather_forecasts (
\n pk_id INT8 not null,
\n weather_pk_id INT8 null,
\n date TIMESTAMP null,
\n week VARCHAR(3) null,
\n high DECIMAL(8,2) null default 999999,
\n low DECIMAL(8,2) null default 999999,
\n wc_day VARCHAR(10) null,
\n wc_night VARCHAR(10) null,
\n wd_day VARCHAR(10) null,
\n wd_night VARCHAR(10) null,
\n text_day VARCHAR(20) null,
\n text_night VARCHAR(20) null,
\n constraint PK_BIZ_WEATHER_FORECASTS primary key (pk_id)
\n);
\ncomment on column biz_weather_forecasts.pk_id is
\n'\u4e3b\u952e';
\ncomment on column biz_weather_forecasts.weather_pk_id is
\n'\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e';
\ncomment on column biz_weather_forecasts.date is
\n'\u65e5\u671f，\u5317\u4eac\u65f6\u533a';
\ncomment on column biz_weather_forecasts.week is
\n'\u661f\u671f，\u5317\u4eac\u65f6\u533a';
\ncomment on column biz_weather_forecasts.high is
\n'\u6700\u9ad8\u6e29\u5ea6(\u2103)';
\ncomment on column biz_weather_forecasts.low is
\n'\u6700\u4f4e\u6e29\u5ea6(\u2103)';
\ncomment on column biz_weather_forecasts.wc_day is
\n'\u767d\u5929\u98ce\u529b';
\ncomment on column biz_weather_forecasts.wc_night is
\n'\u665a\u4e0a\u98ce\u529b';
\ncomment on column biz_weather_forecasts.wd_day is
\n'\u767d\u5929\u98ce\u5411';
\ncomment on column biz_weather_forecasts.wd_night is
\n'\u665a\u4e0a\u98ce\u5411';
\ncomment on column biz_weather_forecasts.text_day is
\n'\u767d\u5929\u5929\u6c14\u73b0\u8c61,\u53c2\u8003\u5929\u6c14\u53d6\u503c\u5bf9\u7167\u8868';
\ncomment on column biz_weather_forecasts.text_night is
\n'\u665a\u4e0a\u5929\u6c14\u73b0\u8c61'; <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5c0f\u65f6\u5929\u6c14\u9884\u62a5\u8868：<\/p>\n

create table biz_weather_forecast_hours (
\n pk_id INT8 not null,
\n weather_pk_id INT8 null,
\n text VARCHAR(20) null,
\n temp_fc DECIMAL(8,2) null,
\n wind_class VARCHAR(10) null,
\n wind_dir VARCHAR(10) null,
\n rh DECIMAL(8,2) null,
\n prec_1h NUMERIC(8,2) null,
\n clouds DECIMAL(8,2) null,
\n data_time TIMESTAMP null,
\n constraint PK_BIZ_WEATHER_FORECAST_HOURS primary key (pk_id)
\n);
\ncomment on column biz_weather_forecast_hours.pk_id is
\n'\u4e3b\u952e';
\ncomment on column biz_weather_forecast_hours.weather_pk_id is
\n'\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e';
\ncomment on column biz_weather_forecast_hours.text is
\n'\u5929\u6c14\u73b0\u8c61';
\ncomment on column biz_weather_forecast_hours.temp_fc is
\n'\u6e29\u5ea6(\u2103)';
\ncomment on column biz_weather_forecast_hours.wind_class is
\n'\u98ce\u529b\u7b49\u7ea7';
\ncomment on column biz_weather_forecast_hours.wind_dir is
\n'\u98ce\u5411\u63cf\u8ff0';
\ncomment on column biz_weather_forecast_hours.rh is
\n'\u76f8\u5bf9\u6e7f\u5ea6';
\ncomment on column biz_weather_forecast_hours.prec_1h is
\n'1\u5c0f\u65f6\u7d2f\u8ba1\u964d\u6c34\u91cf(mm)';
\ncomment on column biz_weather_forecast_hours.clouds is
\n'\u4e91\u91cf(%)';
\ncomment on column biz_weather_forecast_hours.data_time is
\n'\u6570\u636e\u65f6\u95f4'; <\/p>\n

\u4e8c\u3001MybatisPlus\u4e2d\u5b9e\u4f53\u5b9e\u73b0<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MybatisPlus \u5219\u662f\u57fa\u4e8e Mybatis \u7684\u589e\u5f3a\u7248\u672c，\u5b83\u4e0d\u4ec5\u7ee7\u627f\u4e86 Mybatis \u7684\u7075\u6d3b\u6027\u548c\u6613\u7528\u6027，\u8fd8\u901a\u8fc7\u4e00\u7cfb\u5217\u63d2\u4ef6\u548c\u6269\u5c55\u529f\u80fd，\u6781\u5927\u5730\u7b80\u5316\u4e86\u6570\u636e\u5e93\u64cd\u4f5c\u6d41\u7a0b，\u63d0\u9ad8\u4e86\u5f00\u53d1\u6548\u7387，\u5c24\u5176\u5728\u5904\u7406\u590d\u6742\u4e1a\u52a1\u903b\u8f91\u548c\u6570\u636e\u6301\u4e45\u5316\u65b9\u9762\u8868\u73b0\u51fa\u8272\u3002\u5728\u4e4b\u524d\u7684\u535a\u5ba2\u4e2d\u5df2\u7ecf\u4ecb\u7ecd\u4e86\u76f8\u5173\u7c7b\u7684\u8bbe\u8ba1，\u4e0b\u9762\u5c06\u7ed3\u5408MybatisPlus\u6765\u6df1\u5165\u8bb2\u89e3\u8fd9\u4e9b\u5b9e\u4f53\u7684\u8bbe\u8ba1，\u5206\u522b\u4ece\u7c7b\u56fe\u548c\u5177\u4f53\u5b9e\u73b0\u4e24\u4e2a\u65b9\u9762\u5c55\u5f00\u3002<\/p>\n

1\u3001MybatisPlus\u5b9e\u4f53\u7c7b\u56fe\u8bbe\u8ba1<\/h3>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u901a\u8fc7\u5206\u6790\u539f\u6765\u7684\u63a5\u53e3\u4ee5\u53ca\u68b3\u7406\u5bf9\u8c61\u7684\u5173\u7cfb，\u53ef\u4ee5\u6574\u7406\u51fa\u76f8\u5173\u7684\u6570\u636e\u5173\u7cfb，\u6bd4\u5982\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e0e\u9884\u8b66\u4fe1\u606f\u3001\u751f\u6d3b\u6307\u6570\u4fe1\u606f\u3001\u9010\u65e5\u9884\u62a5\u4fe1\u606f\u548c\u9010\u5c0f\u65f6\u9884\u62a5\u4fe1\u606f\u5747\u662f\u4e00\u5bf9\u591a\u7684\u60c5\u51b5\u3002<\/p>\n

2\u3001MybatisPlus\u4e2d\u76f8\u5173\u7c7b\u5b9e\u73b0<\/h3>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u7531\u4e8e\u7bc7\u5e45\u6709\u9650，\u8fd9\u91cc\u5c06\u524d\u9762\u7684\u5185\u5bb9\u4e2d\u5269\u4e0b\u7684\u51e0\u4e2aJavaBean\u7684\u4ee3\u7801\u7ed9\u51fa，\u5728\u4e4b\u524d\u7684\u5185\u5bb9\u4e2d\u5df2\u7ecf\u5bf9BdWeatherDTO.java\u3001WeatherInfoDTO.java\u3001WeatherIndexes.java\u8fdb\u884c\u4e86\u8bf4\u660e\u3002\u9884\u8b66\u4fe1\u606fJavaBean\u5982\u4e0b：<\/p>\n

package com.yelang.project.weather.domain;
\nimport java.io.Serializable;
\nimport com.baomidou.mybatisplus.annotation.TableField;
\nimport com.baomidou.mybatisplus.annotation.TableId;
\nimport com.baomidou.mybatisplus.annotation.TableName;
\nimport com.google.gson.annotations.SerializedName;
\nimport lombok.AllArgsConstructor;
\nimport lombok.Getter;
\nimport lombok.NoArgsConstructor;
\nimport lombok.Setter;
\nimport lombok.ToString;
\n@TableName(value = "biz_weather_alerts")
\n@NoArgsConstructor
\n@AllArgsConstructor
\n@Setter
\n@Getter
\n@ToString
\npublic class WeatherAlerts implements Serializable{
\nprivate static final long serialVersionUID = 9180445236146165608L;
\n@TableId(value ="pk_id")
\nprivate Long pkId ;\/\/\u4e3b\u952e
\n@TableField(value="weather_pk_id")
\nprivate Long weatherPkId;\/\/\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e
\nprivate String type;\/\/\u9884\u8b66\u4e8b\u4ef6\u7c7b\u578b,\u53c2\u8003 \u5929\u6c14\u53d6\u503c\u5bf9\u7167\u8868\u4e2d\u7684\u9884\u8b66\u7c7b\u578b
\nprivate String level;\/\/\u9884\u8b66\u4e8b\u4ef6\u7b49\u7ea7
\nprivate String title;\/\/\u9884\u8b66\u6807\u9898
\n@TableField(value="desc_info")
\n@SerializedName("desc")
\nprivate String descInfo;\/\/\u9884\u8b66\u8be6\u7ec6\u63d0\u793a\u4fe1\u606f
\n} <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u9010\u65e5\u5929\u6c14\u9884\u62a5JavaBean\u4ee3\u7801\u5982\u4e0b：<\/p>\n

package com.yelang.project.weather.domain;
\nimport java.io.Serializable;
\nimport java.math.BigDecimal;
\nimport java.util.Date;
\nimport com.baomidou.mybatisplus.annotation.TableField;
\nimport com.baomidou.mybatisplus.annotation.TableId;
\nimport com.baomidou.mybatisplus.annotation.TableName;
\nimport com.fasterxml.jackson.annotation.JsonFormat;
\nimport com.google.gson.annotations.SerializedName;
\nimport lombok.AllArgsConstructor;
\nimport lombok.Getter;
\nimport lombok.NoArgsConstructor;
\nimport lombok.Setter;
\nimport lombok.ToString;
\n@TableName(value = "biz_weather_forecasts")
\n@NoArgsConstructor
\n@AllArgsConstructor
\n@Setter
\n@Getter
\n@ToString
\npublic class WeatherForecasts implements Serializable{
\nprivate static final long serialVersionUID = 4929733391294381721L;
\n@TableId(value ="pk_id")
\nprivate Long pkId ;\/\/\u4e3b\u952e
\n@TableField(value="weather_pk_id")
\nprivate Long weatherPkId;\/\/\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e
\n@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
\nprivate Date date;\/\/\u65e5\u671f，\u5317\u4eac\u65f6\u533a
\nprivate String week;\/\/\u661f\u671f，\u5317\u4eac\u65f6\u533a
\nprivate BigDecimal high = new BigDecimal(999999);\/\/\u6700\u9ad8\u6e29\u5ea6(\u2103)
\nprivate BigDecimal low = new BigDecimal(999999);\/\/\u6700\u4f4e\u6e29\u5ea6(\u2103)
\n@TableField(value="wc_day")
\n@SerializedName("wc_day")
\nprivate String wcDay;\/\/\u767d\u5929\u98ce\u529b
\n@TableField(value="wc_night")
\n@SerializedName("wc_night")
\nprivate String wcNight;\/\/\u665a\u4e0a\u98ce\u529b
\n@TableField(value="wd_day")
\n@SerializedName("wd_day")
\nprivate String wdDay;\/\/\u767d\u5929\u98ce\u5411
\n@TableField(value="wd_night")
\n@SerializedName("wd_night")
\nprivate String wdNight;\/\/\u665a\u4e0a\u98ce\u5411
\n@TableField(value="text_day")
\n@SerializedName("text_day")
\nprivate String textDay;\/\/\u767d\u5929\u5929\u6c14\u73b0\u8c61,\u53c2\u8003\u5929\u6c14\u53d6\u503c\u5bf9\u7167\u8868
\n@TableField(value="text_night")
\n@SerializedName("text_night")
\nprivate String textNight;\/\/\u665a\u4e0a\u5929\u6c14\u73b0\u8c61
\n} <\/p>\n

\u6700\u540e\u8fd8\u6709\u9010\u5c0f\u65f6\u7684\u5929\u6c14\u9884\u62a5\u4fe1\u606fJavaBean：<\/p>\n

package com.yelang.project.weather.domain;
\nimport java.io.Serializable;
\nimport java.math.BigDecimal;
\nimport java.util.Date;
\nimport com.baomidou.mybatisplus.annotation.TableField;
\nimport com.baomidou.mybatisplus.annotation.TableId;
\nimport com.baomidou.mybatisplus.annotation.TableName;
\nimport com.fasterxml.jackson.annotation.JsonFormat;
\nimport com.google.gson.annotations.SerializedName;
\nimport lombok.AllArgsConstructor;
\nimport lombok.Getter;
\nimport lombok.NoArgsConstructor;
\nimport lombok.Setter;
\nimport lombok.ToString;
\n@TableName(value = "biz_weather_forecast_hours")
\n@NoArgsConstructor
\n@AllArgsConstructor
\n@Setter
\n@Getter
\n@ToString
\npublic class WeatherForecastHours implements Serializable{
\nprivate static final long serialVersionUID = -18102820381727782L;
\n@TableId(value ="pk_id")
\nprivate Long pkId ;\/\/\u4e3b\u952e
\n@TableField(value="weather_pk_id")
\nprivate Long weatherPkId;\/\/\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f\u4e3b\u952e
\nprivate String text;\/\/\u5929\u6c14\u73b0\u8c61
\n@TableField(value="temp_fc")
\n@SerializedName("temp_fc")
\nprivate BigDecimal tempFc;\/\/\u6e29\u5ea6(\u2103)
\n@TableField(value="wind_class")
\n@SerializedName("wind_class")
\nprivate String windClass;\/\/\u98ce\u529b\u7b49\u7ea7
\n@TableField(value="wind_dir")
\n@SerializedName("wind_dir")
\nprivate String windDir;\/\/\u98ce\u5411\u63cf\u8ff0
\nprivate BigDecimal rh;\/\/\u76f8\u5bf9\u6e7f\u5ea6
\n@TableField(value="prec_1h")
\n@SerializedName("prec_1h")
\nprivate BigDecimal prec1h;\/\/1\u5c0f\u65f6\u7d2f\u8ba1\u964d\u6c34\u91cf(mm)
\nprivate BigDecimal clouds;\/\/\u4e91\u91cf(%)
\n@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
\n@TableField(value="data_time")
\n@SerializedName("data_time")
\nprivate Date dataTime;\/\/\u6570\u636e\u65f6\u95f4
\n} <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u7ecf\u8fc7\u4ee5\u4e0a\u7684\u6b65\u9aa4，\u6211\u4eec\u5c31\u5b8c\u6210\u4e86\u5168\u90e8\u7684\u767e\u5ea6\u5929\u6c14\u76f8\u5173\u7684JavaBean\u7684\u5b9a\u4e49，\u63a5\u4e0b\u6765\u6211\u4eec\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5b9e\u73b0\u5c06\u6570\u636e\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n

\u4e09\u3001PostgreSQL\u6301\u4e45\u5316\u5b9e\u73b0<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5728\u5b9e\u9645\u5f00\u53d1\u8fc7\u7a0b\u4e2d，\u6211\u4eec\u9996\u5148\u9700\u8981\u901a\u8fc7\u767e\u5ea6\u5929\u6c14 API \u83b7\u53d6\u539f\u59cb\u7684\u5929\u6c14\u6570\u636e，\u8fd9\u4e9b\u6570\u636e\u901a\u5e38\u4ee5 JSON \u683c\u5f0f\u8fd4\u56de，\u5305\u542b\u4e86\u57ce\u5e02\u3001\u65e5\u671f\u3001\u6e29\u5ea6\u3001\u6e7f\u5ea6\u3001\u98ce\u529b\u3001\u5929\u6c14\u72b6\u51b5\u7b49\u8bf8\u591a\u4fe1\u606f\u3002\u968f\u540e，\u5229\u7528 Java \u7b49\u7f16\u7a0b\u8bed\u8a00\u5bf9\u8fd9\u4e9b JSON \u6570\u636e\u8fdb\u884c\u89e3\u6790，\u5c06\u5176\u8f6c\u6362\u4e3a\u7b26\u5408\u6570\u636e\u5e93\u5b58\u50a8\u8981\u6c42\u7684\u7ed3\u6784\u5316\u6570\u636e\u3002\u63a5\u7740，\u501f\u52a9 MybatisPlus \u6846\u67b6，\u5c06\u8fd9\u4e9b\u7ed3\u6784\u5316\u6570\u636e\u6620\u5c04\u5230\u5bf9\u5e94\u7684\u5b9e\u4f53\u7c7b\u4e2d，\u5e76\u901a\u8fc7\u914d\u7f6e MybatisPlus \u7684 SQL \u4f1a\u8bdd\u5de5\u5382\u3001\u6570\u636e\u6e90\u4ee5\u53ca\u76f8\u5173\u6620\u5c04\u6587\u4ef6，\u5b9e\u73b0\u4e0e PostgreSQL \u6570\u636e\u5e93\u7684\u8fde\u63a5\u548c\u6570\u636e\u7684\u6301\u4e45\u5316\u5b58\u50a8\u3002\u5173\u4e8e\u5982\u4f55\u91c7\u96c6\u6570\u636e\u3001JSON\u6570\u636e\u8f6c\u6362\u7684\u5185\u5bb9\u5728\u4e4b\u524d\u7684\u535a\u5ba2\u4e2d\u90fd\u6709\u6240\u6d89\u53ca，\u63a5\u4e0b\u6765\u6211\u4eec\u6765\u8bb2\u89e3\u6700\u540e\u4e00\u4e2a\u73af\u8282，\u5373\u5982\u4f55\u5c06\u91c7\u96c6\u548c\u8f6c\u6362\u540e\u7684\u6570\u636e\u6301\u4e45\u5230PG\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n

1\u3001\u5929\u6c14\u6570\u636e\u5165\u5e93\u65f6\u5e8f\u56fe<\/h3>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e0a\u56fe\u8be6\u7ec6\u7684\u5c55\u793a\u4e86\u5982\u4f55\u5728\u53ef\u8fd0\u884c\u7a0b\u5e8f\u4e2d\u96c6\u6210\u767e\u5ea6\u63a5\u53e3，\u91c7\u7528\u65f6\u5e8f\u56fe\u7684\u65b9\u5f0f\u8fdb\u884c\u4e86\u8be6\u7ec6\u4ea4\u4e92\u8fc7\u7a0b\u7684\u9610\u8ff0\u3002\u6574\u4e2a\u8fc7\u7a0b\u4e00\u5171\u5206\u4e3a11\u4e2a\u6b65\u9aa4，\u4ece\u5165\u53e3\u7a0b\u5e8f\u8c03\u7528\u5f00\u59cb，\u9996\u5148\u8c03\u7528\u767e\u5ea6\u5730\u56fe\u7684\u63a5\u53e3，\u7136\u540e\u767e\u5ea6\u5730\u56fe\u8fd4\u56deJSON\u7ed3\u679c，\u7a0b\u5e8f\u89e3\u6790JSON\u53cd\u5e8f\u5217\u5316\u6210DTO\u7684JavaBean，\u7136\u540e\u8c03\u7528\u5929\u6c14\u670d\u52a1\u7c7b，\u5206\u522b\u5b9e\u73b0\u5b9e\u65f6\u5929\u6c14\u3001\u9884\u8b66\u4fe1\u606f\u3001\u751f\u6d3b\u6307\u6570\u4fe1\u606f\u3001\u9010\u65e5\u9884\u62a5\u4fe1\u606f\u3001\u9010\u5c0f\u65f6\u9884\u62a5\u4fe1\u606f\u7684PG\u5165\u5e93，\u6700\u540e\u8fd4\u56de\u5199\u5165\u72b6\u6001\u3002\u65f6\u5e8f\u56fe\u5728\u7ed8\u5236\u65f6，\u4e3a\u4e86\u7f8e\u89c2\u5728Service\u7684\u540d\u79f0\u4e0a\u6709\u4e00\u5b9a\u7701\u7565，\u5e0c\u671b\u4e0d\u5f71\u54cd\u9605\u8bfb\u3002<\/p>\n

2\u3001\u8c03\u7528\u7a0b\u5e8f\u6267\u884c<\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5173\u4e8eMybatisPlus\u4e2d\u6d89\u53ca\u7684Mapper\u3001Service\u53ca\u5176\u5b9e\u73b0\u7c7b\u5728\u6b64\u4e0d\u518d\u8fdb\u884c\u8d58\u8ff0，\u901a\u7528\u7684\u7a0b\u5e8f\u90fd\u6bd4\u8f83\u7b80\u5355，\u8fd9\u91cc\u5c06\u6838\u5fc3\u7684\u5929\u6c14\u7a0b\u5e8f\u5165\u53e3\u548c\u6301\u4e45\u5316\u5165\u53e3\u4ee5\u53ca\u5177\u4f53\u7684\u5929\u6c14\u4fe1\u606f\u5165\u5e93\u65b9\u6cd5\u5728\u8fd9\u91cc\u8ddf\u5927\u5bb6\u5206\u4eab\u3002\u5165\u53e3\u6838\u5fc3\u7a0b\u5e8f\u5982\u4e0b\u6240\u793a：<\/p>\n

package com.yelang.project.unihttp;
\nimport org.junit.Test;
\nimport org.junit.runner.RunWith;
\nimport org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.boot.test.context.SpringBootTest;
\nimport org.springframework.test.context.junit4.SpringRunner;
\nimport com.baomidou.mybatisplus.core.toolkit.IdWorker;
\nimport com.burukeyou.uniapi.http.core.response.HttpResponse;
\nimport com.google.gson.Gson;
\nimport com.yelang.project.thridinterface.BaiduWeatherApiServcie;
\nimport com.yelang.project.weather.domain.BdWeatherDTO;
\nimport com.yelang.project.weather.domain.WeatherInfoDTO;
\nimport com.yelang.project.weather.service.IWeatherNowService;
\n@SpringBootTest
\n@RunWith(SpringRunner.class)
\npublic class BaiduWeather2DBCase {
\nprivate static final String DATA_TYPE = "all";
\n@Autowired
\nprivate BaiduWeatherApiServcie baiduWeatherApiService;
\n@Autowired
\nprivate IWeatherNowService weatherService;
\n@Test
\npublic void bdWeather2PG() {
\nString district_id = "430626";\/\/\u8868\u793a\u5177\u4f53\u7684\u884c\u653f\u533a\u5212\u4ee3\u53f7
\nHttpResponse<String> result = baiduWeatherApiService.getWeather(district_id, DATA_TYPE);
\nSystem.out.println(result.getBodyResult());
\nGson gson = new Gson();
\nBdWeatherDTO bdWeatherInfo = gson.fromJson(result.getBodyResult(), BdWeatherDTO.class);
\nWeatherInfoDTO bdResult = bdWeatherInfo.getResult();
\n\/\/\u5c06\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230\u6570\u636e\u5e93\u4e2d
\nif(null != bdResult) {
\nLong weatherId = IdWorker.getId();
\nbdResult.getWeatherNow().setPkId(weatherId);
\nbdResult.getWeatherNow().setLocationCode(district_id);
\nweatherService.insertWeatherInfo(bdResult);
\n}
\n}
\n}<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e3a\u4e86\u5b9e\u73b0\u5929\u6c14\u6570\u636e\u7684\u5165\u5e93，\u5728\u4fdd\u5b58\u76f8\u5173\u7684\u751f\u6d3b\u6307\u6570\u4fe1\u606f\u3001\u9884\u8b66\u4fe1\u606f\u3001\u9010\u65e5\/\u5c0f\u65f6\u5929\u6c14\u9884\u62a5\u4fe1\u606f\u65f6，\u6211\u4eec\u8fd8\u8981\u5c06\u5b9e\u65f6\u5929\u6c14\u4e3b\u952e\u7ed9\u76f8\u5173\u7684\u5b50\u8868\u8d4b\u503c，\u8fd9\u91cc\u7ed9\u51fa\u5929\u6c14\u4fe1\u606f\u7684\u6301\u4e45\u5316\u8be6\u7ec6\u65b9\u6cd5：<\/p>\n

package com.yelang.project.weather.service.impl;
\nimport java.util.List;
\nimport org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.stereotype.Service;
\nimport org.springframework.transaction.annotation.Propagation;
\nimport org.springframework.transaction.annotation.Transactional;
\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
\nimport com.yelang.common.utils.StringUtils;
\nimport com.yelang.project.weather.domain.WeatherAlerts;
\nimport com.yelang.project.weather.domain.WeatherForecastHours;
\nimport com.yelang.project.weather.domain.WeatherForecasts;
\nimport com.yelang.project.weather.domain.WeatherIndexes;
\nimport com.yelang.project.weather.domain.WeatherInfoDTO;
\nimport com.yelang.project.weather.domain.WeatherNow;
\nimport com.yelang.project.weather.mapper.WeatherNowMapper;
\nimport com.yelang.project.weather.service.IWeatherAlertsService;
\nimport com.yelang.project.weather.service.IWeatherForecastHoursService;
\nimport com.yelang.project.weather.service.IWeatherForecastsService;
\nimport com.yelang.project.weather.service.IWeatherIndexesService;
\nimport com.yelang.project.weather.service.IWeatherNowService;
\n@Service
\npublic class WeatherNowServiceImpl extends ServiceImpl<WeatherNowMapper, WeatherNow> implements IWeatherNowService{
\n@Autowired
\nprivate IWeatherAlertsService alertsService;
\n@Autowired
\nprivate IWeatherForecastHoursService forecastHoursService;
\n@Autowired
\nprivate IWeatherForecastsService forecastsService;
\n@Autowired
\nprivate IWeatherIndexesService indexesService;
\n@Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
\n@Override
\npublic void insertWeatherInfo(WeatherInfoDTO infoDto) {
\nWeatherNow now = infoDto.getWeatherNow();
\n\/\/step1\u3001\u4fdd\u5b58\u5b9e\u65f6\u5929\u6c14\u4fe1\u606f
\nthis.baseMapper.insert(now);
\nLong weatherId = now.getPkId();
\n\/\/step2\u3001\u4fdd\u5b58\u751f\u6d3b\u6307\u6570\u4fe1\u606f
\nList<WeatherAlerts> alerts = infoDto.getAlerts();
\nif(StringUtils.isNotEmpty(alerts)) {
\nfor(WeatherAlerts alert : alerts) {
\nalert.setWeatherPkId(weatherId);
\n}
\nalertsService.saveBatch(alerts);
\n}
\n\/\/step3\u3001\u4fdd\u5b58\u9884\u8b66\u4fe1\u606f
\nList<WeatherIndexes> indexes = infoDto.getIndexes();
\nif(StringUtils.isNotEmpty(indexes)) {
\nfor(WeatherIndexes index : indexes) {
\nindex.setWeatherPkId(weatherId);
\n}
\nindexesService.saveBatch(indexes);
\n}
\n\/\/step4\u3001\u4fdd\u5b58\u5929\u6c14\u9884\u62a5
\nList<WeatherForecasts> forecasts = infoDto.getForecasts();
\nif(StringUtils.isNotEmpty(forecasts)) {
\nfor(WeatherForecasts forecast : forecasts) {
\nforecast.setWeatherPkId(weatherId);
\n}
\nforecastsService.saveBatch(forecasts);
\n}
\n\/\/step5\u3001\u4fdd\u5b58\u9010\u5c0f\u65f6\u5929\u6c14\u9884\u62a5
\nList<WeatherForecastHours> forecastHours = infoDto.getForecastHours();
\nif(StringUtils.isNotEmpty(forecastHours)) {
\nfor(WeatherForecastHours forecastHour : forecastHours) {
\nforecastHour.setWeatherPkId(weatherId);
\n}
\nforecastHoursService.saveBatch(forecastHours);
\n}
\n}
\n} <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u81f3\u6b64\u57fa\u672c\u5b8c\u6210\u4e86\u8c03\u7528\u7a0b\u5e8f\u548c\u5165\u53e3\u7a0b\u5e8f\u7684\u7f16\u5199，\u63a5\u4e0b\u6765\u5728PG\u6570\u636e\u5e93\u4e2d\u770b\u4e00\u4e0b\u5b9e\u9645\u7684\u6548\u679c\u3002<\/p>\n

3\u3001\u6570\u636e\u5165\u5e93\u7ed3\u679c<\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6267\u884c\u4ee5\u4e0a\u7a0b\u5e8f\u53ef\u4ee5\u5728\u63a7\u5236\u53f0\u4e2d\u770b\u5230\u4ee5\u4e0b\u8f93\u51fa，\u8bf4\u660e\u6b63\u5e38\u7684\u5411PG\u6570\u636e\u5e93\u8fdb\u884c\u6570\u636e\u6301\u4e45\u5316\u3002<\/p>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6700\u540e\u6211\u4eec\u5230\u6570\u636e\u5e93\u4e2d\u67e5\u8be2\u4e00\u4e0b\u662f\u5426\u5c06\u6570\u636e\u6210\u529f\u7684\u5199\u5165，\u6267\u884c\u7684SQL\u5982\u4e0b：<\/p>\n

select * from biz_weather_now;<\/p>\n

select * from biz_weather_alerts;<\/p>\n

select * from biz_weather_forecasts
\nwhere weather_pk_id = 1955642733221658626; <\/p>\n

\"\"<\/p>\n

\u5b9e\u65f6\u5929\u6c14\u6570\u636e<\/p>\n

\"\"<\/p>\n

\u9010\u5c0f\u65f6\u5929\u6c14\u9884\u62a5<\/p>\n

\u56db\u3001\u603b\u7ed3<\/h2>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4ee5\u4e0a\u5c31\u662f\u672c\u6587\u7684\u4e3b\u8981\u5185\u5bb9，\u672c\u6587\u91cd\u70b9\u5728\u4e8e\u8be6\u7ec6\u5f97\u4ecb\u7ecd\u5728MybatisPlus\u6846\u67b6\u4e2d\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d，\u9996\u5148\u4ecb\u7ecd\u5177\u4f53\u7684PG\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0，\u7136\u540e\u8be6\u7ec6\u4ecb\u7ecdMybatisPlus\u7684\u5b9e\u4f53\u8bbe\u8ba1，\u6700\u540e\u4ee5\u6e90\u4ee3\u7801\u7684\u5f62\u5f0f\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u8fdb\u884c\u6301\u4e45\u5316，\u671f\u5f85\u4e3a\u5927\u5bb6\u63d0\u4f9b\u4e00\u79cd\u826f\u597d\u7684\u89e3\u51b3\u65b9\u6848\u548c\u53c2\u8003\u3002\u8fd9\u4e00\u5b9e\u8df5\u8fc7\u7a0b\u4e0d\u4ec5\u6d89\u53ca\u5230\u6280\u672f\u5c42\u9762\u7684\u591a\u79cd\u77e5\u8bc6\u878d\u5408，\u5982\u7f51\u7edc\u7f16\u7a0b\u3001JSON \u6570\u636e\u5904\u7406\u3001\u6570\u636e\u5e93\u64cd\u4f5c\u4ee5\u53ca\u6846\u67b6\u5e94\u7528\u7b49，\u8fd8\u9762\u4e34\u7740\u8bf8\u5982\u6570\u636e\u51c6\u786e\u6027\u3001\u5b58\u50a8\u6548\u7387\u3001\u7cfb\u7edf\u7a33\u5b9a\u6027\u7b49\u8bf8\u591a\u6311\u6218\u3002\u901a\u8fc7\u5bf9\u6574\u4e2a\u6d41\u7a0b\u7684\u6df1\u5165\u7814\u7a76\u548c\u5b9e\u8df5\u63a2\u7d22，\u6211\u4eec\u5e0c\u671b\u80fd\u591f\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e00\u5957\u5b8c\u6574\u3001\u9ad8\u6548\u4e14\u53ef\u9760\u7684\u89e3\u51b3\u65b9\u6848，\u52a9\u529b\u5927\u5bb6\u66f4\u597d\u5730\u5229\u7528\u767e\u5ea6\u5929\u6c14\u6570\u636e，\u6316\u6398\u5176\u6f5c\u5728\u4ef7\u503c，\u540c\u65f6\u4e5f\u4e3a\u7c7b\u4f3c\u7684\u6570\u636e\u5b58\u50a8\u9879\u76ee\u63d0\u4f9b\u6709\u76ca\u7684\u53c2\u8003\u548c\u501f\u9274\u3002\u884c\u6587\u4ed3\u4fc3，\u5b9a\u6709\u8bb8\u591a\u7684\u4e0d\u8db3\u4e4b\u5904，\u6b22\u8fce\u5404\u4f4d\u670b\u53cb\u5728\u8bc4\u8bba\u533a\u6279\u8bc4\u6307\u6b63，\u4e0d\u80dc\u611f\u6fc0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb832\u6b21\uff0c\u70b9\u8d5e28\u6b21\uff0c\u6536\u85cf21\u6b21\u3002\u672c\u6587\u91cd\u70b9\u5728\u4e8e\u8be6\u7ec6\u5f97\u4ecb\u7ecd\u5728MybatisPlus\u6846\u67b6\u4e2d\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d\uff0c\u9996\u5148\u4ecb\u7ecd\u5177\u4f53\u7684PG\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0\uff0c\u7136\u540e\u8be6\u7ec6\u4ecb\u7ecdMybatisPlus\u7684\u5b9e\u4f53\u8bbe\u8ba1\uff0c\u6700\u540e\u4ee5\u6e90\u4ee3\u7801\u7684\u5f62\u5f0f\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u8fdb\u884c\u6301\u4e45\u5316\uff0c\u671f\u5f85\u4e3a\u5927\u5bb6\u63d0\u4f9b\u4e00\u79cd\u826f\u597d\u7684\u89e3\u51b3\u65b9\u6848\u548c\u53c2\u8003\u3002<\/p>\n","protected":false},"author":2,"featured_media":55794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,5761,5759,5760],"topic":[],"class_list":{"0":"post-55801","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-server","8":"tag-java","10":"tag-pg","11":"tag-5760"},"yoast_head":"\n\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/55801.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb832\u6b21\uff0c\u70b9\u8d5e28\u6b21\uff0c\u6536\u85cf21\u6b21\u3002\u672c\u6587\u91cd\u70b9\u5728\u4e8e\u8be6\u7ec6\u5f97\u4ecb\u7ecd\u5728MybatisPlus\u6846\u67b6\u4e2d\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d\uff0c\u9996\u5148\u4ecb\u7ecd\u5177\u4f53\u7684PG\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0\uff0c\u7136\u540e\u8be6\u7ec6\u4ecb\u7ecdMybatisPlus\u7684\u5b9e\u4f53\u8bbe\u8ba1\uff0c\u6700\u540e\u4ee5\u6e90\u4ee3\u7801\u7684\u5f62\u5f0f\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u8fdb\u884c\u6301\u4e45\u5316\uff0c\u671f\u5f85\u4e3a\u5927\u5bb6\u63d0\u4f9b\u4e00\u79cd\u826f\u597d\u7684\u89e3\u51b3\u65b9\u6848\u548c\u53c2\u8003\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/55801.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-14T00:35:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250814003451-689d2f2b9ebfe.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/55801.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/55801.html\",\"name\":\"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-08-14T00:35:05+00:00\",\"dateModified\":\"2025-08-14T00:35:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/55801.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/55801.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/55801.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/55801.html","og_locale":"zh_CN","og_type":"article","og_title":"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb832\u6b21\uff0c\u70b9\u8d5e28\u6b21\uff0c\u6536\u85cf21\u6b21\u3002\u672c\u6587\u91cd\u70b9\u5728\u4e8e\u8be6\u7ec6\u5f97\u4ecb\u7ecd\u5728MybatisPlus\u6846\u67b6\u4e2d\u5982\u4f55\u5c06\u767e\u5ea6\u5929\u6c14\u4fe1\u606f\u6301\u4e45\u5316\u5230PG\u6570\u636e\u5e93\u4e2d\uff0c\u9996\u5148\u4ecb\u7ecd\u5177\u4f53\u7684PG\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0\uff0c\u7136\u540e\u8be6\u7ec6\u4ecb\u7ecdMybatisPlus\u7684\u5b9e\u4f53\u8bbe\u8ba1\uff0c\u6700\u540e\u4ee5\u6e90\u4ee3\u7801\u7684\u5f62\u5f0f\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u8fdb\u884c\u6301\u4e45\u5316\uff0c\u671f\u5f85\u4e3a\u5927\u5bb6\u63d0\u4f9b\u4e00\u79cd\u826f\u597d\u7684\u89e3\u51b3\u65b9\u6848\u548c\u53c2\u8003\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/55801.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-08-14T00:35:05+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250814003451-689d2f2b9ebfe.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"10 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/55801.html","url":"https:\/\/www.wsisp.com\/helps\/55801.html","name":"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-08-14T00:35:05+00:00","dateModified":"2025-08-14T00:35:05+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/55801.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/55801.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/55801.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u57fa\u4e8e MybatisPlus \u5c06\u767e\u5ea6\u5929\u6c14\u6570\u636e\u5b58\u50a8\u81f3 PostgreSQL \u6570\u636e\u5e93\u7684\u5b9e\u8df5"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/55801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=55801"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/55801\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/55794"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=55801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=55801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=55801"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=55801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}