Mybatis @Insert 注解接口方式插入的简单例子

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

2，建立接口类public interface CCCMaper

        写@Insert解，写用于调用的 insertXXX 接口方法

package com.xxx.xxx;

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

public interface CCCMaper{
    @Insert("insert into xxx(x,xx)" +
            "values (#{xxx},#{xx})")
    int insertXXX(CCC ccc);
}
 

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

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

4，调用

    @Test
    public void insertCCCTest(){
        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();


        CCC ccc= new CCC();
        ccc.setX(1);
        ccc.setXx(2);


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

        int result = mapper.insertCCC(ccc);
        session.commit();
        session.close();
    }