结组作业8

今天又写了一部分代码，用于对数据库内容的增加和查询

package org.test.tongyuzhe.Controller;


import org.springframework.web.bind.annotation.RequestBody;
import org.test.tongyuzhe.Pojo.Chat;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;
import org.test.tongyuzhe.Pojo.Result;
import org.test.tongyuzhe.Service.ChatService;

import java.util.List;

/**
 * <p>
 *  前端控制器
 * </p>
@RestController
@RequestMapping("/message")
public class ChatController1 {
    @Autowired
    ChatService chatService;
    @PostMapping("/getMessage")
    public Result<Object> getMessage(Integer userId)
    {
        List<Chat> list=chatService.getMessage(userId);
        return Result.success(list);
    }
    @PostMapping("/insertMessage")
    public Result<Object> insertMessage(@RequestBody Chat chat){
        chatService.insertMessage(chat);
        return Result.success();
    }
}

package org.test.tongyuzhe.Mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.test.tongyuzhe.Pojo.Chat;

import java.util.List;

@Mapper
public interface ChatMapper {
    @Select("select * from chat where userId=#{userId}")
    List<Chat> getMessage(Integer userId);
    @Insert("insert into chat(userId, request, response, time) VALUES (#{userId},#{request},#{response},#{time})")
    void insertMessage(Chat chat);
}

package org.test.tongyuzhe.Service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.test.tongyuzhe.Mapper.ChatMapper;
import org.test.tongyuzhe.Pojo.Chat;

import java.util.List;

@Service
public class ChatService {
    @Autowired
    ChatMapper chatMapper;

    /**
     * 通过userId来获取当前用户的历史问问题记录
     * @param userId 用户id
     * @return 问题和回答列表信息
     */
    public List<Chat> getMessage(Integer userId) {
        List<Chat> list=chatMapper.getMessage(userId);
        return list;
    }

    /**
     * 添加message（也就是保存用户提出的问题和答案等信息）
     * @param chat
     */
    public void insertMessage(Chat chat) {
       chatMapper.insertMessage(chat);
    }
}