package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Date;
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）;
		}
		if?（type.endsWith（“toupdate1“））?
		{

			toupdate1（req?res）;
		}
		if（type.endsWith（“adminedit“））
		{
			adminedit（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“））;
				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?toupdate1（HttpServletRequest?req?HttpServletResponse?res）
			throws?ServletException?IOException?{
			
				String?id=req.getParameter（“id“）;
				TAdmin?admin=new?TAdmin（）;


				String?sql=“select?*?from?t_admin?where?userId=?“;
				object[]?params={id};
				DB?mydb=new?DB（）;
				try
				{
					mydb.doPstm（sql?params）;
					ResultSet?rs=mydb.getRs（）;
					rs.next（）;
					admin.setUserId（rs.getInt（“userId“））;

					admin.setUserName（rs.getString（“userName“））;
					admin.setUserPw（rs.getString（“userPw“））;
					
					rs.close（）;
				}
				catch（Exception?e）
				{
					e.printStackTrace（）;
				}
				mydb.closed（）;
				
				req.setAttribute（“datas“?admin）;
				
				
				req.getRequestDispatcher（“/admin/admin/adminedit.jsp“）.forward（req?res）;
			}
	//修改
public?void?adminedit（HttpServletRequest?req?HttpServletResponse?res）?{
		
		String?userId=req.getParameter（“id“）;
	
		String?userName=req.getParameter（“userName“）;
		String?userPw=req.getParameter（“userPw“）;
		String?sql?=?“update?t_admin?set?userName=?userPw=??where?userId=?“;

		object[]?params?=?{userNameuserPwuserId};

		DB?mydb?=?new?DB（）;
		mydb.d