package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

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

import?com.dao.DB;
import?com.orm.TAdmin;

public?class?admin_servlet?extends?HttpServlet
{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
		
		if（type.endsWith（“adminMana“））
		{
			adminMana（req?res）;
		}
		if（type.endsWith（“adminAdd“））
		{
			adminAdd（req?res）;
		}
		if（type.endsWith（“adminDel“））
		{
			adminDel（req?res）;
		}
	}
	
	public?void?adminMana（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		List?adminList=new?ArrayList（）;
		String?sql=“select?*?from?t_admin“;
		object[]?params={};
		DB?mydb=new?DB（）;
		try
		{
			mydb.doPstm（sql?params）;
			ResultSet?rs=mydb.getRs（）;
			while（rs.next（））
			{
				TAdmin?admin=new?TAdmin（）;
				admin.setUserId（rs.getInt（“userId“））;
				admin.setUserName（rs.getString（“userName“））;
				admin.setUserPw（rs.getString（“userPw“））;
				admin.setRole（rs.getString（“role“））;

				adminList.add（admin）;
		????}
			rs.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		mydb.closed（）;
		
		req.setAttribute（“adminList“?adminList）;
		req.getRequestDispatcher（“admin/admin/adminMana.jsp“）.forward（req?res）;
	}
	public?void?adminAdd（HttpServletRequest?reqHttpServletResponse?res）
	{
		String?userName=req.getParameter（“userName“）;
		String?userPw=req.getParameter（“userPw“）;
		String?role=“1“;

		String?sql=“insert?into?t_admin?values（???）“;
		object[]?params={userNameuserPwrole};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“admin?type=adminMana“）;
		
????????String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
	}
	
	public?void?adminDel（HttpServletRequest?reqHttpServletResponse?res）
	{
		System.out.println（req.getParameter（“userId“）+“**“）;
		String?sql=“delete?from?t_admin?where?userId=“+Integer.parseInt（req.getParameter（“userId“））;
		object[]?params={};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“admin?type=adminMana“）;
		
????????String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
	}

	public?void?dispatch（String?targetURIHttpServletRequest?requestHttpServletResponse?response）?
	{
		RequestDispatcher?dispatch?=?getServletContext（）.getRequestDispatcher（targetURI）;
		try?
		{
		????dispatch.forward（request?response）;
		????return;
		}?
		catch?（Serv

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-08-30?08:25??數(shù)據(jù)庫(kù)\
?????文件?????1179648??2011-06-08?16:33??數(shù)據(jù)庫(kù)\db_stuxinxi_Data.MDF
?????文件?????1048576??2011-06-08?16:33??數(shù)據(jù)庫(kù)\db_stuxinxi_Log.LDF
?????文件?????1370112??2012-09-26?10:40??新生報(bào)到系統(tǒng).doc
?????目錄???????????0??2012-08-30?08:25??源程序\
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\
?????文件????????1451??2011-05-13?15:01??源程序\stuxinxi\.classpath
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\.myeclipse\
?????文件?????????297??2011-06-04?10:50??源程序\stuxinxi\.mymetadata
?????文件????????1414??2011-06-04?10:55??源程序\stuxinxi\.project
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\.settings\
?????文件?????????500??2011-06-04?10:55??源程序\stuxinxi\.settings\.jsdtscope
?????文件??????????49??2011-06-04?10:55??源程序\stuxinxi\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-06-04?10:55??源程序\stuxinxi\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\src\
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\src\com\
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\src\com\action\
?????文件????????3292??2011-06-07?01:47??源程序\stuxinxi\src\com\action\admin_servlet.java
?????文件????????4004??2011-06-07?09:22??源程序\stuxinxi\src\com\action\banji_servlet.java
?????文件????????5785??2011-06-06?04:56??源程序\stuxinxi\src\com\action\chengji_servlet.java
?????文件????????3164??2011-03-19?01:08??源程序\stuxinxi\src\com\action\jiaoshi_servlet.java
?????文件????????6297??2011-06-07?03:47??源程序\stuxinxi\src\com\action\kecheng_servlet.java
?????文件???????10324??2011-06-07?14:44??源程序\stuxinxi\src\com\action\stu_servlet.java
?????文件????????5583??2011-06-07?01:22??源程序\stuxinxi\src\com\action\tea_servlet.java
?????文件????????4924??2011-06-07?03:58??源程序\stuxinxi\src\com\action\tonggao_servlet.java
?????文件????????4341??2011-06-05?04:47??源程序\stuxinxi\src\com\action\xuefei_servlet.java
?????文件????????3883??2011-06-05?03:16??源程序\stuxinxi\src\com\action\zhuanye_servlet.java
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\src\com\dao\
?????文件????????2116??2011-06-04?10:59??源程序\stuxinxi\src\com\dao\DB.java
?????目錄???????????0??2012-08-30?08:25??源程序\stuxinxi\src\com\orm\
?????文件?????????670??2011-06-06?12:38??源程序\stuxinxi\src\com\orm\TAdmin.java
............此處省略958個(gè)文件信息