package?action;

import?model.Emp;
import?model.Page;
import?util.Dblink;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?java.io.IOException;
import?java.io.UnsupportedEncodingException;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

public?class?EmpAction?extends?HttpServlet?{

????public?void?service（HttpServletRequest?request?HttpServletResponse?response）?throws?UnsupportedEncodingException?{
????????request.setCharacterEncoding（“UTF-8“）;
????????response.setContentType（“text/html;charset=UTF-8“）;

????????String?url?=?request.getRequestURI（）;//獲取action?的url
????????//substring（xy）是從x到y截取字符串?lastIndexOf是從字符串中找到這個子字符串出現的最后位置
????????url?=?url.substring（url.lastIndexOf（“/“）url.lastIndexOf（“.“））;
????????if?（url.equals（“/reg“））{
????????????try?{
????????????????if?（reg（responserequest）>0）{
????????????????????response.sendRedirect（“index.jsp“）;
????????????????}else?{
????????????????????response.sendRedirect（“my.jsp“）;
????????????????}
????????????}?catch?（SQLException?|?ClassNotFoundException?|?IOException?e）?{
????????????????e.printStackTrace（）;

????????????}
????????}else?if?（url.equals（“/so“））{
????????????String?currentPage?=?request.getParameter（“currentPage“）;
????????????if?（currentPage==null||currentPage==““）{
????????????????currentPage=“1“;
????????????}

????????????int?current?=?Integer.parseInt（currentPage）;
????????????try?{
????????????????ArrayList?allEmp?=?getArr（）;
????????????????int?countPa?=?allEmp.size（）;
????????????????int?pageNum?=?5;
????????????????ArrayList?currentEmp?=?getEmpPage（currentpageNum）;
????????????????Page?page?=?new?Page（）;
????????????????page.setCountPage（countPa）;
????????????????page.setCurrentPage（current）;
????????????????page.setPageNum（pageNum）;
????????????????page.setList（currentEmp）;

????????????????request.setAttribute（“ps“page）;
????????????????request.getRequestDispatcher（“list.jsp“）.forward（requestresponse）;
????????????}?catch?（SQLException?|?ServletException?|?IOException?|?ClassNotFoundException?e）?{
????????????????e.printStackTrace（）;
????????????}
????????}else?if?（url.equals（“/del“））{
????????????String?id?=?request.getParameter（“id“）;
????????????try?{
????????????????int?result?=??deleteUser（Integer.parseInt（id））;
????????????????if?（result>0）{
????????????????????response.sendRedirect（“so.do“）;
????????????????}
????????????}?catch?（SQLException?|?ClassNotFoundException?|?IOException?e）?{
????????????????e.printStackTrace（）;
????????????}
????????}else?if?（url.equals（“/Add“））{
????????????try?{
????????????????addDo（requestresponse）;
????????????}?catch?（SQLException?|?ClassNotFoundException?|?ServletException?|?IOException?e）?{
????????????????e.printSt

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-04-19?10:38??myweb01\
?????目錄???????????0??2020-04-20?21:53??myweb01\.idea\
?????文件?????????540??2020-04-20?09:48??myweb01\.idea\compiler.xml
?????目錄???????????0??2020-04-19?10:49??myweb01\.idea\inspectionProfiles\
?????文件?????????813??2020-04-19?10:49??myweb01\.idea\inspectionProfiles\Project_Default.xml
?????文件?????????660??2020-04-19?10:25??myweb01\.idea\misc.xml
?????文件???????12688??2020-04-20?21:53??myweb01\.idea\workspace.xml
?????文件??????????81??2020-04-19?10:24??myweb01\myweb01.iml
?????文件????????2718??2020-04-19?10:38??myweb01\pom.xml
?????目錄???????????0??2020-04-19?10:24??myweb01\src\
?????目錄???????????0??2020-04-19?10:41??myweb01\src\main\
?????目錄???????????0??2020-04-19?10:46??myweb01\src\main\java\
?????目錄???????????0??2020-04-20?21:49??myweb01\src\main\java\action\
?????文件????????8268??2020-04-20?21:49??myweb01\src\main\java\action\EmpAction.java
?????目錄???????????0??2020-04-20?10:42??myweb01\src\main\java\model\
?????文件?????????514??2020-04-19?10:42??myweb01\src\main\java\model\Emp.java
?????文件????????1094??2020-04-20?10:42??myweb01\src\main\java\model\Page.java
?????目錄???????????0??2020-04-19?10:49??myweb01\src\main\java\util\
?????文件?????????386??2020-04-19?10:49??myweb01\src\main\java\util\Dblink.java
?????目錄???????????0??2020-04-20?14:59??myweb01\src\main\webapp\
?????目錄???????????0??2020-04-19?10:43??myweb01\src\main\webapp\WEB-INF\
?????文件?????????443??2020-04-19?10:43??myweb01\src\main\webapp\WEB-INF\web.xml
?????文件?????????495??2020-04-20?11:30??myweb01\src\main\webapp\add.jsp
?????文件??????????52??2020-04-19?10:24??myweb01\src\main\webapp\index.jsp
?????文件????????2353??2020-04-20?11:30??myweb01\src\main\webapp\list.jsp
?????文件?????????706??2020-04-20?14:59??myweb01\src\main\webapp\updata.jsp
?????目錄???????????0??2020-04-20?14:59??myweb01\target\
?????目錄???????????0??2020-04-20?14:54??myweb01\target\classes\
?????目錄???????????0??2020-04-20?14:54??myweb01\target\classes\action\
?????文件????????6673??2020-04-20?14:54??myweb01\target\classes\action\EmpAction.class
?????目錄???????????0??2020-04-20?10:53??myweb01\target\classes\model\
............此處省略29個文件信息