private void scoreToExcel(HttpServletRequest request,
HttpServletResponse response, PrintWriter out)
throws ServletException, IOException {
TeacherDao teacherDao = new TeacherDao();
//查询所有学生成绩信息
List<Map<String,Object>> scoreList = teacherDao.getScoreList();
if (!CollectionUtil.isEmpty(scoreList)) {
//在Excel中建立工作表
HSSFWorkbook workbook = new HSSFWorkbook();
//2.导出文件名为学生成绩表
HSSFSheet sheet = workbook.createSheet("学生成绩表");
/**
* 第一行表头数据
*/
HSSFRow row = sheet.createRow((int)0);
HSSFCell cell1 = row.createCell((short) 0);
HSSFCell cell2 = row.createCell((short) 1);
HSSFCell cell3 = row.createCell((short) 2);
HSSFCell cell4 = row.createCell((short) 3);
HSSFCell cell5 = row.createCell((short) 4);
HSSFCell cell6 = row.createCell((short) 5);
HSSFCell cell7 = row.createCell((short) 6);
//定义单元格为字符串类型,这个字符串类型也可在创建单元格里面设置。
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
cell3.setCellType(HSSFCell.CELL_TYPE_STRING);
cell4.setCellType(HSSFCell.CELL_TYPE_STRING);
cell5.setCellType(HSSFCell.CELL_TYPE_STRING);
cell6.setCellType(HSSFCell.CELL_TYPE_STRING);
cell7.setCellType(HSSFCell.CELL_TYPE_STRING);
//在单元格中输入一些内容
cell1.setCellValue("学号");
cell2.setCellValue("试卷名");
cell3.setCellValue("单选得分");
cell4.setCellValue("多选得分");
cell5.setCellValue("判断得分");
cell6.setCellValue("考试总分");
cell7.setCellValue("考试结果");
/**
* 根据查询到的成绩信息的列数,统计excel行数,并填充数据
*/
//得到excel行数
int count = scoreList.size();
//根据score行数判断
for(int i=0;i<count;i++){
row = sheet.createRow((int)i+1);
//创建单元格,并设置值
row.createCell((short)0).setCellValue((String)scoreList.get(i).get("student_no"));
row.createCell((short)1).setCellValue((String)scoreList.get(i).get("paper_name"));
row.createCell((short)2).setCellValue((Integer)scoreList.get(i).get("single_score"));
row.createCell((short)3).setCellValue((Integer)scoreList.get(i).get("multi_score"));
row.createCell((short)4).setCellValue((Integer)scoreList.get(i).get("judge_score"));
row.createCell((short)5).setCellValue((Integer)scoreList.get(i).get("total_score"));
row.createCell((short)6).setCellValue((String)scoreList.get(i).get("result"));
}
//新建一输出文件流,把相应的Excel工作簿 输出到本地
FileOutputStream fOut = new FileOutputStream("e:\\学生成绩表.xls");
fOut.flush();
out.print("<script>alert('导出学生成绩成功,请到E盘根目录查看');location.href='TeacherServlet?action=L0100001&flag=';</script>");
} else {
out.print("<script>alert('学生成绩信息为空,无法导出学生成绩');location.href='TeacherServlet?action=L0100001&flag=';</script>");
}
}
HttpServletResponse response, PrintWriter out)
throws ServletException, IOException {
TeacherDao teacherDao = new TeacherDao();
//查询所有学生成绩信息
List<Map<String,Object>> scoreList = teacherDao.getScoreList();
if (!CollectionUtil.isEmpty(scoreList)) {
//在Excel中建立工作表
HSSFWorkbook workbook = new HSSFWorkbook();
//2.导出文件名为学生成绩表
HSSFSheet sheet = workbook.createSheet("学生成绩表");
/**
* 第一行表头数据
*/
HSSFRow row = sheet.createRow((int)0);
HSSFCell cell1 = row.createCell((short) 0);
HSSFCell cell2 = row.createCell((short) 1);
HSSFCell cell3 = row.createCell((short) 2);
HSSFCell cell4 = row.createCell((short) 3);
HSSFCell cell5 = row.createCell((short) 4);
HSSFCell cell6 = row.createCell((short) 5);
HSSFCell cell7 = row.createCell((short) 6);
//定义单元格为字符串类型,这个字符串类型也可在创建单元格里面设置。
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
cell3.setCellType(HSSFCell.CELL_TYPE_STRING);
cell4.setCellType(HSSFCell.CELL_TYPE_STRING);
cell5.setCellType(HSSFCell.CELL_TYPE_STRING);
cell6.setCellType(HSSFCell.CELL_TYPE_STRING);
cell7.setCellType(HSSFCell.CELL_TYPE_STRING);
//在单元格中输入一些内容
cell1.setCellValue("学号");
cell2.setCellValue("试卷名");
cell3.setCellValue("单选得分");
cell4.setCellValue("多选得分");
cell5.setCellValue("判断得分");
cell6.setCellValue("考试总分");
cell7.setCellValue("考试结果");
/**
* 根据查询到的成绩信息的列数,统计excel行数,并填充数据
*/
//得到excel行数
int count = scoreList.size();
//根据score行数判断
for(int i=0;i<count;i++){
row = sheet.createRow((int)i+1);
//创建单元格,并设置值
row.createCell((short)0).setCellValue((String)scoreList.get(i).get("student_no"));
row.createCell((short)1).setCellValue((String)scoreList.get(i).get("paper_name"));
row.createCell((short)2).setCellValue((Integer)scoreList.get(i).get("single_score"));
row.createCell((short)3).setCellValue((Integer)scoreList.get(i).get("multi_score"));
row.createCell((short)4).setCellValue((Integer)scoreList.get(i).get("judge_score"));
row.createCell((short)5).setCellValue((Integer)scoreList.get(i).get("total_score"));
row.createCell((short)6).setCellValue((String)scoreList.get(i).get("result"));
}
//新建一输出文件流,把相应的Excel工作簿 输出到本地
FileOutputStream fOut = new FileOutputStream("e:\\学生成绩表.xls");
workbook.write(fOut);
fOut.close();fOut.flush();
out.print("<script>alert('导出学生成绩成功,请到E盘根目录查看');location.href='TeacherServlet?action=L0100001&flag=';</script>");
} else {
out.print("<script>alert('学生成绩信息为空,无法导出学生成绩');location.href='TeacherServlet?action=L0100001&flag=';</script>");
}
}