package?com.mybatis.controller;

import?java.util.ArrayList;
import?java.util.List;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpSession;

import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.stereotype.Controller;
import?org.springframework.transaction.annotation.Transactional;
import?org.springframework.ui.Model;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.ResponseBody;

import?com.alibaba.fastjson.JSONobject;
import?com.mybatis.entity.Grade;
import?com.mybatis.entity.Student;
import?com.mybatis.entity.User;
import?com.mybatis.service.GradeService;
import?com.mybatis.service.StudentService;

@Controller
@Transactional
@RequestMapping（“/student“）
public?class?StudentController?{
	
	@Autowired
	private?StudentService?studentService;
	@Autowired
	private?GradeService?gradeService;
	
	@RequestMapping（“/add“）
	public?String?add（HttpServletRequest?request）?{
		HttpSession?session=request.getSession（）;
		User?user?=?（User）?session.getAttribute（“user“）;
		if?（user!=null）?{
		????return?“/Add“;
					
		}else{
			return?“redirect:/“;
		}
	}
	@RequestMapping（“/edit“）
	public?String?edit（String?snumberHttpServletRequest?request）?{
		HttpSession?session=request.getSession（）;
		User?user?=?（User）?session.getAttribute（“user“）;
		if?（user!=null）?{
			Student?st=?studentService.getStudentInfo（snumber）;	
			request.setAttribute（“student“?st）;
		????return?“/Edit“;
					
		}else{
			return?“redirect:/“;
		}	
	}
	/***
	?*?查詢
	?*?@param?sname
	?*?@param?request
	?*?@return
	?*/
	@RequestMapping（“/selectInfo“）
	public?String?selectStudentInfo（String?pageString?snameHttpServletRequest?requestModel?model）??
	{??	???????
????????//頁面初始的時候page沒有值
		//當前第幾頁
????????if（null?==?page）
????????{
???????????page?=?“1“;
????????}
		//每頁顯示的條數
????????int?pageSize?=?5;??????
????????HttpSession?session=request.getSession（）;
		User?user?=?（User）?session.getAttribute（“user“）;
		model.addAttribute（“user“user）;
		if?（user!=null）?{
			if?（sname==null?||?sname==““）?{
			???List?student?=?new?ArrayList（）;????????
		???????student?=?this.studentService.getAllStudentAndGrade（）;
		???????//查到的總數
		???????model.addAttribute（“stNum“?student.size（））;
		???????//總頁數
		???????int?pageTimes=0;
		???????if（student.size（）%pageSize?==?0）
		???????{
		???????????pageTimes?=?student.size（）/pageSize;
		???????}else
		???????{
		???????????pageTimes?=?student.size（）/pageSize?+1?;
		???????}
		???????request.setAttribute（“pageTimes“?pageTimes）;		???????
		???????//每頁開始的第幾條記錄????????????
		???????int?startRow?=?（Integer.parseInt（page）-1）?*?pageSize;
		???????student?=?this.studentService.getAllStudentByPage（startRow?pageSize）;
		???????
		???????model.addAttribute（“currentPage“?Integer.parseInt（page））;
		???????model.addAttribute（“student“?student

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

?????文件????????908??2017-02-21?10:21??mybatis003?-?副本\grades.sql

?????文件???????3138??2017-02-21?08:59??mybatis003?-?副本\mybatis001\.classpath

?????文件????????303??2015-09-01?15:36??mybatis003?-?副本\mybatis001\.mymetadata

?????文件???????1753??2015-09-01?15:53??mybatis003?-?副本\mybatis001\.project

?????文件????????500??2015-09-01?15:36??mybatis003?-?副本\mybatis001\.settings\.jsdtscope

?????文件?????????57??2017-02-17?21:30??mybatis003?-?副本\mybatis001\.settings\org.eclipse.core.resources.prefs

?????文件????????670??2017-02-17?21:28??mybatis003?-?副本\mybatis001\.settings\org.eclipse.jdt.core.prefs

?????文件????????547??2015-09-01?15:43??mybatis003?-?副本\mybatis001\.settings\org.eclipse.wst.common.component

?????文件????????252??2017-02-17?21:29??mybatis003?-?副本\mybatis001\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-09-01?15:36??mybatis003?-?副本\mybatis001\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-09-01?15:36??mybatis003?-?副本\mybatis001\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????110??2017-02-17?12:40??mybatis003?-?副本\mybatis001\resource\dbconfig.properties

?????文件????????615??2017-02-21?09:50??mybatis003?-?副本\mybatis001\resource\mapper\GradeMapper.xml

?????文件???????3196??2017-02-22?11:07??mybatis003?-?副本\mybatis001\resource\mapper\StudentMapper.xml

?????文件????????450??2017-02-21?12:22??mybatis003?-?副本\mybatis001\resource\mapper\UserMapper.xml

?????文件???????1393??2017-02-20?18:58??mybatis003?-?副本\mybatis001\resource\mybatis-config.xml

?????文件???????6061??2017-02-21?09:08??mybatis003?-?副本\mybatis001\resource\springmvc-servlet.xml

?????文件???????7013??2017-02-22?10:04??mybatis003?-?副本\mybatis001\src\com\mybatis\controller\StudentController.java

?????文件???????1549??2017-02-21?12:26??mybatis003?-?副本\mybatis001\src\com\mybatis\controller\UserController.java

?????文件????????608??2017-02-20?18:44??mybatis003?-?副本\mybatis001\src\com\mybatis\dao\GradeMapper.java

?????文件???????1377??2017-02-21?19:11??mybatis003?-?副本\mybatis001\src\com\mybatis\dao\StudentMapper.java

?????文件????????308??2017-02-21?11:43??mybatis003?-?副本\mybatis001\src\com\mybatis\dao\UserMapper.java

?????文件????????470??2017-02-18?15:23??mybatis003?-?副本\mybatis001\src\com\mybatis\entity\Grade.java

?????文件????????604??2017-02-18?14:49??mybatis003?-?副本\mybatis001\src\com\mybatis\entity\Student.java

?????文件????????597??2017-02-21?12:23??mybatis003?-?副本\mybatis001\src\com\mybatis\entity\User.java

?????文件????????244??2017-02-20?17:39??mybatis003?-?副本\mybatis001\src\com\mybatis\service\GradeService.java

?????文件????????950??2017-02-21?09:49??mybatis003?-?副本\mybatis001\src\com\mybatis\service\impl\GradeServiceImpl.java

?????文件???????1631??2017-02-21?19:06??mybatis003?-?副本\mybatis001\src\com\mybatis\service\impl\StudentServiceImpl.java

?????文件????????544??2017-02-21?11:43??mybatis003?-?副本\mybatis001\src\com\mybatis\service\impl\UserServiceImpl.java

?????文件????????603??2017-02-21?19:04??mybatis003?-?副本\mybatis001\src\com\mybatis\service\StudentService.java

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