Mybatis当数据库属性名字和java对象属性名字不一样时，2种查询方法

第一种&＃xff1a;
mapper文件的配置

<resultMap id&＃61;"GetMap" type&＃61;"org.example.Entity.Student"><id column&＃61;"id" property&＃61;"Sid"/><result column&＃61;"name" property&＃61;"Sname"/><result column&＃61;"email" property&＃61;"Semail"/><result column&＃61;"age" property&＃61;"Sage"/>resultMap>
<select id&＃61;"SelAllStu" resultMap&＃61;"GetMap">select id,name,email,age from studentselect>


其余的东西都不变&＃xff0c;和编写一般的查询一样
第二种&＃xff1a;
直接在列名后加as别名&＃xff0c;也能达到查询效果

<select id&＃61;"selAll" resultType&＃61;"org.example.Entity.NStudent">select id as Sid,name as Sname,email as Semail,age as Sage from studentselect>