Excel数据在(jsp+ssh)环境下导入导出【DOC精选】.docxVIP

导入导出EXCEL数据（jsp+ssh）首先搭建ssh框架（这儿不做介绍）；导入jar包（如下）:导出：（下面以一个例子的形式）新创建一个jsp页面如（export.jsp）,在页面上添加如下代码：a href=%=path %/indexAction!export.action导出数据到excel/a进入indexAction.java文件，编写export方法由于要用到一个STUDENT类，就先编写STUDENT类，Student类代码如下：publicclass Student {private String studentId;private String studentName;private String studentSex;private String studentDormitory;private StringstudentSept;public String getStudentId() {returnstudentId;}publicvoidsetStudentId(String studentId) {this.studentId = studentId;}public String getStudentName() {returnstudentName;}publicvoidsetStudentName(String studentName) {this.studentName = studentName;}public String getStudentSex() {returnstudentSex;}publicvoidsetStudentSex(String studentSex) {this.studentSex = studentSex;}public String getStudentDormitory() {returnstudentDormitory;}publicvoidsetStudentDormitory(String studentDormitory) {this.studentDormitory = studentDormitory;}public String getStudentSept() {returnstudentSept;}publicvoidsetStudentSept(String studentSept) {this.studentSept = studentSept;}}编写export方法：代码如下/***导出数据到excel*@return*@throwsException*/public String export()throws Exception{ /***如果是从数据库里面取数据，就让studentList=取数据的函数：*就没必要下面的for循环 *我下面的for循环就是手动给studentList赋值 */List studentList=newArrayListStudent();//学生LIstfor(inti=0;i10;i++){ Student student=new Student();//学生对象student.setStudentId(200908110+i);student.setStudentName(杨波+i);student.setStudentSex(男);student.setStudentDormitory(14-20+i);student.setStudentSept(软件工程系);studentList.add(student);} /*设置表头：对Excel每列取名 *(必须根据你取的数据编写)*/String []tableHeader={学号,姓名,性别,寝室号,所在系};/* *下面的都可以拷贝不用编写 */shortcellNumber=(short)tableHeader.length;//表的列数HSSFWorkbook workbook = newHSSFWorkbook();//创建一个excelHSSFCell cell = null;//Excel的列HSSFRow row = null;//Excel的行HSSFCellStyle style = workbook.createCellStyle();//设置表头的类型style.setAlignment(HSSFCellStyle.ALIGN_CENTER);HSSFCellStyle style1 = workbook.createCellStyle();//设置数据类型style1.setAli