(2)
(3)
2.编写相应的servlet
(1)
PartpartPhoto=request.getPart("photo");
PartresumePart=request.getPart("resume");
UploadServiceupload=newUploadService();
StudentMessagemessage=newStudentMessage();
StringphotoName=upload.getFileName(partPhoto);
StringresumeName=upload.getFileName(resumePart);
StringcontextPath=(String)request.getAttribute("contextPath");
upload.writeTo(resumeName,resumePart,contextPath);
upload.writeTo(photoName,partPhoto,contextPath);
StringId=request.getParameter("Id")+"";
StringstuId=request.getParameter("stuId");
Stringname=request.getParameter("name");
Stringage=request.getParameter("age");
Stringsex=request.getParameter("sex");
Stringpassword=request.getParameter("password");
Stringheight=request.getParameter("height");
Stringcollage=request.getParameter("collage");
message.setAge((age!
="")?
Integer.parseInt(age):
0);
message.setCollage(collage);
message.setHeight(height);
message.setName(name);
message.setPassword(password);
message.setSex(sex);
message.setStuId(stuId);
message.setPhoto(photoName);
message.setResume(resumeName);
InsertIntoinsert=newInsertInto();
UpdataServiceupDao=newUpdataService();
if(Id.equals("")||Id==null){
Id=System.currentTimeMillis()+stuId;
System.out.println(Id);
message.setId(Id);
if(insert.insertData(message)){
System.out.println("插入成功");
}
request.getRequestDispatcher("/login.jsp").forward(request,response);
}else{
message.setId(Id);
upDao.updata(message);
request.getRequestDispatcher("/show.do").forward(request,response);
}
(2)
StringstuId=request.getParameter("stuId");
StudentMessagemessage=newStudentMessage();
message.setStuId(stuId);
Connectionconn=(Connection)request.getAttribute("dbconn");
DownServicedown=newDownService();
StringphotoName=down.selectResume(message,conn);
StringphotoPath=request.getAttribute("contextPath")+File.separator+photoName;
//response.setContentType(getMimeType(photoName));
//设置Content-Disposition
response.setHeader("Content-Disposition","attachment;filename="+photoName);
InputStreamin=newFileInputStream(photoPath);
ServletOutputStreamout=response.getOutputStream();
bytebuffer[]=newbyte[1024];
intlen=0;
while((len=in.read(buffer))>0){
out.write(buffer,0,len);
}
in.close();
out.close();
(3)
intminAge=Integer.parseInt(request.getParameter("minAge"));
intmaxAge=Integer.parseInt(request.getParameter("maxAge"));
Connectionconn=(Connection)request.getAttribute("dbconn");
ExportExcelServiceexport=newExportExcelService();
List
HSSFWorkbookwb=newHSSFWorkbook();
HSSFSheetsheet=wb.createSheet("学生表");
sheet.setDefaultColumnWidth(15);
HSSFCellStylestyle=wb.createCellStyle();
HSSFRowrow=sheet.createRow(0);
//style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
HSSFCellcell=row.createCell(0);
cell.setCellValue("学号");
cell.setCellStyle(style);
cell=row.createCell
(1);
cell.setCellValue("");
cell.setCellStyle(style);
cell=row.createCell
(2);
cell.setCellValue("年龄");
cell.setCellStyle(style);
cell=row.createCell(3);
cell.setCellValue("性别");
cell.setCellStyle(style);
cell=row.createCell(4);
cell.setCellValue("身高");
cell.setCellStyle(style);
cell=row.createCell(5);
cell.setCellValue("学院");
cell.setCellStyle(style);
cell=row.createCell(6);
cell.setCellValue("密码");
cell.setCellStyle(style);
cell=row.createCell(7);
cell.setCellValue("照片");
cell.setCellStyle(style);
for(inti=0;i row=sheet.createRow(i+1); row.createCell(0).setCellValue(list.get(i).getStuId()); row.createCell (1).setCellValue(list.get(i).getName()); row.createCell (2).setCellValue(list.get(i).getAge()); row.createCell(3).setCellValue(list.get(i).getSex()); row.createCell(4).setCellValue(list.get(i).getHeight()); row.createCell(5).setCellValue(list.get(i).getCollage()); row.createCell(7).setCellValue(list.get(i).getPhoto()); row.createCell(6).setCellValue(list.get(i).getPassword()); } try{ OutputStreamout=response.getOutputStream(); response.reset(); response.setHeader("Content-disposition", "attachment;filename=学生信息表.xls"); response.setContentType("application/msexcel"); wb.write(out); out.close(); }catch(FileNotFoundExceptione){ e.printStackTrace(); }catch(IOExceptione){ e.printStackTrace(); } 5、实验结果分析 对实验内容分析之后,结合XX的知识和老师的PPT内容,进行了实验的操作,实验过后我进一步的熟悉了servlet处理表单提交的请 copyright@ 2008-2022 冰豆网网站版权所有 经营许可证编号:鄂ICP备2022015515号-1