{"id":134,"date":"2016-03-21T20:50:23","date_gmt":"2016-03-21T12:50:23","guid":{"rendered":"http:\/\/www.chenweikang.top\/?p=134"},"modified":"2016-03-21T22:03:23","modified_gmt":"2016-03-21T14:03:23","slug":"mybatis%e5%ad%a6%e4%b9%a0%e4%b9%8b%e8%b7%af-%e5%88%86%e9%a1%b5%e5%92%8c%e7%bc%93%e5%ad%98","status":"publish","type":"post","link":"https:\/\/www.chenweikang.top\/?p=134","title":{"rendered":"Mybatis\u5b66\u4e60\u4e4b\u8def\u2014\u5206\u9875\u548c\u7f13\u5b58"},"content":{"rendered":"

\u4f7f\u7528mybatis\u5b9e\u73b0\u5206\u9875<\/h2>\n

1.\u903b\u8f91\u5206\u9875 ( \u6570\u636e\u8868\u52a0\u8f7d\u5230\u5185\u5b58\u4e2d\u5206\u9875 )<\/h3>\n
\n

<!-- \u4f7f\u7528\u903b\u8f91\u5206\u9875
\n\u67e5\u8be2\u6240\u6709\u6570\u636e\u5230\u5185\u5b58
\nmybatis \u4f7f\u7528RowBounds\u8fdb\u884c\u5206\u9875
\n-->
\n<select id=\"findEmps1\" resultMap=\"empRes\" ><\/p>\n

select * from employee<\/p>\n

<\/select><\/p>\n

Junit\u4ee3\u7801<\/h3>\n

@Test
\npublic void testFindEmps1(){<\/p>\n

logger.info(\"\u903b\u8f91\u5206\u9875\uff1a\u67e5\u627e\u96c7\u5458!\");<\/p>\n

RowBounds rowBounds = new RowBounds(0, 4);<\/p>\n

List<Employee> emps= empMapper.findEmps1(rowBounds);<\/p>\n

for (Employee employee : emps) {<\/p>\n

System.out.println(employee);<\/p>\n

}<\/p>\n

sqlSession.commit();<\/p>\n

}<\/p>\n<\/blockquote>\n

2.\u7269\u7406\u5206\u9875 (\u4f20\u9012\u53c2\u6570\u4f7f\u7528mysql\u7684limit\u5b9e\u73b0\u5206\u9875)<\/h3>\n

<!-- \u7269\u7406\u5206\u9875 -->
\n<select id=\"findEmps2\" resultMap=\"empRes\" parameterType=\"Map\">
\nselect * from employee
\n<if test=\"start!=null and size!=null\">
\nlimit #{start},#{size}
\n<\/if>
\n<\/select><\/p>\n

 <\/p>\n

\/\/\u7269\u7406\u5206\u9875\u6d4b\u8bd5
\n@Test
\npublic void testFindEmps2(){<\/p>\n

logger.info(\"\u7269\u7406\u5206\u9875\uff1a\u67e5\u627e\u96c7\u5458!\");<\/p>\n

Map<String ,Object> page = new HashMap<>();<\/p>\n

page.put(\"start\", 3);<\/p>\n

page.put(\"size\", 3);<\/p>\n

List<Employee> emps= empMapper.findEmps2(page);<\/p>\n

for (Employee employee : emps) {<\/p>\n

System.out.println(employee);<\/p>\n

}<\/p>\n

}<\/p>\n<\/blockquote>\n

 <\/p>\n

mybatis \u7f13\u5b58\u914d\u7f6e<\/h2>\n

Mybatis\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u542f\u7528\u4e00\u7ea7\u7f13\u5b58 \uff0c
\n\u7528\u6237\u53ef\u4ee5\u81ea\u5df1\u914d\u7f6e\u4e8c\u7ea7\u7f13\u5b58(\u5168\u5c40)
\n\u9ed8\u8ba4\u60c5\u51b5\u4e0b select\u67e5\u8be2\u4f7f\u7528\u7f13\u5b58 ,insert,update,delete \u4e0d
\n\u4f7f\u7528\u7f13\u5b58<\/h3>\n

\u53ef\u5728mepper\u4e2d\u914d\u7f6e\u7f13\u5b58
\n<!--
\nsize=1024 :\u5b9a\u4e49\u7f13\u5b58\u5927\u5c0f \u9ed8\u8ba41024
\nflushInterval=\"60000\" : \u7f13\u5b58\u5237\u65b0\u5468\u671f ms
\neviction=\"LRU\" :\u7f13\u5b58\u79fb\u9664\u673a\u5236 LRU(\u6700\u8fd1\u6700\u5c11\u4f7f\u7528),\u8fd8\u6709FIFO
\nreadOnly=fase: \u7f13\u5b58\u53ef\u8bfb\u5199
\n-->
\n<cache size=\"1024\" flushInterval=\"60000\" eviction=\"LRU\" readOnly=\"false\" \/><\/p>\n

 <\/p>\n

\u4e5f\u53ef\u5728select update \u7b49\u6807\u7b7e\u4e2d\u4f7f\u7528 useCache \u6307\u5b9a<\/p>\n

 <\/p><\/blockquote>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u5de6\u624b\u4ee3\u7801\u53f3\u624b\u8bd7<\/a> » Mybatis\u5b66\u4e60\u4e4b\u8def\u2014\u5206\u9875\u548c\u7f13\u5b58<\/a><\/p>

\r\n
\r\n
~\u8c22\u8c22\u6253\u8d4f~<\/div>\r\n
<\/div>
<\/div>
<\/div><\/div>\r\n