@RequestMapping("/uploadSqlFile")
@ResponseBody
public ApiResult uploadSqlFile(HttpServletRequest request, HttpServletResponse response) {
Long userId = WebUtils.getUserId(request);
User user = WebUtils.getUser(request);
JSONObject obj = new JSONObject();
try {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest)request;
Iterator<String> iter = multipartRequest.getFileNames();
Integer integer =0;
while (iter.hasNext()) {
MultipartFile multipartFile = multipartRequest.getFile((String) iter.next());
String originalFilename = multipartFile.getOriginalFilename();
String ext = FileUtils.getFileExtension(originalFilename);
String uploadPath = fileRepository.storeToShareByExt("", ext, multipartFile);
File file = fileRepository.getAbsoluteFile(uploadPath);
SQLExec sqlExec = new SQLExec();
//设置数据库参数
sqlExec.setDriver(DRIVER);
sqlExec.setUrl(URL);
sqlExec.setUserid(USERNAME);
sqlExec.setPassword(PASSWORD);
//要执行的脚本
sqlExec.setSrc(file);
//有出错的语句该如何处理
sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance(SQLExec.OnError.class, "abort")));
// sqlExec.setPrint(true); //设置是否输出
// //输出到文件 sql.out 中;不设置该属性,默认输出到控制台
// sqlExec.setOutput(new File("src/sql.out"));
sqlExec.setProject(new Project()); // 要指定这个属性,不然会出错
sqlExec.execute();
file.delete();
}
return ApiResultUtil.success(obj,"");
} catch (Exception e) {
e.printStackTrace();
return ApiResultUtil.error(500, "网络错误");
}
}
java读取sql脚本
最新推荐文章于 2023-05-11 17:07:26 发布