springboot整合mybatis取别名的问题

用了很久的boot，结果因为一个别名纠结了半个小时，我要来记录一下这个简单的问题

正常情况下，在mapper.xml文件中是不允许使用别名的，resultType与resultMap中默认填写的必须是全限定类名，像这样

  <resultMap id="BaseResultMap" type="com.example.manager.model.Tb_prj" >
    <id column="prj_id" property="prjId" jdbcType="INTEGER" />
    <result column="prj_name" property="prjName" jdbcType="VARCHAR" />
    <result column="prj_startDate" property="prjStartdate" jdbcType="DATE" />
    <result column="prj_endDate" property="prjEnddate" jdbcType="DATE" />
    <result column="prj_manger" property="prjManger" jdbcType="VARCHAR" />
    <result column="prj_schedule" property="prjSchedule" jdbcType="INTEGER" />
  </resultMap>  

<select id="selectAll" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from tb_prj;
  </select>

  <select id="selectAll2" resultType="com.exmaple.manager.Tb_prj">
    select
    <include refid="Base_Column_List" />
    from tb_prj;
  </select>

如果想使用别名的话首先需要在application.properties中配置

#起别名，扫描配置需要取别名的包
mybatis.type-aliases-package=com.example.manager.model

其实这个时候就可以使用mybatis默认的别名，首字母小写全拼，但是如果需要完全自定义别名，可以在需要取别名的bean的上面加@Alias注解，像这样

@Component
@Alias("tb_prjsss")
public class Tb_prj {
    private Integer prjId;

    private String prjName;

    private Date prjStartdate;

    private Date prjEnddate;

    private String prjManger;

    private Integer prjSchedule;

    public Integer getPrjId() {
        return prjId;
    }

    public void setPrjId(Integer prjId) {
        this.prjId = prjId;
    }

    public String getPrjName() {
        return prjName;
    }

    public void setPrjName(String prjName) {
        this.prjName = prjName;
    }

    public Date getPrjStartdate() {
        return prjStartdate;
    }

    public void setPrjStartdate(Date prjStartdate) {
        this.prjStartdate = prjStartdate;
    }

    public Date getPrjEnddate() {
        return prjEnddate;
    }

    public void setPrjEnddate(Date prjEnddate) {
        this.prjEnddate = prjEnddate;
    }

    public String getPrjManger() {
        return prjManger;
    }

    public void setPrjManger(String prjManger) {
        this.prjManger = prjManger;
    }

    public Integer getPrjSchedule() {
        return prjSchedule;
    }

    public void setPrjSchedule(Integer prjSchedule) {
        this.prjSchedule = prjSchedule;
    }

    @Override
    public String toString() {
        return "Tb_prj{" +
                "prjId=" + prjId +
                ", prjName='" + prjName + '\'' +
                ", prjStartdate=" + prjStartdate +
                ", prjEnddate=" + prjEnddate +
                ", prjManger='" + prjManger + '\'' +
                ", prjSchedule=" + prjSchedule +
                '}';
    }
}

配置了完这两个就可以在mapper.xml文件中使用完全自定义的别名了

<select id="selectAll" resultType="tb_prjsss">
    select
    <include refid="Base_Column_List" />
    from tb_prj;
  </select>