MyBatis-映射文件04-查询返回不同类型的结果
1.返回一个JavaBean对象
接口方法:
public Employee getEmpById(Integer id);
sql映射:
<select id="getEmpById" resultType="com.mybatis.bean.Employee">
select id,last_name,email,gender from tbl_employee where id = #{id}
</select>
Test方法:
EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
Employee employee = mapper.getEmpByIdAndLastname(1, "Tom");
System.out.println(employee