/** * 批量插入用户信息 * * @param userList * @return */ int insertList(List<SysUser> userList);
<insert id="insertList" useGeneratedKeys="true" keyProperty="id"> INSERT INTO sys_user(user_name, user_password, user_email, user_info, head_img, create_time) VALUES <foreach collection="list" item="user" separator=","> (#{user.userName},#{user.userPassword},#{user.userEmail},#{user.userInfo},#{user.headImg,jdbcType=BLOB},#{user.createTime,jdbcType=TIMESTAMP}) </foreach> </insert>
Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
<insert id="myInsert" parameterType="java.util.List"> insert into NST_EXPRESS_HOLIDAY(ID,NAME) select A.ID,A.NAME from ( <foreach collection="list" item="one" index="index" separator="UNION ALL"> SELECT #{one.id} ID, #{one.name} NAME FROM dual </foreach> ) A </insert>
参考资料1
参考资料2