package?dao;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?database.dbhelp;
import?java.sql.Connection;
import?model.user;

public?class?userdao?{
	//?添加用戶
	public?boolean?adduser（user?iuser）?{
		Connection?conn?=?null;
		PreparedStatement?ptmt?=?null;
		String?sql?=?“insert?into?user（idnamesexpassword）?values（????）;“;
		user?iuserz?=?new?user（）;
		iuserz?=?seeuser（iuser.getId（））;
		System.out.println（iuserz）;
		if?（iuserz.getName（）?!=?null）?{
			return?false;
		}?else?{
			try?{
				conn?=?dbhelp.getConnection（）;
				ptmt?=?conn.prepareStatement（sql）;
				ptmt.setInt（1?iuser.getId（））;
				ptmt.setString（2?iuser.getName（））;
				ptmt.setString（3?iuser.getSex（））;
				ptmt.setString（4?iuser.getPassword（））;
				ptmt.execute（）;
			}?catch?（Exception?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
			return?true;
		}
	}

	//?修改用戶
	public?boolean?updateuser（user?iuser）?{
		Connection?conn?=?null;
		PreparedStatement?ptmt?=?null;
		String?sql?=?“update?user?set?name=?sex=?password=??where?id=?“;
		user?iuserz?=?new?user（）;
		iuserz?=?seeuser（iuser.getId（））;
		System.out.println（iuserz）;
		if?（iuserz.getName（）?==?null）?{
			return?false;
		}?else?{
			try?{
				conn?=?dbhelp.getConnection（）;
				ptmt?=?conn.prepareStatement（sql）;
				ptmt.setString（1?iuser.getName（））;
				ptmt.setString（2?iuser.getSex（））;
				ptmt.setString（3?iuser.getPassword（））;
				ptmt.setInt（4?iuser.getId（））;
				ptmt.execute（）;
			}?catch?（Exception?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
			return?true;
		}
	}

	//?刪除用戶
	public?boolean?deleteuser（int?id）?{
		Connection?conn?=?null;
		PreparedStatement?ptmt?=?null;
		String?sql?=?“delete?from?user?where?id=?“;
		user?iuserz?=?new?user（）;
		iuserz?=?seeuser（id）;
		System.out.println（iuserz）;
		if?（iuserz.getName（）?==?null）?{
			return?false;
		}?else?{
			try?{
				conn?=?dbhelp.getConnection（）;
				ptmt?=?conn.prepareStatement（sql）;
				ptmt.setInt（1?id）;
				ptmt.execute（）;
			}?catch?（Exception?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
			return?true;
		}
	}

	//?查詢用戶
	public?user?seeuser（int?id）?{
		Connection?conn?=?null;
		PreparedStatement?ptmt?=?null;
		ResultSet?rs?=?null;
		user?iuser?=?new?user（）;
		String?sql?=?“select?*?from?user?where?id=?“;
		try?{
			conn?=?dbhelp.getConnection（）;
			ptmt?=?conn.prepareStatement（sql）;
			ptmt.setInt（1?id）;
			rs?=?ptmt.executeQuery（）;
			while?（rs.next（））?{
				iuser.setId（rs.getInt（“id“））;
				iuser.setName（rs.getString（“name“））;
				iuser.setSex（rs.getString（“sex“））;
				iuser.setPassword（rs.getString（“password“））;
			}
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?iuser;
	}
}

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

?????文件???????1572??2018-01-07?16:30??select_course\.classpath

?????文件????????913??2018-01-10?17:42??select_course\.project

?????文件????????567??2018-01-07?15:05??select_course\.settings\.jsdtscope

?????文件????????364??2018-01-07?15:05??select_course\.settings\org.eclipse.jdt.core.prefs

?????文件????????491??2018-01-10?17:42??select_course\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-01-07?15:05??select_course\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-01-07?15:05??select_course\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-01-07?15:05??select_course\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3134??2018-01-10?17:53??select_course\build\classes\dao\userdao.class

?????文件???????1630??2018-01-10?17:53??select_course\build\classes\database\dbhelp.class

?????文件???????1621??2018-01-10?17:53??select_course\build\classes\model\user.class

?????文件???????3363??2018-01-10?17:53??select_course\build\classes\servlet\userservlet.class

?????文件???????2977??2018-01-10?16:44??select_course\src\dao\userdao.java

?????文件???????1245??2018-01-10?17:41??select_course\src\database\dbhelp.java

?????文件????????928??2018-01-07?15:10??select_course\src\model\user.java

?????文件???????3158??2018-01-10?16:35??select_course\src\servlet\userservlet.java

?????文件?????154142??2017-10-19?16:41??select_course\WebContent\dist\css\flat-ui.css

?????文件?????355583??2017-02-21?12:29??select_course\WebContent\dist\css\flat-ui.css.map

?????文件?????130867??2017-02-21?12:29??select_course\WebContent\dist\css\flat-ui.min.css

?????文件?????109578??2017-10-19?16:36??select_course\WebContent\dist\css\vendor\bootstrap\css\bootstrap.min.css

?????文件??????20127??2017-02-21?12:29??select_course\WebContent\dist\css\vendor\bootstrap\fonts\glyphicons-halflings-regular.eot

?????文件?????108738??2017-02-21?12:29??select_course\WebContent\dist\css\vendor\bootstrap\fonts\glyphicons-halflings-regular.svg

?????文件??????45404??2017-02-21?12:29??select_course\WebContent\dist\css\vendor\bootstrap\fonts\glyphicons-halflings-regular.ttf

?????文件??????23424??2017-02-21?12:29??select_course\WebContent\dist\css\vendor\bootstrap\fonts\glyphicons-halflings-regular.woff

?????文件??????18028??2017-02-21?12:29??select_course\WebContent\dist\css\vendor\bootstrap\fonts\glyphicons-halflings-regular.woff2

?????文件??????25912??2017-02-21?12:29??select_course\WebContent\dist\fonts\glyphicons\flat-ui-icons-regular.eot

?????文件??????57135??2017-02-21?12:29??select_course\WebContent\dist\fonts\glyphicons\flat-ui-icons-regular.svg

?????文件??????25708??2017-02-21?12:29??select_course\WebContent\dist\fonts\glyphicons\flat-ui-icons-regular.ttf

?????文件??????17844??2017-02-21?12:29??select_course\WebContent\dist\fonts\glyphicons\flat-ui-icons-regular.woff

?????文件??????81604??2017-02-21?12:29??select_course\WebContent\dist\fonts\glyphicons\selection.json

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