{"id":1430,"date":"2015-03-04T01:18:39","date_gmt":"2015-03-03T17:18:39","guid":{"rendered":"http:\/\/www.menglanglang.cn\/?p=1430"},"modified":"2015-08-05T07:35:13","modified_gmt":"2015-08-04T23:35:13","slug":"ibatis%e7%ae%80%e5%8d%95%e5%85%a5%e9%97%a8","status":"publish","type":"post","link":"http:\/\/www.menglanglang.cn\/?p=1430","title":{"rendered":"iBATIS\u7b80\u5355\u5165\u95e8"},"content":{"rendered":"

iBATIS \u4e00\u8bcd\u6765\u6e90\u4e8e\u201cinternet\u201d\u548c\u201cabatis\u201d\u7684\u7ec4\u5408\uff0c\u662f\u4e00\u4e2a\u7531 Clinton Begin \u5728 2002 \u5e74\u53d1\u8d77\u7684\u5f00\u653e\u6e90\u4ee3\u7801\u9879\u76ee\uff0c\u4e8e 2010 \u5e74 6 \u6708 16 \u53f7\u88ab\u8c37\u6b4c\u6258\u7ba1\uff0c\u6539\u540d\u4e3a\u00a0MyBatis\u3002\u662f\u4e00\u4e2a\u57fa\u4e8e\u00a0SQL\u00a0\u6620\u5c04\u652f\u6301\u00a0Java\u00a0\u548c \u00b7NET \u7684\u6301\u4e45\u5c42\u6846\u67b6\u3002<\/p>\n

iBATIS\u00a0\u662f apache \u7684\u4e00\u4e2a\u5f00\u6e90\u9879\u76ee\uff0c\u4e00\u4e2aO\/R Mapping\u89e3\u51b3\u65b9\u6848\uff0c\u76f8\u5bf9\u00a0Hibernate\u00a0\u548c\u00a0ApacheOJB \u7b49\u201c\u4e00\u7ad9\u5f0f\u201dORM \u89e3\u51b3\u65b9\u6848\u800c\u8a00\uff0ciBATIS \u662f\u4e00\u79cd\u201c\u534a\u81ea\u52a8\u5316\u201d\u7684 ORM \u5b9e\u73b0\u3002<\/span><\/p>\n

\u7279\u70b9\u662f\u5c0f\u5de7\uff0c\u4e0a\u624b\u5feb\u3002<\/span>\u5b98\u7f51\u5730\u5740\u4e3a\uff1ahttp:\/\/ibatis.apache.org<\/a>\u3002<\/span><\/p>\n

iBATIS \u7684\u8fd0\u7528\u4e5f\u4e0d\u96be\uff0c\u4e3b\u8981\u662f\u4e00\u4e9b\u914d\u7f6e\uff0c\u5728\u8fd9\u91cc\u5206\u4eab\u4e00\u4e2a\u89c6\u9891\uff0c\u4e00\u4e2a\u5bf9\u7167\u89c6\u9891\u5b9e\u7ec3\u7684\u5c0f\u7a0b\u5e8f\uff0c\u8fd8\u6709\u4e00\u4e9b jar \u5305\u4e4b\u7c7b\u7684\uff0c\u4f9b\u5927\u5bb6\u5b66\u4e60\u5de5\u4f5c\u7528\u3002<\/p>\n

iBATIS \u9879\u76ee\u914d\u7f6e\u7684\u4e3b\u914d\u7f6e\u6587\u4ef6\u00a0SqlMapConfig.xml<\/strong>\uff1a<\/p>\n

\n
\n
Code<\/strong>\u00a0\u00a0\u00a0View<\/a>Print<\/a><\/div>\n<\/div>\n
    \n
  1. <?<\/span>xml<\/span>\u00a0<\/span>version<\/span>=<\/span>\"1.0\"<\/span>\u00a0<\/span>encoding<\/span>=<\/span>\"UTF-8\"<\/span>?><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  2. \u00a0\u00a0<\/span><\/li>\n
  3. <!DOCTYPE\u00a0sqlMapConfig\u00a0PUBLIC\u00a0\"-\/\/ibatis.apache.org\/\/DTD\u00a0SQL\u00a0Map\u00a0Config\u00a02.0\/\/EN\"\u00a0\u00a0<\/span><\/li>\n
  4. \u00a0\u00a0\u00a0\u00a0\"http:\/\/ibatis.apache.org\/dtd\/sql-map-config-2.dtd\"><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  5. \u00a0\u00a0<\/span><\/li>\n
  6. <<\/span>sqlMapConfig<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  7. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  8. \u00a0\u00a0\u00a0\u00a0<<\/span>properties<\/span>\u00a0<\/span>resource<\/span>=<\/span>\"com\/sinaapp\/langtuteng\/SqlMap.properties\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  9. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  10. \u00a0\u00a0\u00a0\u00a0<<\/span>transactionManager<\/span>\u00a0<\/span>type<\/span>=<\/span>\"JDBC\"<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  11. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<<\/span>dataSource<\/span>\u00a0<\/span>type<\/span>=<\/span>\"SIMPLE\"<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  12. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<<\/span>property<\/span>\u00a0<\/span>name<\/span>=<\/span>\"JDBC.Driver\"<\/span>\u00a0<\/span>value<\/span>=<\/span>\"${driver}\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  13. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<<\/span>property<\/span>\u00a0<\/span>name<\/span>=<\/span>\"JDBC.ConnectionURL\"<\/span>\u00a0<\/span>value<\/span>=<\/span>\"${url}\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  14. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<<\/span>property<\/span>\u00a0<\/span>name<\/span>=<\/span>\"JDBC.Username\"<\/span>\u00a0<\/span>value<\/span>=<\/span>\"${username}\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  15. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<<\/span>property<\/span>\u00a0<\/span>name<\/span>=<\/span>\"JDBC.Password\"<\/span>\u00a0<\/span>value<\/span>=<\/span>\"${password}\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  16. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/<\/span>dataSource<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  17. \u00a0\u00a0\u00a0\u00a0<\/<\/span>transactionManager<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  18. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  19. \u00a0\u00a0\u00a0\u00a0<<\/span>sqlMap<\/span>\u00a0<\/span>resource<\/span>=<\/span>\"com\/sinaapp\/langtuteng\/Student.xml\"<\/span>\/><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  20. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  21. <\/<\/span>sqlMapConfig<\/span>><\/span>\u00a0\u00a0<\/span><\/span><\/li>\n<\/ol>\n<\/div>\n

    \u89c6\u9891\u4e2d\u8bb2\u89e3\u7528\u7684\u662f Oracle \u6570\u636e\u5e93\uff0c\u4f46\u5728 Demo \u4e2d\u7528\u7684\u662f MySQL \u6570\u636e\u5e93\uff0c\u4e0b\u9762\u662f\u9a71\u52a8\u7684\u914d\u7f6e\u6587\u4ef6 SqlMap.properties<\/strong>\uff1a<\/p>\n

    \n
    \n
    Code<\/strong>\u00a0\u00a0\u00a0View<\/a>Print<\/a><\/div>\n<\/div>\n
      \n
    1. driver<\/span>=<\/span>com<\/span>.mysql.jdbc.Driver\u00a0\u00a0<\/span><\/span><\/li>\n
    2. url<\/span>=<\/span>jdbc<\/span>:mysql:\/\/127.0.0.1:3306\/test\u00a0\u00a0<\/span><\/span><\/li>\n
    3. username<\/span>=<\/span>root<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
    4. password<\/span>=<\/span>123456<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n<\/ol>\n<\/div>\n

      \u5728 Java \u4ee3\u7801\u4e2d\u8bfb\u53d6\u4e3b\u914d\u7f6e\u6587\u4ef6<\/strong>\u7684\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n

      \n
      \n
      Code<\/strong>\u00a0\u00a0\u00a0View<\/a>Print<\/a><\/div>\n<\/div>\n
        \n
      1. try<\/span>\u00a0{\u00a0\u00a0<\/span><\/span><\/li>\n
      2. \u00a0\u00a0\u00a0\u00a0Reader\u00a0reader\u00a0=\u00a0com.ibatis.common.resources.Resources.getResourceAsReader(\"com\/sinaapp\/langtuteng\/SqlMapConfig.xml\"<\/span>);\u00a0\u00a0<\/span><\/span><\/li>\n
      3. \u00a0\u00a0\u00a0\u00a0sqlMapClient\u00a0=\u00a0com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);\u00a0\u00a0<\/span><\/li>\n
      4. \u00a0\u00a0\u00a0\u00a0reader.close();\u00a0\u00a0<\/span><\/li>\n
      5. }\u00a0catch<\/span>\u00a0(IOException\u00a0e)\u00a0{\u00a0\u00a0<\/span><\/span><\/li>\n
      6. \u00a0\u00a0\u00a0\u00a0e.printStackTrace();\u00a0\u00a0<\/span><\/li>\n
      7. }\u00a0\u00a0<\/span><\/li>\n<\/ol>\n<\/div>\n

        \u5176\u5b83\u90e8\u5206\u5982\u679c\u60f3\u53c2\u9605\uff0c\u8bf7\u4e0b\u8f7d Demo \u9644\u4ef6\u5427\uff0c\u4e0b\u9762\u63d0\u4f9b\u4e00\u4e9b\u4e0b\u8f7d\u94fe\u63a5\uff1a<\/p>\n

        \u4ee3\u7801\u5c0f Demo + ibatis\u5305 + mysql\u9a71\u52a8\u5305\u4e0b\u8f7d\uff1a\u767e\u5ea6\u4e91\u5171\u4eab\u4e0b\u8f7d<\/a> | 360\u4e91\u76d8\u4e0b\u8f7d<\/a>\uff08\u8bbf\u95ee\u5bc6\u7801 eb23\uff09<\/p>\n

        \u4f20\u667a\u64ad\u5ba2 ibatis \u6559\u7a0b\u89c6\u9891\u4e0b\u8f7d\uff1a\u767e\u5ea6\u4e91\u5171\u4eab\u4e0b\u8f7d<\/a> | 360\u4e91\u76d8\u4e0b\u8f7d<\/a>\uff08\u8bbf\u95ee\u5bc6\u7801 7a7c\uff09<\/p>\n","protected":false},"excerpt":{"rendered":"

        iBATIS \u4e00\u8bcd\u6765\u6e90\u4e8e\u201cinternet\u201d\u548c\u201cabatis\u201d\u7684\u7ec4\u5408\uff0c\u662f\u4e00\u4e2a\u7531 Clinton Begin \u5728 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[435],"tags":[331,608,89,332],"class_list":["post-1430","post","type-post","status-publish","format-standard","hentry","category-mybatis","tag-ibatis","tag-mybatis","tag-89","tag-332"],"_links":{"self":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/1430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1430"}],"version-history":[{"count":0,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/1430\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1430"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}