<!-- 新增banner图List -->
<insert id ="insertBannerList" parameterType="java.util.List" >
INSERT INTO `banner` (title, content, url, imgsrc,typeCode,typeName, creatDate,orderNum,schoolId,schoolName) VALUES
<foreach collection ="bannerList" item="banner" separator =",">
(
'${banner.title}',
'${banner.content}',
'${banner.url}',
'${banner.imgsrc}',
'${banner.typeCode}',
'${banner.typeName}',
NOW(),
${banner.orderNum},
${banner.schoolId},
'${banner.schoolName}'
)
</foreach >
</insert >