java+vue实现添加单选题、多选题到题库功能

本文为大家分享了java+vue实现添加选择题到题库功能的具体代码，供大家参考，具体内容如下

做个备份

数据库表：

后台接口

@DeleteMapping("deleteQuestion")
 @ApiOperation(value = "删除问题")
 public ServerResponse deleteQuestion(Integer id){
 sysQuestionMapper.deleteByPrimaryKey(id);
 sysQuestionAnswerMapper.deleteByQUestionId(id);
 return ServerResponse.createBySuccess("删除成功");
 }

 @GetMapping("getQuestionList")
 @ApiOperation(value = "获得问题列表")
 public ServerResponse getQuestionList(){
 List list = sysQuestionMapper.selectAllQuestion();
 return ServerResponse.createBySuccess(list);
 }

 @GetMapping("getQuestionAnswerList")
 @ApiOperation(value = "获得问题选项列表")
 public ServerResponse getQuestionAnswerList(Integer question_id){
 List list = sysQuestionAnswerMapper.selectByQuestionId(question_id);
 return ServerResponse.createBySuccess(list);
 }

 @PostMapping("addQuestion")
 @ApiOperation(value = "添加问题")
 public ServerResponse addQuestion(String question,String[] answerList,Integer[] answer){
 Integer type = 1;
 if (answer.length != 1) {
 type = 2;
 }
 String stringAnswer = "";
 List list = Arrays.asList(answer);
 SysQuestion sysQuestion = new SysQuestion();
 sysQuestion.setQuestionName(question);
 sysQuestion.setCreateTime(new Date());
 sysQuestion.setType(type);
 sysQuestionMapper.insert(sysQuestion);
 Integer question_id = sysQuestionMapper.selectLastQuestionId();
 for (int i=0;i list = Arrays.asList(answer);
 sysQuestionAnswerMapper.deleteByQUestionId(question_id);
 for (int i=0;i

代码中涉及的sql语句


 select max(id) from sys_question
 

 
 select * from sys_question order by create_time desc




 select * from sys_question_answer
 where question_id=#{question_id}
 

 
 select max(id) from sys_question_answer
 

 
 delete from sys_question_answer where question_id=#{question_id}


vue页面



 tr {
 & > td.el-table__expanded-cell {
 font-size: 20px;
 }
 }
 .el-textarea.is-disabled .el-textarea__inner{
 color: #17181a !important;
 }


 .shop-container {
 padding: 10px;
 }

 @import url("//unpkg.com/element-ui@2.4.0/lib/theme-chalk/index.css");
 .demo-table-expand {
 font-size: 0;
 }

 .demo-table-expand label {
 width: 90px;
 color: #67C23A;
 }

 .demo-table-expand .el-form-item {
 margin-right: 0;
 margin-bottom: 0;
 width: 100%;
 }

 .el-dialog {
 width: 50% !important;
 }
 .el-form-item {
 float: none!important;
 }








实现效果：


以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持考高分网。