复杂对象ibatis插入，属性为list，怎么一次性插入

转自：http://mzhj.iteye.com/blog/1030359

public class PfStuffInfoVo implements Serializable {
/** 信息Id */
  private String infoId;
  /** 项目Id */
  private String proid;
/** 附件信息 */
  private List<PfFileVo> fileList;

...

这是我的对象 该怎么把fileList属性已插入，PfFileVo 有对应的表

貌似iBatis没有提供多个关联对象的同时插入

你需要再Service层调用多个DAO去做多个关联对象的插入操作

批处理在iBatis里是肯定有的

貌似叫batchUpdate方法

不记得了，这个你可以上网搜搜，答案很多的

iBatis3里貌似确实木有批量插入，很郁闷的说

回答者：clarck_913 - 2011-05-05 09:24:52

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

POJO

Java code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->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

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?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 code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?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>

DAO

Java code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->public interface CustomerDAO {     public Long insert(Customer c);     public List<Customer> getById(Long id);     public List<Customer> getWithCashById(Long id);     public List<Customer> getWithCashByIdInnerjoin();     }public class CustomerDAOImpl extends SqlMapClientDaoSupport implements CustomerDAO {     public Long insert(Customer c) {         return (Long) getSqlMapClientTemplate().insert("customer.insert",c);     }     public List<Customer> getById(Long id) {         return getSqlMapClientTemplate().queryForList("customer.getById",id);     }     public List<Customer> getWithCashById(Long id) {         return getSqlMapClientTemplate().queryForList("customer.getWithCashById",id);     }     public List<Customer> getWithCashByIdInnerjoin(){         return getSqlMapClientTemplate().queryForList("customer.getWithCashByIdInnerjoin");     } }public interface OrdersDAO {     public Long insert(Orders o);     public Orders getById(Long id);     public List<Orders> findByCustomerId(Long cid);     public List<Orders> getByIdWithCash(Long id); }public class OrdersDAOImpl extends SqlMapClientDaoSupport implements OrdersDAO {     public Long insert(Orders o) {         return (Long) getSqlMapClientTemplate().insert("orders.insert", o);     }     public Orders getById(Long id) {         return (Orders) getSqlMapClientTemplate().queryForObject("orders.getById", id);     }     public List<Orders> findByCustomerId(Long cid) {         return getSqlMapClientTemplate().queryForList("orders.findByCustomerId", cid);     }     public List<Orders> getByIdWithCash(Long id) {         return (List<Orders>) getSqlMapClientTemplate().queryForList("orders.getByIdWithCash",id);     } }

test

Java code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->/** * Created by IntelliJ IDEA.<br> * <b>User</b>: leizhimin<br> * <b>Date</b>: 2008-6-15 22:50:15<br> * <b>Note</b>: 客户订单一对多模型：客户 */ public class CustomerDAOTest {     private CustomerDAO customerDAO = (CustomerDAO) ApplicationContextUtils.getApplicationContext().getBean("customerDAO");     public void testInsert() {         System.out.println("--------insert(Customer c)--------");         Customer c = new Customer();         //fuck!竟然不支持级联保存！ //        Orders order1 = new Orders("o1"); //        Orders order2 = new Orders("o2"); //        c.getOrderlist().add(order1); //        c.getOrderlist().add(order2);         c.setName("多对一");         c.setSex("M");         c.setPostcode("450003");         c.setAddress("郑州市花园路");         Long pk = customerDAO.insert(c);         System.out.println("插入数据的ID=" + pk);     }     public void testGetById() {         System.out.println("--------getById(Long id)--------");         Long pk = 1L;         List<Customer> list = customerDAO.getById(pk);         for (Customer c : list) {             System.out.println(c);         }     }     public void testGetWithCashById() {         System.out.println("--------getWithCashById(Long id)--------");         Long pk = 1L;         List<Customer> list = customerDAO.getWithCashById(pk);         for (Customer c : list) {             System.out.println(c);         }     }     public void testGetWithCashByIdInnerjoin() {         System.out.println("--------getWithCashByIdInnerjoin()--------");         List<Customer> list = customerDAO.getWithCashByIdInnerjoin();         for (Customer c : list) {             System.out.println(c);         }     }     public static void main(String args[]) {         System.out.println("正在测试CustomerDAO");         CustomerDAOTest customerDAOTest = new CustomerDAOTest();         customerDAOTest.testInsert();         customerDAOTest.testGetById();         customerDAOTest.testGetWithCashById();         customerDAOTest.testGetWithCashByIdInnerjoin();     } } public class OrdersDAOTest {     OrdersDAO ordersDAO = (OrdersDAO) ApplicationContextUtils.getApplicationContext().getBean("ordersDAO");     public void testInsert() {         System.out.println("--------getWithCashById(Long id)--------");         Orders o = new Orders("o1");         o.setCustomerId(1L);         Long pk = ordersDAO.insert(o);         System.out.println("所插入数据ID=" + pk);     }     public void testGetById() {         System.out.println("--------getById(Long id)--------");         Orders o = ordersDAO.getById(1L);         System.out.println("查询结果：" + o.toString());     }     public void testFindByCustomerId() {         System.out.println("--------findByCustomerId(Long cid)--------");         List<Orders> list = ordersDAO.findByCustomerId(1L);         for(Orders o : list){             System.out.println(o);         }     }     public static void main(String args[]){         System.out.println("正在测试OrderDAO");         OrdersDAOTest ordersDAOTest = new OrdersDAOTest();         ordersDAOTest.testInsert();         ordersDAOTest.testGetById();         ordersDAOTest.testFindByCustomerId();         ordersDAOTest.testGetByIdWithCash();     }     public void testGetByIdWithCash(){         System.out.println("------------getByIdWithCash(Long id)----------");         List<Orders> list = ordersDAO.getByIdWithCash(1L);         for(Orders o : list){             System.out.println(o +"\n\t"+o.getCustomer().toString());         }     } }