\u5728SpringBoot\u9879\u76ee\u4e2d，MyBatis\u4f5c\u4e3a\u6301\u4e45\u5c42\u6846\u67b6\u7684\u6838\u5fc3\u4ef7\u503c\u5728\u4e8e**\u201c\u5e73\u8861\u7075\u6d3b\u6027\u4e0e\u5f00\u53d1\u6548\u7387\u201d**，\u4f53\u73b0\u5728：<\/p>\n
1. \u6570\u636e\u5e93\u8bbf\u95ee\u5c42\u7684\u57fa\u7840\u7ec4\u4ef6；<\/p>\n
2. \u5c06SQL\u8bed\u53e5\u4e0eJava\u65b9\u6cd5\u6620\u5c04；<\/p>\n
3. \u63d0\u4f9b\u52a8\u6001SQL\u80fd\u529b；<\/p>\n
4. \u81ea\u52a8\u914d\u7f6eSqlSessionFactory\u548cMapper\u626b\u63cf；<\/p>\n
5. \u4e0eSpring\u4e8b\u52a1\u7ba1\u7406\u534f\u540c；<\/p>\n
6. \u964d\u4f4eJDBC\u6837\u677f\u4ee3\u7801；<\/p>\n
7. \u652f\u6301\u7075\u6d3b\u7684\u7ed3\u679c\u6620\u5c04；<\/p>\n
8. \u4fbf\u4e8e\u7ef4\u62a4\u548c\u8c03\u4f18SQL\u3002\u6574\u5408\u540e\u5f00\u53d1\u4eba\u5458\u53ea\u9700\u5b9a\u4e49Mapper\u63a5\u53e3\u548cXML\/\u6ce8\u89e3SQL，SpringBoot\u8d1f\u8d23bean\u6ce8\u518c\u3001\u4e8b\u52a1\u3001\u8fde\u63a5\u6c60\u7b49<\/p>\n
\u4ee5\u4e0b\u4ece\u5b9e\u6218\u89d2\u5ea6\u89e3\u6790\u5176\u5177\u4f53\u4f5c\u7528：<\/p>\n
<!– \u6839\u636e\u7528\u6237\u72b6\u6001\u8fc7\u6ee4\u8ba2\u5355，SpringBoot\u8bf7\u6c42\u53c2\u6570\u76f4\u63a5\u6620\u5c04 –>
\n<select id="selectOrders" resultType="Order">
\n SELECT * FROM orders
\n <where>
\n <if test="userId != null">user_id = #{userId}<\/if>
\n <if test="status != null">AND status = #{status}<\/if>
\n <if test="createTime != null">AND create_time > #{createTime}<\/if>
\n <\/where>
\n<\/select><\/p>\n<\/li>\n<\/ul>\n
@Service
\npublic class OrderService {
\n @Autowired
\n -OrderMapper orderMapper;<\/p>\n
@Transactional \/\/ MyBatis\u64cd\u4f5c\u81ea\u52a8\u53c2\u4e0e\u4e8b\u52a1
\n public void updateOrderStatus(Long orderId, status) {
\n orderMapper.updateStatus(orderId, status);
\n \/\/ \u82e5\u629b\u5f02\u5e38，\u81ea\u52a8\u56de\u6edaSQL
\n }
\n}<\/p>\n
\u65e0\u9700\u624b\u52a8\u7ba1\u7406SqlSession\u7684\u63d0\u4ea4\/\u56de\u6eda，\u4e0eSpringBoot\u7684AOP\u673a\u5236\u5b8c\u7f8e\u534f\u540c\u3002<\/p>\n<\/li>\n<\/ul>\n
<resultMap id="UserOrderVO" type="UserOrderVO">
\n <association property="user" column="user_id" select="selectUser"\/>
\n <collection property="orders" column="user_id" select="selectOrdersByUserId"\/>
\n<\/resultMap><\/p>\n
\u76f8\u6bd4JPA\u7684@One\/@Many，SQL\u6267\u884c\u8ba1\u5212\u66f4\u53ef\u63a7（\u907f\u514dN+1\u95ee\u9898）\u3002<\/p>\n<\/li>\n<\/ul>\n
| \n \u573a\u666f\u9700\u6c42<\/p>\n<\/td>\n | \n MyBatis\u4f18\u52bf<\/p>\n<\/td>\n | \n JPA\/\u5176\u4ed6ORM\u7684\u5c40\u9650<\/p>\n<\/td>\n<\/tr>\n |
| \n \u590d\u6742\u591a\u8868\u67e5\u8be2<\/p>\n<\/td>\n | \n \u624b\u5199SQL\u7cbe\u51c6\u63a7\u5236\u8fde\u63a5\u6761\u4ef6\u3001\u805a\u5408\u903b\u8f91<\/p>\n<\/td>\n | \n \u81ea\u52a8\u751f\u6210SQL\u6027\u80fd\u5dee，\u590d\u6742\u67e5\u8be2\u9700\u5199NativeQuery<\/p>\n<\/td>\n<\/tr>\n |
| \n \u9057\u7559\u6570\u636e\u5e93\u5b57\u6bb5\u4e0d\u89c4\u8303<\/p>\n<\/td>\n | \n ResultMap\u7075\u6d3b\u6620\u5c04，\u517c\u5bb9\u65e7\u8868\u7ed3\u6784<\/p>\n<\/td>\n | \n \u5f3a\u4f9d\u8d56\u6ce8\u89e3，\u5b57\u6bb5\u53d8\u66f4\u9700\u6539\u4ee3\u7801<\/p>\n<\/td>\n<\/tr>\n |
| \n \u9ad8\u9891SQL\u6027\u80fd\u4f18\u5316<\/p>\n<\/td>\n | \n \u652f\u6301SQL\u5c42\u9762\u7684\u7d22\u5f15\u4f18\u5316\u3001\u5206\u9875\u4f18\u5316<\/p>\n<\/td>\n | \n \u81ea\u52a8\u5316SQL\u96be\u4f18\u5316，\u6613\u5f15\u53d1\u6027\u80fd\u95ee\u9898<\/p>\n<\/td>\n<\/tr>\n |
| \n \u524d\u540e\u7aef\u8054\u8c03\u5feb\u901f\u8fed\u4ee3<\/p>\n<\/td>\n | \n \u52a8\u6001SQL\u9002\u914d\u53c2\u6570\u53d8\u5316，XML\u70ed\u66f4\u65b0（\u65e0\u9700\u91cd\u542fSpringBoot）<\/p>\n<\/td>\n | \n \u6ce8\u89e3\u4fee\u6539\u9700\u91cd\u542f，\u52a8\u6001\u6761\u4ef6\u62fc\u63a5\u6613\u51fa\u9519<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u9002\u5408\u9879\u76ee\u7c7b\u578b：<\/p>\n
|