java项目中导入excel文件

首先准备一个form表单
注意表单写法：
重点：enctype=“multipart/form-data”

第二步：在页面上加上

第三步：
在servlet写入相对应的方法

例如我需要把学生id（studentId）和课程id(courseId)还有score、remark导入

private void importScore(HttpServletRequest request, HttpServletResponse response) {
FileUpload fileUpload = new FileUpload(request);
fileUpload.setFileFormat(“xls”);
fileUpload.setFileFormat(“xlsx”);
fileUpload.setFileSize(2048);
response.setCharacterEncoding(“UTF-8”);
try {
InputStream uploadInputStream = fileUpload.getUploadInputStream();
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(uploadInputStream);
//这里是得到sheet，每一个工作表
HSSFSheet sheetAt = hssfWorkbook.getSheetAt(0);
int count = 0;
String errorMsg = “”;
StudentDao studentDao = new StudentDao();
CourseDao courseDao = new CourseDao();