mybatis实体类中的属性名和表中的字段名不一样的处理方法
法1:查询的sql语句中定义字段名的别名,让字段名的别名和实体类的属性名一致
entity:
class Order{
int id;
int orderno;
double price;
}
db:
table order(order_id,order_no,order_price)
sql:
<select id=”selectorder” parametertype=”int” resultetype=”me.gacl.domain.order”>
select order_id id, order_no orderno ,order_price price;
</select>
法2:映射字段名和实体类属性名
<select id=”selectorder” parametertype=”int” resultetype=”orderresultmap”>
select order_id id, order_no orderno ,order_price price;
</select>
<select id=”selectorder” parametertype=”int” resultetype=”me.gacl.domain.order”>
<id property=”id” column=”order_id”>
<result property=“orderno” column=”order_no”/>
</select>