package?com.iss.service;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?com.nuoxin.pojo.Users;
import?com.nuoxin.util.DBConnection;

public?class?UserService?{

	//?修改用戶
	public?static?void?updateUser（Users?user）?{
		String?sql?=?“update?users?set?name=‘“?+?user.getName（）?+?“‘sex=‘“
				+?user.getSex（）?+?“‘age=‘“?+?user.getAge（）?+?“‘?where?id=“
				+?user.getId（）?+?““;

		try?{
			Statement?statement?=?DBConnection.getStatement（）;
			statement.executeUpdate（sql）;
			DBConnection.close（）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

	}

	//?刪除用戶
	public?static?void?deleteUser（Users?users）?{
		String?sql?=?“delete?from?users?where?id=“?+?users.getId（）?+?““;
		try?{
			DBConnection.getStatement（）.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

		DBConnection.close（）;
	}

	//?添加用戶

	public?static?void?addUser（Users?user）?{
		String?sql?=?“insert?into?users?values（null‘“?+?user.getName（）?+?“‘‘“
				+?user.getSex（）?+?“‘‘“?+?user.getAge（）?+?“‘）“;
		try?{
			DBConnection.getStatement（）.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		DBConnection.close（）;
	}

	public?static?Users?getUser（int?id）?{
		String?sql?=?“select?*?from?users?where?id=“?+?id;
		Users?user?=?null;
		ResultSet?resultSet?=?DBConnection.getResultSet（sql）;

		try?{
			while?（resultSet.next（））?{
				user?=?new?Users（）;
				user.setId（resultSet.getInt（“id“））;
				user.setName（resultSet.getString（“name“））;
				user.setAge（resultSet.getString（“sex“））;
				user.setSex（resultSet.getString（“age“））;

			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?user;

	}

}

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

?????文件????????529??2014-11-27?16:25??extjs02\.classpath

?????文件????????294??2014-11-13?14:34??extjs02\.mymetadata

?????文件???????1750??2014-11-13?14:37??extjs02\.project

?????文件????????500??2014-11-13?14:34??extjs02\.settings\.jsdtscope

?????文件????????106??2014-11-19?15:29??extjs02\.settings\org.eclipse.core.resources.prefs

?????文件????????401??2014-11-13?14:34??extjs02\.settings\org.eclipse.jdt.core.prefs

?????文件????????459??2014-11-13?14:34??extjs02\.settings\org.eclipse.wst.common.component

?????文件????????252??2014-11-13?14:34??extjs02\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-11-13?14:34??extjs02\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-11-13?14:34??extjs02\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1937??2014-12-01?11:29??extjs02\src\com\iss\service\UserService.java

?????文件????????704??2014-11-19?16:08??extjs02\src\com\nuoxin\pojo\Employee.java

?????文件????????803??2014-11-21?10:28??extjs02\src\com\nuoxin\pojo\Student.java

?????文件????????450??2014-11-13?15:51??extjs02\src\com\nuoxin\pojo\User.java

?????文件????????906??2014-12-01?11:21??extjs02\src\com\nuoxin\pojo\Users.java

?????文件???????1190??2014-11-28?16:29??extjs02\src\com\nuoxin\servlet\AddUserServlet.java

?????文件???????1821??2014-11-24?16:49??extjs02\src\com\nuoxin\servlet\DeleteServlet.java

?????文件???????1304??2014-11-28?15:07??extjs02\src\com\nuoxin\servlet\DeleteUserServlet.java

?????文件???????1312??2014-12-01?11:22??extjs02\src\com\nuoxin\servlet\GetUserServlet.java

?????文件???????3146??2014-11-28?13:50??extjs02\src\com\nuoxin\servlet\GetUsersServlet.java

?????文件???????2092??2014-11-21?14:23??extjs02\src\com\nuoxin\servlet\GridServlet.java

?????文件???????1134??2014-11-13?16:37??extjs02\src\com\nuoxin\servlet\LoginServlet.java

?????文件???????1471??2014-11-20?10:02??extjs02\src\com\nuoxin\servlet\RegisterServlet.java

?????文件???????1192??2014-12-01?11:30??extjs02\src\com\nuoxin\servlet\UpdateUserServlet.java

?????文件???????1241??2014-11-20?10:15??extjs02\src\com\nuoxin\servlet\UploadServlet.java

?????文件???????2279??2014-11-28?15:14??extjs02\src\com\nuoxin\util\DBConnection.java

?????文件???????2225??2014-11-27?10:36??extjs02\WebRoot\card.jsp

?????文件???????1922??2011-05-14?09:40??extjs02\WebRoot\css\common.css

?????文件???????2027??2011-04-17?11:01??extjs02\WebRoot\css\icon.css

?????文件????????714??2011-04-04?15:16??extjs02\WebRoot\css\loading.css

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