{"id":246292,"date":"2020-12-18T03:39:02","date_gmt":"2020-12-17T19:39:02","guid":{"rendered":"http:\/\/4563.org\/?p=246292"},"modified":"2020-12-18T03:39:02","modified_gmt":"2020-12-17T19:39:02","slug":"java-json-%e5%ad%97%e7%ac%a6%e4%b8%b2%e7%9a%84%e5%ad%98%e5%82%a8%e5%92%8c%e8%af%bb%e5%8f%96","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=246292","title":{"rendered":"Java json \u5b57\u7b26\u4e32\u7684\u5b58\u50a8\u548c\u8bfb\u53d6"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  Java json \u5b57\u7b26\u4e32\u7684\u5b58\u50a8\u548c\u8bfb\u53d6               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zjty <\/span>  <span><i><\/i> 3<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u524d\u7aef\u4f7f\u7528\u5b57\u7b26\u4e32\u4f20\u9012\u4e86\u4e00\u4e2a\u5b57\u7b26\u4e32\uff1a JSON.stringify([{&#8220;key&#8221;:&#8221;\u6210\u672c\u503c&#8221;},{&#8220;key1&#8243;:&#8221;\u4ea7\u54c1\u540d\u79f0&#8221;},{&#8220;key2&#8243;:&#8221;\u4ea7\u54c1\u7f16\u7801&#8221;},{&#8220;key3&#8243;:&#8221;\u662f\u5426\u542f\u7528&#8221;}])<\/p>\n<pre><code>[{\"key\":\"\u6210\u672c\u503c\"},{\"key1\":\"\u4ea7\u54c1\u540d\u79f0\"},{\"key2\":\"\u4ea7\u54c1\u7f16\u7801\"},{\"key3\":\"\u662f\u5426\u542f\u7528\"}] <\/code><\/pre>\n<p>\u6211\u4f7f\u7528 jpa \u7684 save \u4fdd\u5b58\u540e\u6570\u636e\u5e93\u4e2d\u4f1a\u5305\u542b\u53cd\u659c\u6760<\/p>\n<pre><code>\"[{\"key\":\"\u6210\u672c\u503c\"},{\"key1\":\"\u4ea7\u54c1\u540d\u79f0\"},{\"key2\":\"\u4ea7\u54c1\u7f16\u7801\"},{\"key3\":\"\u662f\u5426\u542f\u7528\"}]\" <\/code><\/pre>\n<p>\u800c\u6211\u4f7f\u7528<\/p>\n<pre><code>String insertSql = String.format(\"INSERT INTO `%s` (data) VALUES ('%s');\", tableName, data); <\/code><\/pre>\n<p>\u5374\u4e0d\u5305\u542b\u53cd\u659c\u6760\uff0c\u5982\u4e0b<\/p>\n<pre><code>[{\"key\": {\"\u6210\u672c\u503c\": \"\u957f*\u5bbd\"}}, {\"key1\": {\"\u4ea7\u54c1\u540d\u79f0\": \"\u53cc\u63d2\u76d2\u5b50\"}}, {\"key2\": {\"\u4ea7\u54c1\u7f16\u7801\": \"HZ_SCH\"}}, {\"key3\": {\"\u662f\u5426\u542f\u7528\": \"\u662f\"}}] <\/code><\/pre>\n<p>\u8bf7\u95ee\u8fd9\u65f6\u5019\u6211\u5e94\u8be5\u5982\u4f55\u5904\u7406\uff0c\u4e00\u822c\u6765\u8bf4\u6570\u636e\u5e93\u4e2d\u5305\u542b\u7684\u662f\u8981\u6709\u53cd\u659c\u6760\u7684\u5427\uff08\u636e\u8bf4\u662f\u4e3a\u4e86\u5b89\u5168\u8003\u8651\uff09\uff0c\u90a3\u6211\u7684 sql \u8bed\u53e5\u8be5\u5982\u4f55\u5904\u7406\u4ee5\u8fbe\u5230\u7edf\u4e00\u5462<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>Java json \u5b57\u7b26\u4e32\u7684\u5b58\u50a8\u548c&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/246292"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=246292"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/246292\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=246292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=246292"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=246292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}