本文共 3048 字，大约阅读时间需要 10 分钟。

这里以达梦数据库为例，使用MyBatis对数据库进行增删改查

这里先给出截图

此处为了简单，直接在Controller里面调用dao中数据：

关键代码如下：

application.properties

spring.datasource.driver-class-name=dm.jdbc.driver.DmDriverspring.datasource.url=jdbc:dm://XXX.XXX.XXX.XXXspring.datasource.username=XXXXspring.datasource.password=XXXXmybatis.mapperLocations=classpath:/*.xml

AppInfo.java

i1package com.example.demo.object;import lombok.Data;@Datapublic class AppInfo{    private String appXXId;    private String nodeXXId;    private String appXXEngName;    private String appXXChnName;    private String appXXStatus;}

AppInfoMapper.java

package com.example.demo.dao;import com.example.demo.object.AppInfo;import org.apache.ibatis.annotations.Mapper;import java.util.List;@Mapperpublic interface AppInfoMapper {    List
   
     getAllAPPInfo();    void addAPPInfo(AppInfo appInfo);    void updateAPPInfo(AppInfo appInfo);    void deleteAPPInfo(AppInfo appInfo);}
   

TestController.java

package com.example.demo.controller;import com.example.demo.dao.AppInfoMapper;import com.example.demo.object.AppInfo;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.ResponseBody;import javax.annotation.Resource;@Controller@ResponseBodypublic class TestController {    @Resource    private AppInfoMapper mapper;    @GetMapping("/select")    public String select(){        System.out.println(mapper.getAllAPPInfo());        return "
Hello World
";    }    @GetMapping("/insert")    public String insert(){        AppInfo appInfo = new AppInfo();        appInfo.setAppXXId("10086");        appInfo.setNodeXXId("10010");        appInfo.setAppXXChnName("呵呵哒");        appInfo.setAppXXEngName("English");        mapper.addAPPInfo(appInfo);        System.out.println(mapper.getAllAPPInfo());        return "
Hello World
";    }    @GetMapping("/update")    public String update(){        AppInfo appInfo = new AppInfo();        appInfo.setAppXXId("10086");        appInfo.setNodeXXId("10000");        appInfo.setAppXXChnName("哦！是吗");        appInfo.setAppXXEngName("Chinese");        mapper.updateAPPInfo(appInfo);        System.out.println(mapper.getAllAPPInfo());        return "
Hello World
";    }    @GetMapping("/delete")    public String delete(){        AppInfo appInfo = new AppInfo();        appInfo.setAppXXId("10086");        mapper.deleteAPPInfo(appInfo);        System.out.println(mapper.getAllAPPInfo());        return "
Hello World
";    }}

关键的xml文件如下：

   
       
            select APPXXID as appXXId, NODEXXID as nodeXXId, APPXX_ENG_NAME as appXXEngName, APPXX_CHN_NAME as appXXChnName, APPXX_STATUS as appXXStatus from XX.XX        
    
             insert into XX.XX(APPXXID, NODEXXID, APPXX_ENG_NAME, APPXX_CHN_NAME) values(#{appXXId}, #{nodeXXId}, #{appXXEngName}, #{appXXChnName})    
        
    
             update XX.XX set NODEXXID=#{nodeXXId}, APPXX_ENG_NAME=#{appXXEngName}, APPXX_CHN_NAME=#{appXXChnName} where APPXXID=#{appXXId}    
        
    
             delete from XX.XX where APPXXID=#{appXXId}    
        
   

转载地址：https://it1995.blog.csdn.net/article/details/103651250 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！