package?com.wang.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.wang.db.DBManager;

/**
?*?添加管理員信息
?*/
public?class?AddAdminAction?extends?HttpServlet?{
??
	private?static?final?long?serialVersionUID?=?1L;
????public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		response.setContentType（“text/html;utf-8“）;
		PrintWriter?out?=?response.getWriter（）;
		String?name=request.getParameter（“name“）;
		String?pwd=request.getParameter（“pwd“）;
		
		//1.連接數(shù)據(jù)庫
		DBManager?dbm?=?new?DBManager（）;
		//2.插入管理員信息表
		String?sql?=?“insert?into?admin（userNameuserPw）??values（‘“+name+“‘‘“+pwd+“‘）“;

		Statement?stat?=?null;
		Connection?conn=null;
		try?{
			conn=dbm.getConnection（）;
			stat?=?conn.createStatement（）;
			System.out.println（sql）;
			stat.execute（sql）;
		}?catch?（SQLException?e）?{
			?
			e.printStackTrace（）;
		}?finally?{
			try?{
				if（stat!=null）
					stat.close（）;
				if（conn!=null）
					conn.close（）;
			}?catch?（SQLException?e）?{
				?
				e.printStackTrace（）;
			}
		}
		//3.成功向數(shù)據(jù)庫中插入元素后，重新跳轉(zhuǎn)到admin/list.jsp頁面	
		response.sendRedirect（“admin/list.jsp“）;
		out.flush（）;
		out.close（）;
	}
?
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-11?11:19??tcc\
?????文件?????????586??2017-11-22?13:06??tcc\.classpath
?????文件?????????903??2017-11-22?13:45??tcc\.project
?????目錄???????????0??2017-12-21?13:06??tcc\.settings\
?????文件?????????567??2017-11-22?13:06??tcc\.settings\.jsdtscope
?????文件??????????72??2017-11-28?13:48??tcc\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-11-22?13:06??tcc\.settings\org.eclipse.jdt.core.prefs
?????文件?????????461??2017-11-22?13:45??tcc\.settings\org.eclipse.wst.common.component
?????文件?????????305??2017-11-22?13:06??tcc\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-11-22?13:06??tcc\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-11-22?13:06??tcc\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????95??2017-11-22?13:45??tcc\.settings\org.jboss.ide.eclipse.as.core.prefs
?????文件?????????162??2017-11-22?13:22??tcc\.tern-project
?????目錄???????????0??2017-12-21?13:06??tcc\build\
?????目錄???????????0??2017-12-21?13:06??tcc\build\classes\
?????目錄???????????0??2017-12-21?13:06??tcc\build\classes\com\
?????目錄???????????0??2017-12-21?13:06??tcc\build\classes\com\wang\
?????目錄???????????0??2017-12-21?13:06??tcc\build\classes\com\wang\action\
?????文件????????2483??2017-12-21?12:57??tcc\build\classes\com\wang\action\AddAdminAction.class
?????文件????????3122??2017-12-21?12:57??tcc\build\classes\com\wang\action\AddCfeiAction.class
?????文件????????2932??2017-12-21?12:57??tcc\build\classes\com\wang\action\AddCheAction.class
?????文件????????2611??2017-12-21?12:57??tcc\build\classes\com\wang\action\AddCheweiAction.class
?????文件????????2587??2017-12-21?12:57??tcc\build\classes\com\wang\action\AddUserinfoAction.class
?????文件????????2494??2017-12-21?12:57??tcc\build\classes\com\wang\action\ChongAction.class
?????文件????????2279??2017-12-21?12:57??tcc\build\classes\com\wang\action\DelAdminAction.class
?????文件????????2210??2017-12-21?12:57??tcc\build\classes\com\wang\action\DelCfeiAction.class
?????文件????????2269??2017-12-21?12:57??tcc\build\classes\com\wang\action\DelCheAction.class
?????文件????????2220??2017-12-21?12:57??tcc\build\classes\com\wang\action\DelCheweiAction.class
?????文件????????2230??2017-12-21?12:57??tcc\build\classes\com\wang\action\DelUserinfoAction.class
?????文件????????2467??2017-12-21?12:57??tcc\build\classes\com\wang\action\LoginAction.class
?????文件????????2449??2017-12-21?12:57??tcc\build\classes\com\wang\action\ModAdminAction.class
............此處省略390個文件信息