先得弄一个bean
public class PersonnelBasicresumeVo {
private String id;
private String personName;
private String sex;
private String identifyNum;
private String phoneNumber;
private String workMethod;
private String email;
private String highestEducation;
起别名
<resultMap id="BaseResultMap_selectResume" type="com.chinacreator.c2.lhyg.positionManagement.entity.PersonnelBasicresumeVo">
<id column="ID" jdbcType="VARCHAR" property="id" />
<result column="PERSON_NAME" jdbcType="VARCHAR" property="personName" />
<result column="SEX" jdbcType="VARCHAR" property="sex" />
<result column="IDENTIFY_NUM" jdbcType="VARCHAR" property="identifyNum" />
<result column="PHONE_NUMBER" jdbcType="VARCHAR" property="phoneNumber" />
</resultMap>
<!-- 热点简历 -->
<select id="selectResume" resultMap="BaseResultMap_selectResume" useCache="false" flushCache="true">
select * from
lhyg_personnel_basicresume a
LEFT JOIN lhyg_personnel_workexperience b on b.RESUME_ID= a.id
</select>
返回结果
public List<Map<String,Object>> selectHotRecruitment() {
String sql="com.chinacreator.c2.lhyg.positionManagement.entity.PositionManagementMapper.selectHotRecruitment";
List<Map<String,Object>> selectList = DaoFactory.create(PositionManagement.class).getSession().selectList(sql,Map.class);
return selectList;
}