외부 파라미터 맵 사용하기

sqlMap-test.xml

<parameterMap id="accountParameterMap" class="Information">

<parameter property="id" jdbcType="NUMBER"/>
<parameter property="name" jdbcType="VARCHAR"/>
<parameter property="password" jdbcType="VARCHAR"/>
<parameter property="join" jdbcType="TIMESTAMP"/>
<parameter property="address" jdbcType="VARCHAR"/>
<parameter property="state" jdbcType="VARCHAR"/>
<parameter property="country" jdbcType="VARCHAR"/>
<parameter property="postcode" jdbcType="VARCHAR"/>
<parameter property="version" jdbcType="VARCHAR"/>

</parameterMap>

<insert id="insertOutline" parameterMap="accountParameterMap">

insert into account(id, name, password, join, address, city, state, country, postcode, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?)

</insert>

main class file

Information info = new Information();
info.setId("special0strawberry");
...//생략해도 알것이라 생각됨
sqlMapClient.insert("insertInline", info);

//딱히 별 표시 없어도 알듯...