package?com.hly.jsp.javaWeb.controller;

import?com.hly.jsp.javaWeb.dao.EmployeeDao;
import?com.hly.jsp.javaWeb.entity.Employee;
import?com.hly.jsp.javaWeb.impl.EmployeeDaoImpl;

import?javax.servlet.ServletException;
import?javax.servlet.annotation.WebServlet;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?java.io.IOException;
import?java.lang.reflect.Method;
import?java.util.List;
/**
?*?@author?:hly
?*?@github?:https://github.com/huangliangyun
?*?@blog?:blog.csdn.net/Sirius_hly
?*?@date?:2018/11/28
?*/

@WebServlet（urlPatterns?=?{?“*.do“?}）
public?class?EmployeeServlet?extends?HttpServlet?{

????public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?IOException?ServletException?{
????????response.setContentType（“text/html;charset=UTF-8“）;
????????doGet（request?response）;
????}

????public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?{
????????response.setContentType（“text/html;charset=utf-8“）;
????????String?url?=?request.getRequestURI（）;
????????String?methodName?=?url.substring（url.lastIndexOf（“/“）+1?url.lastIndexOf（“.“））;
????????Method?method?=?null;
????????try?{
????????????//?使用反射機制獲取在本類中聲明了的方法
????????????method?=?getClass（）.getDeclaredMethod（methodName?HttpServletRequest.class?HttpServletResponse.class）;
????????????//?執行方法
????????????method.invoke（this?request?response）;
????????}?catch?（Exception?e）?{
????????????throw?new?RuntimeException（“調用方法出錯“）;
????????}
????}

????//增加
????public?void?addEmp（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
????????Employee?employee?=?new?Employee（）;
????????employee.setName（request.getParameter（“addName“））;
????????employee.setNote（request.getParameter（“addNote“））;
????????EmployeeDao?employeeDao?=?new?EmployeeDaoImpl（）;
????????employeeDao.add（employee）;
????????selectAllEmp（requestresponse）;
????}

????//查找全部
????public?void?selectAllEmp（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
????????EmployeeDao?employeeDao?=?new?EmployeeDaoImpl（）;
????????List?list?=?employeeDao.selectAll（）;
????????request.setAttribute（“list“?list）;
????????request.getRequestDispatcher（“/javaWeb/manage/main.jsp“）.forward（request?response）;
????}

????//模糊查詢
????public?void?selectByEmpName（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
????????String?name?=?request.getParameter（“selectName“）;
????????EmployeeDao?employeeDao?=?new?EmployeeDaoImpl（）;
????????List?list?=?employeeDao.query（name）;
????????System.err.println（“list：“+list）;
????????request.setAttribute（“list“?list）;
????????request.getRequestDispatcher（“/javaWeb/manage/main.jsp“）.forward（request?response）;
????}

????//更新數據
????public?void?updateEmp（HttpServletReq

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-29?22:14??controller\
?????文件????????3969??2018-11-29?20:19??controller\EmployeeServlet.java
?????目錄???????????0??2018-11-29?22:14??dao\
?????文件????????1833??2018-11-29?19:26??dao\DBConnection.java
?????文件?????????513??2018-11-29?20:02??dao\EmployeeDao.java
?????目錄???????????0??2018-11-29?22:14??entity\
?????文件?????????927??2018-11-29?20:06??entity\Employee.java
?????目錄???????????0??2018-11-29?22:14??impl\
?????文件????????4009??2018-11-29?20:23??impl\EmployeeDaoImpl.java
?????目錄???????????0??2018-11-29?22:14??javaWeb\
?????目錄???????????0??2018-11-29?22:14??javaWeb\manage\
?????文件????????1781??2018-11-29?21:33??javaWeb\manage\main.jsp