package?action;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.Map;
import?db.db;
import?com.opensymphony.xwork2.ActionContext;
import?com.opensymphony.xwork2.ActionSupport;

public?class?admin?extends?ActionSupport?{
	private?static?final?long?serialVersionUID?=?1L;
	public?String?username;
	public?String?password;
	public?int?role;
	public?String?action;
	public?ArrayList?stuParamArray;
	@Override
	public?String?execute（）?throws?Exception?{
		Connection?conn=db.createDBConn（）;
		//----查詢數據操作----
		String?sqlwhere=new?String（““）;
		String?sql=new?String（““）;
		if（“select“.equals（action））{//如果是查詢操作
			if（username!=null&&username.trim（）.length（）!=0）
				sqlwhere=“where?username?like?‘%“+username.trim（）+“%‘?“;
			sql=“select?*?from?admin?“+sqlwhere;
			Statement?state=conn.createStatement（）;
			ResultSet?rs=state.executeQuery（sql）;
			ArrayList?stuArray=new?ArrayList（）;
			while（rs.next（））{
				admin?stu=new?admin（）;
				stu.setUsername（rs.getString（“username“））;
				stu.setPassword（rs.getString（“password“））;
				stu.setRole（rs.getInt（“role“））;
				stuArray.add（stu）;
			}
			Map?request?=?（Map）ActionContext.getContext（）.get（“request“）;
			request.put（“stuArray“?stuArray）;			
		}
		if（stuParamArray!=null&&“update“.equals（action））{
			for（int?i=0;i					String?sqlstr=“update?admin?set?role=“+stuParamArray.get（i）.getRole（）+
						“?where?username=‘“+stuParamArray.get（i）.getUsername（）+“‘“;
					Statement?state=conn.createStatement（）;
					state.executeUpdate（sqlstr）;
			}
		}
		db.closeConn（conn）;
		return?SUCCESS;
	}
	public?String?getUsername（）?{
		return?username;
	}
	public?void?setUsername（String?username）?{
		this.username?=?username;
	}
	public?String?getPassword（）?{
		return?password;
	}
	public?void?setPassword（String?password）?{
		this.password?=?password;
	}
	public?int?getRole（）?{
		return?role;
	}
	public?void?setRole（int?role）?{
		this.role?=?role;
	}
	public?String?getAction（）?{
		return?action;
	}
	public?void?setAction（String?action）?{
		this.action?=?action;
	}
	public?ArrayList?getStuParamArray（）?{
		return?stuParamArray;
	}
	public?void?setStuParamArray（ArrayList?stuParamArray）?{
		this.stuParamArray?=?stuParamArray;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-03-30?08:59??student-master\
?????文件?????????278??2020-03-30?08:59??student-master\.gitignore
?????文件?????????266??2020-03-30?08:59??student-master\README.md
?????文件????????6617??2020-03-30?08:59??student-master\student.sql
?????目錄???????????0??2020-03-30?08:59??student-master\student\
?????目錄???????????0??2020-03-30?08:59??student-master\student\WebContent\
?????目錄???????????0??2020-03-30?08:59??student-master\student\WebContent\meta-INF\
?????文件??????????39??2020-03-30?08:59??student-master\student\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\
?????目錄???????????0??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\
?????文件???????69002??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\commons-fileupload-1.3.1.jar
?????文件??????173587??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\commons-io-2.2.jar
?????文件??????315805??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\commons-lang3-3.1.jar
?????文件???????62050??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\commons-logging-1.1.3.jar
?????文件??????931168??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\freemarker-2.3.19.jar
?????文件??????614203??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\javassist-3.11.0.GA.jar
?????文件??????489884??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\log4j-1.2.17.jar
?????文件??????999635??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\mysql-connector-java-5.1.44-bin.jar
?????文件??????227997??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\ognl-3.0.6.jar
?????文件??????799980??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\struts2-core-2.3.16.1.jar
?????文件??????653278??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\lib\xwork-core-2.3.16.1.jar
?????文件?????????978??2020-03-30?08:59??student-master\student\WebContent\WEB-INF\web.xml
?????文件????????2755??2020-03-30?08:59??student-master\student\WebContent\banner.html
?????文件????????3000??2020-03-30?08:59??student-master\student\WebContent\course.jsp
?????目錄???????????0??2020-03-30?08:59??student-master\student\WebContent\css\
?????文件????????6423??2020-03-30?08:59??student-master\student\WebContent\css\common_style_blue.css
?????文件???????66957??2020-03-30?08:59??student-master\student\WebContent\css\easyui.css
?????文件????????3480??2020-03-30?08:59??student-master\student\WebContent\css\icon.css
?????文件????????4097??2020-03-30?08:59??student-master\student\WebContent\css\style1.css
?????文件????????2960??2020-03-30?08:59??student-master\student\WebContent\department.jsp
?????文件????????3080??2020-03-30?08:59??student-master\student\WebContent\grade.jsp
............此處省略88個文件信息