springboot的基本增删改查

参考：
springboot搭建
springboot集成mysql
springboot集成mybatis【使用generatorConfig.xml配置自动生成代码】

在集成mysql和mybatis后，对数据进行简单的增删改查操作

参考springboot集成mybatis中的代码继续下面的步骤（springboot集成mybatis【使用generatorConfig.xml配置自动生成代码】）

1、根据表中的字段创建实体类UserInfo.java

package com.study.mybatis.entity;


import lombok.Data;


/**
* @Author: JING
* @Created: 2022/2/9 15:56
* @Description:
* @Version: 1.0.0
* @Since JDK 1.8
*/
@Data
public class UserInfo {
    private Integer id;


    private String userName;


    private String userId;


    private String address;
}

2、编写MybatisController.java

package com.study.mybatis.controller;


import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.study.mybatis.dao.MybatisUserMapper;
import com.study.mybatis.entity.MybatisUser;
import com.study.mybatis.entity.MybatisUserImpl;
import com.study.mybatis.entity.UserInfo;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.http.MediaType;
import org.springframework.web.bind.annotation.*;


import java.util.List;


/**
* @Author: JING
* @Created: 2022/2/8 17:38
* @Description:
* @Version: 1.0.0
* @Since JDK 1.8
*/
@RestController
@EnableAutoConfiguration
@RequestMapping("/study/web")
public class MybatisController {
    @Autowired
    MybatisUserMapper mybatisUserMapper;


    /**
     * 查询
     */
    @CrossOrigin
    @RequestMapping(value = "/getMybatisUserInfo",method = RequestMethod.POST,produces = MediaType.APPLICATION_JSON_VALUE)
    List<MybatisUser> getMybatisUserInfo(){
        MybatisUserImpl mybatisUserImpl = new MybatisUserImpl();
        List<MybatisUser> mybatisUserList = mybatisUserMapper.selectByExample(mybatisUserImpl);
        return mybatisUserList;
    }


    /**
     * 新增
     * @param userInfo 传参对象
     * @return 返回结果
     */
    @CrossOrigin
    @RequestMapping(value = "/insertMybatisUserInfo",method = RequestMethod.POST,produces = MediaType.APPLICATION_JSON_VALUE)
    JSONObject insertMybatisUserInfo(@RequestBody UserInfo userInfo){
        MybatisUser mybatisUser = JSON.toJavaObject((JSONObject) JSONObject.toJSON(userInfo),MybatisUser.class);
        mybatisUserMapper.insert(mybatisUser);
        JSONObject jsonObject = new JSONObject();
        jsonObject.put("新增数据成功：",mybatisUser);


        return jsonObject;
    }


    /**
     * 以参数形式新增数据
     * @param id id
     * @param userName userName
     * @param userId userId
     * @param address address
     * @return 返回结果
     */
    @CrossOrigin
    @RequestMapping(value = "/insertMybatisUserInfo2",method = RequestMethod.POST,produces = MediaType.APPLICATION_JSON_VALUE)
    JSONObject insertMybatisUserInfo2(@Param("id")Integer id,@Param("userName") String userName,@Param("userId")String userId,@Param("address")String address){
        MybatisUser mybatisUserParam = new MybatisUser();
        mybatisUserParam.setId(id);
        mybatisUserParam.setUserName(userName);
        mybatisUserParam.setUserId(userId);
        mybatisUserParam.setAddress(address);
        mybatisUserMapper.insert(mybatisUserParam);
        JSONObject jsonObject = new JSONObject();
        jsonObject.put("参数新增数据：",mybatisUserParam);
        return jsonObject;


    }


    /**
     * 修改数据
     * @param userInfo 修改传参
     * @return 返回结果
     */
    @CrossOrigin
    @RequestMapping(value = "/updateMybatisUserInfo",method = RequestMethod.POST,produces = MediaType.APPLICATION_JSON_VALUE)
    JSONObject updateMybatisUserInfo(@RequestBody UserInfo userInfo){
        MybatisUserImpl mybatisUserImpl = new MybatisUserImpl();
        MybatisUserImpl.Criteria criteria = mybatisUserImpl.createCriteria();
        criteria.andIdEqualTo(userInfo.getId());
        MybatisUser mybatisUser = JSON.toJavaObject((JSONObject) JSONObject.toJSON(userInfo),MybatisUser.class);
        mybatisUserMapper.updateByExample(mybatisUser,mybatisUserImpl);
        JSONObject jsonObject = new JSONObject();
        jsonObject.put("修改数据成功：",mybatisUser);
        return jsonObject;
    }


    /**
     * 删除数据
     * @param userInfo 删除数据所需的参数对象
     * @return 返回结果
     */
    @CrossOrigin
    @RequestMapping(value = "/deleteMybatisUserInfo",method = RequestMethod.POST,produces = MediaType.APPLICATION_JSON_VALUE)
    JSONObject deleteMybatisUserInfo(@RequestBody UserInfo userInfo){
        MybatisUserImpl mybatisUserImpl = new MybatisUserImpl();
        MybatisUserImpl.Criteria criteria = mybatisUserImpl.createCriteria();
        criteria.andIdEqualTo(userInfo.getId());
        mybatisUserMapper.deleteByExample(mybatisUserImpl);
        JSONObject jsonObject = new JSONObject();
        jsonObject.put("删除数据成功，数据id为：",userInfo.getId());
        return jsonObject;
    }


}

3、在postman中访问接口（先启动项目）

3-1、增

url

127.0.0.1:8080/study/web/insertMybatisUserInfo

请求体

{"id":"5","userName":"温宁","userId":"鬼将军","address":"岐山不夜天"}

3-2、删

url

127.0.0.1:8080/study/web/deleteMybatisUserInfo

请求体

{"id":"4"}

3-3、改

url

127.0.0.1:8080/study/web/updateMybatisUserInfo

请求体

{"id":"5","userName":"魏婴","userId":"夷陵老祖","address":"夷陵乱葬岗"}

3-4、查

url

127.0.0.1:8080/study/web/getMybatisUserInfo

END