package com.bjpowernode.buss.controller;
import java.io.InputStream;
import java.io.OutputStream;
import java.math.BigDecimal;
import java.net.URLDecoder;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.hibernate.criterion.DetachedCriteria;
import org.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import com.bjpowernode.buss.entity.base.ScoreEntity;
import com.bjpowernode.buss.entity.base.StudentEntity;
import com.bjpowernode.buss.entity.base.TeacherEntity;
import com.bjpowernode.buss.service.ScoreService;
import com.bjpowernode.common.controller.BaseController;
import com.bjpowernode.common.util.AjaxJson;
import com.bjpowernode.common.util.Pagination;
@Controller
@RequestMapping("/scoreController")
public class ScoreController extends BaseController {
private static final Logger logger = Logger.getLogger(ScoreController.class);
String[] excelHeader = { "学生学号", "课程名称", "分数", "学期", "班级", "教师工号","教师姓名", "学生姓名"};
@Autowired
private ScoreService scoreService;
/**
* 初始访问
*
* @param
* @param model
* @return
*/
@RequestMapping(params = "goScore")
public ModelAndView goScore(HttpServletRequest request) {
return new ModelAndView("buss/score");
}
@RequestMapping(params = "save")
@ResponseBody
public AjaxJson save(HttpServletRequest request, HttpServletResponse response, ScoreEntity scoreEntity,
String studentid, String teacherid) throws Exception {
AjaxJson j = new AjaxJson();
j.setMsg("保存成功！");
j.setSuccess(true);
try {
TeacherEntity teacher = this.scoreService.get(TeacherEntity.class, teacherid);
StudentEntity student = this.scoreService.get(StudentEntity.class, studentid);
scoreEntity.setTeacherEntity(teacher);
scoreEntity.setStudentEntity(student);
this.scoreService.save(scoreEntity);
} catch (Exception e) {
j.setMsg("保存失败！");
j.setSuccess(false);
}
return j;
}
@RequestMapping(params = "update")
@ResponseBody
public AjaxJson update(HttpServletRequest request, HttpServletResponse response, ScoreEntity scoreEntity,
String studentid, String teacherid) throws Exception {
AjaxJson j = new AjaxJson();
j.setMsg("更新成功！");
j.setSuccess(true);
try {
TeacherEntity teacher = this.scoreService.get(TeacherEntity.class, teacherid);
StudentEntity student = this.scoreService.get(StudentEntity.class, studentid);
scoreEntity.setTeacherEntity(teacher);
scoreEntity.setStudentEntity(student);
this.scoreService.update(scoreEntity);
} catch (Exception e) {
j.setMsg("更新失败！");
j.setSuccess(false);
}
return j;
}
@RequestMapping(params = "delete", method = RequestMethod.POST)
@ResponseBody
public AjaxJson delete(HttpServletRequest request, HttpServletResponse response, String ids) throws Exception {
AjaxJson j = new AjaxJson();
j.setMsg("删除成功！");
j.setSuccess(true);
try {
for (String id : ids.split(",")) {
ScoreEntity scoreEntity = new ScoreEntity();
scoreEntity.setId(id);
this.scoreService.delete(scoreEntity);
}
} catch (Exception e) {
j.setMsg("删除失败！");
j.setSuccess(false);
}
return j;
}
@RequestMapping(params = "uploadScore", method = RequestMethod.POST)
@ResponseBody
public AjaxJson uploadScore(@RequestParam("scoreExcel") MultipartFile scoreExcel) {
AjaxJson j = new AjaxJson();
j.setMsg("导入成功！");
j.setSuccess(true);
try {
if (!scoreExcel.isEmpty()) {
InputStream is = scoreExcel.getInputStream();
String[] fileName = scoreExcel.getOriginalFilename().split("\\.");
List<ScoreEntity> scoreList = new ArrayList<ScoreEntity>();
// 判断excel版本
if ("xls".equals(fileName[1])) {
// List<String> results =
// ExcelImportUtil.getExcelStringList(is);
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
for (int i = 0; i < hssfWorkbook.getNumberOfSheets(); i++) {
HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(i);
if (hssfSheet == null) {
continue;
}
// 循环行Row
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
HSSFRow hssfRow = hssfSheet.getRow(rowNum);
if (hssfRow != null) {
ScoreEntity se = new ScoreEntity();
TeacherEntity te = new TeacherEntity();
StudentEntity stu = new StudentEntity();
HSSFCell stuNum = hssfRow.getCell(0);
HSSFCell courseName = hssfRow.getCell(1);
HSSFCell score = hssfRow.getCell(2);
HSSFCell term = hssfRow.getCell(3);
HSSFCell className = hssfRow.getCell(4);
HSSFCell teacherNum = hssfRow.getCell(5);
int stuInt = (int) stuNum.getNumericCellValue();
int teacherInt = (int) teacherNum.getNumericCellValue();
te = this.scoreService.findUniqueByProperty(TeacherEntity.class, "teachernum",
String.valueOf(teacherInt));
stu = this.scoreService.findUniqueByProperty(StudentEntity.class, "studentnum",
String.valueOf(stuInt));
BigDecimal bd = new BigDecimal(score.getNumericCellValue());
se.setTeacherEntity(te);
se.setStudentEntity(stu);
se.setClassname(className.getStringCellValue());
se.setCoursename(courseName.getStringCellValue());
se.setScore(bd);
se.setTerm(term.getStringCellValue());
scoreList.add(se);
}
}
}
} else if ("xlsx".equals(fileName[1])) {
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is);
for (int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++) {
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet);
// Read the Row
for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) {
XSSFRow xssfRow = xssfSheet.getRow(rowNum);
if (xssfRow != null) {
ScoreEntity se = new ScoreEntity();
TeacherEntity te = new TeacherEntity();
StudentEntity stu = new StudentEntity();
XSSFCell stuNum = xssfRow.getCell(0);
XSSFCell courseName = xssfRow.getCell(1);
XSSFCell score = xssfRow.getCell(2);
XSSFCell term = xssfRow.getCell(3);
XSSFCell className = xssfRow.getCell(4);
XSSFCell teacherNum = xssfRow.getCell(5);
int stuInt = (int) stuNum.getNumericCellValue();
int teacherInt = (int) teacherNum.getNumericCellValue();
te = this.scoreService.findUniqueByProperty(TeacherEntity.class, "teachernum",
String.valueOf(teacherInt));
stu = this.scoreService.findUniqueByProperty(StudentEntity.class, "studentnum",
String.valueOf(stuInt));
BigDecimal bd = new BigDecimal(score.getNumericCellValue());
se.setTeacherEntity(te);
se.setStudentEntity(stu);
se.setClass
springMVC+mysql实现的Java web学生成绩管理系统源码+WORD毕业论文文档+视频教程.zip （659个子文件） 
ScoreController.class 13KB ScoreController.class 13KB LoginController.class 8KB LoginController.class 8KB RoleController.class 8KB RoleController.class 8KB UserController.class 8KB UserController.class 8KB StudentController.class 6KB StudentController.class 6KB TeacherController.class 6KB TeacherController.class 6KB ResourceController.class 6KB ResourceController.class 6KB MyBeanUtils.class 6KB MyBeanUtils.class 6KB ExcelImportUtil.class 5KB ExcelImportUtil.class 5KB ScoreServiceImpl.class 5KB ScoreServiceImpl.class 5KB AuthInterceptor.class 4KB AuthInterceptor.class 4KB BaseDaoImpl.class 4KB BaseDaoImpl.class 4KB CaptchaUtil.class 4KB CaptchaUtil.class 4KB BaseServiceImpl.class 4KB BaseServiceImpl.class 4KB SystemDaoImpl.class 4KB SystemDaoImpl.class 4KB SystemServiceImpl.class 4KB SystemServiceImpl.class 4KB BrowserUtils.class 4KB BrowserUtils.class 4KB UserEntity.class 3KB UserEntity.class 3KB StudentServiceImpl.class 3KB StudentServiceImpl.class 3KB TeacherServiceImpl.class 3KB TeacherServiceImpl.class 3KB ResourceUtil.class 3KB ResourceUtil.class 3KB ResourceEntity.class 3KB ResourceEntity.class 3KB TreeGrid.class 3KB TreeGrid.class 3KB CaptchaServlet.class 3KB CaptchaServlet.class 3KB ScoreEntity.class 3KB ScoreEntity.class 3KB TreeNode.class 2KB TreeNode.class 2KB TreeGridModel.class 2KB TreeGridModel.class 2KB DepartEntity.class 2KB DepartEntity.class 2KB RoleEntity.class 2KB RoleEntity.class 2KB AjaxJson.class 2KB AjaxJson.class 2KB StudentEntity.class 2KB StudentEntity.class 2KB DateConvertEditor.class 2KB DateConvertEditor.class 2KB TeacherEntity.class 2KB TeacherEntity.class 2KB Pagination.class 2KB Pagination.class 2KB Client.class 2KB Client.class 2KB ClientManager.class 2KB ClientManager.class 2KB BrowserType.class 2KB BrowserType.class 2KB Data.class 1KB Data.class 1KB BaseEntity.class 1KB BaseEntity.class 1KB ScoreService.class 1KB ScoreService.class 1KB JsonUtil.class 991B JsonUtil.class 991B ContextHolderUtils.class 983B ContextHolderUtils.class 983B BaseService.class 973B BaseService.class 973B BaseController.class 931B BaseController.class 931B BaseDao.class 929B BaseDao.class 929B SystemService.class 925B SystemService.class 925B SystemDao.class 744B SystemDao.class 744B TeacherService.class 557B StudentService.class 557B TeacherService.class 557B StudentService.class 557B SystemConstant.class 410B SystemConstant.class 410B共 659 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
探索者我有我路向
- 粉丝: 175
- 资源: 1657
下载权益
C知道特权
VIP文章
课程特权
VIP享7折，此内容立减3.57元 开通VIP
- 1
- 2
- 3
- 4
- 5
- 6
前往页