编码思路很重要

1.编程思路
一、列表页面

列表查询.访问接口.接口返回list数据,和页面

二、添加

添加,跳转到添加页面，输入内容,表单提交,回到list页面

三、修改,跳转到修改页面,顺便把要修改的数据返回,回显数据,修改数据，提交,回到list页面

四、删除 二次确认, 确认之后,删除数据， 回到list页面

package com.jiyun.controller;

import com.jiyun.entity.Class;
import com.jiyun.entity.Grade;
import com.jiyun.entity.Student;
import com.jiyun.service.StudentService;
import com.jiyun.vo.StudentVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

@Controller
@RequestMapping("studentController")
public class StudentController {

    @Autowired
    StudentService ss;


    @RequestMapping("index")
    public  String index(HttpServletRequest request){
        List<StudentVo> studentVoList = ss.findAll2();
        request.setAttribute("studentList",studentVoList);
        request.setAttribute("helloword","helloword");


        return "index";
    }


    @RequestMapping("tostudent")
    public  Object tostuent(HttpServletRequest request){

        return ss.findAll();
    }
    @RequestMapping("findAll")
    public  Object findAll(){

        return ss.findAll2();
    }
    @RequestMapping("toadd")
    public  String toadd(HttpServletRequest request){
        List<Class> classList = ss.findClass();
        List<Grade> gradeList = ss.findGrade();
        request.setAttribute("gradeList",gradeList);
        request.setAttribute("classList",classList);
        return "add";
    }
    @RequestMapping("toEdit")
    public  String toEdit(Integer id,HttpServletRequest request){
        List<Class> classList = ss.findClass();
        List<Grade> gradeList = ss.findGrade();
        request.setAttribute("gradeList",gradeList);
        request.setAttribute("classList",classList);
        request.setAttribute("stu",ss.findstudentById(id));
        return "edit";
    }
    @RequestMapping("del")
    public  String del(Integer id,HttpServletRequest request){

        ss.delete(id);
        return "redirect:index";
    }
    @RequestMapping("add")
    public  String add(Student student){

        ss.inster(student);
        return "redirect:index";
    }
    @RequestMapping("edit")
    public  String edit(Student student){

        ss.update(student);
        return "redirect:index";
    }

    public void inster(Student student){
        ss.inster(student);
    }
    public void delete(int id){
        ss.delete(id);
    }
    public void update(Student student){
        ss.update(student);
    }

}

注意事项
一、多表操作
1、使用@Select ( sgl语句)

1、必须要使用手写sql的时候,

2、查询条件固定，或者不为空

2、使用xml

必须在application. yml中加上

mybatis:

mapper- locations: classpath :mapper/* . xml

代码思路:

使用mybatis的两种方式，实现三张表的增删改查
表结构自己定义

2、webapp下， 前端页面的位置

springboot下，resources 下，

• classpath: /META- INF/ resources/
• classpath: / resources /

-classpath: /static/

-classpath: /public/