SpringBoot使用Mybatis的Mapper查询数据

编写mapper接口

package com.java1.javatest.mapper;

import com.java1.javatest.entity.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserMapper {

    User SelectId(int id);

    @Insert("insert into user(userName,passWord,realName)values(#{userName},#{passWord},#{realName})")
    void add(User user);

    @Select("select * from user")
    public List<User> queryUser();
}

service调取mapper

package com.java1.javatest.service;

import com.java1.javatest.entity.User;
import com.java1.javatest.mapper.UserMapper;
import org.apache.ibatis.annotations.Insert;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;
    public User SelectId(int id){

        return userMapper.SelectId(id);
    }

    public List<User> queryUser(){

        return userMapper.queryUser();
    }

    public void add(User user){
        userMapper.add(user);
    }
}

控制器

package com.java1.javatest.controller;

import com.java1.javatest.entity.User;
import com.java1.javatest.mapper.UserMapper;
import com.java1.javatest.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired(required = false)
    private UserService userService;

    @GetMapping("/list/{id}")
    public User GetUser(@PathVariable int id){

        return userService.SelectId(id);
    }

    @GetMapping("/query")
    public List<User> queryUser(){
        List<User> list = userService.queryUser();
        return list;
    }
	//添加数据
    @GetMapping("/add/{username}/{password}")
    public void add(@PathVariable(value = "username") String userName, @PathVariable(value = "password") String passWord, User user){
        user.setUserName(userName);
        user.setPassWord(passWord);
        user.setRealName("喝尿1");
        userService.add(user);
    }
    @RequestMapping("/add2")
    public String addUser(@RequestParam(value = "name") String userName,@RequestParam(value = "pass") String passWord, User user){
        System.out.println("id is " + user.getId());
        System.out.println("username is " + userName);
        System.out.println("password is " + passWord);
        return "success";
    }
	//返回map
    @RequestMapping("/add3")
    public Map<String, Object> addUsers(@RequestParam(value = "name") String userName, @RequestParam(value = "pass") String passWord, User user){
        Map<String, Object> map = new HashMap<>();
        map.put("name", userName);
        map.put("pass", passWord);
        return map;
    }
	//返回list
    @RequestMapping("/add4")
    public List<Object> addUseres(@RequestParam(value = "name") String userName, @RequestParam(value = "pass") String passWord, User user){
        List<Object> list = new ArrayList<>();
        user.setUserName(userName);
        list.add(user);
        return list;
    }

}