{"id":5808,"date":"2024-04-16T00:03:59","date_gmt":"2024-04-15T16:03:59","guid":{"rendered":"http:\/\/zyg.luchers.cn\/?p=5808"},"modified":"2024-04-16T00:03:59","modified_gmt":"2024-04-15T16:03:59","slug":"%e4%b8%89%e3%80%81mybatis%e5%a4%9a%e8%a1%a8%e6%98%a0%e5%b0%84","status":"publish","type":"post","link":"http:\/\/zyg.luchers.cn\/index.php\/2024\/04\/16\/%e4%b8%89%e3%80%81mybatis%e5%a4%9a%e8%a1%a8%e6%98%a0%e5%b0%84\/","title":{"rendered":"\u4e09\u3001MyBatis\u591a\u8868\u6620\u5c04"},"content":{"rendered":"

\u4e09\u3001MyBatis\u591a\u8868\u6620\u5c04<\/h1>\n

1\u3001\u591a\u8868\u6620\u5c04\u7684\u6982\u5ff5<\/h2>\n

1\u3001\u601d\u8def<\/h3>\n

1\u3001MyBatis \u601d\u60f3\u662f\uff1a\u6570\u636e\u5e93\u4e0d\u53ef\u80fd\u6c38\u8fdc\u662f\u4f60\u6240\u60f3\u6216\u6240\u9700\u7684\u90a3\u4e2a\u6837\u5b50\u3002 \u6211\u4eec\u5e0c\u671b\u6bcf\u4e2a\u6570\u636e\u5e93\u90fd\u5177\u5907\u826f\u597d\u7684\u7b2c\u4e09\u8303\u5f0f\u6216 BCNF \u8303\u5f0f\uff0c\u53ef\u60dc\u5b83\u4eec\u5e76\u4e0d\u90fd\u662f\u90a3\u6837\u3002 \u5982\u679c\u80fd\u6709\u4e00\u79cd\u6570\u636e\u5e93\u6620\u5c04\u6a21\u5f0f\uff0c\u5b8c\u7f8e\u9002\u914d\u6240\u6709\u7684\u5e94\u7528\u7a0b\u5e8f\u67e5\u8be2\u9700\u6c42\uff0c\u90a3\u5c31\u592a\u597d\u4e86\uff0c\u800c ResultMap \u5c31\u662f MyBatis \u5c31\u662f\u5b8c\u7f8e\u7b54\u6848\u3002 <\/p>\n

2\u3001\u56fe\u89e3<\/p>\n

\"image-20240114162748918\"<\/div><\/p>\n

2\u3001\u5b66\u4e60\u76ee\u6807<\/h3>\n
    \n
  • \n

    \u591a\u8868\u67e5\u8be2\u8bed\u53e5\u4f7f\u7528<\/p>\n<\/li>\n

  • \n

    \u591a\u8868\u7ed3\u679c\u627f\u63a5\u5b9e\u4f53\u7c7b\u8bbe\u8ba1<\/p>\n<\/li>\n

  • \n

    \u4f7f\u7528ResultMap\u5b8c\u6210\u591a\u8868\u7ed3\u679c\u6620\u5c04<\/p>\n<\/li>\n<\/ul>\n

    3\u3001\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\u65b9\u6848<\/h3>\n

    1\u3001\u591a\u8868\u5173\u7cfb\u56de\u987e<\/h4>\n

    \u591a\u8868\u5173\u7cfb\u56de\u987e\uff1a\uff08\u53cc\u5411\u67e5\u770b\uff09<\/p>\n

      \n
    • \n

      \u4e00\u5bf9\u4e00<\/p>\n

      \u592b\u59bb\u5173\u7cfb\uff0c\u4eba\u548c\u8eab\u4efd\u8bc1\u53f7<\/p>\n<\/li>\n

    • \n

      \u4e00\u5bf9\u591a| \u591a\u5bf9\u4e00<\/p>\n

      \u7528\u6237\u548c\u7528\u6237\u7684\u8ba2\u5355\uff0c\u9501\u548c\u94a5\u5319<\/p>\n<\/li>\n

    • \n

      \u591a\u5bf9\u591a<\/p>\n

      \u8001\u5e08\u548c\u5b66\u751f\uff0c\u90e8\u95e8\u548c\u5458\u5de5<\/p>\n<\/li>\n<\/ul>\n

      2\u3001\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\u5173\u7cfb\uff08\u67e5\u8be2\uff09\uff1a\uff08\u5355\u5411\u67e5\u770b\uff09<\/h4>\n

      1\u3001\u5bf9\u4e00<\/h5>\n

      1\u3001\u5bf9\u4e00 \uff1a \u592b\u59bb\u4e00\u65b9\u5bf9\u5e94\u53e6\u4e00\u65b9\uff0c\u8ba2\u5355\u5bf9\u5e94\u7528\u6237\u90fd\u662f\u5bf9\u4e00\u5173\u7cfb<\/p>\n

      2\u3001\u91cd\u70b9\uff1a\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\uff1a\u5bf9\u4e00\u5173\u7cfb\u4e0b\uff0c\u7c7b\u4e2d\u53ea\u8981\u5305\u542b\u5355\u4e2a\u5bf9\u65b9\u5bf9\u8c61\u7c7b\u578b\u5c5e\u6027\u5373\u53ef\uff01<\/strong><\/p>\n

      3\u3001\u4f8b\u5982\uff1a<\/p>\n

      public class Customer {\n\n  private Integer customerId;\n  private String customerName;\n\n}\n\npublic class Order {\n\n  private Integer orderId;\n  private String orderName;\n  private Customer customer;\/\/ \u4f53\u73b0\u7684\u662f\u5bf9\u4e00\u7684\u5173\u7cfb\n\n}  \n<\/code><\/pre>\n
      2\u3001\u5bf9\u591a<\/h5>\n
      1\u3001\u5bf9\u591a: \u7528\u6237\u5bf9\u5e94\u7684\u8ba2\u5355\uff0c\u8bb2\u5e08\u5bf9\u5e94\u7684\u5b66\u751f\u6216\u8005\u5b66\u751f\u5bf9\u5e94\u7684\u8bb2\u5e08\u90fd\u662f\u5bf9\u591a\u5173\u7cfb\uff1a<\/p>\n
      2\u3001\u91cd\u70b9\uff1a\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\uff1a\u5bf9\u591a\u5173\u7cfb\u4e0b\uff0c\u7c7b\u4e2d\u53ea\u8981\u5305\u542b\u5bf9\u65b9\u7c7b\u578b\u96c6\u5408\u5c5e\u6027\u5373\u53ef\uff01<\/strong><\/p>\n
      3\u3001\u4f8b\u5b50<\/p>\n
      public class Customer {\n\n  private Integer customerId;\n  private String customerName;\n  private List<Order> orderList;\/\/ \u4f53\u73b0\u7684\u662f\u5bf9\u591a\u7684\u5173\u7cfb\n}\n\npublic class Order {\n\n  private Integer orderId;\n  private String orderName;\n  private Customer customer;\/\/ \u4f53\u73b0\u7684\u662f\u5bf9\u4e00\u7684\u5173\u7cfb\n\n}\n\n\/\/\u67e5\u8be2\u5ba2\u6237\u548c\u5ba2\u6237\u5bf9\u5e94\u7684\u8ba2\u5355\u96c6\u5408  \u4e0d\u8981\u7ba1!<\/code><\/pre>\n
      3\u3001\u591a\u8868\u7ed3\u679c\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\u6280\u5de7<\/h4>\n
      1\u3001\u5bf9\u4e00\uff1a\u5c5e\u6027\u5305\u542b\u5bf9\u65b9\u5bf9\u8c61<\/p>\n
      2\u3001\u5bf9\u591a\uff1a\u5c5e\u6027\u5305\u542b\u5bf9\u65b9\u5bf9\u8c61\u96c6\u5408<\/p>\n
      3\u3001\u6ce8\u610f\uff01<\/strong><\/p>\n
        \n
      • \n
        \u53ea\u6709\u771f\u5b9e\u53d1\u751f\u591a\u8868\u67e5\u8be2\u65f6\uff0c\u624d\u9700\u8981\u8bbe\u8ba1\u548c\u4fee\u6539\u5b9e\u4f53\u7c7b\uff0c\u5426\u5219\u4e0d\u63d0\u524d\u8bbe\u8ba1\u548c\u4fee\u6539\u5b9e\u4f53\u7c7b\uff01<\/p>\n<\/li>\n
      • \n
        \u65e0\u8bba\u591a\u5c11\u5f20\u8868\u8054\u67e5\uff0c\u5b9e\u4f53\u7c7b\u8bbe\u8ba1\u90fd\u662f\u4e24\u4e24\u8003\u8651!<\/p>\n<\/li>\n
      • \n
        \u5728\u67e5\u8be2\u6620\u5c04\u7684\u65f6\u5019\uff0c\u53ea\u9700\u8981\u5173\u6ce8\u672c\u6b21\u67e5\u8be2\u76f8\u5173\u7684\u5c5e\u6027\uff01\u4f8b\u5982\uff1a\u67e5\u8be2\u8ba2\u5355\u548c\u5bf9\u5e94\u7684\u5ba2\u6237\uff0c\u5c31\u4e0d\u8981\u5173\u6ce8\u5ba2\u6237\u4e2d\u7684\u8ba2\u5355\u96c6\u5408\uff01<\/p>\n<\/li>\n<\/ul>\n
        2\u3001\u5bf9\u4e00\u6620\u5c04<\/h2>\n
        1\u3001\u9700\u6c42<\/h3>\n
        1\u3001\u6839\u636eID\u67e5\u8be2\u8ba2\u5355\uff0c\u4ee5\u53ca\u8ba2\u5355\u5173\u8054\u7684\u7528\u6237\u7684\u4fe1\u606f\uff01<\/p>\n
        2\u3001\u4ee3\u7801\u5b9e\u73b0<\/h3>\n
        1\u3001\u51c6\u5907\u6570\u636e\u5e93<\/p>\n
        CREATE TABLE `t_customer` (`customer_id` INT NOT NULL AUTO_INCREMENT, `customer_name` CHAR(100), PRIMARY KEY (`customer_id`) );\n\nCREATE TABLE `t_order` ( `order_id` INT NOT NULL AUTO_INCREMENT, `order_name` CHAR(100), `customer_id` INT, PRIMARY KEY (`order_id`) ); \n\nINSERT INTO `t_customer` (`customer_name`) VALUES ('c01');\n\nINSERT INTO `t_order` (`order_name`, `customer_id`) VALUES ('o1', '1');\nINSERT INTO `t_order` (`order_name`, `customer_id`) VALUES ('o2', '1');\nINSERT INTO `t_order` (`order_name`, `customer_id`) VALUES ('o3', '1'); \n\nSELECT order_id ,order_name,c.customer_id,customer_name\nfrom t_order o \nleft JOIN t_customer c\nON o.customer_id =c.customer_id\nwhere o.order_id = 1;<\/code><\/pre>\n
        2\u3001\u51c6\u5907\u5b9e\u4f53\u7c7b<\/p>\n
        package com.atgui.pojo;\n\nimport lombok.Data;\n\n@Data\npublic class Order {\n\n    private Integer orderId;\n\n    private String orderName;\n\n    private Integer customerId;\n\n\/\/    \u5bf9\u4e00\u7684\u5173\u7cfb\uff0c\u6240\u4ee5\u8981\u4fdd\u7559customer\u7684\u5bf9\u8c61\n    Customer customer ;\n}\n<\/code><\/pre>\n
        package com.atgui.pojo;\n\nimport lombok.Data;\n\n@Data\npublic class Customer {\n\n    private Integer customerId;\n\n    private String  customerName;\n\n}\n<\/code><\/pre>\n
        3\u3001\u51c6\u5907\u914d\u7f6e\u6587\u4ef6mybatis-config.xml<\/p>\n
        <?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE configuration\n        PUBLIC "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN"\n        "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd">\n<configuration>\n<!--    \u8ba9mybatis\u5f00\u542f\u65e5\u5fd7\u8f93\u51fa-->\n    <settings>\n<!--        \u8fd9\u91cc\u8bbe\u7f6e\u7684\u662f\u9009\u62e9\u7528system\u8fdb\u884c\u65e5\u5fd7\u8f93\u51fa-->\n        <setting name="logImpl" value="STDOUT_LOGGING"\/>\n<!--        \u5f00\u542f\u9a7c\u5cf0\u5f0f\u81ea\u52a8\u6620\u5c04-->\n        <setting name="mapUnderscoreToCamelCase" value="true"\/>\n    <\/settings>\n\n<!--    \u5b9a\u4e49\u81ea\u5df1\u7c7b\u7684\u522b\u540d-->\n    <typeAliases>\n<!--        \u5355\u72ec\u5b9a\u4e49-->\n<!--        <typeAlias type="com.atgui.pojo.Employee" alias="suibian"\/>-->\n<!--        \u6279\u91cf\u5b9a\u4e49-->\n        <package name="com.atgui.pojo"\/>\n    <\/typeAliases>\n\n    <!-- environments\u8868\u793a\u914d\u7f6eMybatis\u7684\u5f00\u53d1\u73af\u5883\uff0c\u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883\uff0c\u5728\u4f17\u591a\u5177\u4f53\u73af\u5883\u4e2d\uff0c\u4f7f\u7528default\u5c5e\u6027\u6307\u5b9a\u5b9e\u9645\u8fd0\u884c\u65f6\u4f7f\u7528\u7684\u73af\u5883\u3002default\u5c5e\u6027\u7684\u53d6\u503c\u662fenvironment\u6807\u7b7e\u7684id\u5c5e\u6027\u7684\u503c\u3002 -->\n    <environments default="development">\n        <!-- environment\u8868\u793a\u914d\u7f6eMybatis\u7684\u4e00\u4e2a\u5177\u4f53\u7684\u73af\u5883 -->\n        <environment id="development">\n            <!-- Mybatis\u7684\u5185\u7f6e\u7684\u4e8b\u52a1\u7ba1\u7406\u5668 -->\n            <transactionManager type="JDBC"\/>\n            <!-- \u914d\u7f6e\u6570\u636e\u6e90 -->\n            <dataSource type="POOLED">\n                <!-- \u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u7684\u5177\u4f53\u4fe1\u606f -->\n                <property name="driver" value="com.mysql.cj.jdbc.Driver"\/>\n                <property name="url" value="jdbc:mysql:\/\/localhost:3306\/mybatis-example"\/>\n                <property name="username" value="root"\/>\n                <property name="password" value="root"\/>\n            <\/dataSource>\n        <\/environment>\n    <\/environments>\n\n    <mappers>\n        <!-- Mapper\u6ce8\u518c\uff1a\u6307\u5b9aMybatis\u6620\u5c04\u6587\u4ef6\u7684\u5177\u4f53\u4f4d\u7f6e -->\n        <!-- mapper\u6807\u7b7e\uff1a\u914d\u7f6e\u4e00\u4e2a\u5177\u4f53\u7684Mapper\u6620\u5c04\u6587\u4ef6 -->\n        <!-- resource\u5c5e\u6027\uff1a\u6307\u5b9aMapper\u6620\u5c04\u6587\u4ef6\u7684\u5b9e\u9645\u5b58\u50a8\u4f4d\u7f6e\uff0c\u8fd9\u91cc\u9700\u8981\u4f7f\u7528\u4e00\u4e2a\u4ee5\u7c7b\u8def\u5f84\u6839\u76ee\u5f55\u4e3a\u57fa\u51c6\u7684\u76f8\u5bf9\u8def\u5f84 -->\n        <!--    \u5bf9Maven\u5de5\u7a0b\u7684\u76ee\u5f55\u7ed3\u6784\u6765\u8bf4\uff0cresources\u76ee\u5f55\u4e0b\u7684\u5185\u5bb9\u4f1a\u76f4\u63a5\u653e\u5165\u7c7b\u8def\u5f84\uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u4ee5resources\u76ee\u5f55\u4e3a\u57fa\u51c6 -->\n        <mapper resource="mappers\/OrderMapper.xml"\/>\n    <\/mappers>\n\n<\/configuration><\/code><\/pre>\n
        4\u3001pom.xml\u548c\u4e0a\u9762\u4e00\u6837\u8fd9\u91cc\u4e0d\u591a\u8d58\u8ff0<\/p>\n
        5\u3001\u51c6\u5907\u63a5\u53e3\u7c7b<\/p>\n
        package com.atgui.mapper;\n\nimport com.atgui.pojo.Order;\n\npublic interface OrderMapper {\n  Order selectOrderWithCustomer(Integer orderId);\n}<\/code><\/pre>\n
        6\u3001\u51c6\u5907mappers\/mapper.xml\u6587\u4ef6<\/p>\n
        <?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE mapper\n        PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"\n        "https:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\n<!-- namespace\u7b49\u4e8emapper\u63a5\u53e3\u7c7b\u7684\u5168\u9650\u5b9a\u540d,\u8fd9\u6837\u5b9e\u73b0\u5bf9\u5e94 -->\n<mapper namespace="com.atgui.mapper.OrderMapper">\n\n    <resultMap id="orderMap" type="order">\n<!--        \u7b2c\u4e00\u5c42\u5c5e\u6027\uff0corder\u5bf9\u8c61-->\n        <id column="order_id" property="orderId"\/>\n        <result column="order_name" property="orderName"\/>\n        <result column="customer_id" property="customerId"\/>\n\n<!--        \u7b2c\u4e8c\u5c42\u5c5e\u6027\uff0ccustomer\u5bf9\u8c61-->\n        <association property="customer" javaType="customer">\n            <id column="customer_id" property="customerId"\/>\n            <result column="customer_name" property="customerName"\/>\n        <\/association>\n    <\/resultMap>\n\n    <select id="selectOrderWithCustomer" resultMap="orderMap">\n        SELECT order_id ,order_name,c.customer_id,customer_name\n        from t_order o\n        left JOIN t_customer c\n        ON o.customer_id =c.customer_id\n        where o.order_id = #{orderId};\n    <\/select>\n<\/mapper><\/code><\/pre>\n
        7\u3001\u6d4b\u8bd5<\/p>\n
        package com.atgui;\n\nimport com.atgui.mapper.UserMapper;\nimport com.atgui.pojo.User;\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\nimport org.junit.jupiter.api.AfterEach;\nimport org.junit.jupiter.api.BeforeEach;\nimport org.junit.jupiter.api.Test;\nimport java.io.IOException;\nimport java.io.InputStream;\nimport java.util.List;\n\npublic class MybatisTest {\n\n    private SqlSession sqlSession;\n\n\/\/    \u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u524d\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n    @BeforeEach\n    public void before() throws IOException {\n        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");\n        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);\n        sqlSession = sqlSessionFactory.openSession(true);\n    }\n\n    \/\/\u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u540e\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n    @AfterEach\n    public void clean(){\n        sqlSession.close();\n    }\n    @Test\n    public void testInsert(){\n        User user = new User();\n        user.setUsername("1231");\n        user.setPassword("123");\n        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n        userMapper.insert(user);\n        System.out.println("userMapper = " + userMapper);\n    }\n\n    @Test\n    public void testUpdate(){\n        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n        User user = userMapper.selectById(1);\/\/\u67e5\u8be2\u5230\u8fd9\u4e2a\u518d\u8fdb\u884c\u4fee\u6539\n        user.setUsername("12311111");\n        user.setPassword("12322222");\n        userMapper.update(user);\n    }\n\n    @Test\n    public void testDelete(){\n        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n        userMapper.delete(1);\n    }\n\n    @Test\n    public void testSelectById(){\n        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n        User user =  userMapper.selectById(1);\n        System.out.println("user = " + user);\n    }\n\n    @Test\n    public void testSelectAll(){\n        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n        List<User> userList = userMapper.selectAll();\n        System.out.println("userList = " + userList);\n    }\n}<\/code><\/pre>\n
        3\u3001\u5173\u952e\u5b57<\/h3>\n
        1\u3001\u5728\u201c\u5bf9\u4e00\u201d\u5173\u8054\u5173\u7cfb\u4e2d\uff0c\u6211\u4eec\u7684\u914d\u7f6e\u6bd4\u8f83\u591a\uff0c\u4f46\u662f\u5173\u952e\u8bcd\u5c31\u53ea\u6709\uff1aassociation<\/strong>\u548cjavaType<\/strong><\/p>\n
        3\u3001\u5bf9\u591a\u6620\u5c04<\/h2>\n
        1\u3001\u9700\u6c42<\/h3>\n
        1\u3001\u67e5\u8be2\u5ba2\u6237\u548c\u5ba2\u6237\u8ba2\u5355\u5173\u8054\u7684\u8ba2\u5355\u4fe1\u606f<\/p>\n
        2\u3001\u4ee3\u7801\u5b9e\u73b0<\/h3>\n
        1\u3001\u51c6\u5907\u5b9e\u4f53\u7c7b<\/p>\n
        package com.atgui.pojo;\n\nimport lombok.Data;\n\nimport java.util.List;\n\n@Data\npublic class Customer {\n\n    private Integer customerId;\n\n    private String  customerName;\n    \/\/\u5bf9\u591a\u7684\u5173\u7cfb\uff0c\u5c31\u7528\u4e00\u4e2a\u96c6\u5408\u88c5Order\n    private List<Order> orderList;\n\n}\n<\/code><\/pre>\n
        package com.atgui.pojo;\n\nimport lombok.Data;\n\n@Data\npublic class Order {\n\n    private Integer orderId;\n\n    private String orderName;\n\n    private Integer customerId;\n\n\/\/    \u5bf9\u4e00\u7684\u5173\u7cfb\uff0c\u6240\u4ee5\u8981\u4fdd\u7559customer\u7684\u5bf9\u8c61\n    Customer customer ;\n}\n<\/code><\/pre>\n
        3\u3001\u51c6\u5907\u914d\u7f6e\u6587\u4ef6mybatis-config.xml<\/p>\n
        <?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE configuration\n        PUBLIC "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN"\n        "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd">\n<configuration>\n<!--    \u8ba9mybatis\u5f00\u542f\u65e5\u5fd7\u8f93\u51fa-->\n    <settings>\n<!--        \u8fd9\u91cc\u8bbe\u7f6e\u7684\u662f\u9009\u62e9\u7528system\u8fdb\u884c\u65e5\u5fd7\u8f93\u51fa-->\n        <setting name="logImpl" value="STDOUT_LOGGING"\/>\n<!--        \u5f00\u542f\u9a7c\u5cf0\u5f0f\u81ea\u52a8\u6620\u5c04-->\n        <setting name="mapUnderscoreToCamelCase" value="true"\/>\n    <\/settings>\n\n<!--    \u5b9a\u4e49\u81ea\u5df1\u7c7b\u7684\u522b\u540d-->\n    <typeAliases>\n<!--        \u5355\u72ec\u5b9a\u4e49-->\n<!--        <typeAlias type="com.atgui.pojo.Employee" alias="suibian"\/>-->\n<!--        \u6279\u91cf\u5b9a\u4e49-->\n        <package name="com.atgui.pojo"\/>\n    <\/typeAliases>\n\n    <!-- environments\u8868\u793a\u914d\u7f6eMybatis\u7684\u5f00\u53d1\u73af\u5883\uff0c\u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883\uff0c\u5728\u4f17\u591a\u5177\u4f53\u73af\u5883\u4e2d\uff0c\u4f7f\u7528default\u5c5e\u6027\u6307\u5b9a\u5b9e\u9645\u8fd0\u884c\u65f6\u4f7f\u7528\u7684\u73af\u5883\u3002default\u5c5e\u6027\u7684\u53d6\u503c\u662fenvironment\u6807\u7b7e\u7684id\u5c5e\u6027\u7684\u503c\u3002 -->\n    <environments default="development">\n        <!-- environment\u8868\u793a\u914d\u7f6eMybatis\u7684\u4e00\u4e2a\u5177\u4f53\u7684\u73af\u5883 -->\n        <environment id="development">\n            <!-- Mybatis\u7684\u5185\u7f6e\u7684\u4e8b\u52a1\u7ba1\u7406\u5668 -->\n            <transactionManager type="JDBC"\/>\n            <!-- \u914d\u7f6e\u6570\u636e\u6e90 -->\n            <dataSource type="POOLED">\n                <!-- \u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u7684\u5177\u4f53\u4fe1\u606f -->\n                <property name="driver" value="com.mysql.cj.jdbc.Driver"\/>\n                <property name="url" value="jdbc:mysql:\/\/localhost:3306\/mybatis-example"\/>\n                <property name="username" value="root"\/>\n                <property name="password" value="root"\/>\n            <\/dataSource>\n        <\/environment>\n    <\/environments>\n\n    <mappers>\n        <!-- Mapper\u6ce8\u518c\uff1a\u6307\u5b9aMybatis\u6620\u5c04\u6587\u4ef6\u7684\u5177\u4f53\u4f4d\u7f6e -->\n        <!-- mapper\u6807\u7b7e\uff1a\u914d\u7f6e\u4e00\u4e2a\u5177\u4f53\u7684Mapper\u6620\u5c04\u6587\u4ef6 -->\n        <!-- resource\u5c5e\u6027\uff1a\u6307\u5b9aMapper\u6620\u5c04\u6587\u4ef6\u7684\u5b9e\u9645\u5b58\u50a8\u4f4d\u7f6e\uff0c\u8fd9\u91cc\u9700\u8981\u4f7f\u7528\u4e00\u4e2a\u4ee5\u7c7b\u8def\u5f84\u6839\u76ee\u5f55\u4e3a\u57fa\u51c6\u7684\u76f8\u5bf9\u8def\u5f84 -->\n        <!--    \u5bf9Maven\u5de5\u7a0b\u7684\u76ee\u5f55\u7ed3\u6784\u6765\u8bf4\uff0cresources\u76ee\u5f55\u4e0b\u7684\u5185\u5bb9\u4f1a\u76f4\u63a5\u653e\u5165\u7c7b\u8def\u5f84\uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u4ee5resources\u76ee\u5f55\u4e3a\u57fa\u51c6 -->\n        <mapper resource="mappers\/OrderMapper.xml"\/>\n        <mapper resource="mappers\/CustomerMapper.xml"\/>\n    <\/mappers>\n\n<\/configuration><\/code><\/pre>\n
        4\u3001pom.xml\u548c\u4e0a\u9762\u4e00\u6837\u8fd9\u91cc\u4e0d\u591a\u8d58\u8ff0<\/p>\n
        5\u3001\u51c6\u5907\u63a5\u53e3\u7c7b<\/p>\n
        package com.atgui.mapper;\n\nimport com.atgui.pojo.Customer;\n\nimport java.util.List;\n\npublic interface CustomerMapper {\n\n    List<Customer> queryList();\n\n}\n<\/code><\/pre>\n
        6\u3001\u51c6\u5907mappers\/mapper.xml\u6587\u4ef6<\/p>\n
        <?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE mapper\n        PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"\n        "https:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\n<!-- namespace\u7b49\u4e8emapper\u63a5\u53e3\u7c7b\u7684\u5168\u9650\u5b9a\u540d,\u8fd9\u6837\u5b9e\u73b0\u5bf9\u5e94 -->\n<mapper namespace="com.atgui.mapper.CustomerMapper">\n\n    <resultMap id="customerMap" type="customer">\n        <id column="customer_id" property="customerId"\/>\n        <result column="customer_name" property="customerName"\/>\n\n<!--        \u662f\u7ed9\u96c6\u5408\u5c5e\u6027\u8d4b\u503c\n            property \u96c6\u5408\u5c5e\u6027\u503c\n            ofType \u96c6\u5408\u7684\u6cdb\u578b\u7c7b\u578b\n-->\n        <collection property="orderList" ofType="order">\n            <id column="order_id" property="orderId"\/>\n            <result column="order_name" property="orderName"\/>\n            <result column="customer" property="customerId"\/>\n        <\/collection>\n\n    <\/resultMap>\n\n    <select id="queryList" resultMap="customerMap">\n        SELECT order_id ,order_name,c.customer_id,customer_name\n        from t_order o\n        left JOIN t_customer c\n        ON o.customer_id =c.customer_id\n\n    <\/select>\n<\/mapper><\/code><\/pre>\n
        7\u3001\u6d4b\u8bd5<\/p>\n
        package com.atgui;\n\nimport com.atgui.mapper.CustomerMapper;\nimport com.atgui.mapper.OrderMapper;\nimport com.atgui.pojo.Customer;\nimport com.atgui.pojo.Order;\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\nimport org.junit.jupiter.api.AfterEach;\nimport org.junit.jupiter.api.BeforeEach;\nimport org.junit.jupiter.api.Test;\n\nimport java.io.IOException;\nimport java.io.InputStream;\nimport java.util.List;\n\npublic class mybatisTest {\n    private SqlSession sqlSession;\n\n    \/\/    \u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u524d\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n    @BeforeEach\n    public void before() throws IOException {\n        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");\n        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);\n        sqlSession = sqlSessionFactory.openSession(true);\n    }\n\n    \/\/\u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u540e\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n    @AfterEach\n    public void clean(){\n        sqlSession.close();\n    }\n\n    @Test\n    public void  test2(){\n        CustomerMapper customerMapper = sqlSession.getMapper(CustomerMapper.class);\n        List<Customer> customerList = customerMapper.queryList();\n        System.out.println("order = " + customerList);\n\n    }\n\n}\n<\/code><\/pre>\n
        3\u3001\u7406\u89e3\u548c\u8865\u5145<\/h3>\n
        1\u3001\u5bf9\u5e94\u5173\u7cfb\u5982\u56fe<\/p>\n
        \"image-20240114232055922\"<\/div><\/p>\n
        4\u3001\u5173\u952e\u5b57<\/h3>\n
        1\u3001\u5728\u201c\u5bf9\u591a\u201d\u5173\u8054\u5173\u7cfb\u4e2d\uff0c\u540c\u6837\u6709\u5f88\u591a\u914d\u7f6e\uff0c\u4f46\u662f\u63d0\u70bc\u51fa\u6765\u6700\u5173\u952e\u7684\u5c31\u662f\uff1a\u201ccollection\u201d\u548c\u201cofType\u201d<\/p>\n
        4\u3001\u591a\u8868\u6620\u5c04\u603b\u7ed3<\/h2>\n
        1\u3001\u591a\u8868\u6620\u5c04\u4f18\u5316<\/h3>\n
        1\u3001\u8865\u5145setting\u8bbe\u7f6e<\/p>\n\n\n\n\n\n
        setting\u5c5e\u6027<\/th>\n\u5c5e\u6027\u542b\u4e49<\/th>\n\u53ef\u9009\u503c<\/th>\n\u9ed8\u8ba4\u503c<\/th>\n<\/tr>\n<\/thead>\n
        autoMappingBehavior<\/td>\n\u6307\u5b9a MyBatis \u5e94\u5982\u4f55\u81ea\u52a8\u6620\u5c04\u5217\u5230\u5b57\u6bb5\u6216\u5c5e\u6027\u3002 NONE \u8868\u793a\u5173\u95ed\u81ea\u52a8\u6620\u5c04\uff1bPARTIAL \u53ea\u4f1a\u81ea\u52a8\u6620\u5c04\u6ca1\u6709\u5b9a\u4e49\u5d4c\u5957\u7ed3\u679c\u6620\u5c04\u7684\u5b57\u6bb5\u3002 FULL \u4f1a\u81ea\u52a8\u6620\u5c04\u4efb\u4f55\u590d\u6742\u7684\u7ed3\u679c\u96c6\uff08\u65e0\u8bba\u662f\u5426\u5d4c\u5957\uff09\u3002<\/td>\nNONE, PARTIAL, FULL<\/td>\nPARTIAL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        2\u3001\u6839\u636e\u4e0a\u9762\u7684\u5bf9\u591a\u4f8b\u5b50<\/p>\n
          \n
        • \n
          \u2460\u4fee\u6539mybatis-config.xml\u7684\u914d\u7f6e\u6587\u4ef6<\/p>\n<\/li>\n
        • \n
          \n\n      \n\n\n      \n\n      \n      \n  <\/settings>\n\n<\/configuration><\/code><\/pre>\n
          \u2461\u4fee\u6539CustomerMapper.xml\u6587\u4ef6<\/p>\n
          \n\n\n\n\n  \n      \n  \n\n\n      \n          \n \n \n      <\/collection>\n\n  <\/resultMap>\n\n  \n\n\n\n\n\n
          \u5173\u8054\u5173\u7cfb<\/th>\n\u914d\u7f6e\u9879\u5173\u952e\u8bcd<\/th>\n\u6240\u5728\u914d\u7f6e\u6587\u4ef6\u548c\u5177\u4f53\u4f4d\u7f6e<\/th>\n<\/tr>\n<\/thead>\n
          \u5bf9\u4e00<\/td>\nassociation\u6807\u7b7e\/javaType\u5c5e\u6027\/property\u5c5e\u6027<\/td>\nMapper\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684resultMap\u6807\u7b7e\u5185<\/td>\n<\/tr>\n
          \u5bf9\u591a<\/td>\ncollection\u6807\u7b7e\/ofType\u5c5e\u6027\/property\u5c5e\u6027<\/td>\nMapper\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684resultMap\u6807\u7b7e\u5185<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
          3\u3001\u8865\u5145\u3010\u591a\u8868\u3011<\/h3>\n
          \"image-20240115004830365\"<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
          \u4e09\u3001MyBatis\u591a\u8868\u6620\u5c04 1\u3001\u591a\u8868\u6620\u5c04\u7684\u6982\u5ff5 1\u3001\u601d\u8def 1\u3001MyBatis \u601d\u60f3\u662f\uff1a\u6570\u636e\u5e93\u4e0d\u53ef\u80fd\u6c38\u8fdc\u662f\u4f60\u6240\u60f3 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-5808","post","type-post","status-publish","format-standard","hentry","category-mybatis"],"_links":{"self":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/comments?post=5808"}],"version-history":[{"count":1,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5808\/revisions"}],"predecessor-version":[{"id":5809,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5808\/revisions\/5809"}],"wp:attachment":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/media?parent=5808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/categories?post=5808"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/tags?post=5808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}