Mybatis @Param注解接口方式指定类-表参数对应的简单例子

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

2，建立接口类public interface CCCMaper

       写@Select解，写用于调用的 selectCCCByXAndXX接口方法

       并写@Param注解，指定类-表参数对应。

  关键部分

@Param("param01")int id,@Param("param02")String name

  完整例子

package com.xxx.xxx;

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

public interface CCCMaper{
    @Select("select * from xxx where x=#{param01} and xx=#{param02}")
    CCC selectCCCByXAndXX(@Param("param01")int x,@Param("param02")String xx);
}
 

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

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

4，调用

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

        CCC ccc= mapper.selectCCCByXAndXX(2,"XXXXX");
        System.out.println(ccc.toString());
        session.close();
    }