package com.bird.mybatis.dao;
import com.bird.mybatis.bean.Employee;
public interface EmployeeMapper {
 public Employee getEmpById(Integer id); 
}

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 
<!-- namespace:名稱空間(若使用接口式編程,與EmployeeMapper接口全類名一致)
 id:唯一標(biāo)識(shí)(與接口中的方法名對(duì)應(yīng))
 resultType:返回值類型(與對(duì)應(yīng)方法的返回值對(duì)應(yīng))
 #{id}:從傳遞過來的參數(shù)中取出id值
 -->
<mapper namespace="com.bird.mybatis.dao.EmployeeMapper">
 <select id="getEmpById" resultType="com.bird.mybatis.bean.Employee"> 
  select id,last_name lastName,gender,email from tbl_employee where id = #{id}
 </select>
</mapper>

/**
  * MyBatis接口編程
  * @throws IOException 
  */
 @Test
 void test2() throws IOException {
  //獲取sqlSessionFactory對(duì)象
  SqlSessionFactory ssf = getSqlSessionFactory();
  //獲取sqlSession對(duì)象
  SqlSession openSession = ssf.openSession();
  try {
   //獲取接口的實(shí)現(xiàn)類對(duì)象
   EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
   Employee empById = mapper.getEmpById(1);
   System.out.println(empById);
  }finally {
   openSession.close();
  }
 }
 
 /**
  * 獲取sqlSessionFactory對(duì)象
  * @throws IOException 
  */
 public static SqlSessionFactory getSqlSessionFactory() throws IOException {
  String resource = "mybatis-config.xml";
  InputStream is = Resources.getResourceAsStream(resource);
  return new SqlSessionFactoryBuilder().build(is);
 }