bean层:
private long id; // 主键 private long homeworkId; // 作业库作业ID private long userId; private int userType; private String content; private Date uploadTime; private int type; // 文件类型 (1.图片 2.语音 3:文档) private String fileName; // 文件名称 private String originalFileName; // 原始文件名称(内容出现敏感字时使用) private String path; // 文件相对路径 private String thumbPath; // 缩略图路径(供客户端使用) private int fileSize; // 文件大小(语音为秒数)
DAO层:
批量插入,注意点:1. _list.homeworkId中的 homeworkId 需要和实体的成员属性一样,2. 不用加 values
//插入教师或家长秀的作业
public void insertHomeworkShowT(
@Param(
"daoAbb")String daoAbb,
@Param(
"_list") List<HomeworkShowEntity> list);
xml层:
<sql id="homeworkShowColumns2"> homework_id, type, user_type, user_id, file_name, original_file_name, content, path, thumb_path </sql>
<!--新增秀作业数据-->
< insert id ="insertHomeworkShowT" parameterType ="ArrayList" >
insert into ${daoAbb}_HOMEWORK_SHOW ( < include refid ="homeworkShowColumns2" />)
< foreach collection ="_list" item ="_list" index ="index" open ="(" close =")" separator ="UNION ALL" >
select
#{_list.homeworkId,jdbcType=NUMERIC},
#{_list.type,jdbcType=NUMERIC},
#{_list.userType,jdbcType=NUMERIC},
#{_list.userId,jdbcType=NUMERIC},
#{_list.fileName,jdbcType=VARCHAR},
#{_list.originalFileName,jdbcType=VARCHAR},
#{_list.content,jdbcType=VARCHAR},
#{_list.path,jdbcType=VARCHAR},
#{_list.thumbPath,jdbcType=VARCHAR}
from dual
</ foreach >
</ insert >
< insert id ="insertHomeworkShowT" parameterType ="ArrayList" >
insert into ${daoAbb}_HOMEWORK_SHOW ( < include refid ="homeworkShowColumns2" />)
< foreach collection ="_list" item ="_list" index ="index" open ="(" close =")" separator ="UNION ALL" >
select
#{_list.homeworkId,jdbcType=NUMERIC},
#{_list.type,jdbcType=NUMERIC},
#{_list.userType,jdbcType=NUMERIC},
#{_list.userId,jdbcType=NUMERIC},
#{_list.fileName,jdbcType=VARCHAR},
#{_list.originalFileName,jdbcType=VARCHAR},
#{_list.content,jdbcType=VARCHAR},
#{_list.path,jdbcType=VARCHAR},
#{_list.thumbPath,jdbcType=VARCHAR}
from dual
</ foreach >
</ insert >