62,614
社区成员
发帖
与我相关
我的任务
分享
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>金山项目</title>
<script type="text/javascript" charset="utf-8" src="jquery/jquery.min.js"></script>
<script type="text/javascript">
function uploadExcel(){
//导入文件
var formData = new FormData();
formData.append("file",$("#upload")[0].files[0]);
$.ajax({
url:'/excel/insertExcel',
type:'POST',
data:formData,
// 告诉jQuery不要去处理发送的数据
processData : false,
// 告诉jQuery不要去设置Content-Type请求头
contentType : false,
success:function(map){
alert(map.message);
},
dataType:'json',
})
}
</script>
</head>
<body>
<input id="upload" type="file" value="选择文件"/>
<button onclick="uploadExcel()">点击上传</button>
</body>
</html>
@Controller
@RequestMapping("excel")
public class InsertExcelController {
@Autowired
private InsertExcelService insertExcelServiceImpl;
/**
* 导入Excel
*/
@RequestMapping("insertExcel")
@ResponseBody
public Map<String,Object> insertExcel(@RequestParam(value = "file",required = false)MultipartFile file, HttpServletRequest request, HttpServletResponse response) throws Exception {
Map<String, Object> map = new HashMap<String, Object>();
String result = insertExcelServiceImpl.insertExcel(file);
map.put("message",result);
return map;
}
}