在helloworld的基础上,有几点变更:
创建一个接口
public interface EmployeeMapper {
public Employee
getEmpById(Integer id);
}
修改EmployeeMapper.xml配置文件
<mapper namespace=
"com.stayreal.mybatis.EmployeeMapper">
<
select id=
"getEmpById" resultType=
"com.stayreal.mybatis.Employee">
select id,last_name lastname,email,gender
from tbl_employee
where id =
#{id}
</
select>
</mapper>
junit测试
@Test
public void testLoad2()
throws IOException {
session = sqlSessionFactory.openSession();
EmployeeMapper employeeMapper = session.getMapper(EmployeeMapper.class);
Employee employee = employeeMapper.getEmpById(
1);
System.out.println(employee.toString());
}