package?com.java1234.action;

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


import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

import?org.apache.struts2.ServletActionContext;

import?com.java1234.dao.ClassDao;
import?com.java1234.dao.GradeDao;
import?com.java1234.dao.StudentDao;
import?com.java1234.model.Class;
import?com.java1234.model.Grade;
import?com.java1234.util.DbUtil;

import?com.java1234.util.ResponseUtil;
import?com.java1234.util.StringUtil;
import?com.opensymphony.xwork2.ActionSupport;

public?class?ClassAction?extends?ActionSupport{

	/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?1L;
	
	private?DbUtil?dbUtil=new?DbUtil（）;
	private?ClassDao?classDao=new?ClassDao（）;
	private?GradeDao?gradeDao=new?GradeDao（）;
	private?StudentDao?studentDao=new?StudentDao（）;
	private?List?classList=new?ArrayList（）;
	private?List?gradeList=new?ArrayList（）;
	private?String?mainPage;?
	private?String?navCode;
	
	private?String?classId;
	private?Class?c;
	
	private?String?s_gradeId;
	
	public?List?getClassList（）?{
		return?classList;
	}
	public?void?setClassList（List?classList）?{
		this.classList?=?classList;
	}
	public?String?getMainPage（）?{
		return?mainPage;
	}
	public?void?setMainPage（String?mainPage）?{
		this.mainPage?=?mainPage;
	}
	public?String?getNavCode（）?{
		return?navCode;
	}

	
	
	
	public?List?getGradeList（）?{
		return?gradeList;
	}
	public?void?setGradeList（List?gradeList）?{
		this.gradeList?=?gradeList;
	}
	public?String?getClassId（）?{
		return?classId;
	}
	public?void?setClassId（String?classId）?{
		this.classId?=?classId;
	}
	public?Class?getC（）?{
		return?c;
	}
	public?void?setC（Class?c）?{
		this.c?=?c;
	}
	
	
	public?String?getS_gradeId（）?{
		return?s_gradeId;
	}
	public?void?setS_gradeId（String?s_gradeId）?{
		this.s_gradeId?=?s_gradeId;
	}
	public?String?list（）{
		Connection?con=null;
		try{
			con=dbUtil.getCon（）;
			classList=classDao.classList（connull）;
			//班級信息管理“?“班級維護“;
			mainPage=“class/classList.jsp“;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}finally{
			try?{
				dbUtil.closeCon（con）;
			}?catch?（Exception?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		return?SUCCESS;
	}
	
	public?String?delete（）{
		Connection?con=null;
		try{
			con=dbUtil.getCon（）;
			JSONobject?resultJson=new?JSONobject（）;
			boolean?exist=studentDao.existStudentByClassId（con?classId）;
			if（exist）{
				resultJson.put（“error“?“班級下面有學生，不能刪除！“）;//class里定義了error，alert
			}else{
				classDao.classDelete（con?classId）;
				resultJson.put（“success“?true）;				
			}
			ResponseUtil.write（resultJson?ServletActionContext.getResponse（））;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}finally{
			try?{
				dbUtil.closeCon（con）;
			}?catch?（Exception?e）?{
				//?TODO?Auto-generated?c

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-12-30?15:59??StudentInfo\
?????文件????????1093??2016-12-15?00:29??StudentInfo\.classpath
?????文件????????1336??2016-12-15?00:29??StudentInfo\.project
?????目錄???????????0??2016-12-30?15:59??StudentInfo\.settings\
?????文件?????????522??2016-12-15?00:29??StudentInfo\.settings\.jsdtscope
?????文件?????????364??2016-12-15?00:29??StudentInfo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????494??2016-12-15?00:29??StudentInfo\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-12-15?00:29??StudentInfo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-12-15?00:29??StudentInfo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-12-15?00:29??StudentInfo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\meta-INF\
?????文件??????????39??2016-12-15?00:29??StudentInfo\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\classes\
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\
?????文件????????6219??2016-12-16?16:22??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\ClassAction.class
?????文件????????7484??2016-12-16?17:30??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\DataDicAction.class
?????文件????????4917??2016-12-16?17:30??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\DataDicTypeAction.class
?????文件????????4731??2016-12-16?16:22??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\GradeAction.class
?????文件???????11677??2016-12-16?00:23??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\StudentAction.class
?????文件????????5132??2016-12-23?16:49??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\action\UserAction.class
?????目錄???????????0??2016-12-30?15:59??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\
?????文件????????4110??2016-12-16?17:30??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\ClassDao.class
?????文件????????4985??2016-12-15?13:48??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\DataDicDao.class
?????文件????????3264??2016-12-15?01:10??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\DataDicTypeDao.class
?????文件????????3121??2016-12-15?01:10??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\GradeDao.class
?????文件????????8037??2016-12-16?00:57??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\StudentDao.class
?????文件????????1982??2016-12-15?01:10??StudentInfo\WebRoot\WEB-INF\classes\com\java1234\dao\UserDao.class
............此處省略158個文件信息