UserRoleAut ura=new UserRoleAut();
ura.setXXX("11");
record.add(ura)
根据这些条件在UserRoleAut表中查询。
参考
http://www.cnblogs.com/luxiaoxun/p/4035040.html
比如你可以看里面的selectUsersByName的实现,怎么写sql怎么传参数。
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
This element was generated on Wed Jul 08 10:06:52 CST 2015.
-->
select RU_ID_SEQ.Nextval from USER_ROLE_AUT
insert into USER_ROLE_AUT
(RU_ID,RU_ROLE_ID, RU_AUT_ID, RU_TIME_INS, RU_USER_INS, RU_TIME_LST, RU_USER_LST, RU_STATUS)
select RU_ID_SEQ.Nextval,U.* from USER_ROLE_AUT
<foreach collection="map" item="item" index="key" separator="union all" >
select
#{item.ruRoleId,jdbcType=DECIMAL},
#{item.ruAutId,jdbcType=DECIMAL},
#{item.ruTimeIns,jdbcType=TIMESTAMP},
#{item.ruUserIns,jdbcType=VARCHAR},
#{item.ruTimeLst,jdbcType=TIMESTAMP},
#{item.ruUserLst,jdbcType=VARCHAR},
#{item.ruStatus,jdbcType=DECIMAL}
from USER_ROLE_AUT
</foreach>
)U
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
This element was generated on Wed Jul 08 10:06:52 CST 2015.
-->
select RU_ID_SEQ.Nextval from USER_ROLE_AUT
insert into USER_ROLE_AUT
(RU_ID,RU_ROLE_ID, RU_AUT_ID, RU_TIME_INS, RU_USER_INS, RU_TIME_LST, RU_USER_LST, RU_STATUS)
select RU_ID_SEQ.Nextval,U.* from USER_ROLE_AUT
<foreach collection="map" item="item" index="key" separator="union all" >
select
#{item.ruRoleId,jdbcType=DECIMAL},
#{item.ruAutId,jdbcType=DECIMAL},
#{item.ruTimeIns,jdbcType=TIMESTAMP},
#{item.ruUserIns,jdbcType=VARCHAR},
#{item.ruTimeLst,jdbcType=TIMESTAMP},
#{item.ruUserLst,jdbcType=VARCHAR},
#{item.ruStatus,jdbcType=DECIMAL}
from USER_ROLE_AUT
</foreach>
)U
select RU_ID_SEQ.Nextval from USER_ROLE_AUT
这个是主键id
List里有一个add方法,直接调用即可