package?web.hotel.admin;

import?java.io.*;
import?java.sql.*;
import?javax.naming.*;
import?javax.servlet.*;
import?javax.servlet.http.*;
import?javax.sql.DataSource;
import?web.hotel.bean.*;

public?class?AddAdminServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		String?sql?=?“insert?into?admin?（idnamepasswordstatus）?values（????）“;
		int?result?=?0;
		String?message=““;
		request.setCharacterEncoding（“utf-8“）;
		String?id?=?request.getParameter（“id“）;
		String?name?=?request.getParameter（“name“）;
		String?password?=?request.getParameter（“password“）;
		String?status?=?request.getParameter（“status“）;
		if?（StringUtil.validateNull（id））?{
			message=“對不起，工號不能為空，請您重新輸入！
“;
			request.setAttribute（“message“?message）;
			request.getRequestDispatcher（“/admin/adminResult.jsp“）.forward（request?response）;
		}?else?if?（StringUtil.validateNull（“name“））?{
			message=“對不起，姓名不能為空，請您重新輸入！
“;
			request.setAttribute（“message“?message）;
			request.getRequestDispatcher（“/admin/adminResult.jsp“）.forward（request?response）;
		}?else?{
			try?{
				Context?initContext=new?InitialContext（）;
				DataSource?ds=（DataSource）initContext.lookup（“java:/comp/env/jdbc/oracleds“）;
				Connection?conn=ds.getConnection（）;
				
				PreparedStatement?pstmt?=?conn.prepareStatement（sql）;
				pstmt.setString（1?id）;
				pstmt.setString（2?name）;
				pstmt.setString（3?password）;
				pstmt.setString（4?status）;
				result?=?pstmt.executeUpdate（）;
				pstmt.close（）;
				conn.close（）;
			}?catch?（NamingException?e）?{
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
			if?（result?==?0）?{
				message=“添加職工信息不成功“;
				request.setAttribute（“message“?message）;
				request.getRequestDispatcher（“/admin/adminResult.jsp“）.forward（request?response）;
			}?else?{
				message=“成功添加職工信息。
“;
				request.setAttribute（“message“?message）;
				request.getRequestDispatcher（“/admin/adminResult.jsp“）.forward（request?response）;
			}
		}
	}

}

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

?????文件????????362??2010-01-06?14:16??hotel\hotel\.classpath

?????文件????????288??2010-01-07?13:48??hotel\hotel\.mymetadata

?????文件???????1411??2010-01-06?14:48??hotel\hotel\.project

?????文件????????500??2010-01-06?14:16??hotel\hotel\.settings\.jsdtscope

?????文件????????245??2010-01-07?11:28??hotel\hotel\.settings\com.genuitec.eclipse.core.prefs

?????文件????????330??2010-01-06?14:16??hotel\hotel\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-01-06?14:16??hotel\hotel\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-01-06?14:16??hotel\hotel\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2237??2010-01-09?12:58??hotel\hotel\src\web\hotel\admin\AddAdminServlet.java

?????文件???????2167??2010-01-09?09:15??hotel\hotel\src\web\hotel\admin\DeleteAdminServlet.java

?????文件???????2944??2010-01-09?10:22??hotel\hotel\src\web\hotel\admin\UpdateAdminServlet.java

?????文件????????647??2010-01-08?15:07??hotel\hotel\src\web\hotel\bean\Home.java

?????文件????????904??2010-01-08?19:36??hotel\hotel\src\web\hotel\bean\StringUtil.java

?????文件???????4575??2010-01-10?15:19??hotel\hotel\src\web\hotel\bill\AccountBillServlet.java

?????文件???????4313??2010-01-10?10:17??hotel\hotel\src\web\hotel\consum\RecordConsumServlet.java

?????文件???????2391??2010-01-09?09:32??hotel\hotel\src\web\hotel\home\AddHomeServlet.java

?????文件???????2152??2010-01-09?09:09??hotel\hotel\src\web\hotel\home\StopHomeServlet.java

?????文件???????2903??2010-01-09?09:09??hotel\hotel\src\web\hotel\home\UpdateHomeServlet.java

?????文件???????3555??2010-01-09?10:09??hotel\hotel\src\web\hotel\login\LoginHotelServlet.java

?????文件???????5573??2010-01-10?14:10??hotel\hotel\src\web\hotel\person\ChangeHomeServlet.java

?????文件???????3484??2010-01-09?21:46??hotel\hotel\src\web\hotel\person\EnteringServlet.java

?????文件???????3424??2010-01-09?20:09??hotel\hotel\src\web\hotel\person\MakeEnterServlet.java

?????文件???????3146??2010-01-09?16:15??hotel\hotel\src\web\hotel\person\MakeHomeServlet.java

?????文件???????2637??2010-01-09?17:26??hotel\hotel\src\web\hotel\person\QuitHomeServlet.java

?????文件????????848??2010-01-10?13:41??hotel\hotel\WebRoot\account\accountBill.jsp

?????文件????????307??2010-01-10?14:19??hotel\hotel\WebRoot\account\accountResult.jsp

?????文件??????20825??2010-01-06?21:22??hotel\hotel\WebRoot\account\zz.JPG

?????文件???????1435??2010-01-09?09:42??hotel\hotel\WebRoot\admin\addAdmin.jsp

?????文件???????1628??2010-01-09?09:04??hotel\hotel\WebRoot\admin\adminMessage.jsp

?????文件????????496??2010-01-09?09:18??hotel\hotel\WebRoot\admin\adminResult.jsp

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