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());