Ibatis对复杂类型的保存或查询操作

sqlmap的配置文件：

<?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>
<typeAlias alias="book" type="com.tr.mysq.Book"/>
<typeAlias alias="user" type="com.tr.mysql.Person"/>

<parameterMap class="user" id="savePerson">

  <parameter property="name" javaType="String" jdbcType="VARCHAR"/>
  <parameter property="age" javaType="int" jdbcType="int"/>
  <parameter property="birthday" javaType="date" jdbcType="date"/>
  <parameter property="book.bookId" javaType="int" jdbcType="int"/>
</parameterMap>

<resultMap class="com.tr.mysql.Person" id="getUserByIdParam">
 
   <result property="name" column="name"/>
   <result property="age" column="age"/>
   <result property="birthday" column="birthday"/>
   <result property="book.bookId" column="bookId"/>
   <result property="book.bookName" column="bookName"/>

</resultMap>

 

 

<statement id="getAllUser" resultMap="getUserByIdParam" parameterClass="int" >
select * from tbperson,tbbook  where id =#id#
</statement>

<insert id="save" parameterMap="savePerson">
  insert into tbperson (name,age,birthday,bookId) values
                        (?,?,?,?);
                        <selectKey keyProperty="id" resultClass="int">
                         select LAST_INSERT_ID()  
                        </selectKey>
        
</insert>

</sqlMap>

 

运行类：

private static SqlMapClient sqlMapClient = null;
 static{
  try {
   Reader reader = Resources.getResourceAsReader("com/tr/mysql/SqlMapConfig.xml");
   sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 

Person person = new Person();
   person.setAge(12);
   person.setBirthday(new Date());
   person.setName("test");
   Book  book = new Book();
   book.setBookId(1);
   person.setBook(book);

 

sqlMapClient.insert("save",person);
   System.out.println(person.getId());