mybatis之接口编程(2)

1.创建接口

EmploeeMapper


public interface EmploeeMapper {
public Employee getEmpById(Integer id);
}


2.绑定

• 1.EmployeeMapper.xml的namespace指定为接口的全类名字
• 2.select的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">
<mapper namespace="com.cbf.dao.EmploeeMapper">
<select id="getEmpById" resultType="com.cbf.bean.Employee">
select id,last_name lastName,email, gander from tb_employee where id = #{id}
</select>
</mapper>


3. 测试


SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
SqlSession openSession = sqlSessionFactory.openSession();
try {
EmploeeMapper mapper = openSession.getMapper(EmploeeMapper.class);
Employee employee = mapper.getEmpById(1);
System.out.print(employee);
} finally {
openSession.close();
}


下载地址：https://download.csdn.net/download/myheartmylove/10277695