读书人

ibatis动态传到表名、字段名

发布时间: 2012-08-22 09:50:35 作者: rapoo

ibatis动态传入表名、字段名

?java

    Map<String,Object> params = new HashMap<String,Object>();        params.put("tableName", tableName);        params.put("sidFieldName", sidFieldName);        params.put("lastDateFiledName", lastDateFiledName);        params.put("serviceDateFiledName", serviceDateFiledName);        params.put("uidFieldName", uidFieldName);        params.put("1", userType);        params.put("2", uid);getSqlMapClientTemplate().update("updateUserType" , params);

?sqlmap.xml

 <update id="updateUserType" parameterClass="map">    <![CDATA[      update /*99*/ $tableName$ SET $sidFieldName$ = #1# , $lastDateFiledName$ = sysdate,$serviceDateFiledName$ = sysdate WHERE $uidFieldName$ = #2#    ]]>  </update>
?

读书人网 >软件架构设计

热点推荐