Mybatis @Delete注解接口方式删除的简单例子

成功人chen某

已于 2024-08-14 23:07:47 修改

阅读量124

点赞数 2

文章标签： mybatis

于 2024-08-14 22:36:20 首次发布

本文链接：https://blog.csdn.net/qq_45258618/article/details/141201948

版权

1，建立实体类com.xxx.xxx.CCC; 和对应数据库xxx

2，建立接口类public interface CCCMaper

写@Delete解，写用于调用的deleteCCC接口方法

package com.xxx.xxx;

import com.xxx.xxx.CCC;
import org.apache.ibatis.annotations.Select;

public interface CCCMaper{
    @Delete("delete from xxxx where xx=#{xx}")
    int deleteCCC(int xx);
}

3，配置Mybatis配置表mybatis-config.xml

        <mapper class="com.xxx.xxx.CCCMapper"/>

4，调用

    @Test
    public void deleteCCCTest(){
        String resources = "mybatis-config.xml";
        Reader reader=null;
        try{
            reader= Resources.getResourceAsReader(resources);
        } catch (IOException e){
            e.printStackTrace();
        }
        SqlSessionFactory sqlMapper=new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlMapper.openSession();


        CCCMapper mapper = session.getMapper(CCCMapper.class);

        int result = mapper.deleteCCC(2);
        session.commit();
        session.close();
    }