JAVAWEB实验上传和下载

1、实验全过程记录实 验名 称上传和下载时间地点姓 名 学号1、 实验目的：Html表单提交以及文件上传下载熟练运用Html表单提交以及文件上传下载二、实验内容：1、编写如下html表单，并编写servlet处理表单提交的请求，表单信息插入数据库2、如下表单，输入学号，点击“下载简历”按钮，实现下载该学生简历3、如下表单，输入最小最大值，点击提交按钮，导出符合条件的学生信息到文本文件（csv文件）中，或者导出到excel文件（使用POI框架）三、实验用设备仪器及材料：软件需求：Eclipse硬件需求：微型计算机四、实验方法及步骤：1. 编写HTML页面（1） <form class=&quo

2、t;form-horizontal" action="submit.do" method="post" id="stuId-form" enctype="multipart/form-data"><div class="form-group" id="messageId"><div class="col-sm-8"><input type="text" name="Id"

3、 value="$student'id'"></div></div><div class="form-group"><label for="inputEmail3" class="col-sm-4 control-label">学号</label><div class="col-sm-8"><input type="text" class="form-control&

4、quot; id="inputstuId3" name="stuId" placeholder="学号" value="$student.stuId"></div></div><div class="form-group"><label for="inputPassword3" class="col-sm-4 control-label">姓名</label><div class=&q

5、uot;col-sm-8"><input type="text" class="form-control" id="inputname3" name="name" placeholder="姓名" value="$"></div></div><div class="form-group"><label for="inputage3" class

6、="col-sm-4 control-label">密码</label><div class="col-sm-8"><input type="password" class="form-control" id="inputpassword3" name="password" placeholder="密码" value="$student.password"></div></d

7、iv><div class="form-group"><label class="col-sm-4 control-label">性别</label><div class="col-sm-8"><input type="radio" name="sex" id="inlineRadio1" value="男" <c:if test="$student.sex='男'

8、">checked="checked"</c:if> /> 男<input type="radio" name="sex" id="inlineRadio2" value="女" <c:if test="$student.sex='女'">checked="checked"</c:if> /> 女</div></div><div class=

9、"form-group"><label for="inputage3" class="col-sm-4 control-label">年龄</label><div class="col-sm-8"><input type="text" class="form-control" id="inputage3" name="age" placeholder="年龄" valu

10、e="$student.age"></div></div><div class="form-group"><label for="inputage3" class="col-sm-4 control-label">身高</label><div class="col-sm-8"><input type="text" class="form-control" id="

11、inputheight3" name="height" placeholder="身高" value="$student.height"></div></div><div class="form-group"><label for="inputage3" class="col-sm-4 control-label">学院</label><div class="col-sm-8"

12、;><select class="form-control" name="collage" id="collage"><option value="A" <c:if test="$student.sex='A'">selectde</c:if>>软件学院</option><option value="B" <c:if test="$student.sex='B

13、9;">selectde</c:if>>计院</option><option value="C" <c:if test="$student.sex='C'">selectde</c:if>>经济学院</option><option value="D" <c:if test="$student.sex='D'">selectde</c:if>>马克思主义学院

14、</option><option value="E" <c:if test="$student.sex='E'">selectde</c:if>>电气学院</option></select></div></div><div class="form-group"><label for="inputage3" class="col-sm-4 control-label"

15、>照片</label><div class="col-sm-8"><input type="file" id="inputPhoto3" name="photo" placeholder="浏览." ></div></div><div class="form-group"><label for="inputage3" class="col-sm-4 control

16、-label">简历</label><div class="col-sm-8"><input type="file" id="inputresume" name="resume" placeholder="浏览."></div></div><div class="form-group"><div class="col-sm-offset-4 col-sm-8"&g

17、t;<button type="button" class="btn btn-default" id="formButton">提交</button></div></div></form>（2）<form class="form-horizontal" action="down.do" method="post" id="stuId-form" > <div class=&quo

18、t;form-group"> <label class="col-sm-4 control-label">简历下载</label> </div> <div class="form-group"> <label for="inputEmail3" class="col-sm-4 control-label">学号</label> <div class="col-sm-8"> <input ty

19、pe="text" class="form-control" id="inputstuId3" name="stuId" placeholder="学号"> </div> </div> <div class="form-group"> <div class="col-sm-offset-4 col-sm-8"> <button type="button" class="

20、;btn btn-default" id="formButton">下载</button> </div> </div></form>（3）<form class="form-horizontal" action="ExportServlet" method="post" id="stuId-form" > <div class="form-group"><label class=&q

21、uot;col-sm-4 control-label">数据导出</label></div> <div class="form-group"><label for="inputEmail3" class="col-sm-4 control-label">年龄</label><div class="col-sm-3"><input type="text" class="form-control&

22、quot; name="minAge" placeholder="年龄"></div><label class="col-sm-1 control-label">-</label><div class="col-sm-3"><input type="text" class="form-control" name="maxAge" placeholder="年龄"><

23、/div></div><div class="form-group"><div class="col-sm-offset-4 col-sm-8"><button type="button" class="btn btn-default" id="formButton">导出</button></div></div></form>2. 编写相应的servlet（1）Part partPhoto =

24、 request.getPart("photo"); Part resumePart = request.getPart("resume"); UploadService upload = new UploadService(); StudentMessage message = new StudentMessage(); String photoName = upload.getFileName(partPhoto); String resumeName = upload.getFileName(resumePart); String contextP

25、ath = (String) request.getAttribute("contextPath"); upload.writeTo(resumeName, resumePart, contextPath); upload.writeTo(photoName, partPhoto,contextPath); String Id = request.getParameter("Id")+"" String stuId = request.getParameter("stuId"); String name = req

26、uest.getParameter("name"); String age = request.getParameter("age"); String sex = request.getParameter("sex"); String password = request.getParameter("password"); String height = request.getParameter("height"); String collage = request.getParameter(&

27、quot;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); Ins

28、ertInto insert = new InsertInto(); UpdataService upDao = new UpdataService(); 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("/

29、login.jsp").forward(request, response); else message.setId(Id); upDao.updata(message); request.getRequestDispatcher("/show.do").forward(request, response); （2）String stuId = request.getParameter("stuId"); StudentMessage message = new StudentMessage(); message.setStuId(stuId)

30、; Connection conn = (Connection) request.getAttribute("dbconn"); DownService down = new DownService(); String photoName = down.selectResume(message, conn); String photoPath = request.getAttribute("contextPath") + File.separator+photoName;/ response.setContentType(getMimeType(phot

31、oName); /设置Content-Disposition response.setHeader("Content-Disposition", "attachment;filename="+photoName); InputStream in = new FileInputStream(photoPath); ServletOutputStream out = response.getOutputStream(); byte buffer = new byte1024; int len = 0; while(len=in.read(buffer)>

32、;0) out.write(buffer,0,len); in.close(); out.close();（3）int minAge = Integer.parseInt(request.getParameter("minAge"); int maxAge = Integer.parseInt(request.getParameter("maxAge"); Connection conn = (Connection) request.getAttribute("dbconn"); ExportExcelService export =

33、 new ExportExcelService(); List<StudentMessage> list = export.selectByAge(minAge, maxAge, conn); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("学生表"); sheet.setDefaultColumnWidth(15); HSSFCellStyle style = wb.createCellStyle(); HSSFRow row = sheet.createRow(0

34、); /style.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFCell cell = 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("学院&