作业

总结：经过n次的项目框架搭建之后，熟练的掌握了搭建spingboot框架,作业方面需要注意的是Mapper文件里面数据库的语句问题，应当现在数据库里面做好并且查询成功后再复制到里面确保没有问题,还有网页传值问题，应当反复检查命名问题，否则无法获取到值。

/**
* Copyright (C), 2015-2018, XXX有限公司
* FileName: GoTest
* Author:   沉梦昂志丶
* Date:     2018/7/26 10:31
* Description:
* History:
* <author>          <time>          <version>          <desc>
* 作者姓名           修改时间           版本号              描述
*/
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.transaction.annotation.Transactional;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.servlet.http.HttpServletResponse;
import java.awt.print.Book;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import java.util.Map;

/**
* 〈一句话功能简述〉<br>
* 〈〉
*
* @author 沉梦昂志丶
* @create 2018/7/26
* @since 1.0.0
*/
@Transactional
@Controller
public class GoTest {

    @Autowired
    private DeptService deptService;

    @Autowired
    private EmpService empService;

    @RequestMapping("go.do")
    public String go(ModelMap map){
        List<Dept> depts = deptService.select();
        map.put("depts",depts);
        return "list";
    }

    @RequestMapping("list.do")
    public String list(@RequestParam(value="deptno",required=false,defaultValue="0")Integer deptno,
                       String empnames,
                       @RequestParam(value = "now", required = false, defaultValue = "1")Integer now,
                       ModelMap map){
        System.out.println(deptno);
        System.out.println(empnames);
        PageHelper.startPage(now,3);
        List<Emp> selectall = empService.selectall(deptno, empnames);
        PageInfo<Emp> pageInfo=new PageInfo<Emp>(selectall);
        List<Dept> depts = deptService.select();
        map.put("depts",depts);
        map.put("pageInfo",pageInfo);
        map.put("empname",empnames);
        map.put("deptno",deptno);
        return "list";
    }

    @RequestMapping("add.do")
    public String add(ModelMap map){
        List<Dept> depts = deptService.select();
        map.put("depts",depts);
        return "add";
    }

    @RequestMapping("addgo.do")
    public void addgo(Emp emp,HttpServletResponse response) throws IOException {
        int insert = empService.insert(emp);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter printWriter=response.getWriter();
        if(insert>0){
            printWriter.write("<script type='text/javascript'>alert('新增成功');location.href='/go.do'</script>");
        } else {
            printWriter.write("<script type='text/javascript'>alert('新增失败');location.href='/addgo.do'</script>");
        }
    }

    @RequestMapping("xq.do")
    public String xq(int empno,ModelMap map){
        Emp emp = empService.selectByPrimaryKey(empno);
        map.put("emp",emp);
        return "xq";
    }

    @RequestMapping("delete.do")
    public void delete(int empno,HttpServletResponse response) throws IOException {
        int i = empService.deleteByPrimaryKey(empno);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter printWriter=response.getWriter();
        if(i>0){
            printWriter.write("<script type='text/javascript'>alert('删除成功');location.href='/go.do'</script>");
        } else {
            printWriter.write("<script type='text/javascript'>alert('删除失败');location.href='/go.do'</script>");
        }
    }

    @RequestMapping("update.do")
    public String update(int empno,ModelMap map){
        Emp emp = empService.selectByPrimaryKey(empno);
        map.put("emp",emp);
        return "update";
    }

    @RequestMapping("updatego.do")
    public void updatego(Emp emp,ModelMap map,HttpServletResponse response) throws IOException {
        int i = empService.updateByPrimaryKey(emp);
        response.setContentType("text/html; charset=UTF-8");
        PrintWriter printWriter=response.getWriter();
        if(i>0){
            printWriter.write("<script type='text/javascript'>alert('修改成功');location.href='/go.do'</script>");
        } else {
            printWriter.write("<script type='text/javascript'>alert('修改失败');location.href='/update.do'</script>");
        }
    }

    @RequestMapping("delects.do")
    public String delects(String[] empnos){
        empService.deleteids(empnos);
        return "list";
    }
}