package?com.icss.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?com.icss.db.DBUtil;
import?com.icss.vo.EmpVO;

public?class?EmpDao?{

	public?List?findAllEmp（）{
		
		List?list?=?new?ArrayList（）;
		
		Connection?conn?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		
		String?query?=?“select?empnoenamejobmgr“?+
				???????“hiredatesalcommdeptno?“?+
				???????“from?emp“;
		
		DBUtil?util?=?new?DBUtil（）;
		
		conn?=?util.getConnection（）;
		
		try?{
			ps?=?conn.prepareStatement（query）;
			rs?=?ps.executeQuery（）;
			
			EmpVO?vo?=?null;
			
			while（rs.next

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

?????文件????????412??2010-08-16?08:41??ebusiness\.classpath

?????文件????????300??2010-08-17?08:01??ebusiness\.mymetadata

?????文件???????1227??2010-08-17?08:42??ebusiness\.project

?????文件???????5274??2010-08-17?08:16??ebusiness\src\com\icss\dao\EmpDao.java

?????文件???????1666??2010-08-16?09:00??ebusiness\src\com\icss\db\DBUtil.java

?????文件???????1780??2010-08-17?15:10??ebusiness\src\com\icss\servlet\DeleteServlet.java

?????文件???????2977??2010-08-17?11:32??ebusiness\src\com\icss\servlet\HelloWorldServlet.java

?????文件???????2337??2010-08-16?09:12??ebusiness\src\com\icss\vo\EmpVO.java

?????文件????????834??2010-08-16?07:59??ebusiness\WebRoot\index.jsp

?????文件?????????39??2010-08-16?07:59??ebusiness\WebRoot\meta-INF\MANIFEST.MF

?????文件???????6294??2010-08-17?08:16??ebusiness\WebRoot\WEB-INF\classes\com\icss\dao\EmpDao.class

?????文件???????2070??2010-08-17?08:03??ebusiness\WebRoot\WEB-INF\classes\com\icss\db\DBUtil.class

?????文件???????1645??2010-08-17?11:30??ebusiness\WebRoot\WEB-INF\classes\com\icss\servlet\DeleteServlet.class

?????文件???????3248??2010-08-17?11:32??ebusiness\WebRoot\WEB-INF\classes\com\icss\servlet\HelloWorldServlet.class

?????文件???????2359??2010-08-17?08:03??ebusiness\WebRoot\WEB-INF\classes\com\icss\vo\EmpVO.class

?????文件????1196109??2010-08-16?08:41??ebusiness\WebRoot\WEB-INF\lib\classes12.jar

?????文件????????983??2010-08-17?11:31??ebusiness\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com\icss\dao

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com\icss\db

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com\icss\servlet

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com\icss\vo

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com\icss

?????目錄??????????0??2010-08-17?11:40??ebusiness\src\com\icss\dao

?????目錄??????????0??2010-08-17?11:40??ebusiness\src\com\icss\db

?????目錄??????????0??2010-08-17?11:40??ebusiness\src\com\icss\servlet

?????目錄??????????0??2010-08-17?11:40??ebusiness\src\com\icss\vo

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2010-08-17?11:40??ebusiness\src\com\icss

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\classes

?????目錄??????????0??2010-08-17?11:40??ebusiness\WebRoot\WEB-INF\lib

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