方式1: 使用 sql语句 as的方法
<select id="getByFlightAll" resultType="com.shs.entity.FlightEntity">
select id as id,flight_id as flightId,company as company, departure_airport as departureAirport,arrive_airport as arriveAirport, departure_time as departureTime,arrive_time as arriveTime,model as model,is_delete as isDelete from shs_flight;
</select>
但是比较复杂,使用as更改
方式2:resultMap定义数据库表中字段名称与类中成员属性名称,使用关联映射
<resultMap id="FlightEntityMap" type="com.shs.entity.FlightEntity">
<id column="id" property="id"></id>
<result column="flight_id" property="flightId"></result>
<result column="departure_airport" property="departureAirport"></result>
<result column="departure_time" property="departureTime"></result>
<result column="arrive_time" property="arriveTime"></result>
<result column="model" property="model"></result>
<result column="is_delete" property="isDelete"></result>
</resultMap>