{"id":99,"date":"2016-05-17T16:21:32","date_gmt":"2016-05-17T08:21:32","guid":{"rendered":"http:\/\/jason19659.pw\/?p=99"},"modified":"2016-05-17T16:28:20","modified_gmt":"2016-05-17T08:28:20","slug":"mysql%e5%87%a0%e7%a7%8d%e6%96%b9%e5%bc%8f%e6%8f%92%e5%85%a5%e7%99%be%e6%9d%a1%e6%95%b0%e6%8d%ae%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/t2t2.cc\/?p=99","title":{"rendered":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5"},"content":{"rendered":"<p>\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002<br \/>\n\u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528service\u4e00\u6761\u4e00\u6761\u63d2\u5165\uff0c\u51fa\u9519\u6ca1\u6709\u56de\u6eda\u3002<br \/>\n\u7ed3\u679c\u8017\u65f6\u975e\u5e38\u957f\uff0c\u8fd9\u4e5f\u662f\u5f88\u6b63\u5e38\u7684\u3002<br \/>\n\u7b2c\u4e8c\u79cd\uff0c\u5728100w\u6761sql\u8dd1\u5728\u540c\u4e00\u4e2a\u4e8b\u7269\u4e2d\uff0c\u597d\u5904\u5c31\u662f\u8fd9\u4e00\u767e\u4e07\u6761\u6570\u636e\u662f\u539f\u5b50\u6027\u7684\u3002\u7edf\u4e00\u6210\u529f\u6216\u8005\u5931\u8d25\u3002<br \/>\n\u6570\u636e\u751f\u6210\u4ee3\u7801<\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\r\n                List&lt;Log&gt; logs = new ArrayList&lt;Log&gt;(100_0000);\r\n\t\tfor (int i = 0; i &lt; 100_0000; i++) {\r\n\t\t\tLog log = new Log();\r\n\t\t\tlog.setAddress(Math.random()+&quot;&quot;);\r\n\t\t\tlog.setJingdu(Math.random()*100);\r\n\t\t\tlog.setWeidu(Math.random()*100);\r\n\t\t\tlog.setTokenId(UUID.randomUUID().toString().split(&quot;-&quot;)&#x5B;0]);\r\n\t\t\tlog.setSignDate(new Date());\r\n\t\t\tlogs.add(log);\r\n\t\t}\r\n<\/pre>\n<p>\u6279\u91cf\u63d2\u5165\u4ee3\u7801<\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\r\n        public void insert(Iterable&lt;Log&gt; logs) {\r\n\t\tfor (Log l : logs) {\r\n\t\t\tbaseDao.insert(l);\r\n\t\t}\r\n\t\t\r\n\t}\r\n<\/pre>\n<p>\u7ed3\u679c\uff1a\u767e\u4e07\u6b21\uff0c\u5341\u6b21\u6d4b\u8bd5[679, 703, 620, 564, 698, 700, 678, 686, 711, 619]\u5355\u4f4d\u79d2<br \/>\n\u7b2c\u4e09\u79cd \u62fc\u63a5sql. insert into &#8230; values (&#8230;),(&#8230;),(&#8230;.)<br \/>\n\u8fd9\u79cd\u65b9\u5f0f\u76f4\u63a5\u5361\u6b7b\u3002<br \/>\n\u7b2c\u56db\u79cd batch update<\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\r\n@Override\r\n\tpublic void addBatch(final List&lt;Log&gt; item) {\r\n\t\tString sql = &quot;insert into log (id, token_id, sign_date,jingdu, weidu, address)values (null,?,?,?,?, ?)&quot;;\r\n\t\tJdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\t\tjdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {  \r\n            \/\/ \u4e3aprepared statement\u8bbe\u7f6e\u53c2\u6570\u3002\u8fd9\u4e2a\u65b9\u6cd5\u5c06\u5728\u6574\u4e2a\u8fc7\u7a0b\u4e2d\u88ab\u8c03\u7528\u7684\u6b21\u6570  \r\n            public void setValues(PreparedStatement pst, int i)  \r\n                    throws SQLException {  \r\n            \tLog log = item.get(i);\r\n                pst.setString(1, log.getTokenId());  \r\n                pst.setDate(2,new java.sql.Date(log.getSignDate().getTime()) );\r\n                pst.setDouble(3, log.getJingdu());\r\n                pst.setDouble(4, log.getWeidu());\r\n                pst.setString(5, log.getAddress());  \r\n            }  \r\n  \r\n            \/\/ \u8fd4\u56de\u66f4\u65b0\u7684\u7ed3\u679c\u96c6\u6761\u6570  \r\n            public int getBatchSize() {  \r\n                return item.size();  \r\n            }  \t\r\n        });  \r\n\t}\r\n<\/pre>\n<p>\u7ed3\u679c[211, 216, 243, 234, 235, 238, 237, 224, 222, 226]\u79d2<br \/>\n\u76ee\u524d\u6765\u770b\u8fd8\u662fbatchUpdate\u7684\u6548\u7387\u6700\u9ad8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser&hellip; <a href=\"https:\/\/t2t2.cc\/?p=99\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-data"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"jason\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/t2t2.cc\/?p=99\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_CN\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Jason&#039;s Blog |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/t2t2.cc\/?p=99\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"180\" \/>\n\t\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-05-17T08:21:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-05-17T08:28:20+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#article\",\"name\":\"mysql\\u51e0\\u79cd\\u65b9\\u5f0f\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u6d4b\\u8bd5 | Jason's Blog\",\"headline\":\"mysql\\u51e0\\u79cd\\u65b9\\u5f0f\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u6d4b\\u8bd5\",\"author\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g\",\"width\":96,\"height\":96,\"caption\":\"jason\"},\"datePublished\":\"2016-05-17T16:21:32+08:00\",\"dateModified\":\"2016-05-17T16:28:20+08:00\",\"inLanguage\":\"zh-CN\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#webpage\"},\"articleSection\":\"\\u65e5\\u5fd7\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/t2t2.cc\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?cat=1#listItem\",\"name\":\"\\u65e5\\u5fd7\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?cat=1#listItem\",\"position\":2,\"name\":\"\\u65e5\\u5fd7\",\"item\":\"https:\\\/\\\/t2t2.cc\\\/?cat=1\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#listItem\",\"name\":\"mysql\\u51e0\\u79cd\\u65b9\\u5f0f\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u6d4b\\u8bd5\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#listItem\",\"position\":3,\"name\":\"mysql\\u51e0\\u79cd\\u65b9\\u5f0f\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u6d4b\\u8bd5\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?cat=1#listItem\",\"name\":\"\\u65e5\\u5fd7\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#person\",\"name\":\"jason\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g\",\"width\":96,\"height\":96,\"caption\":\"jason\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?author=1#author\",\"url\":\"https:\\\/\\\/t2t2.cc\\\/?author=1\",\"name\":\"jason\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g\",\"width\":96,\"height\":96,\"caption\":\"jason\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#webpage\",\"url\":\"https:\\\/\\\/t2t2.cc\\\/?p=99\",\"name\":\"mysql\\u51e0\\u79cd\\u65b9\\u5f0f\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u6d4b\\u8bd5 | Jason's Blog\",\"description\":\"\\u6700\\u8fd1\\u597d\\u5947\\u505a\\u4e86\\u4e00\\u4e2a\\u6d4b\\u8bd5\\uff0c\\u4f7f\\u7528spring + mybatis \\u5bf9mysql\\u63d2\\u5165\\u767e\\u6761\\u6570\\u636e\\u3002 \\u7b2c\\u4e00\\u79cd\\uff0c\\u901a\\u8fc7\\u8c03\\u7528ser\",\"inLanguage\":\"zh-CN\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?p=99#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/?author=1#author\"},\"datePublished\":\"2016-05-17T16:21:32+08:00\",\"dateModified\":\"2016-05-17T16:28:20+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#website\",\"url\":\"https:\\\/\\\/t2t2.cc\\\/\",\"name\":\"Jason's Blog\",\"inLanguage\":\"zh-CN\",\"publisher\":{\"@id\":\"https:\\\/\\\/t2t2.cc\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason's Blog","description":"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser","canonical_url":"https:\/\/t2t2.cc\/?p=99","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/t2t2.cc\/?p=99#article","name":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason's Blog","headline":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5","author":{"@id":"https:\/\/t2t2.cc\/?author=1#author"},"publisher":{"@id":"https:\/\/t2t2.cc\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/t2t2.cc\/?p=99#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g","width":96,"height":96,"caption":"jason"},"datePublished":"2016-05-17T16:21:32+08:00","dateModified":"2016-05-17T16:28:20+08:00","inLanguage":"zh-CN","mainEntityOfPage":{"@id":"https:\/\/t2t2.cc\/?p=99#webpage"},"isPartOf":{"@id":"https:\/\/t2t2.cc\/?p=99#webpage"},"articleSection":"\u65e5\u5fd7"},{"@type":"BreadcrumbList","@id":"https:\/\/t2t2.cc\/?p=99#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/#listItem","position":1,"name":"Home","item":"https:\/\/t2t2.cc\/","nextItem":{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/?cat=1#listItem","name":"\u65e5\u5fd7"}},{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/?cat=1#listItem","position":2,"name":"\u65e5\u5fd7","item":"https:\/\/t2t2.cc\/?cat=1","nextItem":{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/?p=99#listItem","name":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5"},"previousItem":{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/?p=99#listItem","position":3,"name":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5","previousItem":{"@type":"ListItem","@id":"https:\/\/t2t2.cc\/?cat=1#listItem","name":"\u65e5\u5fd7"}}]},{"@type":"Person","@id":"https:\/\/t2t2.cc\/#person","name":"jason","image":{"@type":"ImageObject","@id":"https:\/\/t2t2.cc\/?p=99#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g","width":96,"height":96,"caption":"jason"}},{"@type":"Person","@id":"https:\/\/t2t2.cc\/?author=1#author","url":"https:\/\/t2t2.cc\/?author=1","name":"jason","image":{"@type":"ImageObject","@id":"https:\/\/t2t2.cc\/?p=99#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/18561e923c466a267e9ab413a1698a8adf4239af59ca334407d910141fddc8c6?s=96&r=g","width":96,"height":96,"caption":"jason"}},{"@type":"WebPage","@id":"https:\/\/t2t2.cc\/?p=99#webpage","url":"https:\/\/t2t2.cc\/?p=99","name":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason's Blog","description":"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser","inLanguage":"zh-CN","isPartOf":{"@id":"https:\/\/t2t2.cc\/#website"},"breadcrumb":{"@id":"https:\/\/t2t2.cc\/?p=99#breadcrumblist"},"author":{"@id":"https:\/\/t2t2.cc\/?author=1#author"},"creator":{"@id":"https:\/\/t2t2.cc\/?author=1#author"},"datePublished":"2016-05-17T16:21:32+08:00","dateModified":"2016-05-17T16:28:20+08:00"},{"@type":"WebSite","@id":"https:\/\/t2t2.cc\/#website","url":"https:\/\/t2t2.cc\/","name":"Jason's Blog","inLanguage":"zh-CN","publisher":{"@id":"https:\/\/t2t2.cc\/#person"}}]},"og:locale":"zh_CN","og:site_name":"Jason's Blog |","og:type":"article","og:title":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason's Blog","og:description":"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser","og:url":"https:\/\/t2t2.cc\/?p=99","og:image":"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg","og:image:secure_url":"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg","og:image:width":180,"og:image:height":180,"article:published_time":"2016-05-17T08:21:32+00:00","article:modified_time":"2016-05-17T08:28:20+00:00","twitter:card":"summary","twitter:title":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5 | Jason's Blog","twitter:description":"\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser","twitter:image":"https:\/\/t2t2.cc\/wp-content\/uploads\/2016\/12\/47062d21jw8ex2adqbqv3j2050050wes.jpg"},"aioseo_meta_data":{"post_id":"99","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-02 12:43:16","updated":"2026-10-20 19:21:41","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/t2t2.cc\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/t2t2.cc\/?cat=1\" title=\"\u65e5\u5fd7\">\u65e5\u5fd7<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tmysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/t2t2.cc\/"},{"label":"\u65e5\u5fd7","link":"https:\/\/t2t2.cc\/?cat=1"},{"label":"mysql\u51e0\u79cd\u65b9\u5f0f\u63d2\u5165\u767e\u6761\u6570\u636e\u6d4b\u8bd5","link":"https:\/\/t2t2.cc\/?p=99"}],"_links":{"self":[{"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/t2t2.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":2,"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":101,"href":"https:\/\/t2t2.cc\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions\/101"}],"wp:attachment":[{"href":"https:\/\/t2t2.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/t2t2.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/t2t2.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}