当表字段于实体属性不一致时,则映射失败,值无法注入,因为orm就来解决这个问题
两个方法:设置别名与结果映射
设置别名
dao层语句
//取别名
public List<Manager> selectAll();
mapper语句
<select id="selectAll" resultType="manager">
select mgr_id id,mgr_name name,mgr_pwd pwd from t_manager
</select
测试层语句
ManagerDao managerDao = MyBatisUtils.getMapper(ManagerDao.class);
List<Manager> managers = managerDao.selectAll();
结果映射
dao层语句
//结果映射
public List<Manager> selectAllOrm();
mapper语句
<resultMap id="rm" type="manager">
<id property="id" column="mgr_id"></id>
<result property="name" column="mgr_name"></result>
<result property="pwd" column="mgr_pwd"></result>
</resultMap>
<select id="selectAllOrm" resultMap="rm">
select * from t_manager
</select>
测试层语句
List<Manager> orm = managerDao.selectAllOrm();
System.out.println(orm);