java数据库导入选择题_java实现Excel导入数据库，并返回导入信息

$("#saveZipButton").on('click', function(){

var formData = new FormData();

var name = $("#articleImageFile").val();

var index = name.lastIndexOf(".");

var suffix = name.substring(index).toLowerCase();

formData.append("file",$("#articleImageFile")[0].files[0]);

formData.append("name",name);//这个地方可以传递多个参数

if(".xlsx" == suffix){

$("#uploadModal").modal('hide');

$.ajax({

url : "/excel/import_2007",

type : 'POST',

async : false,

data : formData,

// 告诉jQuery不要去处理发送的数据

processData : false,

// 告诉jQuery不要去设置Content-Type请求头

contentType : false,

success : function(res) {

//清空模态窗内容

$("#UploadSuccess").html("");

$("#UploadFail").html("");

//console.log(res);

if (res.map.statusCode==500){

layer.alert(res.message)

}else {

for (var index in res) {

if(res[index].map.statusCode == 200){　　//上传正确信息

if(res[index].map.testList.stlx == "01"){

var html = "

\n" +

" 单选题: "+ res[index].map.testList.stmc +"
\n" +

"

"

}

if(res[index].map.testList.stlx == "02"){

var html = "

\n" +

" 多选题: "+ res[index].map.testList.stmc +"
\n" +

"

"

}

if(res[index].map.testList.stlx == "03"){

var html = "

\n" +

" 判断题: "+ res[index].map.testList.sttg +"
\n" +

"

"

}

if(res[index].map.testList.stlx == "04"){

var html = "

\n" +

" 填空题: "+ res[index].map.testList.sttg +"
\n" +

"

"

}

if(res[index].map.testList.stlx == "05"){

var html = "

\n" +

" 主观题: "+ res[index].map.testList.sttg +"
\n" +

"

"

}

$("#UploadSuccess").append(html);

}

if(res[index].map.statusCode == 500){　　//上传错误信息

var rownuber = parseInt(res[index].map.row) + 1;

if(res[index].map.testList.stlx == "01"){

var html = "

\n" +

" 单选题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}else if(res[index].map.testList.stlx == "02"){

var html = "

\n" +

" 多选题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}else if(res[index].map.testList.stlx == "03"){

var html = "

\n" +

" 判断题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}else if(res[index].map.testList.stlx == "04"){

var html = "

\n" +

" 填空题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}else if(res[index].map.testList.stlx == "05"){

var html = "

\n" +

" 主观题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}else{

var html = "

\n" +

" 未知题(第"+ rownuber +"行): "+ res[index].map.errorMessage +"
\n" +

"

"

}

$("#UploadFail").append(html);

}

}

parent.layer.msg('正在校验文件内容，请稍候...', {shade: 0.3},function () {

layer.open({

type: 1,

title: ["上传结果", "color:#333333"], //不显示标题栏

closeBtn: false,

area: '600px;',

shade: 0.3,

id: 'LAY_layuipro', //设定一个id，防止重复弹出

btn: ['确认'],

btnAlign: 'a',

moveType: 1, //拖拽模式，0或者1

content: $("#uploadResult"),

yes: function(index,layero) {

$("#articleImageFile").val(""); //清空选择文件内容

search(pageNum,pageSize);

layer.close(index);

}

});

})

//错误信息窗结束

}

},

error:function (msg) {

layer.msg("程序发生错误，请联系技术人员！");

}

});

}else if(".xls" == suffix){

$("#uploadModal").modal('hide');

$.ajax({

url : "/excel/import_2003",

type : 'POST',

async : false,

dataType: "json",

data : formData,

// 告诉jQuery不要去处理发送的数据

processData : false,

// 告诉jQuery不要去设置Content-Type请求头

contentType : false,

success : function(res) {

//layer.msg('数据加载中，请稍后...',{shade: 0.3},function () {

//清空模态窗内容

$("#UploadSuccess").html("");

$("#UploadFail").html("");

//console.log(res);

if (res.map.statusCode==500){

layer.alert(res.message)

}else {

for (var index in res) {