package?com.action;

import?java.sql.*;
import?java.util.*;

import?com.sun.jndi.url.corbaname.corbanameURLContextFactory;
import?com.util.DBUtil;
import?com.util.DataConvert;

public?class?Assess?{

	public?String?EmployeeID?Position?GetType?Duty?Department?English
			Computer?Remark;

	public?java.sql.Date?GetDate?StartDate?EndDate;

	public?int?AssessNO;

	public?Assess（）?{
	};

	public?String?getEmployeeID（）?{
		return?EmployeeID;
	}

	public?void?setEmployeeID（String?s）?{
		this.EmployeeID?=?s;
	}

	public?String?getPosition（）?{
		return?Position;
	}

	public?void?setPosition（String?s）?{
		this.Position?=?s;
	}

	public?String?getGetType（）?{
		return?GetType;
	}

	public?void?setGetType（String?s）?{
		this.GetType?=?s;
	}

	public?String?getDuty（）?{
		return?Duty;
	}

	public?void?setDuty（String?s）?{
		this.Duty?=?s;
	}

	public?String?getDepartment（）?{
		return?Department;
	}

	public?void?setDepartment（String?s）?{
		this.Department?=?s;
	}

	public?String?getEnglish（）?{
		return?English;
	}

	public?void?setEnglish（String?s）?{
		this.English?=?s;
	}

	public?String?getComputer（）?{
		return?Computer;
	}

	public?void?setComputer（String?s）?{
		this.Computer?=?s;
	}

	public?String?getRemark（）?{
		return?Remark;
	}

	public?void?setRemark（String?s）?{
		this.Remark?=?s;
	}

	public?void?setAssessNO（int?i）?{
		this.AssessNO?=?i;
	}

	public?String?getAssessNO（）?{
		return?DataConvert.IntToStr（AssessNO）;
	}

	public?String?getGetDate（）?{
		if?（this.GetDate?!=?null）
			return?DataConvert.sqlDateToStr（GetDate）;
		else
			return?““;
	}

	public?void?setGetDate（String?str）?{
		if?（str?!=?null）
			this.GetDate?=?DataConvert.StrTosqlDate（str）;
		else
			this.GetDate?=?null;
	}

	public?String?getStartDate（）?{
		if?（this.StartDate?!=?null）
			return?DataConvert.sqlDateToStr（StartDate）;
		else
			return?““;
	}

	public?void?setStartDate（String?str）?{
		if?（str?!=?null）
			this.StartDate?=?DataConvert.StrTosqlDate（str）;
		else
			this.StartDate?=?null;
	}

	public?String?getEndDate（）?{
		if?（this.EndDate?!=?null）
			return?DataConvert.sqlDateToStr（EndDate）;
		else
			return?““;
	}

	public?void?setEndDate（String?str）?{
		if?（str?!=?null）
			this.EndDate?=?DataConvert.StrTosqlDate（str）;
		else
			this.EndDate?=?null;
	}

	/*
	?*?Find?Assess?by?NO
	?*/
	public?static?Assess?FindByNO（String?_AssessNO）?{
		Connection?connection?=?null;
		Assess?assess?=?new?Assess（）;
		try?{
			connection?=?DBUtil.getConnection（）;
			PreparedStatement?dbc?=?connection
					.prepareStatement（“SELECT?*?FROM?assess?WHERE?AssessNO=?“）;
			dbc.setString（1?_AssessNO）;
			ResultSet?rs?=?dbc.executeQuery（）;
			if?（rs.next（））?{
				assess.setAssessNO（rs.getInt（“AssessNO“））;
				assess.setEmployeeID（rs.getString（“EmployeeID“））;
				assess.setPosition（rs.getString（“Position“））;
				assess.setGetDate（rs.getString（“GetDate“））;
		

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

?????文件???????1338??2013-05-26?19:16??rlsys\.classpath

?????文件????????288??2013-05-26?19:04??rlsys\.mymetadata

?????文件???????1411??2013-05-26?19:07??rlsys\.project

?????文件????????500??2013-05-26?19:04??rlsys\.settings\.jsdtscope

?????文件????????330??2013-05-26?19:04??rlsys\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2013-05-26?19:04??rlsys\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-05-26?19:04??rlsys\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????9062??2013-05-27?10:22??rlsys\src\com\action\Assess.java

?????文件???????1017??2013-05-26?20:23??rlsys\src\com\action\LoginAction.java

?????文件???????9170??2013-05-28?21:50??rlsys\src\com\action\Reward.java

?????文件???????7716??2013-05-27?10:30??rlsys\src\com\action\Train.java

?????文件???????7957??2013-05-27?10:32??rlsys\src\com\action\Translate.java

?????文件????????840??2013-05-26?19:23??rlsys\src\com\dao\impl\JdbcUserDAO.java

?????文件????????162??2013-05-26?19:23??rlsys\src\com\dao\UserDAO.java

?????文件??????20560??2013-05-28?22:06??rlsys\src\com\employee\Employee.java

?????文件????????608??2013-05-27?09:41??rlsys\src\com\servlet\AddempServlet.java

?????文件????????413??2013-05-26?19:23??rlsys\src\com\user\User.java

?????文件???????1152??2013-05-26?19:23??rlsys\src\com\util\DataConvert.java

?????文件???????1117??2013-05-26?19:23??rlsys\src\com\util\DBUtil.java

?????文件????????437??2013-05-26?19:23??rlsys\src\com\util\DegistUtil.java

?????文件????????150??2013-05-27?12:02??rlsys\src\db.properties

?????文件???????7440??2013-05-28?09:58??rlsys\WebRoot\assess\AddAssessStep1.jsp

?????文件???????2626??2013-05-28?10:03??rlsys\WebRoot\assess\AddAssessStep2.jsp

?????文件????????829??2013-05-28?10:03??rlsys\WebRoot\assess\Assess.jsp

?????文件???????1582??2008-05-20?16:56??rlsys\WebRoot\assess\AssessLeft.jsp

?????文件????????714??2013-05-26?19:06??rlsys\WebRoot\assess\Common.jsp

?????文件???????1535??2013-05-28?10:05??rlsys\WebRoot\assess\DelAssessStep1.jsp

?????文件????????598??2013-05-26?19:06??rlsys\WebRoot\assess\Footer.jsp

?????文件???????2314??2013-05-26?19:06??rlsys\WebRoot\assess\Header.jsp

?????文件???????2847??2013-05-28?10:06??rlsys\WebRoot\assess\ManageAssessStep1.jsp

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