SSH实现学生毕业设计管理系统

package com.kai.action; import java.io.IOException; import java.io.OutputStream; import java.util.ArrayList; import java.util.List; import javax.servlet.http.HttpServletResponse; import com.kai.domain.PersonDao; import com.kai.domain.Student; import com.opensymphony.xwork2.ActionSupport; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFHeader; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.struts2.ServletActionContext; import org.springframework.beans.factory.BeanFactory; import org.springframework.context.support.ClassPathXmlApplicationContext; public class ExportAction extends ActionSupport { public String export() throws IOException{ String name=new String(ServletActionContext.getRequest().getParameter("name").getBytes("ISO-8859-1"),"GBK"); String stu_class=new String(ServletActionContext.getRequest().getParameter("stu_class").getBytes("ISO-8859-1"),"GBK"); String number=ServletActionContext.getRequest().getParameter("number"); String student_birthday=ServletActionContext.getRequest().getParameter("student_birthday"); String student_native_place=ServletActionContext.getRequest().getParameter("student_native_place"); String student_entrance=ServletActionContext.getRequest().getParameter("student_entrance"); String student_drop=ServletActionContext.getRequest().getParameter("student_drop"); String isgraduate=ServletActionContext.getRequest().getParameter("isgraduate"); String work=ServletActionContext.getRequest().getParameter("work"); String Password=ServletActionContext.getRequest().getParameter("Password"); BeanFactory applicationContext= new ClassPathXmlApplicationContext("applicationContext.xml"); String sql=getSql(stu_class,name,number); PersonDao dao = (PersonDao) applicationContext.getBean("Dao"); List student_list=dao.Search(sql); List<String> tableHeader = new ArrayList(); tableHeader.add("学号"); tableHeader.add("姓名"); tableHeader.add("班级"); tableHeader.add("学院"); if(student_birthday.equals("true")){ tableHeader.add("出生日期"); } if(student_native_place.equals("true")){ tableHeader.add("籍贯"); } if(student_entrance.equals("true")){ tableHeader.add("入学时间"); } if(student_drop.equals("true")){ tableHeader.add("毕业时间"); } if(isgraduate.equals("true")){ tableHeader.add("答辩状态"); } if(work.equals("true")){ tableHeader.add("课题名称"); } if(Password.equals("true")){ tableHeader.add("密码"); } short cellNumber=(short)tableHeader.size(); HSSFWorkbook workbook = new HSSFWorkbook(); HSSFCell cell = null; //Excel的列 HSSFRow row = null; //Excel的行 HSSFCellStyle style = workbook.createCellStyle(); //设置表头的类型 style.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFCellStyle style1 = workbook.createCellStyle(); //设置数据类型 style1.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFFont font = workbook.createFont(); //设置字体 HSSFSheet sheet = workbook.createSheet("sheet1"); //创建一个sheet HSSFHeader header = sheet.getHeader();//设置sheet的头 try { /** *根据是否取出数据，设置header信息 * */ if(student_list.size() < 1 ){ header.setCenter("查无资料"); }else{ header.setCenter("学生表"); row = sheet.createRow(0); row.setHeight((short)400); for(int k = 0;k < cellNumber;k++){ cell = row.createCell(k);//创建第0行第k列 cell.setCellValue(tableHeader.get(k));//设置第0行第k列的值 sheet.setColumnWidth(k,8000);//设置列的宽度 font.setColor(HSSFFont.COLOR_NORMAL); // 设置单元格字体的颜色. font.setFontHeight((short)350); //设置单元字体高度 style1.setFont(font);//设置字体风格 cell.setCellStyle(style1); } /* * // 给excel填充数据这里需要编写 * */ for(int i = 0 ;i < student_list.size() ;i++){ Student student = (Student)student_list.get(i);//获取student对象 row = sheet.createRow((short) (i + 1));//创建第i+1行 row.setHeight((short)400);//设置行高 cell = row.createCell(0);//创建第i+1行第0列 cell.setCellValue(student.getStudent_id());//设置第i+1行第0列的值 cell.setCellStyle(style);//设置风格 cell = row.createCell(1);//创建第i+1行第0列 cell.setCellValue(student.getName());//设置第i+1行第0列的值 cell.setCellStyle(style);//设置风格 cell = row.createCell(2);//创建第i+1行第0列 cell.setCellValue(student.getStudent_class());//设置第i+1行第0列的值 cell.setCellStyle(style);//设置风格 cell = row.createCell(3);//创建第i+1行第0列 cell.setCellValue(student.getCollege());//设置第i+1行第0列的值 cell.setCellStyle(style);//设置风格 for(int j=4;j<tableHeader.size();j++){ if(tableHeader.get(j).equals("出生日期")){ cell = row.createCell(j); cell.setCellValue(student.getBirthday()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("籍贯")){ cell = row.createCell(j); cell.setCellValue(student.getNativePlace()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("入学时间")){ cell = row.createCell(j); cell.setCellValue(student.getEntrance()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("毕业时间")){ cell = row.createCell(j); cell.setCellValue(student.getDrop()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("答辩状态")){ cell = row.createCell(j); cell.setCellValue(student.getIsgraduate()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("课题名称")){ cell = row.createCell(j); cell.setCellValue(student.getWorks()); cell.setCellStyle(style);//设置风格 } if(tableHeader.get(j).equals("密码")){ cell = row.createCell(j); cell.setCellValue(student.getPassword()); cell.setCellStyle(style);//设置风格 } } } } } catch (Exception e) { e.printStackTrace(); } /* *下面的可以不用编写，直接拷贝 * */ HttpServletResponse response = null;//创建一个HttpServletResponse对象 OutputStream out = null;//创建一个输出流对象 try { response = ServletActionContext.getResponse();//初始化HttpServletResponse对象 out = response.getOutputStream();// response.setHeader("Content-disposition","attachment; filename="+"student.xls");//filename是下载的xls的名，建议最好用英文 response.setContentType("application/msexcel;charset=UTF-8");//设置类型 response.setHeader("Pragma","No-cache");//设置头 response.setHeader("Cache-Control","no-cache");//设置头 response.setDateHeader("Expires", 0);//设置日期头 workbook.write(out); out.flush(); } catch (IOException e) { e.printStackTrace(); }finally{ try{ if(out!=null){ out.close(); } }catch(IOException e){ e.printStackTrace(); } } return null; } public String getSql(String stu_class,String name,String number){ int flag=0; String str="where "; if(!stu_class.equals("")){ str+="student_class= '"+stu_class+"'"; flag=1; } if(!name.equals("")){ if(flag==1