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

一、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 >