实用，简单 ibatis demo （包含多对一；一对多）

最新推荐文章于 2018-05-15 17:07:15 发布

原创最新推荐文章于 2018-05-15 17:07:15 发布 · 151 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#iBATIS #SQL #Apache #XML #C

MVC+ORM 专栏收录该内容

29 篇文章

订阅专栏

本文介绍了一个使用MyBatis框架的简单示例，包括Customer和Orders两个POJO类的设计及其对应的XML配置文件。通过这些配置，实现了基本的数据库操作，如插入、查询等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、POJO

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 String toString() {
        return "Customer{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", address='" + address + '\'' +
                ", postcode='" + postcode + '\'' +
                ", sex='" + sex + '\'' +
                ", orderlist=" + orderlist.size() +
                '}';
    }

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

    public String toString() {
        return "Orders{" +
                "id=" + id +
                ", code='" + code + '\'' +
                ", customerId=" + customerId +
                '}';
    }

二、SqlMap

Customer.xml

<?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="long" resultMap="result_base">
        select * from customer where id = #value#
    </select>
    <select id="getWithCashById" parameterClass="long" resultMap="result">
        select * from customer where id = #value#
    </select>
    <select id="getWithCashByIdInnerjoin" parameterClass="long" resultClass="customer" resultMap="result">
        select c.* from customer c inner join orders o on c.id=o.customerId
    </select>

</sqlMap>

Orders.xml

<?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="orders">
    <typeAlias alias="orders" type="com.lavasoft.ssi.domain.Orders"/>
    <resultMap id="result_base" class="orders">
        <result property="id" column="id"/>
        <result property="code" column="code"/>
        <result property="customerId" column="customerId"/>
    </resultMap>
    <resultMap id="result" class="orders" extends="result_base">
        <result property="customer" column="customerId" select="customer.getById"/>
    </resultMap>

    <insert id="insert" parameterClass="orders">
        insert into orders(id,code,customerId) values(#id#,#code#,#customerId#)
        <selectKey keyProperty="id" resultClass="long">
            select LAST_INSERT_ID()
        </selectKey>
    </insert>

    <select id="findByCustomerId" resultMap="result_base" parameterClass="long">
        select * from orders where customerId = #value#
    </select>
    <select id="getById" parameterClass="long" resultMap="result_base">
        select * from orders where id = #value#
    </select>
    <select id="getByIdWithCash" resultMap="result" resultClass="orders" parameterClass="long">
        select * from orders where id = #value#
    </select>

</sqlMap>