Mybaits batch database operations

Welcome to the Oracle community forum and interact with 2 million technical staff to access the ORACLE database: insertparameterTypejava. util. ListINSERTINTOQCMS_PUB_ROLE_R_MENU (MENU_ID, ROLE_ID) (foreachcollectionlistitemitemindexin

Welcome to the Oracle community forum to interact with 2 million technical staff> go to the ORACLE database: insert id = "batchInsertRoleRMenu" parameterType = "java. util. list "insert into QCMS_PUB_ROLE_R_MENU (MENU_ID, ROLE_ID) (foreach collection =" list "item =" item "index =" in

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

ORACLE Database:

Insert into QCMS_PUB_ROLE_R_MENU (

MENU_ID,

ROLE_ID

)(

Select

# {Item. menuId, jdbcType = NUMERIC },

# {Item. roleId, jdbcType = NUMERIC}

From dual

)

Other databases such as mybaits:

Insert into QCMS_PUB_ROLE_R_MENU (

MENU_ID,

ROLE_ID

) VALUES

(

# {Item. menuId, jdbcType = NUMERIC },

# {Item. roleId, jdbcType = NUMERIC}

)