mybatis用association指定外键结合select实现级联属性查询
来源:互联网 发布:数据库用户权限设置 编辑:程序博客网 时间:2024/06/05 20:20
package com.gewb.dao;
import java.util.List;
import com.gewb.entity.Student;
public interface StudentDao {
public void addStudent(Student student);
// public List<Student> findStudentByAddress(int addressId);
public List<Student> findStudentWithAddress(int id);
import com.gewb.entity.Address;
public interface AddressDao {
public Address findById(int id);
<?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.gewb.dao.StudentDao">
<resultMap type="Student" id="StudentResult">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="age" column="age"/>
<association property="address" column="addressId" select="com.gewb.dao.AddressDao.findById"></association>
</resultMap>
<select id="findStudentWithAddress" parameterType="Integer" resultMap="StudentResult">
select t1.* from student t1,address t2 where t1.addressId = t2.id and t1.id = #{id};
</select>
<insert id="addStudent" parameterType="Student">
insert into student values(null,#{name},#{age});
</insert>
<?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.gewb.dao.AddressDao">
<resultMap type="Address" id="AddressResult">
<id property="eId" column="id"/>
<result property="eProvince" column="province"/>
<result property="eCity" column="city"/>
<result property="eDistrict" column="district"/>
</resultMap>
<select id="findById" parameterType="Integer" resultMap="AddressResult">
select * from address where id = #{id};
</select>
</mapper>
import java.util.List;
import com.gewb.entity.Student;
public interface StudentDao {
public void addStudent(Student student);
// public List<Student> findStudentByAddress(int addressId);
public List<Student> findStudentWithAddress(int id);
}
import com.gewb.entity.Address;
public interface AddressDao {
public Address findById(int id);
}
<?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.gewb.dao.StudentDao">
<resultMap type="Student" id="StudentResult">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="age" column="age"/>
<association property="address" column="addressId" select="com.gewb.dao.AddressDao.findById"></association>
</resultMap>
<select id="findStudentWithAddress" parameterType="Integer" resultMap="StudentResult">
select t1.* from student t1,address t2 where t1.addressId = t2.id and t1.id = #{id};
</select>
<insert id="addStudent" parameterType="Student">
insert into student values(null,#{name},#{age});
</insert>
</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.gewb.dao.AddressDao">
<resultMap type="Address" id="AddressResult">
<id property="eId" column="id"/>
<result property="eProvince" column="province"/>
<result property="eCity" column="city"/>
<result property="eDistrict" column="district"/>
</resultMap>
<select id="findById" parameterType="Integer" resultMap="AddressResult">
select * from address where id = #{id};
</select>
</mapper>
0 1
- mybatis用association指定外键结合select实现级联属性查询
- MyBatis的级联查询(association 进行分布查询)
- Mybatis中使用Association元素进行一对一级联查询
- mybatis 学习记录(4.1)—— 级联查询(无 association 和 collection)
- mybatis 学习记录(4.2)—— 级联查询(有 association 和 collection)
- MyBatis中Association联合select使用
- MyBatis中Association联合select使用
- MyBatis中Association联合select使用
- MyBatis中Association联合select使用
- Mybatis 级联属性赋值
- mybatis 级联查询
- mybatis特性--- 级联查询
- MyBatis 的级联查询
- mybatis级联查询
- Mybatis级联查询
- mybatis级联查询
- mybatis级联查询
- MyBatis 级联查询
- Java语言类库
- GIT第三讲的四种文件状态和索引
- 机器学习小组知识点18:伽马分布(Gamma Distribution)
- VTK数据结构2
- 基础C语音编程时常犯的错误
- mybatis用association指定外键结合select实现级联属性查询
- X86操作系统与X64操作系统的区别
- angularjs Error: [ngRepeat:dupes] http://errors.angularjs.org/1.5.8/ngRepeat/dupes?
- 二维数组与指针
- SQLite3 小技巧
- u-boot器件驱动模型(Device&Drivers)之链接器的秘密
- 实时查询引擎 - 构建于HDFS之上的Greenplum: HAWQ
- PMP学习笔记之第13章 项目干系人管理 ——13.1识别干系人
- 机器数及真值