mybatis如何把结果集映射成java类型

mybatis如何把结果集映射成java类型

1.需求：还是差些emp表，但是Emp类的属性名称与emp表的字段名称不同
实体类：

package com.abc.mybatis.domain;

import java.util.Date;

public class Emp {
	
	/** 属性名称与表中字段名称不对应*/
	private Integer empnos;
	private String enames;
	private Double sals;
	private Date hiredates;
	private String jobs;
	public Integer getEmpnos() {
		return empnos;
	}
	public void setEmpnos(Integer empnos) {
		this.empnos = empnos;
	}
	public String getEnames() {
		return enames;
	}
	public void setEnames(String enames) {
		this.enames = enames;
	}
	public Double getSals() {
		return sals;
	}
	public void setSals(Double sals) {
		this.sals = sals;
	}
	public Date getHiredates() {
		return hiredates;
	}
	public void setHiredates(Date hiredates) {
		this.hiredates = hiredates;
	}
	public String getJobs() {
		return jobs;
	}
	public void setJobs(String jobs) {
		this.jobs = jobs;
	}
	@Override
	public String toString() {
		return "Emp [empnos=" + empnos + ", enames=" + enames + ", sals=" + sals + ", hiredates=" + hiredates
				+ ", jobs=" + jobs + "]\n";
	}
	
	

}

我们看如何解决？

第一种解决方案：

给sql语句的查询列取个别名，别名与emp类的属性名对应
例：

public interface EmpMapper {
	public List<Emp> queryAll();
}

<select id="queryAll" resultMap="empMap">
	select empno empnos,ename enames,sal sals,
	hiredate hiredates,job jobs from emp
</select>

第二种解决方案：

<?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.abc.mybatis.mapper.EmpMapper">
	
	
	<!-- public List<Emp> queryAll();
	 -->
	 <select id="queryAll" resultMap="empMap">
	 <!-- select empno empnos,ename enames,sal sals,hiredate hiredates,job jobs from emp -->
	 select empno,ename,sal,hiredate,job from emp
	 </select>
	 
	 <resultMap type="Emp" id="empMap">
	 
	 	<id column="empno" property="empnos"/>
	 	<result column="ename" property="enames"/>
	 	<result column="sal" property="sals"/>
	 	<result column="hiredate" property="hiredates"/>
	 	<result column="job" property="jobs"/>
	 
	 </resultMap>
</mapper>

测试类

import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.abc.mybatis.domain.Emp;
import com.abc.mybatis.mapper.EmpMapper;

public class Test1 {

	public static void main(String[] args)throws Exception {
		// 初始化sqlSessionFactory
		InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
		SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(is);
		//初始化SqlSession
		SqlSession sqlSession=sessionFactory.openSession();
		
		EmpMapper mapper=sqlSession.getMapper(com.abc.mybatis.mapper.EmpMapper.class);
		
		List<Emp> emps=mapper.queryAll();
		
		System.out.println(emps.toString());
	}

}