01 <?xml version="1.0" encoding="UTF-8" ?>
02 <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
03 <sqlMap namespace="ArtistDAO">
04
05 <resultMap id="ArtistResult" class="com.asimovt.ibatisext.samples.crud.Artist">
06 <result property="id" column="id" />
07 <result property="name" column="name" />
08 <result property="birthDay" column="birth_day" />
09 </resultMap>
10
11 <select id="ArtistDAO_findAll" resultMap="ArtistResult">
12 SELECT * FROM artist
13 </select>
14
15 <select id="ArtistDAO_findByPk" parameterClass="java.lang.Integer" resultMap="ArtistResult">
16 SELECT * FROM artist
17 WHERE id = #id#
18 </select>
19
20 <insert id="ArtistDAO_insert" parameterClass="com.asimovt.ibatisext.samples.crud.Artist">
21 INSERT INTO artist
22 ( name, birth_day)
23 VALUES ( #name#, #birthDay#)
24 <selectKey type="post" resultClass="java.lang.Integer" keyProperty="id">
25 SELECT LAST_INSERT_ID();
26 </selectKey>
27 </insert>
28
29 <update id="ArtistDAO_update" parameterClass="com.asimovt.ibatisext.samples.crud.Artist">
30 UPDATE artist
31 SET name = #name#, birth_day = #birthDay#
32 WHERE id = #id#
33 </update>
34
35 <delete id="ArtistDAO_delete" parameterClass="java.lang.Integer">
36 DELETE FROM artist
37 WHERE id = #id#
38 </delete>
39
40 </sqlMap>
|