Mybatis映射文件学习（三）多对多映射 resultMap

最新推荐文章于 2022-07-29 22:03:26 发布

Hardison_Dream

最新推荐文章于 2022-07-29 22:03:26 发布

阅读量284

点赞数

分类专栏： Java 文章标签： spring mybatis 多对多 resultMap JAVA

本文链接：https://blog.csdn.net/qq_35099583/article/details/103146456

版权

摘要由CSDN通过智能技术生成

1，声明

本博客所有内容来源于网络、书籍、和各类手册。
内容均为非盈利，旨为学习记录，方便查询、总结备份、开源分享。
部分转载内容均有注明出处，如有侵权请告知，马上删除

参考链接
[Mybatis(四) 高级映射，一对一，一对多，多对多映射] (https://www.cnblogs.com/whgk/p/6721935.html)
————————————————
版权声明：本文为CSDN博主「Hardison_C」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。

2，工具

Idea 2019.2
maven 3.61
mysql 8.017
mybatis
Navicat

3，依赖jar包 Dependencies

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.hardes</groupId>
  <artifactId>MybatisEntry5</artifactId>
  <version>1.0-SNAPSHOT</version>

  <name>MybatisEntry5</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
    <!-- spring版本号 -->
    <spring.version>5.1.9.RELEASE</spring.version>
    <!-- Mybatis版本号 -->
    <mybatis.version>3.4.6</mybatis.version>
    <!-- log4j 版本号 -->
    <log4j.version>1.2.17</log4j.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!-- spring核心包 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-oxm</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.4</version>
    </dependency>
    <!-- mybatis核心包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    <!-- mybatis/spring包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.2</version>
    </dependency>

    <!-- 导入Mysql数据库链接jar包 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.16</version>
    </dependency>

    <!-- 日志文件管理包 -->
    <!-- log start -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>

  </dependencies>

  <build>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <!-- clean lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#clean_Lifecycle -->
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- default lifecycle, jar packaging: see https://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_jar_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-jar-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
        <!-- site lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#site_Lifecycle -->
        <plugin>
          <artifactId>maven-site-plugin</artifactId>
          <version>3.7.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-project-info-reports-plugin</artifactId>
          <version>3.0.0</version>
        </plugin>
      </plugins>
    </pluginManagement>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>
  </build>
</project>

4，代码结构

在这里插入图片描述

5， Mybatis Generator 配置文件

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!-- 取别名，或者别的其他全局配置信息，就在这里编写 -->
    <typeAliases>
        <!-- 别名为类名首字母大小写都可以 -->
        <package name="com.hardes.pojo"/>
    </typeAliases>
    <!-- 原先这里还有连接数据库的一些配置，与spring整合后，都交由spring来管理 -->

    <!-- 加载mapper映射文件,使用通用的配置 -->
    <mappers>
        <package name="com.hardes.mapper"/>

    </mappers>
</configuration>

6, Spring 配置文件

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd ">
    <!-- 引用java配置文件 -->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${db.driver}"/>
        <property name="url" value="${db.url}"/>
        <property name="username" value="${db.username}"/>
        <property name="password" value="${db.password}"/>
        <property name="maxActive" value="10"/>
        <property name="maxIdle" value="5"/>
    </bean>

    <!-- 配置SqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 指定mybatis的全局配置文件的路径 -->
        <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>
        <!-- 数据源 -->
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!-- 批量配置，这里是批量配置mapper代理，那么下面就不用配置id了。
       我们想要获取哪个mapper代理用这个格式：类名首字母小写
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.hardes.mapper"></property>
        <!-- 默认不需要配置，但是如果有多个数据源的配置，那么就需要配置此项 -->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

</beans>

jdbc.properties

db.driver=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql:///test?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=UTC
db.username=root
db.password=root

mapper

Ordersmapper.java

package com.hardes.mapper;

import com.hardes.pojo.Orders;

import java.util.List;

public interface OrdersMapper {
   

    List<Orders> findOrdersAndUsersByOid(int i);

    List<Orders> findOrdersAndDetailRstMap(int i);
}

OrdersMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--
    namespace命名空间，作用就是对sql进行分类化管理，将sql隔离
    注意：使用mapper代理方法开发，namespace有特殊重要的作用，namespace为对应的mapper接口地址
-->
<mapper namespace="com.hardes.mapper.OrdersMapper">
    <!--一对一映射,还用resultMap-->
    <resultMap id="findOrdersAndUsersReM" type="com.hardes.pojo.Orders">
        <id column="oid" property="id"/>
        <result column="number" property="number"/>
        <result column="user_id" property="userId"/>
        <result column="time"   property="time"/>

        <association property="users" javaType="com.hardes.pojo.Users">
            <id column="uid" property="id"/>
            <result column="username" property="username"/>
            <result column="sex" property="sex"/>
        </association>
    </resultMap>

    <select id="findOrdersAndUsersByOid" parameterType="int" resultMap="findOrdersAndUsersReM">
        SELECT
            orders.id oid,
            orders.number,
            orders.user_id,
            orders.time,
            users.id uid,
            users.username,
            users.sex

         FROM users

最低0.47元/天解锁文章

Hardison_Dream

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Mybatis映射文件学习（三）多对多映射 resultMap

1，声明本博客所有内容来源于网络、书籍、和各类手册。内容均为非盈利，旨为学习记录，方便查询、总结备份、开源分享。部分转载内容均有注明出处，如有侵权请告知，马上删除参考链接[Mybatis(四) 高级映射，一对一，一对多，多对多映射] (https://www.cnblogs.com/whgk/p/6721935.html)————————————————版权声明：本文为CSDN博主...
复制链接

扫一扫