package?com.wm;

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;

public?class?DAO?{
	private?DUtil?dbu;

	public?DAO（DUtil?dbu）?{
		super（）;
		this.dbu?=?dbu;
	}

	public?List?getlist（）?{
		Connection?con?=?dbu.getConnection（）;
		String?sql?=?“select?name?pswE-mail?from?[User]“;
		List?list?=?new?ArrayList（）;
		PreparedStatement?psta?=?null;
		try?{
			psta?=?con.prepareStatement（sql）;
			ResultSet?res?=?psta.executeQuery（）;
			while?（res.next（））?{
				String?name?=?res.getString（“username“）;
				String?psw?=?res.getString（“psw“）;
				String?mail?=?res.getString（“E-mail“）;
				UserVO?user?=?new?UserVO（）;
				user

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

?????文件????????552??2009-10-16?12:33??WebPro\.classpath

?????文件????????291??2009-10-14?19:48??WebPro\.mymetadata

?????文件???????1224??2009-10-14?21:48??WebPro\.project

?????文件????????334??2009-10-14?19:48??WebPro\.settings\org.eclipse.jdt.core.prefs

?????文件????????147??2009-10-14?21:18??WebPro\src\com\wm\Config.properties

?????文件???????3381??2009-10-19?19:14??WebPro\src\com\wm\DAO.java

?????文件???????1582??2009-10-16?12:31??WebPro\src\com\wm\DUtil.java

?????文件???????2638??2009-10-19?19:11??WebPro\src\com\wm\MySecondServlet.java

?????文件???????3414??2009-10-19?18:27??WebPro\src\com\wm\MyServletTest.java

?????文件???????1191??2009-10-19?17:07??WebPro\src\com\wm\UserVO.java

?????文件???????1465??2009-10-19?16:47??WebPro\WebRoot\Index.html

?????文件???????1969??2009-10-19?19:08??WebPro\WebRoot\Login.html

?????文件?????????39??2009-10-14?19:48??WebPro\WebRoot\meta-INF\MANIFEST.MF

?????文件???????6638??2009-10-19?17:05??WebPro\WebRoot\regester.html

?????文件????????147??2009-10-14?21:18??WebPro\WebRoot\WEB-INF\classes\com\wm\Config.properties

?????文件???????3600??2009-10-19?19:14??WebPro\WebRoot\WEB-INF\classes\com\wm\DAO.class

?????文件???????1975??2009-10-19?15:12??WebPro\WebRoot\WEB-INF\classes\com\wm\DUtil.class

?????文件???????2700??2009-10-19?19:11??WebPro\WebRoot\WEB-INF\classes\com\wm\MySecondServlet.class

?????文件???????3302??2009-10-19?18:27??WebPro\WebRoot\WEB-INF\classes\com\wm\MyServletTest.class

?????文件???????1729??2009-10-19?17:08??WebPro\WebRoot\WEB-INF\classes\com\wm\UserVO.class

?????文件?????302282??2009-10-14?21:06??WebPro\WebRoot\WEB-INF\lib\msbase.jar

?????文件??????69477??2009-10-14?21:06??WebPro\WebRoot\WEB-INF\lib\mssqlserver.jar

?????文件??????67235??2009-10-14?21:06??WebPro\WebRoot\WEB-INF\lib\msutil.jar

?????文件???????1244??2009-10-19?18:52??WebPro\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2009-10-19?19:21??WebPro\WebRoot\WEB-INF\classes\com\wm

?????目錄??????????0??2009-10-19?19:21??WebPro\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2009-10-19?19:21??WebPro\src\com\wm

?????目錄??????????0??2009-10-19?19:21??WebPro\WebRoot\WEB-INF\classes

?????目錄??????????0??2009-10-19?19:21??WebPro\WebRoot\WEB-INF\lib

?????目錄??????????0??2009-10-19?19:21??WebPro\src\com

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