package?com.csai.action;
import?java.util.ArrayList;
import?javax.servlet.http.HttpServletRequest;
import?org.apache.struts2.ServletActionContext;
import?org.hibernate.Query;
import?org.hibernate.Session;
import?com.csai.POJO.Student;
import?com.opensymphony.xwork2.ActionContext;
import?com.opensymphony.xwork2.ActionSupport;

public?class?AcceptMoneyAction?extends?ActionSupport?{
	private?static?final?long?serialVersionUID?=?1L;
	public?String?studentname;
	public?String?action;
	public?String?matrino;
	public?ArrayList?stuParamArray;
	public?Session?sessionHibernate;
	public?Session?getSessionHibernate（）?{
		return?sessionHibernate;
	}
	public?void?setSessionHibernate（Session?sessionHibernate）?{
		this.sessionHibernate?=?sessionHibernate;
	}
	@Override
	public?String?execute（）?throws?Exception?{
		sessionHibernate.beginTransaction（）;
		//----查詢數據操作----
		String?hsqlwhere=new?String（““）;
		String?hsql=new?String（““）;
		if（“select“.equals（action））{//如果是查詢操作
			if（studentname!=null&&studentname.trim（）.length（）!=0）
				hsqlwhere=“where?StudentName?like?‘%“+studentname.trim（）+“%‘?“;
			if（hsqlwhere!=null&&hsqlwhere.length（）!=0）{
				if（matrino!=null&&matrino.trim（）.length（）!=0）
					hsqlwhere+=“?and?MatriNo?like?‘%“+matrino.trim（）+“%‘?“;
			}else{
				if（matrino!=null&&matrino.trim（）.length（）!=0）
					hsqlwhere=“?where?MatriNo?like?‘%“+matrino.trim（）+“%‘?“;
			}
			hsql=“from?Student?“+hsqlwhere;
			Query?query=sessionHibernate.createQuery（hsql）;
			ArrayList?stuArray?=（ArrayList）query.list（）;
			HttpServletRequest?request?=?（HttpServletRequest）ActionContext.getContext（）.get（ServletActionContext.HTTP_REQUEST）;
			request.setAttribute（“stuArray“?stuArray）;			
		}
		//----交費操作----
		if（stuParamArray!=null&&“update“.equals（action））{
			for（int?i=0;i				if（stuParamArray.get（i）.getPayAmount（）!=null&&stuParamArray.get（i）.getPayOK（）!=null&&stuParamArray.get（i）.getStudentId（）!=null）{
					String?hsqlstr=“from?Student?where?StudentId=“+stuParamArray.get（i）.getStudentId（）;
					Query?query=sessionHibernate.createQuery（hsqlstr）;
					ArrayList?stuArray?=（ArrayList）query.list（）;
					if（stuArray.size（）>=1）{
						Student?stu=stuArray.get（0）;
						stu.setPayAmount（stuParamArray.get（i）.getPayAmount（））;
						stu.setPayOK（stuParamArray.get（i）.getPayOK（））;
						sessionHibernate.save（stu）;
					}
				}	
			}
		}
		sessionHibernate.getTransaction（）.commit（）;
		return?SUCCESS;
	}
	public?ArrayList?getStuParamArray（）?{
		return?stuParamArray;
	}
	public?void?setStuParamArray（ArrayList?stuParamArray）?{
		this.stuParamArray?=?stuParamArray;
	}
	public?String?getStudentname（）?{
		return?studentname;
	}
	public?void?setStudentname（String?studentname）?{
		this.studentname?=?studentname;
	}
	public?String?getAction（）?{
		return?action;
	}
	public?void?setAction（String?action）?{
		this.action?=?action;
	}

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

?????文件????????834??2011-09-03?13:56??ch18\.classpath

?????文件???????1037??2011-09-03?13:56??ch18\.project

?????文件????????503??2011-09-03?13:56??ch18\.settings\.jsdtscope

?????文件????????395??2011-09-03?13:56??ch18\.settings\org.eclipse.jdt.core.prefs

?????文件????????442??2011-09-03?13:56??ch18\.settings\org.eclipse.wst.common.component

?????文件????????345??2011-09-03?13:56??ch18\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-09-03?13:56??ch18\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-09-03?13:56??ch18\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4516??2011-09-03?13:58??ch18\build\classes\com\csai\action\AcceptMoneyAction.class

?????文件???????3800??2011-09-03?13:58??ch18\build\classes\com\csai\action\AdminUserAction.class

?????文件???????4868??2011-09-03?13:58??ch18\build\classes\com\csai\action\BedAction.class

?????文件???????3415??2011-09-03?13:58??ch18\build\classes\com\csai\action\BedchamberAction.class

?????文件???????3343??2011-09-03?13:58??ch18\build\classes\com\csai\action\ClassAction.class

?????文件???????4955??2011-09-03?13:58??ch18\build\classes\com\csai\action\ClassAdminAction.class

?????文件???????2894??2011-09-03?13:58??ch18\build\classes\com\csai\action\ClassViewAction.class

?????文件????????614??2008-08-25?11:29??ch18\build\classes\com\csai\action\LoginAction-validation.xml

?????文件???????2719??2011-09-03?13:58??ch18\build\classes\com\csai\action\LoginAction.class

?????文件???????6080??2011-09-03?13:58??ch18\build\classes\com\csai\action\MatriAction.class

?????文件???????2909??2011-09-03?13:58??ch18\build\classes\com\csai\action\RegStatusAction.class

?????文件???????3368??2011-09-03?13:58??ch18\build\classes\com\csai\action\SpecialityAction.class

?????文件???????1669??2011-09-03?13:58??ch18\build\classes\com\csai\db\HibernateUtil.class

?????文件???????1004??2011-09-03?13:58??ch18\build\classes\com\csai\POJO\AdminUser.class

?????文件????????554??2008-09-28?09:47??ch18\build\classes\com\csai\POJO\AdminUser.hbm.xml

?????文件???????1321??2011-09-03?13:58??ch18\build\classes\com\csai\POJO\Bedchamber.class

?????文件????????685??2008-09-07?17:50??ch18\build\classes\com\csai\POJO\Bedchamber.hbm.xml

?????文件???????1282??2011-09-03?13:58??ch18\build\classes\com\csai\POJO\ClassTa.class

?????文件????????671??2008-09-28?09:49??ch18\build\classes\com\csai\POJO\ClassTa.hbm.xml

?????文件???????1321??2011-09-03?13:58??ch18\build\classes\com\csai\POJO\Speciality.class

?????文件????????685??2008-09-28?09:49??ch18\build\classes\com\csai\POJO\Speciality.hbm.xml

?????文件???????2630??2011-09-03?13:58??ch18\build\classes\com\csai\POJO\Student.class

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