package?com.tangcoo.dal;
import?java.util.*;
import?java.sql.*;

import?com.tangcoo.entity.*;
public?class?AuthorDao?{
	DBHelper?dh?=?new?DBHelper（）;
	public?ArrayList?getAuthors（）{
		ArrayList?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?authorTbl?“;
		object[]?pram?=?new?object[0];
		ResultSet?rs?=?dh.executeQuery（sql?pram）;
		try?{
			while（rs.next（））{
				Author?author?=?new?Author（）;
				author.setId（rs.getInt（“aid“））;
				author.setName（rs.getString（“aname“））;
				author.setAddress（rs.getString（“address“））;
				
				list.add（author）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			dh.closeResultSet（rs）;
			dh.closeConnection（）;
		}
		
		return?list;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????410??2009-11-25?11:07??bookweb\.classpath

?????文件????????294??2009-11-27?10:42??bookweb\.mymetadata

?????文件???????1225??2009-11-25?11:16??bookweb\.project

?????文件????????334??2009-11-25?11:06??bookweb\.settings\org.eclipse.jdt.core.prefs

?????文件????????774??2009-11-27?11:01??bookweb\src\com\tangcoo\dal\AuthorDao.java

?????文件???????3041??2009-11-27?11:26??bookweb\src\com\tangcoo\dal\BookDao.java

?????文件???????2731??2009-11-26?10:51??bookweb\src\com\tangcoo\dal\DBHelper.java

?????文件????????625??2009-11-25?12:13??bookweb\src\com\tangcoo\dal\MasterDao.java

?????文件????????740??2009-11-27?11:08??bookweb\src\com\tangcoo\dal\PublisherDao.java

?????文件????????727??2009-11-27?11:08??bookweb\src\com\tangcoo\dal\TypeDao.java

?????文件????????598??2009-11-26?12:18??bookweb\src\com\tangcoo\entity\Author.java

?????文件???????1349??2009-11-26?11:06??bookweb\src\com\tangcoo\entity\Book.java

?????文件????????433??2009-11-26?11:05??bookweb\src\com\tangcoo\entity\BookType.java

?????文件????????545??2009-11-25?12:00??bookweb\src\com\tangcoo\entity\Master.java

?????文件????????437??2009-11-26?11:03??bookweb\src\com\tangcoo\entity\Publisher.java

?????文件???????3461??2009-11-27?11:10??bookweb\WebRoot\back\addbook.jsp

?????文件???????1009??2009-11-26?12:21??bookweb\WebRoot\back\deletebook.jsp

?????文件???????1803??2009-11-27?11:18??bookweb\WebRoot\back\doaddbook.jsp

?????文件???????1367??2009-11-26?10:58??bookweb\WebRoot\back\dologin.jsp

?????文件???????1910??2009-11-27?11:45??bookweb\WebRoot\back\doupdatebook.jsp

?????文件???????2053??2009-11-27?11:24??bookweb\WebRoot\back\index.jsp

?????文件???????1046??2009-11-26?10:57??bookweb\WebRoot\back\login.jsp

?????文件???????4337??2009-11-27?11:42??bookweb\WebRoot\back\updatebook.jsp

?????文件?????????39??2009-11-25?11:06??bookweb\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1632??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\AuthorDao.class

?????文件???????4225??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\BookDao.class

?????文件???????3169??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\DBHelper.class

?????文件???????1328??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\MasterDao.class

?????文件???????1596??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\PublisherDao.class

?????文件???????1570??2009-11-27?11:37??bookweb\WebRoot\WEB-INF\classes\com\tangcoo\dal\TypeDao.class

............此處省略29個(gè)文件信息