在线教育项目之院校信息功能

TypeScript
package com.example.entity;

import lombok.Data;

@Data
public class College {
private Integer id;
private String name;
private String content;
private Integer score;
}

XML
<el-sub-menu index="2">
<template #title>
<el-icon><Promotion /></el-icon>
<span>信息管理</span>
</template>
<el-menu-item index="/college">
<el-icon><OfficeBuilding /></el-icon>
<span>学院信息</span>
</el-menu-item>
</el-sub-menu>

TypeScript
{ path: 'college', component: () => import('@/views/manager/College.vue')},

Java
package com.example.controller;

/**
* 学院信息前端请求的接口入口
*/
@RestController
@RequestMapping("/college")
public class CollegeController {
@Resource
private CollegeService collegeService;

/**
* 新增
*/
@PostMapping("/add")
public Result add(@RequestBody College college) {
collegeService.add(college);
return Result.success();
}
}

TypeScript
package com.example.service;

import com.example.entity.College;

public interface CollegeService {
void add(College college);
}

Java
package com.example.service.impl;

import com.example.entity.College;
import com.example.mapper.CollegeMapper;
import com.example.service.CollegeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class CollegeServiceImpl implements CollegeService {
@Autowired
private CollegeMapper collegeMapper;
@Override
public void add(College college) {
collegeMapper.insert(college);
}
}

TypeScript
package com.example.mapper;

import com.example.entity.College;

public interface CollegeMapper {
void insert(College college);
}

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.example.mapper.CollegeMapper">

<insert id="insert" parameterType="com.example.entity.College" useGeneratedKeys="true">
insert into college (id, name, content, score)
values (#{id}, #{name}, #{content}, #{score})
</insert>
</mapper>

TypeScript
/**
* 分页查询
*/
@GetMapping("/selectPage")
public Result selectPage(String name,
@RequestParam(defaultValue = "1") Integer pageNum,
@RequestParam(defaultValue = "5") Integer pageSize){
PageInfo<College> pageInfo = collegeService.selectPage(name, pageNum, pageSize);
return Result.success(pageInfo);
}

TypeScript
@Override
public PageInfo<College> selectPage(String name, Integer pageNum, Integer pageSize) {
List<College> list = new ArrayList<>();
PageHelper.startPage(pageNum, pageSize);
if (ObjectUtil.isNotEmpty(name)) {
list = collegeMapper.selectByName(name);
} else {
list = collegeMapper.selectAll();
}
return PageInfo.of(list);
}

Java
@Select("select * from college")
List<College> selectAll();

@Select("select * from college where name like concat('%', #{name}, '%')")
List<College> selectByName(String name);

TypeScript
/**
* 查询所有
*/
@GetMapping("/selectAll")
public Result selectAll() {
List<College> list = collegeService.selectAll();
return Result.success(list);
}

TypeScript
@Override
public List<College> selectAll() {
return collegeMapper.selectAll();
}

SQL
/**
* 更新
*/
@PutMapping("/update")
public Result update(@RequestBody College college) {
collegeService.updateById(college);
return Result.success();
}

TypeScript
@Override
public void updateById(College college) {
collegeMapper.updateById(college);
}

TypeScript
@Update("update college set name = #{name}, content = #{content}, score = #{score}" +
" where id = #{id} ")
void updateById(College college);

SQL
/**
* 根据id删除
*/
@DeleteMapping("/deleteById/{id}")
public Result deleteById(@PathVariable Integer id) {
collegeService.deleteById(id);
return Result.success();
}

TypeScript
public void deleteById(Integer id) {
collegeMapper.deleteById(id);
}

TypeScript
@Delete("delete from college where id = #{id}")
void deleteById(Integer id);