ibatis 实体映射(一对多)

最新推荐文章于 2022-02-14 21:27:56 发布

江湖小蜗牛

最新推荐文章于 2022-02-14 21:27:56 发布

阅读量491

点赞数

分类专栏： hibernate

本文链接：https://blog.csdn.net/zhyb0306/article/details/18796681

版权

本文介绍了如何通过iBATIS框架进行一对多映射的配置和操作，包括在POJO类中定义一对多关系、在XML映射文件中设置映射规则以及在DAO层实现数据的增删查改。示例中展示了Customer与Orders的关联关系，并提供了测试用例。

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

可以通过ibatis建立一对多的映射

POJO
Java code

public class Customer {
private Long id;
private String name;
private String address;
private String postcode;
private String sex;
private List<Orders> orderlist = new ArrayList<Orders>();

public class Orders {
private Long id;
private String code;
private Long customerId;
private Customer customer;

Customer.xml
XML code

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="customer">
<typeAlias alias="customer" type="com.lavasoft.ssi.domain.Customer"/>

<resultMap id="result_base" class="customer">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="address" column="address"/>
<result property="postcode" column="postcode"/>
<result property="sex" column="sex"/>
</resultMap>
<resultMap id="result" class="customer" extends="result_base">
<result property="orderlist" column="id" select="orders.findByCustomerId"/>
</resultMap>

<insert id="insert" parameterClass="customer">
insert into customer(address,postcode,sex,name) values(#address#,#postcode#,#sex#,#name#)
<selectKey keyProperty="id" resultClass="long">
select LAST_INSERT_ID()
</selectKey>
</insert>
<select id="getById" parameterClass="