Vue+Element之SpingBoot学生管理系统

目录

前后端分离

        1.1后端

        1.1.1配置generatorConfig.xml中的mysql文件目录,自动生成代码

        1.1.2mapper层

        1.1.2.1mapper.xml层

        1.1.3StudentService-->将BookMapper复制到Service

        1.1.4StudentServiceImpl（业务逻辑层）

        1.1.5StudentController层

        1.2前端

        1.2.1在cmd中下载依赖npm i(install)

        1.2.2在api中action.js配置请求路径

        1.2.3前端views写前端页面功能代码

        1.2.4在cmd中跑起来npm run dev

查询+主页面绑值

新增

generatorConfig.xml

mapper层

@Repository
public interface StudentMapper {

    /**
     * 新增
     * @param record
     * @return
     */
    int insert(Student record);

    /**
     * 查询
     * @param student
     * @return
     */
    List<Student> all(Student student);
}

 mapper.xml层

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zking.spboot.mapper.StudentMapper" >
  <resultMap id="BaseResultMap" type="com.zking.spboot.model.Student" >
    <constructor >
      <idArg column="sid" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="sname" jdbcType="VARCHAR" javaType="java.lang.String" />
      <arg column="score" jdbcType="VARCHAR" javaType="java.lang.String" />
      <arg column="sex" jdbcType="VARCHAR" javaType="java.lang.String" />
    </constructor>
  </resultMap>
  <sql id="Base_Column_List" >
    sid, sname, score, sex
  </sql>

    <select id="all" resultType="com.zking.spboot.model.Student">
      select <include refid="Base_Column_List" /> from t_student where 1=1
      <if test="sname!=null">
        and sname like concat('%',#{sname},'%')
      </if>
    </select>

  <insert id="insert" parameterType="com.zking.spboot.model.Student" >
    insert into t_student (sname, score,sex)
    values (#{sname,jdbcType=VARCHAR}, #{score,jdbcType=VARCHAR},#{sex,jdbcType=VARCHAR})
  </insert>

</mapper>

StudentService

public interface StudentService {

    /**
     * 新增
     * @param record
     * @return
     */
    int insert(Student record);

    /**
     * 查询
     * @param student
     * @return
     */
    List<Student> all(Student student);
}

StudentServiceImpl 

@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentMapper studentMapper;
    @Override
    public int insert(Student record) {
        return studentMapper.insert(record);
    }

    @Override
    public List<Student> all(Student student) {
        return studentMapper.all(student);
    }
}

StudentController层

package com.zking.spboot.controller;

import com.zking.spboot.model.Student;
import com.zking.spboot.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("/student")
public class StudentController {

    @Autowired
    private StudentService studentService;

    /**
     * 查询
     * @param student
     * @return
     */
    @RequestMapping("/list")
    public Map<String,Object> all(Student student){
        List<Student> all = studentService.all(student);
        Map<String,Object> rs=new HashMap<>();
        rs.put("code",200);
        rs.put("list",all);
        return  rs;
    }

    /**
     * 新增
     * @param student
     * @return
     */
    @RequestMapping("/add")
    public Map<String,Object> add(Student student){
        int i = studentService.insert(student);
        Map<String,Object> rs=new HashMap<>()