{"id":105616,"date":"2026-09-15T18:56:26","date_gmt":"2026-09-15T10:56:26","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/105616.html"},"modified":"2026-09-15T18:56:26","modified_gmt":"2026-09-15T10:56:26","slug":"mybatis-%e5%9f%ba%e7%a1%80%e5%85%a5%e9%97%a8%e4%b8%8e-crud-%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/105616.html","title":{"rendered":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3"},"content":{"rendered":"

MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3<\/h2>\n

\u5b9a\u4f4d：MyBatis \u7cfb\u5217\u7b2c 1 \u7bc7：\u5feb\u901f\u5165\u95e8\u3001\u5168\u5c40\u914d\u7f6e\u3001Mapper \u6620\u5c04\u3001\u53c2\u6570\u4f20\u9012\u3001\u4e3b\u952e\u56de\u586b\u4e0e\u57fa\u7840 CRUD \u9002\u7528\u7248\u672c：MyBatis 3.5.x（JDK 8+）<\/p>\n

\n

\u76ee\u5f55<\/h3>\n
  • MyBatis \u6982\u8ff0<\/li>\n
  • \u5feb\u901f\u5165\u95e8\u4e0e SqlSession \u4f7f\u7528<\/li>\n
  • \u5168\u5c40\u914d\u7f6e\u57fa\u7840<\/li>\n
  • Mapper \u6620\u5c04\u65b9\u5f0f<\/li>\n
  • \u53c2\u6570\u4f20\u9012<\/li>\n
  • #{} \u4e0e ${}<\/li>\n
  • \u4e3b\u952e\u56de\u586b<\/li>\n
  • \u57fa\u7840 CRUD \u6a21\u677f<\/li>\n
  • \u603b\u7ed3<\/li>\n
  • \u5e38\u89c1\u9ad8\u9891\u9762\u8bd5\u9898<\/li>\n
    \n

    \u4e00\u3001MyBatis \u6982\u8ff0<\/h3>\n

    1.1 \u5386\u53f2\u6f14\u8fdb<\/h4>\n

    MyBatis \u7684\u524d\u8eab\u662f iBATIS，\u540d\u79f0\u6765\u6e90\u4e8e \u201cInternet\u201d \u4e0e \u201cAbatis\u201d（\u9e7f\u7826，\u4e00\u79cd\u9632\u5fa1\u5de5\u4e8b）\u7684\u7ec4\u5408，\u5bd3\u610f\u300c\u4e92\u8054\u7f51\u7684\u6301\u4e45\u5c42\u9632\u7ebf\u300d\u3002<\/p>\n\n\u65f6\u95f4\u4e8b\u4ef6<\/tr>\n\n\n\n\n\n\n
    2002<\/td>\nClinton Begin \u5f00\u6e90 iBATIS \u9879\u76ee<\/td>\n<\/tr>\n
    2004<\/td>\n\u9879\u76ee\u6350\u8d60\u7ed9 Apache \u57fa\u91d1\u4f1a，\u66f4\u540d Apache iBATIS<\/td>\n<\/tr>\n
    2010<\/td>\n\u9879\u76ee\u4ece Apache \u8fc1\u51fa，\u66f4\u540d MyBatis；\u540c\u5e74\u53d1\u5e03 MyBatis 3，\u5f15\u5165 Mapper \u63a5\u53e3 + \u52a8\u6001\u4ee3\u7406\u7684\u65b0\u67b6\u6784<\/td>\n<\/tr>\n
    2016<\/td>\nMyBatis 3.4.x：\u6ce8\u89e3\u4e2d\u652f\u6301 <script> \u52a8\u6001 SQL，\u539f\u751f\u652f\u6301 Java 8 \u65e5\u671f\u65f6\u95f4\u7c7b\u578b（JSR-310）<\/td>\n<\/tr>\n
    2019<\/td>\nMyBatis 3.5.x \u53d1\u5e03，\u6700\u4f4e\u8981\u6c42 JDK 8；3.5.x \u7cfb\u5217\u6301\u7eed\u7ef4\u62a4\u81f3\u4eca<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u751f\u6001\u7248\u56fe：<\/p>\n\n\u9879\u76ee\u5b9a\u4f4d<\/tr>\n\n\n\n\n\n\n
    MyBatis \u6838\u5fc3\u6846\u67b6<\/td>\nSQL \u6620\u5c04\u5f15\u64ce\u672c\u4f53（\u672c\u7bc7\u5f00\u59cb\u8bb2\u89e3）<\/td>\n<\/tr>\n
    MyBatis-Spring<\/td>\nSpring \u6574\u5408（\u89c1\u7cfb\u5217 06 \u7bc7）<\/td>\n<\/tr>\n
    MyBatis-Spring-Boot-Starter<\/td>\nSpring Boot \u81ea\u52a8\u88c5\u914d（\u89c1\u7cfb\u5217 06 \u7bc7）<\/td>\n<\/tr>\n
    MyBatis-Plus<\/td>\n\u56fd\u4ea7\u589e\u5f3a\u5de5\u5177：\u514d SQL \u5355\u8868 CRUD（\u89c1\u7cfb\u5217 07 \u7bc7）<\/td>\n<\/tr>\n
    PageHelper<\/td>\n\u7b2c\u4e09\u65b9\u5206\u9875\u63d2\u4ef6（\u539f\u7406\u89c1\u7cfb\u5217 05 \u7bc7）<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    1.2 \u5b9a\u4f4d：\u534a\u81ea\u52a8\u5316 ORM<\/h4>\n

    ORM（\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04）\u6846\u67b6\u6309\u300cSQL \u7531\u8c01\u63a7\u5236\u300d\u5206\u4e3a\u4e24\u7c7b：<\/p>\n\n\u7c7b\u522b\u4ee3\u8868SQL \u63a7\u5236\u6743\u7279\u70b9<\/tr>\n\n\n\n
    \u5168\u81ea\u52a8 ORM<\/td>\nHibernate\u3001JPA \u5b9e\u73b0（EclipseLink \u7b49）<\/td>\n\u6846\u67b6\u6839\u636e\u5bf9\u8c61\u6a21\u578b\u81ea\u52a8\u751f\u6210 SQL<\/td>\n\u5f00\u53d1\u6548\u7387\u9ad8；\u590d\u6742 SQL \u96be\u4ee5\u7cbe\u7ec6\u63a7\u5236<\/td>\n<\/tr>\n
    \u534a\u81ea\u52a8 ORM<\/td>\nMyBatis<\/td>\n\u5f00\u53d1\u8005\u624b\u5199 SQL，\u6846\u67b6\u8d1f\u8d23\u53c2\u6570\u6620\u5c04\u4e0e\u7ed3\u679c\u6620\u5c04<\/td>\nSQL \u5b8c\u5168\u53ef\u63a7\u3001\u4fbf\u4e8e\u4f18\u5316；\u6620\u5c04\u4ee3\u7801\u7531\u6846\u67b6\u6258\u7ba1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    MyBatis \u5b98\u65b9\u6587\u6863\u5bf9\u5176\u5b9a\u4f4d\u662f\u300c\u652f\u6301\u81ea\u5b9a\u4e49 SQL\u3001\u5b58\u50a8\u8fc7\u7a0b\u548c\u9ad8\u7ea7\u6620\u5c04\u7684\u6301\u4e45\u5c42\u6846\u67b6\u300d\u3002\u5b83\u6d88\u9664\u4e86\u51e0\u4e4e\u5168\u90e8 JDBC \u6837\u677f\u4ee3\u7801：<\/p>\n

    \/\/ \u88f8 JDBC：\u7ea6 20 \u884c\u6837\u677f\u4ee3\u7801<\/span>
    \nConnection<\/span> conn =<\/span> dataSource.<\/span>getConnection<\/span>(<\/span>)<\/span>;<\/span>
    \nPreparedStatement<\/span> ps =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>"SELECT id, name FROM user WHERE id = ?"<\/span>)<\/span>;<\/span>
    \nps.<\/span>setLong<\/span>(<\/span>1<\/span>,<\/span> 1L<\/span>)<\/span>;<\/span>
    \nResultSet<\/span> rs =<\/span> ps.<\/span>executeQuery<\/span>(<\/span>)<\/span>;<\/span>
    \nUser<\/span> user =<\/span> null<\/span>;<\/span>
    \nif<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
    \n user =<\/span> new<\/span> User<\/span>(<\/span>)<\/span>;<\/span>
    \n user.<\/span>setId<\/span>(<\/span>rs.<\/span>getLong<\/span>(<\/span>"id"<\/span>)<\/span>)<\/span>;<\/span>
    \n user.<\/span>setName<\/span>(<\/span>rs.<\/span>getString<\/span>(<\/span>"name"<\/span>)<\/span>)<\/span>;<\/span>
    \n}<\/span>
    \nrs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span> ps.<\/span>close<\/span>(<\/span>)<\/span>;<\/span> conn.<\/span>close<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u8fd8\u6709\u5f02\u5e38\u5904\u7406\u3001\u4e8b\u52a1\u2026\u2026<\/span><\/p>\n

    \/\/ MyBatis：\u4e00\u884c\u8c03\u7528 + \u4e00\u4efd\u6620\u5c04\u6587\u4ef6<\/span>
    \nUser<\/span> user =<\/span> userMapper.<\/span>selectById<\/span>(<\/span>1L<\/span>)<\/span>;<\/span><\/p>\n

    1.3 \u540c\u7c7b\u4ea7\u54c1\u5bf9\u6bd4\u4e0e\u9009\u578b<\/h4>\n\n\u7ef4\u5ea6MyBatisHibernate\/JPASpring JdbcTemplateSpring Data JDBC<\/tr>\n\n\n\n\n\n\n\n
    \u62bd\u8c61\u5c42\u7ea7<\/td>\n\u534a\u81ea\u52a8 ORM<\/td>\n\u5168\u81ea\u52a8 ORM<\/td>\nJDBC \u8584\u5c01\u88c5<\/td>\n\u8f7b\u91cf ORM<\/td>\n<\/tr>\n
    SQL \u63a7\u5236<\/td>\n\u624b\u5199，\u5b8c\u5168\u53ef\u63a7<\/td>\nHQL\/JPQL + \u81ea\u52a8\u751f\u6210<\/td>\n\u624b\u5199<\/td>\n\u90e8\u5206\u81ea\u52a8\u751f\u6210<\/td>\n<\/tr>\n
    \u5bf9\u8c61\u6620\u5c04<\/td>\nresultMap \u663e\u5f0f\/\u81ea\u52a8\u9a7c\u5cf0<\/td>\n\u6ce8\u89e3\u5b9e\u4f53\u5168\u81ea\u52a8\u6620\u5c04<\/td>\n\u624b\u5199 RowMapper<\/td>\n\u6ce8\u89e3\u5b9e\u4f53\u6620\u5c04<\/td>\n<\/tr>\n
    \u7f13\u5b58<\/td>\n\u4e00\u7ea7\/\u4e8c\u7ea7\u7f13\u5b58<\/td>\n\u4e00\u7ea7\/\u4e8c\u7ea7\u7f13\u5b58 + \u67e5\u8be2\u7f13\u5b58<\/td>\n\u65e0<\/td>\n\u65e0<\/td>\n<\/tr>\n
    \u5b66\u4e60\u66f2\u7ebf<\/td>\n\u5e73\u7f13（\u4f1a SQL \u5373\u53ef\u5165\u95e8）<\/td>\n\u8f83\u9661（\u9700\u7406\u89e3\u6301\u4e45\u5316\u4e0a\u4e0b\u6587）<\/td>\n\u6781\u4f4e<\/td>\n\u4f4e<\/td>\n<\/tr>\n
    \u5178\u578b\u573a\u666f<\/td>\n\u590d\u6742\u67e5\u8be2\u591a\u3001SQL \u9700 DBA \u5ba1\u67e5\u4f18\u5316<\/td>\n\u9886\u57df\u6a21\u578b\u7a33\u5b9a\u3001CRUD \u5bc6\u96c6<\/td>\n\u7b80\u5355\u9879\u76ee\u3001\u4e34\u65f6\u811a\u672c<\/td>\n\u805a\u5408\u6839\u6a21\u578b\u7684\u8f7b\u91cf\u6301\u4e45\u5316<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u9009\u578b\u7ecf\u9a8c：\u4e92\u8054\u7f51\u4e1a\u52a1\u7cfb\u7edf\u4e2d\u8868\u7ed3\u6784\u53d8\u66f4\u9891\u7e41\u3001\u67e5\u8be2\u590d\u6742\u5ea6\u9ad8\u3001\u9700\u8981\u7cbe\u7ec6 SQL \u8c03\u4f18，MyBatis \u662f\u56fd\u5185\u4e3b\u6d41\u9009\u62e9；\u82e5\u9886\u57df\u6a21\u578b\u7a33\u5b9a\u4e14\u4ee5\u5355\u5b9e\u4f53 CRUD \u4e3a\u4e3b，JPA \u6548\u7387\u66f4\u9ad8\u3002\u4e8c\u8005\u5e76\u975e\u4e92\u65a5，\u540c\u4e00\u7cfb\u7edf\u53ef\u6df7\u5408\u4f7f\u7528\u3002ORM \u901a\u7528\u539f\u7406\u4e0e\u9009\u578b\u65b9\u6cd5\u8bba\u89c1\u300a01-ORM\u6846\u67b6\u77e5\u8bc6\u70b9\u8be6\u89e3\u300b\u3002<\/p>\n

    1.4 \u6838\u5fc3\u4ef7\u503c<\/h4>\n
  • SQL \u4e0e\u4ee3\u7801\u5206\u79bb：SQL \u96c6\u4e2d\u5728 XML\/\u6ce8\u89e3\u4e2d\u7ba1\u7406，\u4fbf\u4e8e\u5ba1\u67e5\u3001\u4f18\u5316\u4e0e\u590d\u7528\u3002<\/li>\n
  • \u6d88\u9664 JDBC \u6837\u677f：\u8fde\u63a5\u83b7\u53d6\u3001\u53c2\u6570\u7ed1\u5b9a\u3001\u7ed3\u679c\u96c6\u904d\u5386\u5168\u90e8\u7531\u6846\u67b6\u6258\u7ba1\u3002<\/li>\n
  • \u52a8\u6001 SQL：\u58f0\u660e\u5f0f\u6807\u7b7e\u66ff\u4ee3\u624b\u5de5\u5b57\u7b26\u4e32\u62fc\u63a5，\u5929\u7136\u89c4\u907f\u6ce8\u5165\u98ce\u9669（\u89c1 02 \u7bc7）\u3002<\/li>\n
  • \u53ef\u6269\u5c55\u6027：\u63d2\u4ef6\u673a\u5236\u63d0\u4f9b\u6267\u884c\u94fe\u8def\u4e0a\u7684\u62e6\u622a\u70b9（\u89c1 05 \u7bc7）\u3002<\/li>\n
    \n

    \u4e8c\u3001\u5feb\u901f\u5165\u95e8\u4e0e SqlSession \u4f7f\u7528<\/h3>\n

    2.1 \u6700\u5c0f\u8fd0\u884c\u73af\u5883<\/h4>\n

    \u8131\u79bb Spring \u7684\u539f\u751f MyBatis \u9700\u8981\u56db\u6837\u4e1c\u897f：\u4f9d\u8d56\u3001\u5168\u5c40\u914d\u7f6e\u3001Mapper XML\u3001\u5b9e\u4f53\u7c7b\u3002<\/p>\n

    <!– pom.xml –><\/span>
    \n<<\/span>dependency<\/span>><\/span><\/span>
    \n <<\/span>groupId<\/span>><\/span><\/span>org.mybatis<\/<\/span>groupId<\/span>><\/span><\/span>
    \n <<\/span>artifactId<\/span>><\/span><\/span>mybatis<\/<\/span>artifactId<\/span>><\/span><\/span>
    \n <<\/span>version<\/span>><\/span><\/span>3.5.16<\/<\/span>version<\/span>><\/span><\/span>
    \n<\/<\/span>dependency<\/span>><\/span><\/span>
    \n<<\/span>dependency<\/span>><\/span><\/span>
    \n <<\/span>groupId<\/span>><\/span><\/span>com.mysql<\/<\/span>groupId<\/span>><\/span><\/span>
    \n <<\/span>artifactId<\/span>><\/span><\/span>mysql-connector-j<\/<\/span>artifactId<\/span>><\/span><\/span>
    \n <<\/span>version<\/span>><\/span><\/span>8.4.0<\/<\/span>version<\/span>><\/span><\/span>
    \n<\/<\/span>dependency<\/span>><\/span><\/span><\/p>\n

    \u5b9e\u4f53\u7c7b\u4e0e\u8868\u7ed3\u6784\u5bf9\u5e94：<\/p>\n

    public<\/span> class<\/span> User<\/span> {<\/span>
    \n private<\/span> Long<\/span> id;<\/span>
    \n private<\/span> String<\/span> name;<\/span>
    \n private<\/span> String<\/span> email;<\/span>
    \n private<\/span> LocalDateTime<\/span> createTime;<\/span>
    \n \/\/ getter\/setter \u7701\u7565<\/span>
    \n}<\/span><\/p>\n

    2.2 \u6838\u5fc3 API \u4e24\u4ef6\u5957<\/h4>\n

    SqlSessionFactoryBuilder \u2500\u2500\u89e3\u6790\u914d\u7f6e\u2500\u2500\u2192 SqlSessionFactory \u2500\u2500openSession\u2500\u2500\u2192 SqlSession
    \n （\u5e94\u7528\u7ea7\u5355\u4f8b\u3001\u91cd\u91cf\u7ea7） （\u975e\u7ebf\u7a0b\u5b89\u5168\u3001\u7528\u5b8c\u5373\u5173）<\/p>\n\nAPI\u751f\u547d\u5468\u671f\u7ebf\u7a0b\u5b89\u5168\u4f7f\u7528\u7eaa\u5f8b<\/tr>\n\n\n\n\n
    SqlSessionFactoryBuilder<\/td>\n\u7528\u5b8c\u5373\u5f03<\/td>\n\u5426<\/td>\n\u6784\u5efa\u5b8c Factory \u540e\u53ef\u4e22\u5f03<\/td>\n<\/tr>\n
    SqlSessionFactory<\/td>\n\u5e94\u7528\u7ea7\u5355\u4f8b<\/td>\n\u662f<\/td>\n\u5168\u5c40\u4e00\u4e2a，\u91cd\u590d\u521b\u5efa\u662f\u5178\u578b\u53cd\u6a21\u5f0f<\/td>\n<\/tr>\n
    SqlSession<\/td>\n\u8bf7\u6c42\/\u4f1a\u8bdd\u7ea7<\/td>\n\u5426<\/td>\n\u5fc5\u987b try-with-resources \u5173\u95ed，\u7981\u6b62\u4f5c\u4e3a\u6210\u5458\u53d8\u91cf\u5171\u4eab<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    2.3 \u539f\u751f\u4f7f\u7528\u5b8c\u6574\u6d41\u7a0b<\/h4>\n

    public<\/span> class<\/span> MyBatisDemo<\/span> {<\/span><\/p>\n

    private<\/span> static<\/span> final<\/span> SqlSessionFactory<\/span> FACTORY<\/span>;<\/span><\/p>\n

    static<\/span> {<\/span>
    \n try<\/span> (<\/span>InputStream<\/span> in =<\/span> Resources<\/span>.<\/span>getResourceAsStream<\/span>(<\/span>"mybatis-config.xml"<\/span>)<\/span>)<\/span> {<\/span>
    \n FACTORY<\/span> =<\/span> new<\/span> SqlSessionFactoryBuilder<\/span>(<\/span>)<\/span>.<\/span>build<\/span>(<\/span>in)<\/span>;<\/span>
    \n }<\/span> catch<\/span> (<\/span>IOException<\/span> e)<\/span> {<\/span>
    \n throw<\/span> new<\/span> ExceptionInInitializerError<\/span>(<\/span>e)<\/span>;<\/span>
    \n }<\/span>
    \n }<\/span><\/p>\n

    public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[<\/span>]<\/span> args)<\/span> {<\/span>
    \n \/\/ \u67e5\u8be2<\/span>
    \n try<\/span> (<\/span>SqlSession<\/span> session =<\/span> FACTORY<\/span>.<\/span>openSession<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
    \n UserMapper<\/span> mapper =<\/span> session.<\/span>getMapper<\/span>(<\/span>UserMapper<\/span>.<\/span>class<\/span>)<\/span>;<\/span>
    \n User<\/span> user =<\/span> mapper.<\/span>selectById<\/span>(<\/span>1L<\/span>)<\/span>;<\/span>
    \n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>user.<\/span>getName<\/span>(<\/span>)<\/span>)<\/span>;<\/span>
    \n }<\/span><\/p>\n

    \/\/ \u5199\u64cd\u4f5c：openSession() \u9ed8\u8ba4 autoCommit=false，\u9700\u624b\u52a8 commit<\/span>
    \n try<\/span> (<\/span>SqlSession<\/span> session =<\/span> FACTORY<\/span>.<\/span>openSession<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
    \n UserMapper<\/span> mapper =<\/span> session.<\/span>getMapper<\/span>(<\/span>UserMapper<\/span>.<\/span>class<\/span>)<\/span>;<\/span>
    \n User<\/span> u =<\/span> new<\/span> User<\/span>(<\/span>)<\/span>;<\/span>
    \n u.<\/span>setName<\/span>(<\/span>"\u5f20\u4e09"<\/span>)<\/span>;<\/span>
    \n u.<\/span>setEmail<\/span>(<\/span>"zhangsan@example.com"<\/span>)<\/span>;<\/span>
    \n mapper.<\/span>insert<\/span>(<\/span>u)<\/span>;<\/span>
    \n session.<\/span>commit<\/span>(<\/span>)<\/span>;<\/span>
    \n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u65b0\u4e3b\u952e："<\/span> +<\/span> u.<\/span>getId<\/span>(<\/span>)<\/span>)<\/span>;<\/span> \/\/ \u5df2\u56de\u586b<\/span>
    \n }<\/span>
    \n }<\/span>
    \n}<\/span><\/p>\n

    \u8981\u70b9：<\/p>\n

      \n
    • session.getMapper(UserMapper.class) \u8fd4\u56de\u7684\u662f JDK \u52a8\u6001\u4ee3\u7406\u5bf9\u8c61，Mapper \u63a5\u53e3\u65e0\u9700\u5b9e\u73b0\u7c7b（\u4ee3\u7406\u539f\u7406\u89c1\u7cfb\u5217 03 \u7bc7）\u3002<\/li>\n
    • \u539f\u751f\u6a21\u5f0f\u4e0b\u5199\u64cd\u4f5c\u4e0d\u63d0\u4ea4\u4e0d\u751f\u6548；Spring \u6574\u5408\u540e\u7531\u4e8b\u52a1\u7ba1\u7406\u5668\u6258\u7ba1，\u65e0\u9700\u624b\u52a8 commit（\u89c1\u7cfb\u5217 06 \u7bc7）\u3002<\/li>\n
    • SqlSession \u8fd8\u63d0\u4f9b\u66f4\u5e95\u5c42\u7684\u95e8\u9762 API（selectOne\/selectList\/insert\/update\/delete，\u4ee5 statementId \u8c03\u7528），\u5b9e\u9645\u5f00\u53d1\u7edf\u4e00\u8d70 Mapper \u63a5\u53e3\u3002<\/li>\n<\/ul>\n
      \n

      \u4e09\u3001\u5168\u5c40\u914d\u7f6e\u57fa\u7840<\/h3>\n

      3.1 mybatis-config.xml \u7ed3\u6784<\/h4>\n

      <?xml version="1.0" encoding="UTF-8" ?><\/span>
      \n<!<\/span>DOCTYPE<\/span> configuration<\/span> PUBLIC<\/span> "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN"<\/span>
      \n "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd"<\/span>><\/span><\/span>
      \n<<\/span>configuration<\/span>><\/span><\/span>
      \n <!– \u5143\u7d20\u987a\u5e8f\u56fa\u5b9a：properties \u2192 settings \u2192 typeAliases \u2192 typeHandlers
      \n \u2192 objectFactory \u2192 plugins \u2192 environments \u2192 mappers，\u4e71\u5e8f\u4f1a\u89e3\u6790\u62a5\u9519 –><\/span><\/p>\n

      <<\/span>settings<\/span>><\/span><\/span>
      \n <<\/span>setting<\/span> name<\/span>=<\/span>"<\/span>mapUnderscoreToCamelCase"<\/span><\/span> value<\/span>=<\/span>"<\/span>true"<\/span><\/span>\/><\/span><\/span>
      \n <<\/span>setting<\/span> name<\/span>=<\/span>"<\/span>logImpl"<\/span><\/span> value<\/span>=<\/span>"<\/span>SLF4J"<\/span><\/span>\/><\/span><\/span>
      \n <\/<\/span>settings<\/span>><\/span><\/span><\/p>\n

      <<\/span>typeAliases<\/span>><\/span><\/span>
      \n <<\/span>package<\/span> name<\/span>=<\/span>"<\/span>com.example.entity"<\/span><\/span>\/><\/span><\/span>
      \n <\/<\/span>typeAliases<\/span>><\/span><\/span><\/p>\n

      <<\/span>environments<\/span> default<\/span>=<\/span>"<\/span>development"<\/span><\/span>><\/span><\/span>
      \n <<\/span>environment<\/span> id<\/span>=<\/span>"<\/span>development"<\/span><\/span>><\/span><\/span>
      \n <<\/span>transactionManager<\/span> type<\/span>=<\/span>"<\/span>JDBC"<\/span><\/span>\/><\/span><\/span>
      \n <<\/span>dataSource<\/span> type<\/span>=<\/span>"<\/span>POOLED"<\/span><\/span>><\/span><\/span>
      \n <<\/span>property<\/span> name<\/span>=<\/span>"<\/span>driver"<\/span><\/span> value<\/span>=<\/span>"<\/span>com.mysql.cj.jdbc.Driver"<\/span><\/span>\/><\/span><\/span>
      \n <<\/span>property<\/span> name<\/span>=<\/span>"<\/span>url"<\/span><\/span> value<\/span>=<\/span>"<\/span>jdbc:mysql:\/\/localhost:3306\/demo"<\/span><\/span>\/><\/span><\/span>
      \n <<\/span>property<\/span> name<\/span>=<\/span>"<\/span>username"<\/span><\/span> value<\/span>=<\/span>"<\/span>root"<\/span><\/span>\/><\/span><\/span>
      \n <<\/span>property<\/span> name<\/span>=<\/span>"<\/span>password"<\/span><\/span> value<\/span>=<\/span>"<\/span>******"<\/span><\/span>\/><\/span><\/span>
      \n <\/<\/span>dataSource<\/span>><\/span><\/span>
      \n <\/<\/span>environment<\/span>><\/span><\/span>
      \n <\/<\/span>environments<\/span>><\/span><\/span><\/p>\n

      <<\/span>mappers<\/span>><\/span><\/span>
      \n <<\/span>package<\/span> name<\/span>=<\/span>"<\/span>com.example.mapper"<\/span><\/span>\/><\/span><\/span>
      \n <\/<\/span>mappers<\/span>><\/span><\/span>
      \n<\/<\/span>configuration<\/span>><\/span><\/span><\/p>\n

      3.2 environments \u73af\u5883\u914d\u7f6e<\/h4>\n
        \n
      • default \u5c5e\u6027\u51b3\u5b9a\u6fc0\u6d3b\u54ea\u4e2a environment（\u5982 development\/production）\u3002<\/li>\n
      • transactionManager：\n
          \n
        • JDBC：MyBatis \u76f4\u63a5\u8c03\u7528 Connection \u7684 commit\/rollback；<\/li>\n
        • MANAGED：\u4e8b\u52a1\u7531\u5bb9\u5668（\u5982 Spring\u3001\u5e94\u7528\u670d\u52a1\u5668）\u6258\u7ba1，MyBatis \u4e0d\u63d0\u4ea4\u3002<\/li>\n<\/ul>\n<\/li>\n
        • dataSource \u7c7b\u578b：<\/li>\n<\/ul>\n\n\u7c7b\u578b\u8bf4\u660e\u9002\u7528<\/tr>\n\n\n\n\n
          UNPOOLED<\/td>\n\u6bcf\u6b21\u65b0\u5efa\u8fde\u63a5，\u65e0\u6c60\u5316<\/td>\n\u4ec5\u6d4b\u8bd5<\/td>\n<\/tr>\n
          POOLED<\/td>\n\u5185\u7f6e\u8fde\u63a5\u6c60（poolMaximumActiveConnections \u9ed8\u8ba4 10 \u7b49\u53c2\u6570\u53ef\u8c03）<\/td>\n\u7b80\u5355\u5e94\u7528<\/td>\n<\/tr>\n
          JNDI<\/td>\n\u4ece\u5e94\u7528\u670d\u52a1\u5668 JNDI \u67e5\u627e\u6570\u636e\u6e90<\/td>\n\u4f20\u7edf JavaEE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          \u751f\u4ea7\u5b9e\u8df5：\u4ee5\u4e0a\u4e09\u79cd\u90fd\u4f1a\u88ab Druid\/HikariCP \u7b49\u4e13\u4e1a\u8fde\u63a5\u6c60\u66ff\u4ee3\u2014\u2014\u901a\u8fc7 Spring \u6574\u5408\u65f6 DataSource \u7531 Spring \u7ba1\u7406，mybatis-config.xml \u4e2d\u7684 environments \u6574\u8282\u4e0d\u518d\u9700\u8981（\u89c1\u7cfb\u5217 06 \u7bc7）\u3002<\/p>\n

          3.3 \u5e38\u7528 settings（\u5165\u95e8\u5fc5\u77e5\u9879）<\/h4>\n\n\u914d\u7f6e\u9879\u9ed8\u8ba4\u503c\u8bf4\u660e<\/tr>\n\n\n\n\n\n\n\n
          mapUnderscoreToCamelCase<\/td>\nfalse<\/td>\n\u4e0b\u5212\u7ebf\u5217\u540d\u81ea\u52a8\u8f6c\u9a7c\u5cf0\u5c5e\u6027，\u5f3a\u70c8\u5efa\u8bae\u5f00\u542f，\u5426\u5219 create_time \u6620\u5c04\u4e0d\u5230 createTime<\/td>\n<\/tr>\n
          useGeneratedKeys<\/td>\nfalse<\/td>\n\u5168\u5c40\u5141\u8bb8\u4e3b\u952e\u56de\u586b<\/td>\n<\/tr>\n
          cacheEnabled<\/td>\ntrue<\/td>\n\u4e8c\u7ea7\u7f13\u5b58\u603b\u5f00\u5173（\u751f\u4ea7\u5efa\u8bae\u5173\u95ed，\u89c1\u7cfb\u5217 04 \u7bc7）<\/td>\n<\/tr>\n
          lazyLoadingEnabled<\/td>\nfalse（3.4.1+）<\/td>\n\u5d4c\u5957\u67e5\u8be2\u5ef6\u8fdf\u52a0\u8f7d\u5168\u5c40\u5f00\u5173（\u89c1 02 \u7bc7）<\/td>\n<\/tr>\n
          logImpl<\/td>\n\u81ea\u52a8\u63a2\u6d4b<\/td>\n\u6307\u5b9a\u65e5\u5fd7\u5b9e\u73b0；\u5f00\u53d1\u6392\u969c\u53ef\u4e34\u65f6\u8bbe STDOUT_LOGGING \u6253\u5370 SQL<\/td>\n<\/tr>\n
          defaultExecutorType<\/td>\nSIMPLE<\/td>\nSIMPLE\/REUSE\/BATCH（\u539f\u7406\u89c1 03 \u7bc7）<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          3.4 typeAliases \u7c7b\u578b\u522b\u540d<\/h4>\n

          <<\/span>typeAliases<\/span>><\/span><\/span>
          \n <<\/span>typeAlias<\/span> type<\/span>=<\/span>"<\/span>com.example.entity.User"<\/span><\/span> alias<\/span>=<\/span>"<\/span>user"<\/span><\/span>\/><\/span><\/span>
          \n <<\/span>package<\/span> name<\/span>=<\/span>"<\/span>com.example.entity"<\/span><\/span>\/><\/span><\/span> <!– \u6279\u91cf\u6ce8\u518c：\u522b\u540d=\u7c7b\u540d\u9996\u5b57\u6bcd\u5c0f\u5199，@Alias \u53ef\u81ea\u5b9a\u4e49 –><\/span>
          \n<\/<\/span>typeAliases<\/span>><\/span><\/span><\/p>\n

          \u4f5c\u7528\u4ec5\u662f\u7b80\u5316 XML \u4e66\u5199：resultType="user" \u7b49\u4ef7\u4e8e resultType="com.example.entity.User"\u3002\u57fa\u672c\u7c7b\u578b\u522b\u540d（int\u3001string\u3001map\u3001list \u7b49）\u5185\u7f6e\u53ef\u7528\u4e14\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u3002<\/p>\n

          3.5 mappers \u6620\u5c04\u6ce8\u518c<\/h4>\n

          <<\/span>mappers<\/span>><\/span><\/span>
          \n <<\/span>mapper<\/span> resource<\/span>=<\/span>"<\/span>mapper\/UserMapper.xml"<\/span><\/span>\/><\/span><\/span> <!– \u7c7b\u8def\u5f84\u6587\u4ef6 –><\/span>
          \n <<\/span>mapper<\/span> url<\/span>=<\/span>"<\/span>file:\/\/\/opt\/app\/mapper\/OrderMapper.xml"<\/span><\/span>\/><\/span><\/span><!– \u7edd\u5bf9\u8def\u5f84 –><\/span>
          \n <<\/span>mapper<\/span> class<\/span>=<\/span>"<\/span>com.example.mapper.UserMapper"<\/span><\/span>\/><\/span><\/span> <!– \u6ce8\u89e3 Mapper –><\/span>
          \n <<\/span>package<\/span> name<\/span>=<\/span>"<\/span>com.example.mapper"<\/span><\/span>\/><\/span><\/span> <!– \u5305\u626b\u63cf：\u8981\u6c42 XML \u4e0e\u63a5\u53e3\u540c\u540d\u540c\u5305 –><\/span>
          \n<\/<\/span>mappers<\/span>><\/span><\/span><\/p>\n

          <package> \u65b9\u5f0f\u7684\u7ea6\u5b9a：com.example.mapper.UserMapper \u63a5\u53e3\u4e0e com\/example\/mapper\/UserMapper.xml \u540c\u5305\u540c\u540d，\u81ea\u52a8\u914d\u5bf9\u3002Spring Boot Starter \u4e0b\u7531 mybatis.mapper-locations \u66ff\u4ee3（\u89c1 06 \u7bc7）\u3002<\/p>\n

          \n

          \u56db\u3001Mapper \u6620\u5c04\u65b9\u5f0f<\/h3>\n

          4.1 XML \u6620\u5c04（\u4e3b\u6d41）<\/h4>\n

          \u7ea6\u675f\u4e24\u6761：namespace \u5fc5\u987b\u7b49\u4e8e Mapper \u63a5\u53e3\u5168\u9650\u5b9a\u540d；id \u5fc5\u987b\u7b49\u4e8e\u63a5\u53e3\u65b9\u6cd5\u540d\u3002\u4e8c\u8005\u5171\u540c\u6784\u6210 statementId（namespace.id），\u662f\u6846\u67b6\u5b9a\u4f4d SQL \u7684\u552f\u4e00\u4f9d\u636e\u3002<\/p>\n

          <?xml version="1.0" encoding="UTF-8" ?><\/span>
          \n<!<\/span>DOCTYPE<\/span> mapper<\/span> PUBLIC<\/span> "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"<\/span>
          \n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd"<\/span>><\/span><\/span>
          \n<<\/span>mapper<\/span> namespace<\/span>=<\/span>"<\/span>com.example.mapper.UserMapper"<\/span><\/span>><\/span><\/span><\/p>\n

          <<\/span>select<\/span> id<\/span>=<\/span>"<\/span>selectById"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>com.example.entity.User"<\/span><\/span>><\/span><\/span>
          \n SELECT id, name, email, create_time
          \n FROM user
          \n WHERE id = #{id}
          \n <\/<\/span>select<\/span>><\/span><\/span><\/p>\n

          <\/<\/span>mapper<\/span>><\/span><\/span><\/p>\n

          \u5bf9\u5e94\u63a5\u53e3：<\/p>\n

          public<\/span> interface<\/span> UserMapper<\/span> {<\/span>
          \n User<\/span> selectById<\/span>(<\/span>Long<\/span> id)<\/span>;<\/span>
          \n}<\/span><\/p>\n

          4.2 \u6ce8\u89e3\u6620\u5c04<\/h4>\n

          public<\/span> interface<\/span> UserMapper<\/span> {<\/span><\/p>\n

          @Select<\/span>(<\/span>"SELECT id, name, email FROM user WHERE id = #{id}"<\/span>)<\/span>
          \n User<\/span> selectById<\/span>(<\/span>Long<\/span> id)<\/span>;<\/span><\/p>\n

          @Insert<\/span>(<\/span>"INSERT INTO user(name, email) VALUES(#{name}, #{email})"<\/span>)<\/span>
          \n @Options<\/span>(<\/span>useGeneratedKeys =<\/span> true<\/span>,<\/span> keyProperty =<\/span> "id"<\/span>)<\/span>
          \n int<\/span> insert<\/span>(<\/span>User<\/span> user)<\/span>;<\/span><\/p>\n

          @Update<\/span>(<\/span>"UPDATE user SET name = #{name} WHERE id = #{id}"<\/span>)<\/span>
          \n int<\/span> updateById<\/span>(<\/span>User<\/span> user)<\/span>;<\/span><\/p>\n

          @Delete<\/span>(<\/span>"DELETE FROM user WHERE id = #{id}"<\/span>)<\/span>
          \n int<\/span> deleteById<\/span>(<\/span>Long<\/span> id)<\/span>;<\/span>
          \n}<\/span><\/p>\n

          \u6ce8\u89e3\u65cf\u8865\u5145：<\/p>\n

            \n
          • @Options：\u627f\u8f7d useGeneratedKeys\u3001keyProperty\u3001flushCache\u3001useCache\u3001timeout \u7b49\u8bed\u53e5\u7ea7\u5c5e\u6027\u3002<\/li>\n
          • @Results + @Result：\u6ce8\u89e3\u7248 resultMap（\u590d\u6742\u6620\u5c04\u53ef\u8bfb\u6027\u5dee，\u4ecd\u63a8\u8350 XML）\u3002<\/li>\n
          • @SelectProvider \u7b49 Provider \u6ce8\u89e3：SQL \u7531 Java \u65b9\u6cd5\u52a8\u6001\u6784\u5efa（\u89c1 02 \u7bc7）\u3002<\/li>\n<\/ul>\n

            \u9009\u578b\u5efa\u8bae：\u5355\u8868\u7b80\u5355 CRUD \u7528\u6ce8\u89e3，\u590d\u6742 SQL\u3001\u52a8\u6001 SQL\u3001\u5d4c\u5957\u6620\u5c04\u7528 XML；\u540c\u4e00 Mapper \u5185\u98ce\u683c\u5c3d\u91cf\u7edf\u4e00\u3002<\/p>\n

            4.3 \u6df7\u7528\u89c4\u5219<\/h4>\n
          • \u540c\u4e00 statementId \u4e0d\u80fd\u540c\u65f6\u5b58\u5728 XML \u4e0e\u6ce8\u89e3\u5b9a\u4e49，\u542f\u52a8\u5373\u62a5\u9519\u3002<\/li>\n
          • \u540c\u4e00\u63a5\u53e3\u5185\u53ef\u90e8\u5206\u65b9\u6cd5\u6ce8\u89e3\u3001\u90e8\u5206\u65b9\u6cd5 XML，\u6846\u67b6\u6309 statementId \u5404\u81ea\u89e3\u6790\u3002<\/li>\n
            \n

            \u4e94\u3001\u53c2\u6570\u4f20\u9012<\/h3>\n

            5.1 \u5355\u53c2\u6570<\/h4>\n

            \/\/ \u57fa\u672c\u7c7b\u578b：#{} \u5185\u540d\u79f0\u4e0d\u6821\u9a8c（\u4ec5\u4e00\u4e2a\u53c2\u6570），\u4efb\u610f\u5199\u6cd5\u90fd\u80fd\u53d6\u5230\u503c<\/span>
            \nUser<\/span> selectById<\/span>(<\/span>Long<\/span> id)<\/span>;<\/span> \/\/ XML: WHERE id = #{id}<\/span><\/p>\n

            \/\/ POJO：#{\u5c5e\u6027\u540d}，\u7ecf getter \u53d6\u503c<\/span>
            \nint<\/span> updateById<\/span>(<\/span>User<\/span> user)<\/span>;<\/span> \/\/ XML: SET name = #{name} WHERE id = #{id}<\/span><\/p>\n

            \/\/ Map：#{key}<\/span>
            \nUser<\/span> selectByMap<\/span>(<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span><\/span> params)<\/span>;<\/span>\/\/ XML: WHERE name = #{name}<\/span><\/p>\n

            5.2 \u591a\u53c2\u6570<\/h4>\n

            \/\/ \u274c \u4e0d\u63a8\u8350：\u53ea\u80fd\u7528 param1\/param2 \u6216 arg0\/arg1 \u5f15\u7528，\u53ef\u8bfb\u6027\u5dee\u4e14\u53d7\u7f16\u8bd1\u53c2\u6570\u5f71\u54cd<\/span>
            \nUser<\/span> selectByNameAndStatus<\/span>(<\/span>String<\/span> name,<\/span> Integer<\/span> status)<\/span>;<\/span><\/p>\n

            \/\/ \u2705 \u63a8\u8350：@Param \u663e\u5f0f\u547d\u540d，\u53c2\u6570\u5c01\u88c5\u4e3a ParamMap<\/span>
            \nUser<\/span> selectByNameAndStatus<\/span>(<\/span>@Param<\/span>(<\/span>"name"<\/span>)<\/span> String<\/span> name,<\/span>
            \n @Param<\/span>(<\/span>"status"<\/span>)<\/span> Integer<\/span> status)<\/span>;<\/span>
            \n\/\/ XML: WHERE name = #{name} AND status = #{status}<\/span><\/p>\n

            5.3 \u96c6\u5408\u4e0e\u6570\u7ec4<\/h4>\n

            \/\/ List \u5355\u53c2\u6570：foreach \u4e2d collection="list"（\u65e7\u7ea6\u5b9a）\u6216 @Param \u547d\u540d<\/span>
            \nList<\/span><<\/span>User<\/span>><\/span><\/span> selectByIds<\/span>(<\/span>@Param<\/span>(<\/span>"ids"<\/span>)<\/span> List<\/span><<\/span>Long<\/span>><\/span><\/span> ids)<\/span>;<\/span>
            \n\/\/ XML: <foreach collection="ids" …><\/span><\/p>\n

            \/\/ \u6570\u7ec4\u5355\u53c2\u6570：collection="array"<\/span>
            \nList<\/span><<\/span>User<\/span>><\/span><\/span> selectByIds<\/span>(<\/span>Long<\/span>[<\/span>]<\/span> ids)<\/span>;<\/span><\/p>\n

            5.4 parameterType \u5c5e\u6027<\/h4>\n

            parameterType \u53ef\u7701\u7565\u2014\u2014MyBatis \u901a\u8fc7\u53cd\u5c04\u63a8\u65ad\u5b9e\u9645\u53c2\u6570\u7c7b\u578b\u3002\u8be5\u5c5e\u6027\u4ec5\u4f5c\u53ef\u8bfb\u6027\u63d0\u793a，\u4e0d\u505a\u5f3a\u5236\u6821\u9a8c，\u73b0\u4ee3\u9879\u76ee\u666e\u904d\u7701\u7565\u3002<\/p>\n

            5.5 \u7279\u6b8a\u7c7b\u578b\u5904\u7406<\/h4>\n\n\u7c7b\u578b\u9ed8\u8ba4\u884c\u4e3a\u5b9a\u5236\u624b\u6bb5<\/tr>\n\n\n\n\n
            \u679a\u4e3e<\/td>\n\u6309 name() \u5b57\u7b26\u4e32\u5b58\u53d6（EnumTypeHandler）<\/td>\n\u6362 EnumOrdinalTypeHandler（\u6309\u5e8f\u53f7）\u6216\u81ea\u5b9a\u4e49 TypeHandler<\/td>\n<\/tr>\n
            null \u53c2\u6570<\/td>\n\u591a\u6570\u6570\u636e\u5e93\u76f4\u63a5\u8bbe null<\/td>\nOracle \u7b49\u573a\u666f\u5fc5\u987b\u58f0\u660e jdbcType（\u5982 #{status,jdbcType=NUMERIC}）<\/td>\n<\/tr>\n
            Java 8 \u65e5\u671f\u65f6\u95f4<\/td>\n3.4.5+ \u5185\u7f6e JSR-310 TypeHandler，LocalDateTime \u7b49\u76f4\u63a5\u6620\u5c04<\/td>\n\u65e0\u9700\u989d\u5916\u914d\u7f6e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            TypeHandler \u7684\u5b8c\u6574\u673a\u5236（\u81ea\u5b9a\u4e49 JSON \u5217\u8f6c\u6362\u7b49）\u5728 02 \u7bc7\u7ed3\u679c\u6620\u5c04\u7ae0\u8282\u5c55\u5f00\u3002<\/p>\n

            \n

            \u516d\u3001#{} \u4e0e ${}<\/h3>\n

            \u4e8c\u8005\u5728\u7f16\u8bd1\u671f\u4e0e\u8fd0\u884c\u671f\u7684\u884c\u4e3a\u5b8c\u5168\u4e0d\u540c：<\/p>\n

            #{id} \u7684\u5904\u7406：
            \n XML SQL: SELECT * FROM user WHERE id = #{id}
            \n BoundSql: SELECT * FROM user WHERE id = ? \u2190 \u9884\u7f16\u8bd1\u5360\u4f4d\u7b26
            \n \u53c2\u6570\u7ed1\u5b9a: ps.setLong(1, 1001L) \u2190 PreparedStatement \u7ed1\u5b9a<\/p>\n

            ${name} \u7684\u5904\u7406：
            \n XML SQL: SELECT * FROM user WHERE name = '${name}'
            \n BoundSql: SELECT * FROM user WHERE name = '\u5f20\u4e09' \u2190 OGNL \u6c42\u503c\u540e\u76f4\u63a5\u62fc\u63a5<\/p>\n\n\u5bf9\u6bd4\u9879#{}${}<\/tr>\n\n\n\n\n\n
            \u672c\u8d28<\/td>\n\u9884\u7f16\u8bd1\u5360\u4f4d\u7b26 ?<\/td>\n\u5b57\u7b26\u4e32\u66ff\u6362<\/td>\n<\/tr>\n
            SQL \u6ce8\u5165<\/td>\n\u5929\u7136\u9632\u5fa1<\/td>\n\u6709\u98ce\u9669<\/td>\n<\/tr>\n
            \u6267\u884c\u8ba1\u5212\u7f13\u5b58<\/td>\n\u540c\u6a21\u677f SQL \u53ef\u590d\u7528<\/td>\n\u6bcf\u4e2a\u503c\u751f\u6210\u4e0d\u540c SQL \u6587\u672c<\/td>\n<\/tr>\n
            \u9002\u7528\u4f4d\u7f6e<\/td>\n\u6240\u6709\u6570\u636e\u503c<\/td>\n\u8868\u540d\u3001\u5217\u540d\u3001ORDER BY \u5b57\u6bb5\u7b49\u6807\u8bc6\u7b26<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            ${} \u7684\u5408\u7406\u4f7f\u7528\u573a\u666f\u53ea\u6709\u6807\u8bc6\u7b26\u62fc\u63a5（\u5360\u4f4d\u7b26 ? \u4e0d\u80fd\u66ff\u4ee3\u8868\u540d\/\u5217\u540d），\u4e14\u5fc5\u987b\u505a\u767d\u540d\u5355\u6821\u9a8c：<\/p>\n

            \/\/ \u274c \u9519\u8bef\u793a\u4f8b：\u76f4\u63a5\u62fc\u63a5\u7528\u6237\u8f93\u5165 \u2192 SQL \u6ce8\u5165<\/span>
            \nList<\/span><<\/span>User<\/span>><\/span><\/span> sortUsers<\/span>(<\/span>@Param<\/span>(<\/span>"col"<\/span>)<\/span> String<\/span> col)<\/span>;<\/span>
            \n\/\/ XML: ORDER BY ${col} \u82e5 col = "id; DROP TABLE user" \u540e\u679c\u4e25\u91cd<\/span><\/p>\n

            \/\/ \u2705 \u6b63\u786e\u505a\u6cd5：Service \u5c42\u767d\u540d\u5355\u6821\u9a8c\u540e\u518d\u4f20\u5165<\/span>
            \nprivate<\/span> static<\/span> final<\/span> Set<\/span><<\/span>String<\/span>><\/span><\/span> SORTABLE<\/span> =<\/span> Set<\/span>.<\/span>of<\/span>(<\/span>"id"<\/span>,<\/span> "name"<\/span>,<\/span> "create_time"<\/span>)<\/span>;<\/span><\/p>\n

            public<\/span> List<\/span><<\/span>User<\/span>><\/span><\/span> sortUsers<\/span>(<\/span>String<\/span> col)<\/span> {<\/span>
            \n if<\/span> (<\/span>!<\/span>SORTABLE<\/span>.<\/span>contains<\/span>(<\/span>col)<\/span>)<\/span> {<\/span>
            \n throw<\/span> new<\/span> IllegalArgumentException<\/span>(<\/span>"\u975e\u6cd5\u6392\u5e8f\u5217: "<\/span> +<\/span> col)<\/span>;<\/span>
            \n }<\/span>
            \n return<\/span> userMapper.<\/span>sortUsers<\/span>(<\/span>col)<\/span>;<\/span>
            \n}<\/span><\/p>\n

            #{} \u8fd8\u652f\u6301\u9ad8\u7ea7\u5c5e\u6027\u5185\u8054\u58f0\u660e：<\/p>\n

            <!– \u6307\u5b9a jdbcType \u4e0e typeHandler –><\/span>
            \n<<\/span>insert<\/span> id<\/span>=<\/span>"<\/span>insert"<\/span><\/span>><\/span><\/span>
            \n INSERT INTO user(name, status)
            \n VALUES(#{name}, #{status,jdbcType=NUMERIC,typeHandler=com.example.handler.StatusTypeHandler})
            \n<\/<\/span>insert<\/span>><\/span><\/span><\/p>\n

            \n

            \u4e03\u3001\u4e3b\u952e\u56de\u586b<\/h3>\n

            7.1 \u81ea\u589e\u4e3b\u952e：useGeneratedKeys<\/h4>\n

            \u5e95\u5c42\u4f7f\u7528 JDBC getGeneratedKeys \u80fd\u529b：<\/p>\n

            <<\/span>insert<\/span> id<\/span>=<\/span>"<\/span>insert"<\/span><\/span> useGeneratedKeys<\/span>=<\/span>"<\/span>true"<\/span><\/span> keyProperty<\/span>=<\/span>"<\/span>id"<\/span><\/span>><\/span><\/span>
            \n INSERT INTO user(name, email) VALUES(#{name}, #{email})
            \n<\/<\/span>insert<\/span>><\/span><\/span>
            \n<!– \u6267\u884c\u540e\u5165\u53c2\u5bf9\u8c61\u7684 getId() \u5df2\u88ab\u56de\u586b –><\/span><\/p>\n

            \u6ce8\u89e3\u7248：<\/p>\n

            @Insert<\/span>(<\/span>"INSERT INTO user(name, email) VALUES(#{name}, #{email})"<\/span>)<\/span>
            \n@Options<\/span>(<\/span>useGeneratedKeys =<\/span> true<\/span>,<\/span> keyProperty =<\/span> "id"<\/span>)<\/span>
            \nint<\/span> insert<\/span>(<\/span>User<\/span> user)<\/span>;<\/span><\/p>\n

            3.5+ \u652f\u6301\u590d\u5408\u56de\u586b：keyProperty="id,createTime"（\u914d\u5408\u652f\u6301\u591a\u5217\u751f\u6210\u7684\u6570\u636e\u5e93）\u3002\u6279\u91cf\u63d2\u5165\u7684 foreach \u8bed\u53e5\u540c\u6837\u652f\u6301，3.3.1+ \u4f1a\u628a\u751f\u6210\u7684\u4e3b\u952e\u4f9d\u6b21\u56de\u586b\u5230\u96c6\u5408\u5404\u5143\u7d20\u3002<\/p>\n

            7.2 \u5e8f\u5217\u4e0e\u524d\u7f6e\u751f\u6210：selectKey<\/h4>\n

            <!– Oracle \u5e8f\u5217：\u5148\u53d6\u4e3b\u952e\u518d\u63d2\u5165 –><\/span>
            \n<<\/span>insert<\/span> id<\/span>=<\/span>"<\/span>insert"<\/span><\/span>><\/span><\/span>
            \n <<\/span>selectKey<\/span> keyProperty<\/span>=<\/span>"<\/span>id"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>long"<\/span><\/span> order<\/span>=<\/span>"<\/span>BEFORE"<\/span><\/span>><\/span><\/span>
            \n SELECT seq_user.NEXTVAL FROM dual
            \n <\/<\/span>selectKey<\/span>><\/span><\/span>
            \n INSERT INTO user(id, name) VALUES(#{id}, #{name})
            \n<\/<\/span>insert<\/span>><\/span><\/span><\/p>\n

            <!– MySQL：\u63d2\u5165\u540e\u53d6 LAST_INSERT_ID（useGeneratedKeys \u4e0d\u53ef\u7528\u65f6\u7684\u66ff\u4ee3） –><\/span>
            \n<<\/span>insert<\/span> id<\/span>=<\/span>"<\/span>insert"<\/span><\/span>><\/span><\/span>
            \n <<\/span>selectKey<\/span> keyProperty<\/span>=<\/span>"<\/span>id"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>long"<\/span><\/span> order<\/span>=<\/span>"<\/span>AFTER"<\/span><\/span>><\/span><\/span>
            \n SELECT LAST_INSERT_ID()
            \n <\/<\/span>selectKey<\/span>><\/span><\/span>
            \n INSERT INTO user(name, email) VALUES(#{name}, #{email})
            \n<\/<\/span>insert<\/span>><\/span><\/span><\/p>\n

            UUID \u9884\u751f\u6210\u540c\u7406（order="BEFORE" + Java \u4fa7\u751f\u6210\u6216\u6570\u636e\u5e93\u51fd\u6570\u751f\u6210）\u3002<\/p>\n

            7.3 \u6ce8\u610f\u533a\u5206<\/h4>\n

            insert\/update\/delete \u7684\u8fd4\u56de\u503c\u662f\u5f71\u54cd\u884c\u6570，\u4e0d\u662f\u4e3b\u952e\u503c；\u4e3b\u952e\u53ea\u901a\u8fc7 keyProperty \u56de\u586b\u5230\u5165\u53c2\u5bf9\u8c61\u3002\u8fd9\u662f\u521d\u5b66\u8005\u6700\u5e38\u89c1\u7684\u8bef\u89e3\u3002<\/p>\n

            \n

            \u516b\u3001\u57fa\u7840 CRUD \u6a21\u677f<\/h3>\n

            8.1 \u5b8c\u6574\u6a21\u677f（XML）<\/h4>\n

            <<\/span>mapper<\/span> namespace<\/span>=<\/span>"<\/span>com.example.mapper.UserMapper"<\/span><\/span>><\/span><\/span><\/p>\n

            <<\/span>insert<\/span> id<\/span>=<\/span>"<\/span>insert"<\/span><\/span> useGeneratedKeys<\/span>=<\/span>"<\/span>true"<\/span><\/span> keyProperty<\/span>=<\/span>"<\/span>id"<\/span><\/span>><\/span><\/span>
            \n INSERT INTO user(name, email, create_time)
            \n VALUES(#{name}, #{email}, #{createTime})
            \n <\/<\/span>insert<\/span>><\/span><\/span><\/p>\n

            <<\/span>delete<\/span> id<\/span>=<\/span>"<\/span>deleteById"<\/span><\/span>><\/span><\/span>
            \n DELETE FROM user WHERE id = #{id}
            \n <\/<\/span>delete<\/span>><\/span><\/span><\/p>\n

            <<\/span>update<\/span> id<\/span>=<\/span>"<\/span>updateById"<\/span><\/span>><\/span><\/span>
            \n UPDATE user
            \n SET name = #{name}, email = #{email}
            \n WHERE id = #{id}
            \n <\/<\/span>update<\/span>><\/span><\/span><\/p>\n

            <<\/span>select<\/span> id<\/span>=<\/span>"<\/span>selectById"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>com.example.entity.User"<\/span><\/span>><\/span><\/span>
            \n SELECT id, name, email, create_time FROM user WHERE id = #{id}
            \n <\/<\/span>select<\/span>><\/span><\/span><\/p>\n

            <<\/span>select<\/span> id<\/span>=<\/span>"<\/span>selectAll"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>com.example.entity.User"<\/span><\/span>><\/span><\/span>
            \n SELECT id, name, email, create_time FROM user
            \n <\/<\/span>select<\/span>><\/span><\/span><\/p>\n

            <<\/span>select<\/span> id<\/span>=<\/span>"<\/span>selectByIds"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>com.example.entity.User"<\/span><\/span>><\/span><\/span>
            \n SELECT id, name, email, create_time FROM user
            \n WHERE id IN
            \n <<\/span>foreach<\/span> collection<\/span>=<\/span>"<\/span>ids"<\/span><\/span> item<\/span>=<\/span>"<\/span>id"<\/span><\/span> open<\/span>=<\/span>"<\/span>("<\/span><\/span> separator<\/span>=<\/span>"<\/span>,"<\/span><\/span> close<\/span>=<\/span>"<\/span>)"<\/span><\/span>><\/span><\/span>
            \n #{id}
            \n <\/<\/span>foreach<\/span>><\/span><\/span>
            \n <\/<\/span>select<\/span>><\/span><\/span><\/p>\n

            <<\/span>select<\/span> id<\/span>=<\/span>"<\/span>count"<\/span><\/span> resultType<\/span>=<\/span>"<\/span>long"<\/span><\/span>><\/span><\/span>
            \n SELECT COUNT(*) FROM user
            \n <\/<\/span>select<\/span>><\/span><\/span><\/p>\n

            <\/<\/span>mapper<\/span>><\/span><\/span><\/p>\n

            \u8bf4\u660e：\u672c\u7bc7 updateById \u4e3a\u5168\u5b57\u6bb5\u66f4\u65b0；\u751f\u4ea7\u73af\u5883\u63a8\u8350\u9009\u62e9\u6027\u66f4\u65b0（\u53ea\u66f4\u65b0\u975e null \u5b57\u6bb5），\u9700\u8981\u52a8\u6001 SQL \u7684 <set>+<if> \u652f\u6301，\u89c1 02 \u7bc7\u3002<\/p>\n

            8.2 \u8fd4\u56de\u503c\u7ea6\u5b9a<\/h4>\n\n\u65b9\u6cd5\u7c7b\u578b\u8fd4\u56de\u503c\u8bf4\u660e<\/tr>\n\n\n\n\n\n
            \u67e5\u8be2\u5355\u6761<\/td>\n\u5b9e\u4f53\u6216 null<\/td>\n\u547d\u4e2d\u591a\u6761\u65f6 selectOne \u629b TooManyResultsException<\/td>\n<\/tr>\n
            \u67e5\u8be2\u591a\u6761<\/td>\nList<T><\/td>\n\u65e0\u7ed3\u679c\u8fd4\u56de\u7a7a\u96c6\u5408（\u975e null）<\/td>\n<\/tr>\n
            \u589e\u5220\u6539<\/td>\nint（\u5f71\u54cd\u884c\u6570）<\/td>\n\u4e0d\u662f\u4e3b\u952e\u503c<\/td>\n<\/tr>\n
            \u65e0\u5b9e\u4f53\u4e34\u65f6\u67e5\u8be2<\/td>\nresultType="map"<\/td>\n\u5217\u540d\u505a key，\u9002\u5408\u62a5\u8868\u7c7b\u4e00\u6b21\u6027\u67e5\u8be2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            8.3 \u6279\u91cf\u64cd\u4f5c\u5165\u95e8<\/h4>\n

            \/\/ IN \u67e5\u8be2：foreach \u62fc\u63a5（\u8c03\u7528\u524d\u5fc5\u987b\u5224\u7a7a，\u9632\u6b62 IN () \u8bed\u6cd5\u9519\u8bef）<\/span>
            \nif<\/span> (<\/span>ids !=<\/span> null<\/span> &&<\/span> !<\/span>ids.<\/span>isEmpty<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
            \n List<\/span><<\/span>User<\/span>><\/span><\/span> users =<\/span> userMapper.<\/span>selectByIds<\/span>(<\/span>ids)<\/span>;<\/span>
            \n}<\/span><\/p>\n

            \/\/ \u6279\u91cf\u5199\u5165：\u6279\u91cf\u6a21\u5f0f Executor<\/span>
            \ntry<\/span> (<\/span>SqlSession<\/span> session =<\/span> sqlSessionFactory.<\/span>openSession<\/span>(<\/span>ExecutorType<\/span>.<\/span>BATCH<\/span>)<\/span>)<\/span> {<\/span>
            \n UserMapper<\/span> mapper =<\/span> session.<\/span>getMapper<\/span>(<\/span>UserMapper<\/span>.<\/span>class<\/span>)<\/span>;<\/span>
            \n for<\/span> (<\/span>User<\/span> u :<\/span> userList)<\/span> {<\/span>
            \n mapper.<\/span>insert<\/span>(<\/span>u)<\/span>;<\/span>
            \n }<\/span>
            \n session.<\/span>flushStatements<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u7edf\u4e00\u63d0\u4ea4\u6279\u6b21<\/span>
            \n session.<\/span>commit<\/span>(<\/span>)<\/span>;<\/span>
            \n}<\/span><\/p>\n

            \u6279\u91cf\u5199\u5165\u7684\u8fdb\u9636\u8981\u70b9（\u5206\u6279\u5927\u5c0f\u3001MySQL rewriteBatchedStatements \u53c2\u6570）\u5728 08 \u7bc7\u6027\u80fd\u8c03\u4f18\u7ae0\u8282\u5c55\u5f00\u3002<\/p>\n

            \n

            \u4e5d\u3001\u603b\u7ed3<\/h3>\n
          • \u5b9a\u4f4d：MyBatis \u662f\u534a\u81ea\u52a8 ORM\u2014\u2014SQL \u624b\u5199\u3001\u6846\u67b6\u6258\u7ba1\u53c2\u6570\u4e0e\u7ed3\u679c\u6620\u5c04；\u4e0e Hibernate（\u5168\u81ea\u52a8）\u3001JdbcTemplate（\u8584\u5c01\u88c5）\u6784\u6210\u4e09\u4e2a\u62bd\u8c61\u5c42\u7ea7，\u9002\u5408 SQL \u9700\u7cbe\u7ec6\u63a7\u5236\u7684\u7cfb\u7edf\u3002<\/li>\n
          • \u6838\u5fc3 API \u7eaa\u5f8b：SqlSessionFactory \u5e94\u7528\u7ea7\u5355\u4f8b；SqlSession \u975e\u7ebf\u7a0b\u5b89\u5168\u3001\u7528\u5b8c\u5373\u5173（try-with-resources）；\u5199\u64cd\u4f5c\u5728\u539f\u751f\u6a21\u5f0f\u4e0b\u9700\u624b\u52a8 commit\u3002<\/li>\n
          • \u5168\u5c40\u914d\u7f6e：mybatis-config.xml \u5143\u7d20\u987a\u5e8f\u56fa\u5b9a；\u5165\u95e8\u5fc5\u77e5 settings \u9996\u63a8 mapUnderscoreToCamelCase；\u751f\u4ea7\u73af\u5883\u6570\u636e\u6e90\u4ea4\u7531\u4e13\u4e1a\u8fde\u63a5\u6c60\u4e0e Spring \u7ba1\u7406\u3002<\/li>\n
          • \u6620\u5c04\u65b9\u5f0f：XML（namespace=\u63a5\u53e3\u5168\u9650\u5b9a\u540d\u3001id=\u65b9\u6cd5\u540d）\u4e0e\u6ce8\u89e3\u4e8c\u9009\u4e00\u6216\u6df7\u7528，\u540c\u4e00 statementId \u4e0d\u53ef\u91cd\u590d\u5b9a\u4e49\u3002<\/li>\n
          • \u53c2\u6570\u4f20\u9012：\u591a\u53c2\u6570\u4e00\u5f8b @Param \u663e\u5f0f\u547d\u540d；parameterType \u53ef\u7701\u7565；\u679a\u4e3e\u4e0e null \u53c2\u6570\u6ce8\u610f TypeHandler \u4e0e jdbcType\u3002<\/li>\n
          • \u5360\u4f4d\u7b26\u94c1\u5f8b：#{} \u9884\u7f16\u8bd1\u9632\u6ce8\u5165\u7528\u4e8e\u6240\u6709\u6570\u636e\u503c；${} \u4ec5\u7528\u4e8e\u6807\u8bc6\u7b26\u4e14\u5fc5\u987b\u767d\u540d\u5355\u6821\u9a8c\u3002<\/li>\n
          • \u4e3b\u952e\u56de\u586b：\u81ea\u589e\u7528 useGeneratedKeys+keyProperty，\u5e8f\u5217\/\u9884\u751f\u6210\u7528 selectKey；\u6ce8\u610f\u8fd4\u56de\u503c\u662f\u5f71\u54cd\u884c\u6570\u800c\u975e\u4e3b\u952e\u3002<\/li>\n
          • CRUD \u57fa\u7840：\u638c\u63e1\u6807\u51c6\u6a21\u677f\u4e0e\u8fd4\u56de\u503c\u7ea6\u5b9a，\u9009\u62e9\u6027\u66f4\u65b0\u3001\u52a8\u6001\u6761\u4ef6\u7b49\u5f85 02 \u7bc7\u52a8\u6001 SQL \u8865\u5168\u3002<\/li>\n
            \n

            \u5341\u3001\u5e38\u89c1\u9ad8\u9891\u9762\u8bd5\u9898<\/h3>\n

            1. #{} \u548c ${} \u7684\u533a\u522b？<\/p>\n

            \u8981\u70b9：#{} \u89e3\u6790\u4e3a\u9884\u7f16\u8bd1\u5360\u4f4d\u7b26 ?，\u901a\u8fc7 PreparedStatement \u7ed1\u5b9a\u53c2\u6570，\u9632 SQL \u6ce8\u5165\u4e14\u5229\u4e8e\u6267\u884c\u8ba1\u5212\u7f13\u5b58；${} \u662f OGNL \u6c42\u503c\u540e\u7684\u5b57\u7b26\u4e32\u76f4\u63a5\u66ff\u6362，\u6709\u6ce8\u5165\u98ce\u9669，\u53ea\u5e94\u7528\u4e8e\u8868\u540d\/\u5217\u540d\/\u6392\u5e8f\u5b57\u6bb5\u7b49\u6807\u8bc6\u7b26\u573a\u666f\u4e14\u5fc5\u987b\u767d\u540d\u5355\u6821\u9a8c\u3002<\/p>\n

            2. MyBatis \u7684 insert \u8fd4\u56de\u503c\u662f\u4ec0\u4e48？\u5982\u4f55\u62ff\u5230\u81ea\u589e\u4e3b\u952e？<\/p>\n

            \u8981\u70b9：\u8fd4\u56de\u503c\u662f\u5f71\u54cd\u884c\u6570\u800c\u975e\u4e3b\u952e\u3002\u81ea\u589e\u4e3b\u952e\u901a\u8fc7 useGeneratedKeys="true" keyProperty="id"（\u5e95\u5c42 JDBC getGeneratedKeys）\u56de\u586b\u5230\u5165\u53c2\u5bf9\u8c61；\u5e8f\u5217\u7c7b\u4e3b\u952e\u7528 <selectKey order="BEFORE"> \u5148\u53d6\u540e\u63d2\u3002<\/p>\n

            3. Mapper \u63a5\u53e3\u65b9\u6cd5\u6709\u591a\u4e2a\u53c2\u6570\u65f6\u5982\u4f55\u4f20\u9012？<\/p>\n

            \u8981\u70b9：\u4e0d\u52a0 @Param \u65f6\u53ea\u80fd\u7528 param1\/param2（\u6216 arg0\/arg1）\u5f15\u7528；\u63a8\u8350 @Param("name") \u663e\u5f0f\u547d\u540d，\u53c2\u6570\u88ab\u5c01\u88c5\u4e3a ParamMap，XML \u4e2d\u4ee5\u540d\u79f0\u5f15\u7528\u3002\u5355\u4e2a POJO\/Map \u53c2\u6570\u5219\u76f4\u63a5\u5f15\u7528\u5c5e\u6027\/key\u3002<\/p>\n

            4. parameterType \u662f\u5fc5\u987b\u7684\u5417？<\/p>\n

            \u8981\u70b9：\u4e0d\u662f\u3002MyBatis \u901a\u8fc7\u53cd\u5c04\u63a8\u65ad\u5b9e\u9645\u53c2\u6570\u7c7b\u578b，parameterType \u4ec5\u4f5c\u53ef\u8bfb\u6027\u63d0\u793a\u4e14\u4e0d\u505a\u5f3a\u5236\u6821\u9a8c，\u73b0\u4ee3\u9879\u76ee\u666e\u904d\u7701\u7565\u3002<\/p>\n

            5. MyBatis \u76f8\u6bd4 Hibernate \u7684\u4f18\u7f3a\u70b9？\u5982\u4f55\u9009\u578b？<\/p>\n

            \u8981\u70b9：MyBatis \u4f18\u70b9\u2014\u2014SQL \u5b8c\u5168\u53ef\u63a7\u3001\u590d\u6742\u67e5\u8be2\u6613\u4f18\u5316\u3001DBA \u53ef\u4ecb\u5165\u3001\u5b66\u4e60\u66f2\u7ebf\u5e73\u7f13；\u7f3a\u70b9\u2014\u2014SQL \u4e0e\u6620\u5c04\u6587\u4ef6\u7ef4\u62a4\u91cf\u5927\u3001\u4e0d\u652f\u6301\u6570\u636e\u5e93\u65e0\u5173\u6027\u3002\u9009\u578b：SQL \u590d\u6742\u591a\u53d8\u3001\u9700\u7cbe\u7ec6\u8c03\u4f18\u9009 MyBatis；\u9886\u57df\u6a21\u578b\u7a33\u5b9a\u7684 CRUD \u5bc6\u96c6\u578b\u7cfb\u7edf\u9009 Hibernate\/JPA；\u4e8c\u8005\u53ef\u5171\u5b58\u3002<\/p>\n

            6. SqlSession \u662f\u7ebf\u7a0b\u5b89\u5168\u7684\u5417？\u5e94\u8be5\u5982\u4f55\u4f7f\u7528？<\/p>\n

            \u8981\u70b9：\u4e0d\u662f\u7ebf\u7a0b\u5b89\u5168\u7684，\u5185\u90e8\u6301\u6709 Executor \u4e0e\u4e00\u7ea7\u7f13\u5b58\u7b49\u4f1a\u8bdd\u72b6\u6001\u3002\u7eaa\u5f8b：\u4f5c\u4e3a\u65b9\u6cd5\u5185\u5c40\u90e8\u53d8\u91cf，try-with-resources \u7528\u5b8c\u5373\u5173，\u7981\u6b62\u4f5c\u4e3a\u7c7b\u6210\u5458\u6216\u9759\u6001\u53d8\u91cf\u5171\u4eab；SqlSessionFactory \u624d\u662f\u5e94\u7528\u7ea7\u5355\u4f8b\u3002<\/p>\n

            7. MyBatis \u4e2d\u5982\u4f55\u5b9e\u73b0\u6a21\u7cca\u67e5\u8be2\u4e14\u9632\u6b62 SQL \u6ce8\u5165？<\/p>\n

            \u8981\u70b9：WHERE name LIKE CONCAT('%', #{kw}, '%') \u6216 <bind name="kw" value="'%' + keyword + '%'"\/> \u540e\u7528 #{kw}；\u7981\u6b62 '%${kw}%' \u62fc\u63a5\u3002<\/p>\n

            8. mybatis-config.xml \u4e2d\u5982\u4f55\u6279\u91cf\u6ce8\u518c Mapper？\u7ea6\u5b9a\u662f\u4ec0\u4e48？<\/p>\n

            \u8981\u70b9：<package name="com.example.mapper"\/> \u5305\u626b\u63cf，\u7ea6\u5b9a XML \u4e0e\u63a5\u53e3\u540c\u540d\u540c\u5305\u81ea\u52a8\u914d\u5bf9；\u4e5f\u53ef resource\/url\/class \u9010\u4e2a\u6ce8\u518c\u3002Spring Boot \u73af\u5883\u4e0b\u7531 mybatis.mapper-locations \u901a\u914d\u7b26\u914d\u7f6e\u66ff\u4ee3\u3002<\/p>\n

            \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n","protected":false},"excerpt":{"rendered":"

            MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 \u5b9a\u4f4d：MyBatis \u7cfb\u5217\u7b2c 1 \u7bc7：\u5feb\u901f\u5165\u95e8\u3001\u5168\u5c40\u914d\u7f6e\u3001Mapper \u6620\u5c04\u3001\u53c2\u6570\u4f20\u9012\u3001\u4e3b\u952e\u56de\u586b\u4e0e\u57fa\u7840 CRUD \u9002\u7528\u7248\u672c：MyBatis 3.5.x（JDK 8） \u76ee\u5f55
            \nMyBatis \u6982\u8ff0\u5feb\u901f\u5165\u95e8\u4e0e SqlSession \u4f7f\u7528\u5168\u5c40\u914d\u7f6e\u57fa\u7840Mapper \u6620\u5c04\u65b9\u5f0f\u53c2\u6570\u4f20\u9012#{} \u4e0e ${}\u4e3b\u952e\u56de\u586b\u57fa\u7840 CRUD \u6a21\u677f\u603b\u7ed3\u5e38\u89c1\u9ad8\u9891\u9762\u8bd5\u9898 \u4e00\u3001MyBatis \u6982\u8ff0 <\/p>\n","protected":false},"author":2,"featured_media":105615,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[292,190,188],"topic":[],"class_list":["post-105616","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-292","tag-190","tag-188"],"yoast_head":"\nMyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \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\/105616.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 \u5b9a\u4f4d：MyBatis \u7cfb\u5217\u7b2c 1 \u7bc7：\u5feb\u901f\u5165\u95e8\u3001\u5168\u5c40\u914d\u7f6e\u3001Mapper \u6620\u5c04\u3001\u53c2\u6570\u4f20\u9012\u3001\u4e3b\u952e\u56de\u586b\u4e0e\u57fa\u7840 CRUD \u9002\u7528\u7248\u672c：MyBatis 3.5.x（JDK 8） \u76ee\u5f55 MyBatis \u6982\u8ff0\u5feb\u901f\u5165\u95e8\u4e0e SqlSession \u4f7f\u7528\u5168\u5c40\u914d\u7f6e\u57fa\u7840Mapper \u6620\u5c04\u65b9\u5f0f\u53c2\u6570\u4f20\u9012#{} \u4e0e ${}\u4e3b\u952e\u56de\u586b\u57fa\u7840 CRUD \u6a21\u677f\u603b\u7ed3\u5e38\u89c1\u9ad8\u9891\u9762\u8bd5\u9898 \u4e00\u3001MyBatis \u6982\u8ff0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/105616.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-15T10:56:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/09\/20260915105624-6aa9245885bdf.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\/105616.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/105616.html\",\"name\":\"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-15T10:56:26+00:00\",\"dateModified\":\"2026-09-15T10:56:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/105616.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/105616.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/105616.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3\"}]},{\"@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":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \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\/105616.html","og_locale":"zh_CN","og_type":"article","og_title":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 \u5b9a\u4f4d：MyBatis \u7cfb\u5217\u7b2c 1 \u7bc7：\u5feb\u901f\u5165\u95e8\u3001\u5168\u5c40\u914d\u7f6e\u3001Mapper \u6620\u5c04\u3001\u53c2\u6570\u4f20\u9012\u3001\u4e3b\u952e\u56de\u586b\u4e0e\u57fa\u7840 CRUD \u9002\u7528\u7248\u672c：MyBatis 3.5.x（JDK 8） \u76ee\u5f55 MyBatis \u6982\u8ff0\u5feb\u901f\u5165\u95e8\u4e0e SqlSession \u4f7f\u7528\u5168\u5c40\u914d\u7f6e\u57fa\u7840Mapper \u6620\u5c04\u65b9\u5f0f\u53c2\u6570\u4f20\u9012#{} \u4e0e ${}\u4e3b\u952e\u56de\u586b\u57fa\u7840 CRUD \u6a21\u677f\u603b\u7ed3\u5e38\u89c1\u9ad8\u9891\u9762\u8bd5\u9898 \u4e00\u3001MyBatis \u6982\u8ff0","og_url":"https:\/\/www.wsisp.com\/helps\/105616.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-15T10:56:26+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/09\/20260915105624-6aa9245885bdf.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\/105616.html","url":"https:\/\/www.wsisp.com\/helps\/105616.html","name":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-15T10:56:26+00:00","dateModified":"2026-09-15T10:56:26+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/105616.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/105616.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/105616.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MyBatis \u57fa\u7840\u5165\u95e8\u4e0e CRUD \u8be6\u89e3"}]},{"@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\/105616","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=105616"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/105616\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/105615"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=105616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=105616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=105616"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=105616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}