例:
很明显以上图片数据库的字段和实体类的属性并不一致!!!
解决方案一:使用as关键字起别名
<sql id="Base_Column_List">
<!-- 数据库种表的字段 as 实体类属性-->
uid as id, userName as name, age as age,
email as email, create_time as createTime,
update_time as updateTime, is_deleted as deleted
</sql>
解决方案一:使用resultMap标签映射
<!-- type:指定需要映射的实体类 -->
<resultMap id="userMap" type="User">
<!-- column:数据库表中的字段名 -->
<!-- property:实体类中的属性 -->
<id column="uid" property="id" />
<result column="userName" property="name" />
<result column="age" property="age" />
<result column="email" property="email" />
<result column="create_time" property="createTime" />
<result column="update_time" property="updateTime" />
<result column="is_deleted" property="deleted" />
</resultMap>
<select id="getUserList" resultMap="userMap">
select uid,userName,age,email,create_time,update_time,is_deleted from t_user;
</select>