1、在sql语句中使用列的别名
比如:select order_id id,orderNo orderno ,order_price price from order where order_id = #{id}
2、使用resultMap处理
<select id="findAllOrders2" resultMap="findAllOrders2Map">
select * from orders
</select>
<resultMap type="Orders" id="findAllOrders2Map">
<id property="id" column="order_id"/>
<result property="orderNo" column="order_no"/>
<result property="price" column="order_price"/>
</resultMap>
resultMap子节点中id为表的主键,result为普通列