package?com.Dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;
import?com.entity.Employee;
import?com.entity.Position;
import?com.entity.User;
import?com.util.DButil;

public?class?baseDAO?extends?DButil?{
	//?用于查詢
	public?List?getAll（）?{
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?employee“;
		ResultSet?rs?=?super.executeQuery（sql）;?//?此處可用的executeQuery是父類中的方法
												//?可變參數可以傳空值此處亦可用this.
		try?{
			while?（rs.next（））?{
				list.add（new?Employee（rs.getInt（1）?rs.getString（2）
						rs.getString（3）rs.getDate（4）?rs.getInt（5）?rs.getString（6）?
						rs.getString（7）?rs.getString（8）rs.getString（9）））;
			}
			return?list;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?null;
		}?finally?{
			super.close（）;
		}
	}
	//如果在jsp頁面中處理日期格式像update中對日期的傳參方式即可
	public?int?add（Employee?e）?{
		String?sql?=?“insert?into?employee（namesexbirthdaypositionIdeducationteladressusername）?value（????????）“;
		return?this.executeUpdate（sql?e.getName（）?e.getSex（）
				e.getBirthday（）
				e.getPositionId（）?e.getEducation（）?e.getTel（）?e.getAdress（）e.getUsername（））;
	}

	public?int?update（Employee?e）{
		String?sql?=?“update?employee?set?name=?sex=?birthday=?positionId=?education=?tel=?adress=?username=??where?id=?“;
		return?this.executeUpdate（sql?e.getName（）?e.getSex（）
				new?SimpleDateFormat（“yyyy-MM-dd“）.format（e.getBirthday（））
				e.getPositionId（）?e.getEducation（）?e.getTel（）?e.getAdress（）e.getUsername（）
				e.getId（））;	}
	
	public?int?delete（int?id）{
		String?sql?=?“delete?from?employee?where?id=?“;
		return?this.executeUpdate（sql?id）;
	}
	
	public?Employee?getById（int?id）{
		String?sql?=?“select?*?from?employee?where?id=?“;
		ResultSet?rs?=?super.executeQuery（sqlid）;??//此處可用的executeQuery是父類中的方法?可變參數可以傳空值此處亦可用this.
		try?{
			if（rs.next（））{
				return?new?Employee（rs.getInt（1）?rs.getString（2）
						rs.getString（3）rs.getDate（4）?rs.getInt（5）?rs.getString（6）?
						rs.getString（7）?rs.getString（8）?rs.getString（9））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			
		}finally{
			super.close（）;
		}
		return?null;
	}
	
	public?List?getList（）?{
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?position“;
		ResultSet?rs?=?super.executeQuery（sql）;
		try?{
			while（rs.next（））{
				list.add（new?Position（rs.getInt（1）rs.getString（2）））;
			}
			return?list;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?null;
		}finally{
			close（）;
		}
	}
	public?List?search（String?ser）?{
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?employee?whe

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-28?12:30??Employee\
?????文件?????????771??2018-12-28?12:30??Employee\.classpath
?????目錄???????????0??2018-12-28?12:32??Employee\.myeclipse\
?????文件?????????297??2018-12-28?12:30??Employee\.mymetadata
?????文件????????1751??2018-12-28?12:30??Employee\.project
?????目錄???????????0??2018-12-28?12:30??Employee\.settings\
?????文件?????????500??2018-12-28?12:30??Employee\.settings\.jsdtscope
?????文件?????????395??2018-12-28?12:30??Employee\.settings\org.eclipse.jdt.core.prefs
?????文件?????????462??2018-12-28?12:30??Employee\.settings\org.eclipse.wst.common.component
?????文件?????????252??2018-12-28?12:30??Employee\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-12-28?12:30??Employee\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-12-28?12:30??Employee\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\
?????文件????????1071??2018-12-28?12:30??Employee\WebRoot\LICENSE
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\meta-INF\
?????文件??????????36??2018-12-28?12:30??Employee\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\Dao\
?????文件????????6361??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\Dao\baseDAO.class
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\entity\
?????文件????????3489??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\entity\Employee.class
?????文件?????????930??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\entity\Position.class
?????文件????????1333??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\entity\User.class
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\filter\
?????文件????????1529??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\filter\CharacrerEncodingFlieter$1.class
?????文件????????2033??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\filter\CharacrerEncodingFlieter.class
?????文件????????2063??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\filter\authorizationFilter.class
?????目錄???????????0??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\servlet\
?????文件????????8000??2018-12-28?12:30??Employee\WebRoot\WEB-INF\classes\com\servlet\EmployeeServlet.class
............此處省略242個文件信息