java+jsp导入excel

分手后的思念是犯贱 2022-07-24 06:23 219阅读 0赞

jsp

javascript

action

private InputStream inputStream;

private String filePath; //文件路劲（全名称）  
private File file; //文件  
//提交过来的file的名字 必须有  
private String fileFileName;  
//提交过来的file的MIME类型  
private String fileContentType;  
public String getFilePath() \{  
return filePath;  
\}  
public void setFilePath(String filePath) \{  
this.filePath = filePath;  
\}  
public String getFileContentType() \{  
return fileContentType;  
\}  
public void setFileContentType(String fileContentType) \{  
this.fileContentType = fileContentType;  
\}  
public File getFile() \{  
return file;  
\}  
public void setFile(File file) \{  
this.file = file;  
\}  
public String getFileFileName() \{  
return fileFileName;  
\}  
public void setFileFileName(String fileFileName) \{  
this.fileFileName = fileFileName;  
\}

/\*\*  
\* 导入excel  
\* @return  
\* @throws IOException   
\*/  
public String test2() throws IOException\{   
ImportExcel im=new ImportExcel();  
 String root = ServletActionContext.getServletContext().getRealPath("/importExcel");  
       InputStream is = new FileInputStream(file);  
       File files=new File(root);  
       if (!files.exists()) \{  
        files.mkdir();  
\}  
       OutputStream os = new FileOutputStream(new File(root, fileFileName));  
       byte\[\] buffer = new byte\[500\];  
       int length = 0;  
       try \{  
while(-1 != (length = is.read(buffer, 0, buffer.length)))  
\{  
   os.write(buffer);  
\}  
 os.close();  
     is.close();  
\} catch (IOException e) \{  
e.printStackTrace();  
\}  
   
try \{  
im.read(lexiconService,(root+filePath),ClassifyAction.getTypeId());  
inputStream =new ByteArrayInputStream("导入成功，且已成功入库".getBytes("utf-8"));  
\} catch (Exception e) \{  
try \{  
inputStream =new ByteArrayInputStream("导入失败".getBytes("utf-8"));  
\} catch (UnsupportedEncodingException e1) \{  
e1.printStackTrace();  
\}  
\}  
return "importExcel";  
\}

ImportExcel  （导入类）  
  
  
import java.io.FileInputStream;  
import java.io.FileNotFoundException;  
import java.io.IOException;  
import java.io.InputStream;  
import java.text.ParseException;  
import java.text.SimpleDateFormat;  
  
  
import javassist.compiler.Lex;  
  
  
import javax.annotation.Resource;  
  
  
import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
import org.apache.poi.ss.usermodel.Cell;  
import org.apache.poi.ss.usermodel.Row;  
import org.apache.poi.ss.usermodel.Sheet;  
import org.apache.poi.ss.usermodel.Workbook;  
import org.apache.poi.xssf.usermodel.XSSFWorkbook;  
import org.bigdatacn.sfgk.filter.action.BaseAction;  
import org.bigdatacn.sfgk.filter.service.LexiconService;  
import org.bigdatacn.sfgk.filter.service.impl.LexiconServiceImpl;  
import org.bigdatacn.sfgk.wlzbs.domain.Lexicon;  
import org.bigdatacn.sfgk.wlzbs.domain.User;  
import org.springframework.stereotype.Controller;  
public class ImportExcel\{  
InputStream stream;  
public  void read(LexiconService lexiconService,String filePath,int typeId) throws IOException, ParseException   \{  
   String fileType = filePath.substring(filePath.lastIndexOf(".") + 1, filePath.length());  
   InputStream stream = new FileInputStream(filePath);  
   Workbook wb = null;  
   if (fileType.equals("xls")) \{  
     wb = new HSSFWorkbook(stream);  
   \}else if (fileType.equals("xlsx")) \{  
       wb = new XSSFWorkbook(stream);  
   \}else \{  
     System.out.println("您输入的excel格式不正确");  
   \}  
   Sheet sheet1 = wb.getSheetAt(0);  
   int num=0;  
   for (Row row : sheet1) \{  
   if (num==0 || num==sheet1.getLastRowNum()) \{  
   num++;  
   continue;  
\}  
   if (null== row.getCell(2) || row.getCell(2).toString()=="" ) \{//若主要内容  没写 则不予通过  
break;  
\}  
     实体类 le=new 实体();  
    le.setCreateDate(new SimpleDateFormat("yyyy-mm-dd hh:MM:ss").parse(row.getCell(1).toString()));  
    le.setContains(row.getCell(2).toString());  
    le.setType(typeId);  
    try \{  
    System.out.println(lexiconService);  
    lexiconService.saveInfo(le);  
\} catch (Exception e) \{  
System.out.println("保存saveInfo失败");  
\}  
   \}  
\}  
\}

maven的方式，在pom.xml中的配置  
  
<dependency>  
<groupId>org.apache.poi</groupId>  
<artifactId>poi</artifactId>  
<version>3.14</version>  
</dependency>

若是不用maven的方式，则需要导入jar包![Center][]

[Center]: /images/20220722/5ce511201eaf4945a2fc42f27fa26497.png