之前琢磨了一段时间,终于弄好了,在此作为记录,一面以后忘记。
适用于Oracle,mybatis
service层:
pomProjPlanNodeMapper.insertForeach(pomProjPlanNodeList);
Dao层:
public interface PomProjPlanNodeMapper{
void insertForeach(List<PomProjPlanNode> list);
}
mybatis 的 xml:
<insert id="insertForeach" parameterType="java.util.List">
<selectKey keyProperty="id" order="BEFORE" resultType="java.lang.String">
select sys_guid() AS id from dual
</selectKey>
insert into POM_PROJ_PLAN_NODE
( ID, PROJ_PLAN_ID, ORIGINAL_NODE_ID, TEMPLATE_NODE_ID,
STANDARD_NODE_ID, NODE_GRADE, NODE_NAME, NODE_CODE, NODE_LEVEL,
PROJ_STAGE, MAIN_RESPONSIBILITY, CONTROL_TYPE,