先看看没有缓存的情况
mapper
@Mapper
public interface UserMapper {
@Select("select * from user")
List<User> selectAll();
@Select("select * from user where user_id=#{integer}")
User selectByid(Integer integer);
@Delete("delete from user where user_id=#{userId}")
int deleteByPrimaryKey(Integer userId);
@Options(useGeneratedKeys = true,keyProperty = "userId")
@Insert("insert into user (user_type,user_name,user_pwd,user_phone) values (#{userType},#{userName},#{userPwd},#{userPhone})")
int insert(User record);
@Update("update user set user_type=#{userType},user_name=#{userName},user_pwd=#{userPwd},user_phone=#{userPhone} where user_id=#{userId}")
int updateuser(User user);
}
service
@Service
public class UserService {
@Autowired
UserMapper userMapper;
public User getuser(Integer id){
System.out.println("进方法了");
User user = userMapper.selectByid(id);
System.out.println("方法执行完成");
return user;
}
}
controller
@RestController
public class UserController {
@Autowired
UserService userService;
@GetMapping("/user/{id}")
public User selectById(@PathVariable Integer id) {
User getuser = userService.getuser(id);
return getuser;
}
}
我们连续两次查询一个用户看结果(没有缓存的情况下)
此时我们开启注解缓存(标注缓存注解即可)