package?dao;

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

import?entity.User;
import?util.DBUtils;

/**
?*?DAO類
?*
?*/
public?class?UserDAO?{
	/**
	?*?依據uname查詢用戶，如果找不到，返回null?否則，返回一個User對象（里面存放了該用戶?的所有信息，包括密碼）
	?*/
	public?User?find（String?uname）?{
		User?user?=?null;
		Connection?conn?=?null;
		try?{
			conn?=?DBUtils.getConn（）;
			String?sql?=?“SELECT?*?FROM?t_user?“?+?“WHERE?uname=?“;
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ps.setString（1?uname）;
			ResultSet?rs?=?ps.executeQuery（）;
			if?（rs.next（））?{
				user?=?new?User（）;
				user.setId（rs.getInt（“id“））;
				user.setUname（“uname“）;
				user.setPwd（rs.getString（“password“））;
				user.setPhone（rs.getString（“phone“））;
				user.setEmail（rs.getString（“email“））;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（e）;
		}?finally?{
			DBUtils.closeConn（conn）;
		}
		return?user;
	}

	/**
	?*?依據id從數據庫中刪除對應的用戶
	?*/
	public?void?delete（int?id）?{
		Connection?conn?=?null;
		try?{
			conn?=?DBUtils.getConn（）;
			String?sql?=?“DELETE?FROM?t_user?“?+?“WHERE?id=?“;
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ps.setInt（1?id）;
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（e）;
		}?finally?{
			DBUtils.closeConn（conn）;
		}
	}

	/**
	?*?將用戶信息添加到數據庫
	?*/
	public?void?save（User?user）?{
		Connection?conn?=?null;
		try?{
			conn?=?DBUtils.getConn（）;
			String?sql?=?“INSERT?INTO?t_user?“?+?“VALUES（null????）“;
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ps.setString（1?user.getUname（））;
			ps.setString（2?user.getPwd（））;
			ps.setString（3?user.getPhone（））;
			ps.setString（4?user.getEmail（））;
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（e）;
		}?finally?{
			DBUtils.closeConn（conn）;
		}
	}

	/**
	?*?查詢出所有用戶信息
	?*/
	public?List?findAll（）?{
		List?users?=?new?ArrayList（）;
		Connection?conn?=?null;
		try?{
			conn?=?DBUtils.getConn（）;
			String?sql?=?“SELECT?*?FROM?t_user“;
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ResultSet?rs?=?ps.executeQuery（）;
			while?（rs.next（））?{
				int?id?=?rs.getInt（“id“）;
				String?uname?=?rs.getString（“uname“）;
				String?pwd?=?rs.getString（“password“）;
				String?phone?=?rs.getString（“phone“）;
				String?email?=?rs.getString（“email“）;
				User?user?=?new?User（）;
				user.setId（id）;
				user.setUname（uname）;
				user.setPwd（pwd）;
				user.setPhone（phone）;
				user.setEmail（email）;
				users.add（user）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（e）;
		}?finally?{
			DBUtils.closeConn（conn）;
		}
		return?users;
	}

}

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

?????文件???????1723??2018-04-01?08:40??StudentManagementSystem\.classpath

?????文件????????876??2018-04-01?07:05??StudentManagementSystem\pom.xml

?????文件???????1062??2018-04-02?09:39??StudentManagementSystem\.project

?????文件????????626??2018-04-01?07:01??StudentManagementSystem\.settings\.jsdtscope

?????文件????????422??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.jdt.core.prefs

?????文件?????????86??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.m2e.core.prefs

?????文件????????667??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.wst.common.component

?????文件????????284??2018-04-01?07:03??StudentManagementSystem\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????????48??2018-04-01?07:01??StudentManagementSystem\.settings\org.eclipse.wst.validation.prefs

?????文件????????723??2018-04-01?07:08??StudentManagementSystem\src\test\java\test\TestCase.java

?????文件????????733??2018-04-01?07:08??StudentManagementSystem\src\main\java\tag\DateTag.java

?????文件???????1925??2018-04-01?08:43??StudentManagementSystem\src\main\java\util\DBUtils.java

?????文件???????4703??2018-04-01?08:52??StudentManagementSystem\src\main\java\web\ActionServlet.java

?????文件???????2733??2018-03-19?12:08??StudentManagementSystem\src\main\java\web\CheckcodeServlet.java

?????文件???????2986??2018-04-01?08:44??StudentManagementSystem\src\main\java\dao\UserDAO.java

?????文件????????843??2018-04-01?07:08??StudentManagementSystem\src\main\java\entity\User.java

?????文件????????143??2018-04-01?08:35??StudentManagementSystem\src\main\resources\jdbc.properties

?????文件???????8915??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\css\style.css

?????文件??????17920??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\Thumbs.db

?????文件????????446??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\bg.gif

?????文件????????182??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\bullet_green.gif

?????文件????????128??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\bullet_grey.gif

?????文件????????104??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\button.gif

?????文件????????143??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\content_bg.gif

?????文件???????2139??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\footer.gif

?????文件????????439??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\footer_bg.gif

?????文件??????12364??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\nane.gif

?????文件???????1293??2018-04-01?07:06??StudentManagementSystem\src\main\webapp\img\tableheader-bg-grey.gif

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