搭建学校oj平台-后端创建比赛题目

呜呜呜～铁

于 2023-04-07 12:30:00 发布

阅读量142

点赞数 1

文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/qq_52839873/article/details/129979459

版权

后端创建比赛题目

gitee仓库代码在文章尾部

Mysql新建competiton_problem表

create table competition_problem
(
	id int auto_increment,
	competition_id int null,
	number int null,
	title varchar(100) null,
	type varchar(100) null,
	score int null,
	topic_description varchar(5000) null,
	input_description varchar(500) null,
	output_description varchar(500) null,
	example_one_input varchar(500) null,
	example_one_output varchar(500) null,
	example_two_input varchar(500) null,
	example_two_output varchar(500) null,
	example_three_input varchar(500) null,
	example_three_output varchar(500) null,
	constraint competition_problem_id_uindex
		unique (id)
);

alter table competition_problem
	add primary key (id);

后端SpringBoot 创建competitionProblem

pojo层

package com.OJ.backend.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class CompetitionProblem {
    @TableId(type = IdType.AUTO)
    private Integer id;
    private Integer competitionId;
    private Integer number;
    private String title;
    private String type;
    private Integer score;
    private String topicDescription;
    private String inputDescription;
    private String outputDescription;
    private String exampleOneInput;
    private String exampleOneOutput;
    private String exampleTwoInput;
    private String exampleTwoOutput;
    private String exampleThreeInput;
    private String exampleThreeOutput;
}

mapper层建立

package com.OJ.backend.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.OJ.backend.pojo.CompetitionProblem;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface CompetitionProblemMapper extends BaseMapper<CompetitionProblem> {
}

service层

add操作

package com.OJ.backend.service.competitionProblem;

import java.util.Map;

public interface AddCompetitionProblemService {
    Map<String,String> addCompetitionProblem(Map<String ,String>data);
}

remove操作

package com.OJ.backend.service.competitionProblem;

import java.util.Map;

public interface RemoveCompetitionProblemService {
    Map<String,String> removeCompetitionProblem(Map<String,String>data);
}

update操作

package com.OJ.backend.service.competitionProblem;

import java.util.Map;

public interface UpdateCompetitionProblemService {
    Map<String,String> updateCompetitionProblem(Map<String,String>data);
}

getList操作

package com.OJ.backend.service.competitionProblem;

import com.OJ.backend.pojo.CompetitionProblem;

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

public interface GetListCompetitionProblemService {
    List<CompetitionProblem>getListCompetitionProblem(Map<String,String>data);
}

service层impl实现

add操作

package com.OJ.backend.service.impl.competitionProblem;

import com.OJ.backend.mapper.CompetitionProblemMapper;
import com.OJ.backend.pojo.CompetitionProblem;
import com.OJ.backend.service.competitionProblem.AddCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service
public class AddCompetitionProblemServiceImpl implements AddCompetitionProblemService {
    @Autowired
    private CompetitionProblemMapper competitionProblemMapper;
    @Override
    public Map<String, String> addCompetitionProblem(Map<String, String> data) {
        Map<String, String> map = new HashMap<>();
        Integer competitionId = Integer.parseInt(data.get("competition_id"));
        Integer number = Integer.parseInt(data.get("number"));
        String title = data.get("title");
        String type = data.get("type");
        Integer score = Integer.parseInt(data.get("score"));
        String topicDescription = data.get("topic_description");
        String inputDescription = data.get("input_description");
        String outputDescription = data.get("output_description");
        String exampleOneInput = data.get("example_one_input");
        String exampleOneOutput = data.get("example_one_output");
        String exampleTwoInput = data.get("example_two_input");
        String exampleTwoOutput = data.get("example_two_output");
        String exampleThreeInput = data.get("example_three_input");
        String exampleThreeOutput = data.get("example_three_output");

        CompetitionProblem problem = new CompetitionProblem(
                null,
                competitionId,
                number,
                title,
                type,
                score,
                topicDescription,
                inputDescription,
                outputDescription,
                exampleOneInput,
                exampleOneOutput,
                exampleTwoInput,
                exampleTwoOutput,
                exampleThreeInput,
                exampleThreeOutput
        );
        competitionProblemMapper.insert(problem);
        map.put("error_message", "success");
        return map;
    }
}

remove操作

package com.OJ.backend.service.impl.competitionProblem;

import com.OJ.backend.mapper.CompetitionProblemMapper;
import com.OJ.backend.service.competitionProblem.RemoveCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service
public class RemoveCompetitionProblemServiceImpl implements RemoveCompetitionProblemService {
    @Autowired
    private CompetitionProblemMapper competitionProblemMapper;
    @Override
    public Map<String, String> removeCompetitionProblem(Map<String, String> data) {
        Map<String, String> map = new HashMap<>();
        competitionProblemMapper.deleteById(data.get("competition_problem_id"));
        map.put("error_message", "success");
        return map;
    }
}

update操作

package com.OJ.backend.service.impl.competitionProblem;

import com.OJ.backend.mapper.CompetitionProblemMapper;
import com.OJ.backend.pojo.CompetitionProblem;
import com.OJ.backend.service.competitionProblem.UpdateCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.HashMap;
import java.util.Map;

@Service
public class UpdateCompetitionProblemServiceImpl implements UpdateCompetitionProblemService {
    @Autowired
    private CompetitionProblemMapper competitionProblemMapper;
    @Override
    public Map<String, String> updateCompetitionProblem(Map<String, String> data) {
        Map<String,String> map = new HashMap<>();
        Integer competitionId = Integer.parseInt(data.get("competition_id"));
        Integer number = Integer.parseInt(data.get("number"));
        String title = data.get("title");
        String type = data.get("type");
        Integer score = Integer.parseInt(data.get("score"));
        String topicDescription = data.get("topic_description");
        String inputDescription = data.get("input_description");
        String outputDescription = data.get("output_description");
        String exampleOneInput = data.get("example_one_input");
        String exampleOneOutput = data.get("example_one_output");
        String exampleTwoInput = data.get("example_two_input");
        String exampleTwoOutput = data.get("example_two_output");
        String exampleThreeInput = data.get("example_three_input");
        String exampleThreeOutput = data.get("example_three_output");

        CompetitionProblem competitionProblem=competitionProblemMapper.selectById(data.get("competition_problem_id"));
        CompetitionProblem now_competitionProblem= new CompetitionProblem(
                competitionProblem.getId(),
                competitionId,
                number,
                title,
                type,
                score,
                topicDescription,
                inputDescription,
                outputDescription,
                exampleOneInput,
                exampleOneOutput,
                exampleTwoInput,
                exampleTwoOutput,
                exampleThreeInput,
                exampleThreeOutput
        );
        competitionProblemMapper.updateById(now_competitionProblem);
        map.put("error_message", "success");
        return map;
    }
}

getList操作

package com.OJ.backend.service.impl.competitionProblem;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.OJ.backend.mapper.CompetitionProblemMapper;
import com.OJ.backend.pojo.CompetitionProblem;
import com.OJ.backend.service.competitionProblem.GetListCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

@Service
public class GetListCompetitionProblemServiceImpl implements GetListCompetitionProblemService {
    @Autowired
    private CompetitionProblemMapper competitionProblemMapper;
    @Override
    public List<CompetitionProblem> getListCompetitionProblem(Map<String,String>data) {
        QueryWrapper<CompetitionProblem> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("competition_id",data.get("competition_id"));
        return competitionProblemMapper.selectList(queryWrapper);
    }
}

controller层

add操作

package com.OJ.backend.controller.competitionProblem;

import com.OJ.backend.service.competitionProblem.AddCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.Map;

@RestController
public class AddCompetitionProblemController {
    @Autowired
    private AddCompetitionProblemService addCompetitionProblemService;
    @PostMapping("/api/competition/problem/add/")
    public Map<String,String>addCompetitionProblem(@RequestParam Map<String,String>data){
        return addCompetitionProblemService.addCompetitionProblem(data);
    }
}

remove操作

package com.OJ.backend.controller.competitionProblem;

import com.OJ.backend.service.competitionProblem.RemoveCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.Map;

@RestController
public class RemoveCompetitionProblemController {
    @Autowired
    private RemoveCompetitionProblemService removeCompetitionProblemService;
    @PostMapping("/api/competition/problem/remove/")
    public Map<String,String>removeCompetitionProblem(@RequestParam Map<String,String>data){
        return removeCompetitionProblemService.removeCompetitionProblem(data);
    }
}

update操作

package com.OJ.backend.controller.competitionProblem;

import com.OJ.backend.service.competitionProblem.UpdateCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.Map;

@RestController
public class UpdateCompetitionProblemController {
    @Autowired
    private UpdateCompetitionProblemService updateCompetitionProblemService;
    @PostMapping("/api/competition/problem/update/")
    public Map<String,String>updateCompetitionProblem(@RequestParam Map<String,String>data){
        return updateCompetitionProblemService.updateCompetitionProblem(data);
    }
}

getList操作

package com.OJ.backend.controller.competitionProblem;

import com.OJ.backend.pojo.CompetitionProblem;
import com.OJ.backend.service.competitionProblem.GetListCompetitionProblemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

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

@RestController
public class GetListCompetitionProblemController {
    @Autowired
    private GetListCompetitionProblemService getListCompetitionProblemService;
    @GetMapping("/api/competition/problem/getlist/")
    public List<CompetitionProblem> getListCompetitionProblem(@RequestParam Map<String,String>data){
        return getListCompetitionProblemService.getListCompetitionProblem(data);
    }
}