| | |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.io.IOException; |
| | | import java.io.InputStream; |
| | | import java.sql.ResultSet; |
| | | import java.util.List; |
| | | |
| | |
| | | if(!name.substring(name.length()-4).equals(".xls") && !name.substring(name.length()-5).equals(".xlsx")){ |
| | | response.set(1,false,"文件类型错误"); |
| | | }else{ |
| | | service.excelImport(file.getInputStream()); |
| | | InputStream is=file.getInputStream(); |
| | | service.excelImport(is); |
| | | if(is!=null){ |
| | | try { |
| | | is.close(); |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | response.set(1,true,"数据导入完成"); |
| | | } |
| | | return response; |