1,建立实体类com.xxx.xxx.CCC; 和对应数据库xxx
2,建立接口类public interface CCCMaper
写@Select注解,写用于调用的 selectXXX(int id);接口方法
package com.xxx.xxx;
import com.xxx.xxx.CCC;
import org.apache.ibatis.annotations.Select;
public interface CCCMaper{
@Select("select * from xxx where id = #{id}")
CCC selectXXX(int id);
}
3,配置Mybatis配置表mybatis-config.xml
<mapper class="com.xxx.xxx.CCCMapper"/>
4,调用
@Test
public void findCCCById(){
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.selectXXX(1);
System.out.println(ccc.toString());
session.close();
}