userServlet

package servlet;

import entity.User;
import java.util.*;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import dao.Jdbchelper;

public class UserServlet extends HttpServlet {
    private Jdbchelper jdbc=new Jdbchelper();
    public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");

        String method=request.getParameter("method");
        //登录
        if(method.equals("login")){
            login(request,response);
        }
        else if(method.equals("list")){
            list(request,response);
        }

        else if(method.equals("add")){
            add(request,response);
        }
        else if(method.equals("edit")){
            edit(request,response);
        }
        else if(method.equals("update")){
            update(request,response);
        }
        else if(method.equals("del")){
            del(request,response);
        }

        else if(method.equals("delRows")){
            delRows(request,response);
        }
        else if(method.equals("loginout")){
            loginout(request,response);
        }


    }

    public void loginout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

            HttpSession session=request.getSession();
            session.setAttribute("login_id",null);
            session.setAttribute("login_no",null);
            session.setAttribute("login_name",null);

            //request.setAttribute("status","用户名或密码错误");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);


    }

    public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        String no=request.getParameter("no");
        String pass=request.getParameter("pass");

        if(no.equals("") || pass.equals("")){
            request.setAttribute("status","用户名和密码不能为空");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }
        String sql="select * from user where no=? and pass=?";
        Map<String,Object> map=jdbc.findOne(sql,no,pass);
        if(map.size()>0){ //说明有
            HttpSession session=request.getSession();
            session.setAttribute("login_id",map.get("id"));
            session.setAttribute("login_no",map.get("no"));
            session.setAttribute("login_name",map.get("name"));

            String login_no=map.get("no").toString();
            if("admin".equals(login_no)){
                request.setAttribute("status","登录成功!");
                //request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
                response.sendRedirect(request.getContextPath()+"/userServlet?method=list");
            }
            else{
                request.setAttribute("status","登录成功!");
                //request.getRequestDispatcher("/userclassServlet?method=selfClassList").forward(request,response);
                response.sendRedirect(request.getContextPath()+"/userclassServlet?method=selfClassList");
            }
        }
        else{
            request.setAttribute("status","用户名或密码错误");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

    }


    public void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

        String nameQuery=request.getParameter("nameQuery");
        //id no pass name
        List<Map<String,Object>> list1=new ArrayList<Map<String,Object>>();
        String sql="select * from user where 1=1 ";
        if(!"".equals(nameQuery) && null!=nameQuery){
            sql+=" and name like ?";
            list1=jdbc.findList(sql,'%'+nameQuery+'%');
        }
        else{
            list1=jdbc.findList(sql);
        }


        //request.setAttribute("status","查询成功!");
        request.setAttribute("list",list1);
        request.getRequestDispatcher("jsp/user/list.jsp").forward(request,response);

    }


    public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

        String no=request.getParameter("no");
        String pass=request.getParameter("pass");
        String name=request.getParameter("name");
        //id no pass name
        if(no==null || "".equals(no) || pass==null || "".equals(pass) || name==null || "".equals(name)){
            request.setAttribute("status","编号、密码、姓名不能为空!");
            request.getRequestDispatcher("jsp/user/add.jsp").forward(request,response);
        }
        else{
            String sql="insert into user(no,pass,name) values(?,?,?)";
            int reesult=jdbc.executeSave(sql,no,pass,name);
            if(reesult>0){
                request.setAttribute("status","保存成功!");
                request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
            }
            else{
                request.setAttribute("status","保存失败!");
                request.getRequestDispatcher("jsp/user/add.jsp").forward(request,response);
            }
        }

    }


    public void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }
        String id=request.getParameter("id");
        String sql="select * from user where id=?";
        Map<String,Object> map=jdbc.findOne(sql,id);
        if(map.size()>0){ //说明有
            User u=new User();
            u.setId(Integer.valueOf(map.get("id").toString()));
            u.setNo(map.get("no").toString());
            u.setPass(map.get("pass").toString());
            u.setName(map.get("name").toString());

            request.setAttribute("status","查询成功!");
            request.setAttribute("info",u);
            request.getRequestDispatcher("jsp/user/edit.jsp").forward(request,response);
        }
        else{
            request.setAttribute("status","查找失败");
            request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
        }

    }


    public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

        String id=request.getParameter("id");
        String pass=request.getParameter("pass");
        String name=request.getParameter("name");
        //id no pass name

        String sql="update user set pass=?,name=? where id=?";
        int reesult=jdbc.executeSave(sql,pass,name,id);
        if(reesult>0){
            request.setAttribute("status","修改成功!");
            request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
        }
        else{
            request.setAttribute("status","修改失败!");
            request.getRequestDispatcher("/userServlet?method=edit&id="+id).forward(request,response);
        }
    }

    public void del(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

        String id=request.getParameter("id");
        //id no pass name
        if(id=="3" || id.equals("3")){
            request.setAttribute("status","管理员不允许删除!");
            request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
        }
        else{
            String sql="delete from user where id=?";
            int reesult=jdbc.executeSave(sql,id);
            if(reesult>0){
                request.setAttribute("status","删除成功!");
                request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
                //response.sendRedirect("/userServlet?method=list");
            }
            else{
                request.setAttribute("status","删除失败!");
                request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
            }
        }

    }


    public void delRows(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if(session.getAttribute("login_id")==null){
            request.setAttribute("status","登录过期，请重新登录！");
            request.getRequestDispatcher("jsp/user/login.jsp").forward(request,response);
        }

        String[] delid=request.getParameterValues("pks");
        if(delid==null){
            request.setAttribute("status","请选择一条记录!");
            //response.sendRedirect("/userServlet?method=list");
            request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
        }
        else{
            String sql="delete from user where id=?";
            int reesult=0;
            for(int i=0;i<delid.length;i++){
                reesult=jdbc.executeSave(sql,delid[i]);
            }
            if(reesult>0){
                request.setAttribute("status","删除成功!");
                request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
            }
            else{
                request.setAttribute("status","删除失败!");
                request.getRequestDispatcher("/userServlet?method=list").forward(request,response);
            }
        }

    }
}