例：

很明显以上图片数据库的字段和实体类的属性并不一致！！！

解决方案一：使用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>