ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicholoz Koka Kiknadze" <kikna...@gmail.com>
Subject Re: <update> with parameterMap and parameterClass ?
Date Wed, 26 Nov 2008 22:32:30 GMT
>
>     <parameterMap id="messageParameterMap" class="Message">
>         <parameter property="id1" jdbcType="INTEGER"/>
>         <parameter property="id2" jdbcType="INTEGER"/>
>         <parameter property="messageCount" jdbcType="INTEGER" />
>         <parameter property="title" jdbcType="VARCHAR"/>
>     </parameterMap>
>
>     <insert id="insertMessage" parameterMap="messageParameterMap" >
>         INSERT INTO MSGS ( SY_ID1, SY_ID2, MS_COUNT, MS_TITLE)
>         VALUES (#id1#,#id2,#messageCount#,#title#)
>     </insert>
>
>     <update id="update" parameterMap="messageParameterMap" >
>         UPDATE MSGS SET MS_COUNT=#messageCount#, MS_TITLE=#title# WHERE
> SY_ID1=#id1# AND SY_ID2 = #id2#
>     </update>
>
>
I.e. for selects/crud replace question marks with actual property name
enclosed with ##.
However you'll have to use questionmark placeholders when calling stored
procedures, and there you'll need to care about the order in your parameter
map.

Mime
View raw message