package?com.biyeseng.action;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.*;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.biyeseng.db.DBManager;

/**
?*?添加管理員
?*?@author?win7
?*
?*/
public?class?AddAdminAction?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?AddAdminAction（）?{
		super（）;
	}

	/**
	?*?Destruction?of?the?servlet.?

	?*/
	public?void?destroy（）?{
		super.destroy（）;?//?Just?puts?“destroy“?string?in?log
		//?Put?your?code?here
	}

	/**
	?*?The?doPost?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		response.setContentType（“text/html“）;
		PrintWriter?out?=?response.getWriter（）;
		String?name=request.getParameter（“name“）;
		String?pwd=request.getParameter（“pwd“）;
		String?zhi=request.getParameter（“zhi“）;
		String?tel=request.getParameter（“tel“）;
		String?age=request.getParameter（“age“）;
		
		DBManager?dbm?=?new?DBManager（）;
		//插入管理員信息表
		String?sql?=?“insert?into?admin（userNameuserPwzhitelage）??values（‘“+name+“‘‘“+pwd+“‘‘“+zhi+“‘‘“+tel+“‘‘“+age+“‘）“;

		Statement?stat?=?null;
		Connection?conn=null;
		try?{
			conn=dbm.getConnection（）;
			stat?=?conn.createStatement（）;
			System.out.println（sql）;
			stat.execute（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			try?{
				if（stat!=null）
					stat.close（）;
				if（conn!=null）
					conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		response.sendRedirect（“admin/admin/list.jsp“）;
		out.flush（）;
		out.close（）;
	}

	/**
	?*?Initialization?of?the?servlet.?

	?*
	?*?@throws?ServletException?if?an?error?occurs
	?*/
	public?void?init（）?throws?ServletException?{
		//?Put?your?code?here
	}

}