上传
javaScript
str3 +='<div id="fileDiv" class="my-input-box" style="width:80%"><div class="label-box"><label class="test">文件:</label></div>';
str3 +='<div>';
str3 +='<table class="layui-table" style="margin-left: 70px;"><thead><tr><th>上传 <input type="button" class="my-button resetmargin" style="float: right;" οnclick="addFile()" value="添加文件" /></th>';
str3 +='</tr></thead><tbody id="subjectTbody"><tr><td><div id="fileTd"></div></td></tr></tbody></table></div></div>';
$("#schoolRollStatusUpdate").html(str3);
/**
* 添加文件
* @returns
*/
function addFile() {
fileDivId += 1;
$("#fileTd").append('<div class="filesDiv" id="fileDiv' + fileDivId + '" style="height: 30px;"><input name="applyFiles" style="width: 180px;display: inline-block;line-height: 15px;" type="file"/><input type="button" οnclick="deleteFileInput(' + fileDivId + ')" value="删除" class="my-button" /></div>');
}
/**
* 删除文件
* @param id
* @returns
*/
function deleteFileInput(id) {
$("#fileDiv" + id).remove();
}
//学生审核文件变更提交
function saveStudentRoll(){
/*判断审核文件是否上传*/
//stuNameNew stuNumberNew grnderNew idCardNew nationNew
var filesI = $("input[name='applyFiles']");
var nullNum = 0;
for (var i = 0; i < filesI.length; i++) {
console.log(filesI[i].files[0].name);
if (filesI[i].files.length == 0) {
nullNum = 1;
}
}
//如果文件时必填项,加上此段代码
/**if(filesI.length == 0) {
layer.msg("请上传审核文件!");
return false;
}*/
if (nullNum == 1) {
layer.msg("请检查上传文件!");
$('#saveStudent').attr('disabled',false);
return false;
}
var filesI = $("input[name='applyFiles']");
var formData = new FormData();
//formData.append("length", filesI.length);
formData.append("newRunningId", newRunningId);
for (var i = 0; i < filesI.length; i++) {
console.log(filesI[i].files[0].name);
formData.append("file"+(i+1), filesI[i].files[0]);
}
$.ajax({
url: ctx+"/applySchoolRollUpdate/insertFiles",
type: 'post',
data: formData,
cache: false,
processData: false,
contentType: false,
async: false,
success : function(data){
if(data==1){
layer.msg('上传成功');
}
}
Controller
/*
* 审核文件
*/
@SysLog("学籍异动--审核文件")
@NotifyWebSocketProject(value = "4",name="学生转专业")
@RequestMapping(value = "insertFiles", method = RequestMethod.POST)
@ResponseBody
public String uploadMult(HttpServletRequest request) {
return applySchoolRollUpdateService.uploadMultFiles(request);
}
Service
/*
* 文件审批处理 存储文件
*/
@Transactional
public String uploadMultFiles(HttpServletRequest request){
// 转型为MultipartHttpRequest:
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
ExamApprovalManageManage entity = new ExamApprovalManageManage();//创建实体类,进行文件路径存储
String currentTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());//获取当前时间,添加在文件路径存储只能
String newRunning = request.getParameter("newRunningId"); ;//得到参数主表id 进行文件路径保存
List<String> filePath = new ArrayList<>();
String path = Global.getUserfilesBaseDir()+"userfiles/SchoolRollfiles/";
File dirFile = new File(path);
if (!dirFile.exists()) {
dirFile.mkdirs();
}
/* String path = "E:/test";*/
filePath.add(0, currentTime);
filePath.add(path);//集合中添加路径
int index = 1;
for(int i=1;i<=index;i++){
List<MultipartFile> files = multipartRequest.getFiles("file"+i);
if (files.isEmpty()) {
continue;//数据保存结束
}else{
index++;//下次循环长度加1
for (MultipartFile file : files) {
String fileName = file.getOriginalFilename();
int size = (int) file.getSize();
System.out.println(fileName + "-->" + size);
filePath.add(fileName);//集合中添加文件名称
File dest = new File(path + "/" + fileName);
if (!dest.getParentFile().exists()) { // 判断文件父目录是否存在
dest.getParentFile().mkdir();
}
try {
file.transferTo(dest);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return "-2";//文件保存失败
}
}
}
}
System.out.println(filePath.toString());
System.out.println(newRunning);
entity.setApporvalFiles(filePath.toString());//将文件存储路径放入实体类
entity.setRunningId(newRunning);//放入对应数据主键
//执行数据修改
int i = this.dao.updateSchoolRollPrimary(entity);
if(i>0){
return "1";
}
return "-1";
}
/**
* 获取上传文件的根目录
* @return
*/
public static String getUserfilesBaseDir() {
String dir = getConfig("userfiles.basedir");
if(!dir.endsWith("/")) {
dir += "/";
}
// System.out.println("userfiles.basedir: " + dir);
return dir;
}
dao
/*
* 更改学籍变更申请主表中的数据,添加文件路径
*/
int updateSchoolRollPrimary(ExamApprovalManageManage examApprovalManageManage);
xml
<!-- 更改学籍变更申请表中的数据,添加文件路径 -->
<update id="updateSchoolRollPrimary" parameterType="com.bigdata.campus.stu.entity.ExamApprovalManageManage">
update school_roll_primary_table set apply_files=#{apporvalFiles} where running_id = #{runningId}
</update>
多文件存储到数据库的形式
下载
js
//个人学籍变更记录
var tempParams = {};
var curr = 1;
var pageSize = 10;
function schoolRollList(idCard,stuNumber,stuName,examNumber,degree){
var str = '<div class="tableWrap" ><table class="layui-table my-table" align="center">';
str +='<thead><tr><th width=60 >序号</th><th width=120>操作时间</th><th width=80>操作人</th><th width=60>流水号</th><th width=120">原专业</th><th width=120">原班级</th><th width=120">现专业</th><th width=120">现班级</th><th width=120>申请文件</th>';
str +='<th width=100>备注</th></tr></thead><tbody id="tableData" align="center"></tbody></table></div>';
str +='<div class="foot"></div></div><br>';
$("#schoolRollList").html(str);
var str1 = '';
$.ajax({
url: ctx +"/applySchoolRollUpdate/findListSchoolRoll",
data: {"stuNumber":stuNumber,"idCard":idCard,"degree":degree,"examNumber":examNumber,"stuName":stuName},
dataType: "json",
contentType: 'application/x-www-form-urlencoded',
type: 'post',
success: function(data){
var list = data.data;
var fileStr = "";
for (var t = 0,s=1; t < list.length; t++) {
str1 +="<tr align='center'><td>"+(s++)+"</td>";
str1 +="<td>"+list[t].createTime+"</td>";
str1 +="<td>"+list[t].userName+"</td>"
str1 +="<td>"+list[t].runningId+"</td>";
str1 +="<td>"+list[t].oldMajor+"</td>";
str1 +="<td>"+list[t].oldClass+"</td>";
str1 +="<td>"+list[t].newMajor+"</td>";
str1 +="<td>"+list[t].newClass+"</td>";
var FileNameA = list[t].applyFiles;
var FileNameB="";
if(FileNameA!=null){
FileNameB = FileNameA.split("][");
}
var fileStr = "";
if (FileNameB != null&&FileNameB!="") {
for(var j=0;j<FileNameB.length;j++){
fileStr += "<div>";
var FileName = FileNameB[j].replace("[","").replace("]","").split(",");
for (var i = 2; i < FileName.length; i++) {
var key ="1" + "" + j + "" + i + "" + t;
tempParams["" +key + ""] = FileName[1] + "," + FileName[i];
fileStr += "<div class='normalWrap'>";
if (imgExt.in_array(FileName[i].substring(FileName[i].lastIndexOf(".")))) {
fileStr += "<a id='normalA" + key + "' οnclick='downLoadFile(" + key + ")'>"
+ "<i class='layui-icon'></i> "
+ FileName[i].trim() + "</a>";
} else {
fileStr += "<a id='normalA" + key + "' οnclick='downLoadFile(" + key + ")'><i class='layui-icon'></i> " + FileName[i].trim() + "</a>";
}
fileStr += "</div>";
}
}
}
str1+="<td title="+list[t].applyFiles+">"+fileStr+"</td><td title="+list[t].remark+">"+list[t].remark+"</td></tr>";
}
$("#tableData").html(str1);
}
})
}
var imgExt = new Array(".png",".jpg",".jpeg",".bmp",".gif");
Array.prototype.in_array = function (element) {
for (var i = 0; i < this.length; i++) {
if (this[i] == element) {
return true;
}
}
return false;
}
controller
/**
* 预览图片
* @param params
* @param response
*/
@SysLog("预览图片")
@RequestMapping(value="imgLook",method=RequestMethod.GET)
public void imageLook(String params, HttpServletResponse response) {
majorService.imageLook(params,response);
}
/**
* 专业审批文件下载
* @param params
* @param response
*/
@SysLog("专业审批文件下载")
@RequestMapping(value="fileDownLoad",method=RequestMethod.GET)
public void fileDownLoad(String params, HttpServletResponse response) {
majorService.fileDownLoadSer(params, response);
}
service
/**
* 图片预览
* @param params
* @param response
*/
public void imageLook(String params, HttpServletResponse response) {
String[] split = params.split(",");
String dir = split[0].trim();
String file = split[1].trim();
response.setContentType("text/html; charset=UTF-8");
response.setContentType("image/jpeg");
FileInputStream fis;
OutputStream os;
try {
fis = new FileInputStream(dir + file);
os = response.getOutputStream();
int count = 0;
byte[] buffer = new byte[1024 * 1024];
while ((count = fis.read(buffer)) != -1)
os.write(buffer, 0, count);
os.flush();
os.close();
fis.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 文件下载Ser
* @param params
* @param response
*/
public void fileDownLoadSer(String params, HttpServletResponse response){
String[] split = params.split(",");
String dir = split[0].trim();
String file = split[1].trim();
InputStream inputStream;
try {
//获取输入流
inputStream = new BufferedInputStream(new FileInputStream(new File(dir + file)));
//设置下载头
response.addHeader("Content-Disposition", "attachment; filename =" + URLEncoder.encode(file, "UTF-8"));
//response.setContentType("");
BufferedOutputStream outputStream = new BufferedOutputStream(response.getOutputStream());
int b = 0;
while ((b = inputStream.read()) != -1) {
outputStream.write(b);
outputStream.flush();
}
outputStream.close();
System.out.println("下载文件成功");
} catch (FileNotFoundException e) {
System.out.println("找不到指定下载文件");
System.out.println("下载文件失败");
e.printStackTrace();
} catch (UnsupportedEncodingException e) {
System.out.println("编码异常");
System.out.println("下载文件失败");
e.printStackTrace();
} catch (IOException e) {
System.out.println("文件流异常");
System.out.println("下载文件失败");
e.printStackTrace();
}
}