package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?util.DBUtil;
import?entity.Employee;
/**
?*?功能：查詢數據庫
?*?@author?曾維豪
?*
?*/
public?class?EmployeeDAO?{
	public?Employee?findByName（String?name）?throws?Exception{
		Employee?user?=?null;
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;
		ResultSet?rst?=?null;
		try?{
			conn?=?DBUtil.getConnection（）;
			prep?=?conn.prepareStatement（“select?*?from?employee?where?name=?“）;
			prep.setString（1?name）;
			rst?=?prep.executeQuery（）;
			if（rst.next（））{
				user?=?new?Employee（）;
				user.setId（rst.getInt（“id“））;
				user.setName（name）;
				user.setAge（rst.getInt（“age“））;
				user.setDepartment（rst.getString（“department“））;
				user.setPwd（rst.getString（“pwd“））;
				user.setGender（rst.getString（“gender“））;	
				user.setPosition（rst.getInt（“position“））;
				return?user;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?e;
		}finally{
			DBUtil.close（conn）;
		}		
		return?user;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\
?????文件????????1287??2017-08-23?23:18??leaveworkflow\.classpath
?????文件????????1196??2017-08-23?21:34??leaveworkflow\.project
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\.settings\
?????文件?????????522??2017-08-23?12:18??leaveworkflow\.settings\.jsdtscope
?????文件?????????364??2017-08-23?12:18??leaveworkflow\.settings\org.eclipse.jdt.core.prefs
?????文件?????????498??2017-08-23?21:34??leaveworkflow\.settings\org.eclipse.wst.common.component
?????文件?????????412??2017-08-23?12:18??leaveworkflow\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-08-23?12:18??leaveworkflow\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-08-23?12:18??leaveworkflow\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????37??2017-08-23?13:52??leaveworkflow\.tern-project
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\meta-INF\
?????文件??????????39??2017-08-23?12:18??leaveworkflow\WebRoot\meta-INF\MANIFEST.MF
?????文件??????????80??2017-06-30?18:14??leaveworkflow\WebRoot\meta-INF\context.xml
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\classes\dao\
?????文件????????1817??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\dao\EmployeeDAO.class
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\classes\entity\
?????文件????????1646??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\entity\Employee.class
?????文件????????1934??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\entity\LeaveTable.class
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\classes\util\
?????文件????????1175??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\util\DBUtil.class
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\classes\web\
?????文件????????1795??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\web\Examine.class
?????文件????????2086??2017-08-28?12:43??leaveworkflow\WebRoot\WEB-INF\classes\web\LoginServlet.class
?????文件????????2534??2017-08-28?14:36??leaveworkflow\WebRoot\WEB-INF\classes\web\State.class
?????目錄???????????0??2017-08-28?14:37??leaveworkflow\WebRoot\WEB-INF\lib\
?????文件??????996444??2017-08-23?23:20??leaveworkflow\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.42-bin.jar
?????文件????????1625??2017-08-24?20:15??leaveworkflow\WebRoot\WEB-INF\web.xml
............此處省略31個文件信息