package?com.hyg.buss.controller;

import?java.io.InputStream;
import?java.io.OutputStream;
import?java.math.BigDecimal;
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.hyg.buss.entity.base.ScoreEntity;
import?com.hyg.buss.entity.base.StudentEntity;
import?com.hyg.buss.entity.base.TeacherEntity;
import?com.hyg.buss.service.ScoreService;
import?com.hyg.common.controller.baseController;
import?com.hyg.common.util.AjaxJson;
import?com.hyg.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?r

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????606720??2017-05-31?14:49??學生成績管理系統\00_項目說明.doc

?????文件????????834??2017-05-31?10:13??學生成績管理系統\score\.classpath

?????文件???????1038??2017-05-31?10:13??學生成績管理系統\score\.project

?????文件????????503??2017-05-31?10:13??學生成績管理系統\score\.settings\.jsdtscope

?????文件????????364??2017-05-31?10:13??學生成績管理系統\score\.settings\org.eclipse.jdt.core.prefs

?????文件????????467??2017-05-31?10:13??學生成績管理系統\score\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-05-31?10:13??學生成績管理系統\score\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-05-31?10:13??學生成績管理系統\score\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-05-31?10:13??學生成績管理系統\score\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????13288??2017-05-31?11:17??學生成績管理系統\score\build\classes\com\hyg\buss\controller\ScoreController.class

?????文件???????5956??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\controller\StudentController.class

?????文件???????5686??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\controller\TeacherController.class

?????文件???????2498??2017-05-31?10:56??學生成績管理系統\score\build\classes\com\hyg\buss\entity\base\ScoreEntity.class

?????文件???????1928??2017-05-31?10:56??學生成績管理系統\score\build\classes\com\hyg\buss\entity\base\StudentEntity.class

?????文件???????1840??2017-05-31?10:56??學生成績管理系統\score\build\classes\com\hyg\buss\entity\base\TeacherEntity.class

?????文件???????4662??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\impl\ScoreServiceImpl.class

?????文件???????3274??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\impl\StudentServiceImpl.class

?????文件???????3104??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\impl\TeacherServiceImpl.class

?????文件???????1020??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\ScoreService.class

?????文件????????501??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\StudentService.class

?????文件????????501??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\buss\service\TeacherService.class

?????文件????????907??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\common\controller\baseController.class

?????文件????????921??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\common\dao\baseDao.class

?????文件???????4463??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\common\dao\impl\baseDaoImpl.class

?????文件???????1433??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\common\entity\base\baseEntity.class

?????文件????????949??2017-05-31?10:51??學生成績管理系統\score\build\classes\com\hyg\common\service\baseService.class

?????文件???????3996??2017-05-31?10:52??學生成績管理系統\score\build\classes\com\hyg\common\service\impl\baseServiceImpl.class

?????文件???????1988??2017-05-31?10:51??學生成績管理系統\score\build\classes\com\hyg\common\util\AjaxJson.class

?????文件???????1517??2017-05-31?10:51??學生成績管理系統\score\build\classes\com\hyg\common\util\BrowserType.class

?????文件???????3622??2017-05-31?10:51??學生成績管理系統\score\build\classes\com\hyg\common\util\BrowserUtils.class

............此處省略657個文件信息