使用mybatis+springboot将MapString Object数据 insert到数据库写一个代码示例

假设要将Map<String, Object>数据插入到数据库表user中，以下是示例代码：

1. 创建User实体类

public class User {
    private Long id;
    private String username;
    private Integer age;
    // 省略getter和setter方法
}

2. 创建UserMapper接口

@Mapper
public interface UserMapper {
    @Insert("insert into user(username, age) values(#{username}, #{age})")
    int insertUser(User user);
}

3. 创建UserServiceImpl实现类

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    public int insertUser(Map<String, Object> data) {
        User user = new User();
        user.setUsername((String) data.get("username"));
        user.setAge((Integer) data.get("age"));
        return userMapper.insertUser(user);
    }
}

4. 在Controller中调用insertUser方法

@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;

    @PostMapping("/add")
    public String addUser(@RequestBody Map<String, Object> data) {
        int result = userService.insertUser(data);
        if (result == 1) {
            return "添加成功";
        } else {
            return "添加失败";
        }
    }
}

这样，就可以将Map<String, Object>类型的数据插入到数据库表user中