Spring Boot MyBatis Postgres 实现对数据表增删改查操作（采用注解方式）

 1.创建Java实体类

package com.example.server;

public class SceneService {

    private  String servicename;
    private  ServiceTypeEnum servicetype;
    private  String serviceurl;

    public String getServicename() {
        return servicename;
    }

    public void setServicename(String servicename) {
        this.servicename = servicename;
    }

    public ServiceTypeEnum getServicetype() {
        return servicetype;
    }

    public void setServicetype(ServiceTypeEnum servicetype) {
        this.servicetype = servicetype;
    }

    public String getServiceurl() {
        return serviceurl;
    }

    public void setServiceurl(String serviceurl) {
        this.serviceurl = serviceurl;
    }
}

2.创建Mapper接口

package com.example.server; 

import org.apache.ibatis.annotations.*;

import java.util.Map;

@Mapper
public interface SceneServicesMapper {


    //按名称查询
    @Select("select * from sys_scene_services_tb where servicename=#{name}")
    public SceneService selectServiceByName(String servicename);

    //查询服务列表
    @Select("select * from sys_scene_services_tb")
    @MapKey("servicename")
    public Map<String,SceneService> selectServices();

    //删除
    @Delete("delete from sys_scene_services_tb where servicename=#{name}")

    public int deleteService(String servicename);

    //修改
    @Update("update sys_scene_services_tb set servicetype=#{servicetype}, serviceurl=#{serviceurl} where servicename=#{servicename}")

    public int updateService(SceneService sceneService);

    //插入
    @Insert("insert into sys_scene_services_tb(servicename,servicetype,serviceurl) values(#{servicename},#{servicetype},#{serviceurl})")
    public int insertService(SceneService sceneService);

}

3. 创建控制类Controller 

package com.example.server.controller;

import com.example.server.SceneService;
import com.example.server.SceneServicesMapper;
import net.minidev.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.Map;

@RestController

public class SceneServicesController {

    @Autowired
    SceneServicesMapper sceneServicesMapper;

    //查询
    @RequestMapping("/get/{name}")

    public SceneService getServiceByName(@PathVariable("name") String name) {

        return  sceneServicesMapper.selectServiceByName(name);
    }

   // 查询服务列表
    @RequestMapping("/services")
    public Map<String,SceneService> getServices(){

        return (Map<String, SceneService>) sceneServicesMapper.selectServices();
    }

    //删除
    @RequestMapping("/delete/{name}")
    public String deleteService(@PathVariable("name") String name){

        sceneServicesMapper.deleteService(name);
        return "删除成功！";
    }

    //插入
    @RequestMapping("/insert")

    public SceneService insertService(SceneService sceneService){

        sceneServicesMapper.insertService(sceneService);
        return sceneService;
    }

    //修改
    @RequestMapping("/update")
    public SceneService updateService(SceneService sceneService){

        sceneServicesMapper.updateService(sceneService);
        return sceneService;
    }

}