package?com.mybatis.controller;

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.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（）;
		String?username?=?（String）?session.getAttribute（“username“）;
		if?（username!=null）?{
		????return?“/Add“;
					
		}else{
			return?“redirect:/“;
		}
	}
	@RequestMapping（“/edit“）
	public?String?edit（String?snumberHttpServletRequest?request）?{
		HttpSession?session=request.getSession（）;
		String?username?=?（String）?session.getAttribute（“username“）;
		if?（username!=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?snameHttpServletRequest?requestModel?model）??
	{???
		HttpSession?session=request.getSession（）;
		String?username?=?（String）?session.getAttribute（“username“）;
		model.addAttribute（“username“username）;
		if?（username!=null）?{
			if?（sname==null?||?sname==““）?{
				List?list=studentService.getAllStudentAndGrade（）;
				request.setAttribute（“student“?list）;
			}else
			{
				List?list=?studentService.getStudentAndGrade（sname）;	
				request.setAttribute（“student“?list）;
			}
			return?“/List“;
		}else{
			return?“redirect:/“;
		}
	}
	/***
	?*?刪除
	?*?@param?snumber
	?*?@param?request
	?*?@return
	?*/
	@RequestMapping（“/deleteInfo“）
	@ResponseBody
	public?JSONobject?deleteInfo（String?snumberHttpServletRequest?request）throws?Exception
	{	
		JSONobject?rData=new?JSONobject（）;?
		HttpSession?session=request.getSession（）;
		String?username?=?（String）?session.getAttribute（“username“）;
		if?（username!=null）?{
			try?{
				studentService.deleteStudentInfo（snumber）;
				gradeService.deleteGradeInfo（snumber）;
				rData.put（“status“?0）;
				rData.put（“message“?“刪除成功！“）;				
			
			}?catch?（Exception?e）?{
				//?TODO:?handle?exception
				rData.put（“status“?1）;
				rData.put（“message“?“刪除失敗！“）;
			}			

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

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

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

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

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

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

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

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

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

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

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

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

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

?????文件???????2294??2017-02-20?18:30??mybatis001\resource\mapper\StudentMapper.xml

?????文件????????443??2017-02-18?12:21??mybatis001\resource\mapper\UserMapper.xml

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

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

?????文件???????5293??2017-02-21?09:49??mybatis001\src\com\mybatis\controller\StudentController.java

?????文件???????1890??2017-02-20?15:19??mybatis001\src\com\mybatis\controller\UserController.java

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

?????文件???????1159??2017-02-20?18:50??mybatis001\src\com\mybatis\dao\StudentMapper.java

?????文件????????324??2017-02-20?13:23??mybatis001\src\com\mybatis\dao\UserMapper.java

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

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

?????文件????????443??2017-02-17?12:49??mybatis001\src\com\mybatis\entity\User.java

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

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

?????文件???????1230??2017-02-21?09:49??mybatis001\src\com\mybatis\service\impl\StudentServiceImpl.java

?????文件????????561??2017-02-20?13:14??mybatis001\src\com\mybatis\service\impl\UserServiceImpl.java

?????文件????????445??2017-02-21?09:48??mybatis001\src\com\mybatis\service\StudentService.java

?????文件????????188??2017-02-20?13:20??mybatis001\src\com\mybatis\service\UserService.java

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