package web;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import entity.Accident;
import entity.Book;
import entity.BookOfSelf;
import entity.ClassOfChange;
import entity.Company;
import entity.CompetitionOfStu;
import entity.GoodPaper;
import entity.PaperOfScience;
import entity.PaperOfStudent;
import entity.PaperOfTeacher;
import entity.StuOfGameResult;
import entity.StuOfSocialpractice;
import entity.TeachOfChange;
import entity.Teacher;
import entity.TeacherOfMatch;
import entity.TeacherOfProject;
import entity.TeacherOfScience;
import service.AccidentService;
import service.BookOfSelfService;
import service.BookService;
import service.ClassOfChangeService;
import service.CompanyService;
import service.CompetitionOfStuService;
import service.GoodPaperService;
import service.MajorService;
import service.PaperOfScienceService;
import service.PaperOfStudentService;
import service.PaperOfTeacherService;
import service.StuOfGameResultService;
import service.StuOfSocialpracticeService;
import service.TeachOfChangeService;
import service.TeacherOfMatchService;
import service.TeacherOfProjectService;
import service.TeacherOfScienceService;
import service.TeacherService;
import util.UseCaseExcelUtil;
/**
*
* <一句话功能简述>
* <功能详细描述>
*
* @author hehaiyan
* @version [版本号, 2017年4月26日]
* @see [相关类/方法]
* @since [产品/模块版本]
*/
@Controller
public class DownLoadController
{
@Resource
AccidentService accidentService;
@Resource
MajorService majorService;
@Resource
BookService bookService;
@Resource
private BookOfSelfService bookOfSelfService;
@Resource
private ClassOfChangeService classOfChangeService;
@Resource
private CompanyService companyService;
@Resource
private CompetitionOfStuService competitionOfStuService;
@Resource
private GoodPaperService goodPaperService;
@Resource
private PaperOfScienceService paperOfScienceService;
@Resource
private PaperOfStudentService paperOfStudentService;
@Resource
private PaperOfTeacherService paperOfTeacherService;
@Resource
private StuOfGameResultService stuOfGameResultService;
@Resource
private StuOfSocialpracticeService stuOfSocialpracticeService;
@Resource
private TeacherService teacherService;
@Resource
private TeacherOfMatchService teacherOfMatchService;
@Resource
private TeacherOfProjectService teacherOfProjectService;
@Resource
private TeacherOfScienceService teacherOfScienceService;
@Resource
private TeachOfChangeService teachOfChangeService;
//下载
@RequestMapping("/downloadAccidentByMajor.do")
public String downloadAccidentInfo(HttpServletRequest request,HttpSession session,HttpServletResponse response) throws Exception
{
String mid = request.getParameter("major");
String major = majorService.findById(mid);
String fileName=major+"教学事故信息表";
List<Accident> accidents = accidentService.findInfo(major);
List<Map<String,Object>> list = createExcelRecord1(accidents);
//列名:
String columnName[] = {"序号","时间","事故等级","负责人","职称","事故描述"};
//map中的key
String keys[] = {"id","term","s_level","teacher","t_prof","descr"};
ByteArrayOutputStream os = new ByteArrayOutputStream();
UseCaseExcelUtil.createWorkBook(list, keys, columnName).write(os);
byte[] content = os.toByteArray();
InputStream is = new ByteArrayInputStream(content);
response.reset();
response.setContentType("application/vnd.ms-excel;charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename="+ new String((fileName + ".xls").getBytes(), "iso-8859-1"));
ServletOutputStream out = response.getOutputStream();
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
try{
bis = new BufferedInputStream(is);
bos = new BufferedOutputStream(out);
byte[] buff = new byte[2048];
int bytesRead;
while (-1 != (bytesRead = bis.read(buff, 0, buff.length)))
{
bos.write(buff, 0, bytesRead);
}
}
catch (final IOException e)
{
throw e;
}
finally
{
if (bis != null)
bis.close();
if (bos != null)
bos.close();
}
return null;
}
private List<Map<String, Object>> createExcelRecord1(List<Accident> accidents)
{
List<Map<String, Object>> listmap = new ArrayList<Map<String, Object>>();
Map<String, Object> map = new HashMap<String, Object>();
map.put("sheetName", "sheet1");
listmap.add(map);
Accident accident=null;
for (int j = 0; j < accidents.size(); j++) {
accident=accidents.get(j);
Map<String, Object> mapValue = new HashMap<String, Object>();
mapValue.put("id", accident.getId());
mapValue.put("term", accident.getTerm());
mapValue.put("s_level", accident.getS_level());
mapValue.put("teacher", accident.getTeacher());
mapValue.put("t_prof", accident.getT_prof());
mapValue.put("descr", accident.getDescr());
listmap.add(mapValue);
}
return listmap;
}
//教材选用情况下载
@RequestMapping("/downloadBookInfoByMajor.do")
public String downloadTeacherInfoByMajor(HttpServletRequest request,
HttpServletResponse response,HttpSession session) throws Exception
{
String mid = request.getParameter("major");
String major =majorService.findById(mid);
String fileName= major+"教材选用情况统计表";
List<Book> books = bookService.findInfo(major);
List<Map<String,Object>> list = createExcelRecord2(books);
//列名:
String columnName[] = {"序号","学年","课程名称","教材名称","主编","出版社","出版时间","获奖项目"};
//map中的key
String keys[] = {"id","term","class_name","book_name","book_author","book_pub","pub_time","p_price"};
ByteArrayOutputStream os = new ByteArrayOutputStream();
UseCaseExcelUtil.createWorkBook(list, keys, columnName).write(os);
byte[] content = os.toByteArray();
InputStream is = new ByteArrayInputStream(content);
response.reset();
response.setContentType("application/vnd.ms-excel;charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename="+ new String((fileName + ".xls").getBytes(), "iso-8859-1"));
ServletOutputStream out = response.getOutputStream();
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
try{
bis = new BufferedInputStream(is);
bos = new BufferedOutputStream(out);
byte[] buff = new byte[2048];
int bytesRead;
while (-1 != (bytesRead = bis.read(buff, 0, buff.length)))
{
bos.write(buff, 0, bytesRead);
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于javaweb的档案管理系统+Spring+SpringMVC+MyBatis (521个子文件)
DownLoadController.class 39KB
PrincipalController.class 15KB
TeacherController.class 11KB
StuOfSocialpracticeController.class 11KB
TeacherOfProjectController.class 11KB
CompetitionOfStuController.class 11KB
GoodPaperController.class 11KB
TeacherOfScienceController.class 10KB
TeacherOfMatchController.class 10KB
BookOfSelfController.class 10KB
AccidentController.class 10KB
StuOfGameResultController.class 10KB
PaperOfStudentController.class 10KB
BookController.class 10KB
PaperOfScienceController.class 10KB
CompanyController.class 10KB
ClassOfChangeController.class 10KB
PaperOfTeacherController.class 10KB
TeachOfChangeController.class 10KB
UserQueryController.class 9KB
UserController.class 8KB
AdminController.class 6KB
Page.class 6KB
Teacher.class 5KB
LoginController.class 5KB
StuOfSocialpractice.class 4KB
BookOfSelf.class 4KB
GoodPaper.class 4KB
Book.class 4KB
TeacherOfMatch.class 4KB
TeacherOfScience.class 4KB
TeacherOfProject.class 4KB
MajorController.class 4KB
CompetitionOfStu.class 4KB
PaperOfScience.class 4KB
StuOfGameResult.class 4KB
PaperOfStudent.class 4KB
ContentController.class 4KB
TeacherOfProjectServiceTestCase.class 4KB
QuestionController.class 4KB
ProjectController.class 4KB
PaperOfTeacher.class 4KB
ClassOfChange.class 3KB
Accident.class 3KB
GoodPaperServiceTestCase.class 3KB
TeacherServiceTestCase.class 3KB
PaperOfTeacherServiceTestCase.class 3KB
TeachOfChange.class 3KB
UseCaseExcelUtil.class 3KB
Company.class 3KB
StuOfSocialpracticeServiceCaseTest.class 3KB
BookOfSelfServiceTestCase.class 3KB
ComptitionOfStuServiceTestCase.class 3KB
ClassOfChangeServiceTestCase.class 3KB
BookServiceTestCase.class 3KB
AccidentServiceTestCase.class 3KB
CompanyServiceTestCase.class 3KB
PaperOfTeacherServiceImpl.class 3KB
StuOfSocialpracticeServiceImpl.class 3KB
CompetitionOfStuServcieImpl.class 3KB
TeacherOfProjectServiceImp.class 3KB
PaperOfScienceServiceImpl.class 3KB
StuOfGameResultServiceImpl.class 3KB
TeacherOfMatchServiceImpl.class 3KB
TeacherOfScienceServcieImpl.class 3KB
PaperOfStudentServiceImpl.class 3KB
ClassOfChangeServiceImpl.class 3KB
AccidentServiceImpl.class 3KB
TeacherServiceImpl.class 3KB
CompanyServiceImpl.class 3KB
BookOfSelfServiceImpl.class 3KB
GoodPaperServcieImpl.class 2KB
TeachOfChangeServiceImpl.class 2KB
BookServiceImpl.class 2KB
UserServiceImpl.class 2KB
User.class 2KB
DevelopOfStu.class 2KB
JsonResult.class 2KB
UserLoginTest.class 2KB
SessionInterceptor.class 2KB
DefaultController.class 2KB
DevelopOfStuServiceImpl.class 2KB
Question.class 2KB
MajorServiceImpl.class 2KB
Content.class 2KB
PageState.class 2KB
NoteController.class 2KB
QuestionServiceImpl.class 2KB
TeachMass.class 2KB
ContentServiceImpl.class 2KB
Major.class 2KB
Quality.class 2KB
Project.class 2KB
ProjectServiceImpl.class 1KB
QualityServiceImpl.class 1KB
PageUtil.class 1KB
RoleTypeTestCase.class 1KB
ContentTest.class 1KB
RoleTypeServiceImpl.class 1KB
RoleType.class 1KB
共 521 条
- 1
- 2
- 3
- 4
- 5
- 6
self_defining
- 粉丝: 31
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 351AN-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 346G-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 342P-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 3420-VB一款SOT23封装N-Channel场效应MOS管
- UDP原理详解和代码示例
- 3414-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 以下是一些大数据面试习题.pdf
- 3414-CMN3414-VB一款SOT23封装N-Channel场效应MOS管
- ASTM G154-2023 Practice for Operating Fluorescent Ultraviolet UV
- 小米智能摄像机 云台版2K 固件
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页