代码

package com.test.controller;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.test.po.Dept;
import com.test.po.Emp;
import com.test.service.DeptService;
import com.test.service.EmpService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.bind.annotation.SessionAttributes;
import org.springframework.web.context.ServletContextAware;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;
import java.util.Date;
import java.util.List;
import java.util.Map;

@Controller

public class EmpController implements ServletContextAware {
   @Autowired
   private DeptService deptService;
    private ServletContext servletContext;
    @Override
    public void setServletContext(ServletContext servletContext) {
        this.servletContext = servletContext;
    }
    @Autowired
    private EmpService empService;
   /* @RequestMapping("/test.do")
    public String selectAll(@RequestParam(value = "deptname",required = false,defaultValue = "0")Integer deptname,
                            @RequestParam(value = "now", required = false, defaultValue = "1")Integer now,
                            @RequestParam(value = "ename")String ename, ModelMap map
                            ){
        //分页工具 设置分页
        PageHelper.startPage(now,3);
        //查询 书籍 返回 集合
        List<Emp> emps = empService.selectEmp(deptname,ename);
        //将集合与分页绑定 存到map
        PageInfo<Emp> pageInfo=new PageInfo<Emp>(emps);
        map.put("pageInfo",pageInfo);
        List<Dept> depts= deptService.selectAllDept();
        map.put("depts",depts);
        map.put("deptname",deptname);
        map.put("ename",ename);
        return "select";
    }*/
    @RequestMapping("/login.do")
    public String selectbyID(ModelMap map){
        Emp emps = empService.selectByPrimaryKey(1);
        map.put("emps",emps);
        return "login";
    }
    @RequestMapping("/select.do")

    public String selectAll(@RequestParam(value = "deptname",required = false,defaultValue = "0")Integer id,
                            String empname
,ModelMap map,
                            @RequestParam(value = "now", required = false, defaultValue = "1")Integer now
    ){
        System.out.println("deptname--"+id);
        System.out.println("ename--"+empname);
        System.out.println("now--"+now);
        //分页工具 设置分页
        PageHelper.startPage(now,3);
        //查询 书籍 返回 集合
        List<Emp> emps = empService.selectEmp(id, empname);
        for ( Emp ee:emps
             ) {
            System.out.println(ee);
        }
        //将集合与分页绑定 存到map
        PageInfo<Emp> pageInfo=new PageInfo<Emp>(emps);
        map.put("pageInfo",pageInfo);
        //获取所有图书类型显示到页面
        List<Dept> depts = deptService.selectAllDept();
        map.put("depts",depts);
        //作为回显把参数都缓存进去
        map.put("deptname",id);
        map.put("empname",empname);
        map.put("now",now);
        for ( Dept ee:depts
                ) {
            System.out.println(ee);
        }
        return "select";
    }

    @RequestMapping("/add.do")
    public String insertEmp(ModelMap map){

        List<Dept> depts = deptService.selectAllDept();
        map.put("depts",depts);
        return "add";
    }
    @RequestMapping("/goAdd.do")
    public String addEmp(Emp emp,HttpServletResponse response) throws IOException {
        System.out.println("进入ADD");
        System.out.println(emp);
        int row = empService.insert(emp);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter pWriter = response.getWriter();
        if (row > 0) {
            pWriter.write("<script type='text/javascript'>alert('新增成功');location.href='querybook.htm'</script>");
        } else {
            pWriter.write("<script type='text/javascript'>alert('新增失败');location.href='add.htm'</script>");
        }
        return "select";

    }
    @RequestMapping("/update.do")
    public String updateEmp(Integer id,ModelMap map){
        Emp emp = empService.selectByPrimaryKey(id);
        List<Dept> depts = deptService.selectAllDept();
        map.put("depts",depts);
        map.put("emp",emp);
        return "update";
    }
    @RequestMapping("/goupdate.do")
    public String insertEmp(Emp emp,HttpServletResponse response) throws IOException {
        System.out.println("进入insert");
        System.out.println(emp);
        int row = empService.updateByPrimaryKey(emp);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter pWriter = response.getWriter();
        if (row > 0) {
            pWriter.write("<script type='text/javascript'>alert('修改成功');location.href='querybook.htm'</script>");
        } else {
            pWriter.write("<script type='text/javascript'>alert('修改失败');location.href='add.htm'</script>");
        }
        return "select";
    }
    @RequestMapping("/delete.do")
    public String delEmp(Integer id,HttpServletResponse response) throws IOException {
       int row = empService.deleteByPrimaryKey(id);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter pWriter = response.getWriter();
        if (row > 0) {
            pWriter.write("<script type='text/javascript'>alert('删除成功');location.href='querybook.htm'</script>");
        } else {
            pWriter.write("<script type='text/javascript'>alert('删除失败');location.href='add.htm'</script>");
        }
        return "select";
    }
    @RequestMapping("/details.do")
    public String selectEmp(Integer id,ModelMap map){
        Emp emp = empService.selectByPrimaryKey(id);
        List<Dept> depts = deptService.selectAllDept();
        map.put("depts",depts);
        map.put("emp",emp);
        return "detil";
    }
    @RequestMapping("delAll.do")
    //获取bookid的集合
    public String delallBook(String[] bookid,HttpServletResponse response) throws IOException {
        int rows = empService.deleteAllemp(bookid);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter pWriter = response.getWriter();
        if (rows > 0) {
            pWriter.write("<script type='text/javascript'>alert('删除成功');location.href='query.do'</script>");
        } else {
            pWriter.write("<script type='text/javascript'>alert('删除失败');location.href='query.do'</script>");
        }
        return "select";
    }
}