{"id":14317,"date":"2023-12-04T01:26:02","date_gmt":"2023-12-03T17:26:02","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=14317"},"modified":"2023-12-04T01:27:09","modified_gmt":"2023-12-03T17:27:09","slug":"mybatis-de-sqlmapconfigxml-zhong-pei-zhi-you-na-xi","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/12\/04\/mybatis-de-sqlmapconfigxml-zhong-pei-zhi-you-na-xi\/","title":{"rendered":"MyBatis \u7684 SQLMapConfig.xml \u4e2d\u914d\u7f6e\u6709\u54ea\u4e9b\u5185\u5bb9\uff1f"},"content":{"rendered":"

\u5728 MyBatis \u4e2d\uff0cSQLMapConfig.xml<\/code> \u6587\u4ef6\u88ab\u7528\u4e8e\u914d\u7f6e\u6574\u4e2a MyBatis \u7684\u8fd0\u884c\u73af\u5883\u548c\u5168\u5c40\u5c5e\u6027\uff0c\u4e3b\u8981\u5305\u542b\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n

    \n
  1. \u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f<\/strong>\uff1a\u914d\u7f6e\u6570\u636e\u5e93\u7684\u8fde\u63a5\u4fe1\u606f\uff0c\u6bd4\u5982\u6570\u636e\u5e93 URL\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u7b49\u3002<\/p>\n<\/li>\n
  2. \n

    \u6620\u5c04\u6587\u4ef6\u7684\u5f15\u7528<\/strong>\uff1a\u6307\u5b9a MyBatis SQL \u6620\u5c04\u6587\u4ef6\u7684\u4f4d\u7f6e\uff0c\u53ef\u4ee5\u662f\u5355\u4e2a\u6587\u4ef6\uff0c\u4e5f\u53ef\u4ee5\u662f\u591a\u4e2a\u6587\u4ef6\u3002<\/p>\n<\/li>\n

  3. \n

    \u7c7b\u578b\u522b\u540d\u7684\u6ce8\u518c<\/strong>\uff1a\u6ce8\u518c Java \u5bf9\u8c61\u7684\u522b\u540d\uff0c\u4f7f\u5f97\u5728 XML \u6620\u5c04\u6587\u4ef6\u4e2d\u53ef\u4ee5\u4f7f\u7528\u7b80\u77ed\u7684\u522b\u540d\u4ee3\u66ff\u5b8c\u6574\u7684\u7c7b\u540d\u3002<\/p>\n<\/li>\n

  4. \n

    \u5168\u5c40\u8bbe\u7f6e<\/strong>\uff1a\u914d\u7f6e MyBatis \u7684\u5168\u5c40\u5c5e\u6027\uff0c\u4f8b\u5982\u8d85\u65f6\u65f6\u95f4\u3001\u7f13\u5b58\u8bbe\u7f6e\u3001\u65e5\u5fd7\u6253\u5370\u7b49\u3002<\/p>\n<\/li>\n

  5. \n

    \u73af\u5883\u914d\u7f6e<\/strong>\uff1a\u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883\uff0c\u6bcf\u4e2a\u73af\u5883\u5305\u542b\u4e00\u4e2a\u6570\u636e\u6e90\u548c\u4e8b\u52a1\u7ba1\u7406\u5668\u7684\u914d\u7f6e\u3002<\/p>\n<\/li>\n<\/ol>\n

    \u5178\u578b\u7684 SQLMapConfig.xml<\/code> \u6587\u4ef6\u53ef\u80fd\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n

    <?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE configuration PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n\n<configuration>\n    <!-- \u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f -->\n    <environments default=\"development\">\n        <environment id=\"development\">\n            <transactionManager type=\"JDBC\"\/>\n            <dataSource type=\"POOLED\">\n                <property name=\"driver\" value=\"com.mysql.jdbc.Driver\"\/>\n                <property name=\"url\" value=\"jdbc:mysql:\/\/localhost:3306\/mybatis_db\"\/>\n                <property name=\"username\" value=\"root\"\/>\n                <property name=\"password\" value=\"password\"\/>\n            <\/dataSource>\n        <\/environment>\n    <\/environments>\n\n    <!-- \u6620\u5c04\u6587\u4ef6\u7684\u5f15\u7528 -->\n    <mappers>\n        <mapper resource=\"com\/example\/mapper\/UserMapper.xml\"\/>\n        <!-- \u5176\u4ed6\u6620\u5c04\u6587\u4ef6\u7684\u5f15\u7528 -->\n    <\/mappers>\n\n    <!-- \u7c7b\u578b\u522b\u540d\u7684\u6ce8\u518c -->\n    <typeAliases>\n        <typeAlias alias=\"User\" type=\"com.example.model.User\"\/>\n        <!-- \u5176\u4ed6\u7c7b\u578b\u522b\u540d\u7684\u6ce8\u518c -->\n    <\/typeAliases>\n\n    <!-- \u5168\u5c40\u8bbe\u7f6e -->\n    <settings>\n        <setting name=\"logImpl\" value=\"STDOUT_LOGGING\"\/>\n        <!-- \u5176\u4ed6\u5168\u5c40\u8bbe\u7f6e -->\n    <\/settings>\n<\/configuration>\n<\/code><\/pre>\n
    \u8bf7\u6ce8\u610f\uff0c\u5177\u4f53\u7684\u914d\u7f6e\u5185\u5bb9\u53ef\u80fd\u56e0\u9879\u76ee\u548c\u9700\u6c42\u800c\u5f02\uff0c\u4ee5\u4e0a\u4ec5\u662f\u4e00\u79cd\u5178\u578b\u7684\u914d\u7f6e\u793a\u4f8b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u5728 MyBatis \u4e2d\uff0cSQLMapConfig.xml \u6587\u4ef6\u88ab\u7528\u4e8e\u914d\u7f6e\u6574\u4e2a MyBatis \u7684\u8fd0\u884c\u73af\u5883\u548c\u5168\u5c40 […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[113],"tags":[],"class_list":["post-14317","post","type-post","status-publish","format-standard","hentry","category-mybatis"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=14317"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14317\/revisions"}],"predecessor-version":[{"id":14318,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14317\/revisions\/14318"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=14317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=14317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=14317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}