在线教育项目之专业信息功能

TypeScript
package com.example.entity;

import lombok.Data;

@Data
public class Speciality {

private Integer id;
private String name;
private Integer collegeId;

}

XML
<el-menu-item index="/speciality">
<el-icon><School /></el-icon>
<span>专业信息</span>
</el-menu-item>

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

Java
package com.example.controller;

/**
* 专业信息前端请求的接口入口
*/
@RestController
@RequestMapping("/speciality")
public class SpecialityController {
@Resource
private SpecialityService specialityService;

/**
* 新增
*/
@PostMapping("/add")
public Result add(@RequestBody Speciality speciality) {
specialityService.add(speciality);
return Result.success();
}
}

TypeScript
package com.example.service;

import com.example.entity.Speciality;

public interface SpecialityService {
void add(Speciality speciality);
}

Java
package com.example.service.impl;

@Service
public class SpecialityServiceImpl implements SpecialityService {
@Resource
private SpecialityMapper specialityMapper;
@Override
public void add(Speciality speciality) {
specialityMapper.insert(speciality);
}
}

Java
package com.example.mapper;

public interface SpecialityMapper {

@Insert("insert into speciality(name, college_id) values(#{name}, #{collegeId})")
void insert(Speciality speciality);
}

TypeScript
// 学院名称
private String collegeName;

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

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

Java
package com.example.mapper;

public interface SpecialityMapper {

@Insert("insert into speciality(name, college_id) values(#{name}, #{collegeId})")
void insert(Speciality speciality);

@Select("SELECT s.*,c.`name` collegeName FROM speciality s " +
"LEFT JOIN college c ON s.college_id = c.id " +
"WHERE s.`name` LIKE CONCAT('%',#{name},'%')")
List<Speciality> selectByName(String name);

@Select("SELECT s.*,c.`name` collegeName FROM speciality s " +
"LEFT JOIN college c ON s.college_id = c.id")
List<Speciality> selectAll();
}

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

TypeScript
@Override
public List<Speciality> selectAll() {
return specialityMapper.selectAll();
}

SQL
/**
* 更新
*/
@PutMapping("/update")
public Result update(@RequestBody Speciality speciality) {
specialityService.updateById(speciality);
return Result.success();
}

TypeScript
@Override
public void updateById(Speciality speciality) {
specialityMapper.updateById(speciality);
}

TypeScript
@Update("update speciality set name = #{name}, college_id = #{collegeId} where id = #{id}")
void updateById(Speciality speciality);

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

TypeScript
@Override
public void deleteById(Integer id) {
specialityMapper.deleteById(id);
}

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