Mybatis高级映射多对一映射映射关系分布查询使用两条SQL完成映射-----Mybatis框架

曾经终败给现在 2024-03-03 08:36 111阅读 0赞

>     <?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">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.StudentMapper">
>         <resultMap id="studentResultMapAssociation" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>     
>     
>             <association property="clazz" javaType="clazz">
>                 <id column="cid" property="cid"></id>
>                 <result property="cname" column="cname"></result>
>             </association>
>         </resultMap>
>         <resultMap id="studentResultMap" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>             <result property="clazz.cid" column="cid"></result>
>             <result property="clazz.cname" column="cname"></result>
>         </resultMap>
>         <select id="selectById" resultMap="studentResultMap">
>             select
>                 s.sid,s.sname,c.cid,c.cname
>             from
>                 t_stu as s left join t_clazz as c on s.cid = c.cid
>             where
>                 s.sid = #{sid};
>         </select>
>         <select id="selectByAssociation" resultMap="studentResultMapAssociation">
>             select
>                 s.sid,s.sname,c.cid,c.cname
>             from
>                 t_stu as s left join t_clazz as c on s.cid = c.cid
>             where
>                 s.sid = #{sid};
>         </select>
>         <select id="selectByIDStepOne" resultMap="studentResultMapByStep">
>             select sid,sname,cid from t_stu where sid = #{sid}
>         </select>
>     
>     
>     
>         <resultMap id="studentResultMapByStep" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>     
>             <association property="clazz" select="com.powernode.mybatis.mappers.ClazzMapper.selectByIdStepTwo" column="cid"></association>
>         </resultMap>
>     </mapper>
> 
>     <?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">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.StudentMapper">
>         <resultMap id="studentResultMapAssociation" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>     
>     
>             <association property="clazz" javaType="clazz">
>                 <id column="cid" property="cid"></id>
>                 <result property="cname" column="cname"></result>
>             </association>
>         </resultMap>
>         <resultMap id="studentResultMap" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>             <result property="clazz.cid" column="cid"></result>
>             <result property="clazz.cname" column="cname"></result>
>         </resultMap>
>         <select id="selectById" resultMap="studentResultMap">
>             select
>                 s.sid,s.sname,c.cid,c.cname
>             from
>                 t_stu as s left join t_clazz as c on s.cid = c.cid
>             where
>                 s.sid = #{sid};
>         </select>
>         <select id="selectByAssociation" resultMap="studentResultMapAssociation">
>             select
>                 s.sid,s.sname,c.cid,c.cname
>             from
>                 t_stu as s left join t_clazz as c on s.cid = c.cid
>             where
>                 s.sid = #{sid};
>         </select>
>         <select id="selectByIDStepOne" resultMap="studentResultMapByStep">
>             select sid,sname,cid from t_stu where sid = #{sid}
>         </select>
>     
>     
>     
>         <resultMap id="studentResultMapByStep" type="student">
>             <id property="sid" column="sid"></id>
>             <result property="sname" column="sname"></result>
>     
>             <association property="clazz" select="com.powernode.mybatis.mappers.ClazzMapper.selectByIdStepTwo" column="cid"></association>
>         </resultMap>
>     </mapper>

>     <?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">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.ClazzMapper">
>         <select id="selectByIdStepTwo" resultType="clazz">
>             select cid,cname from t_clazz where cid = #{cid}
>         </select>
>     </mapper>
> 
>     <?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">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.ClazzMapper">
>         <select id="selectByIdStepTwo" resultType="clazz">
>             select cid,cname from t_clazz where cid = #{cid}
>         </select>
>     </mapper>

>     package com.powernode.mybatis.mappers;
>     
>     import com.powernode.mybatis.pojo.Clazz;
>     
>     public interface ClazzMapper
>     {
>         //分步查询第二步,根据cid查询班级信息
>         Clazz selectByIdStepTwo(Integer cid);
>     }
> 
>     package com.powernode.mybatis.mappers;
>     
>     import com.powernode.mybatis.pojo.Clazz;
>     
>     public interface ClazzMapper
>     {
>         //分步查询第二步,根据cid查询班级信息
>         Clazz selectByIdStepTwo(Integer cid);
>     }

>     package com.powernode.mybatis.mappers;
>     
>     import com.powernode.mybatis.pojo.Student;
>     
>     public interface StudentMapper
>     {
>         //分步查询第一步,根据SID查询学生信息
>         Student selectByIDStepOne(Integer id);
>         //使用Association的方式查询学生信息
>         Student selectByAssociation(Integer id);
>         //根据ID获取学生信息,获取学生关联的ID信息
>         Student selectById(Integer id);
>     }
> 
>     package com.powernode.mybatis.mappers;
>     
>     import com.powernode.mybatis.pojo.Student;
>     
>     public interface StudentMapper
>     {
>         //分步查询第一步,根据SID查询学生信息
>         Student selectByIDStepOne(Integer id);
>         //使用Association的方式查询学生信息
>         Student selectByAssociation(Integer id);
>         //根据ID获取学生信息,获取学生关联的ID信息
>         Student selectById(Integer id);
>     }

>     package com.powernode.mybatis.Test;
>     
>     import com.powernode.mybatis.mappers.StudentMapper;
>     import com.powernode.mybatis.pojo.Student;
>     import com.powernode.mybatis.utils.SqlSessionUtils;
>     import org.apache.ibatis.session.SqlSession;
>     import org.junit.Test;
>     import org.slf4j.Logger;
>     import org.slf4j.LoggerFactory;
>     
>     public class StudentMapperTest
>     {
>         private static final Logger logger = LoggerFactory.getLogger(StudentMapperTest.class);
>         @Test
>         public void selectById()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectById(1);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>         @Test
>         public void selectByAssociation()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectByAssociation(2);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>         @Test
>         public void selectByIdStepTwo()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectByIDStepOne(1);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>     }
> 
>     package com.powernode.mybatis.Test;
>     
>     import com.powernode.mybatis.mappers.StudentMapper;
>     import com.powernode.mybatis.pojo.Student;
>     import com.powernode.mybatis.utils.SqlSessionUtils;
>     import org.apache.ibatis.session.SqlSession;
>     import org.junit.Test;
>     import org.slf4j.Logger;
>     import org.slf4j.LoggerFactory;
>     
>     public class StudentMapperTest
>     {
>         private static final Logger logger = LoggerFactory.getLogger(StudentMapperTest.class);
>         @Test
>         public void selectById()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectById(1);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>         @Test
>         public void selectByAssociation()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectByAssociation(2);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>         @Test
>         public void selectByIdStepTwo()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
>             Student student = mapper.selectByIDStepOne(1);
>             logger.info(student.toString());
>             SqlSessionUtils.close(sqlSession);
>         }
>     }