ibatis的resultClass

今天在敲代码的时候，写了个resultClass，发现执行sql语句的时候，有些字段是查不出来的，查找之后发现是sql返回的字段和我写的bean里面的字段不统一导致的。

 

ReserveModel：

 private Integer roomBookId;
 public String bookUserName;
 private Integer roomId;
 private String roomName;
 private String bookDay;
 private String bookTimeStart;
 private String bookTimeEnd;
 private Integer bookTimeStartId;
 private Integer bookTimeEndId;

 

sql語句中：

<select id="queryReserveByRid" resultClass="reserve"
  parameterClass="java.lang.Integer">
        <![CDATA[
            SELECT S3.rid as roomBookId,S3.roomid,S1.roomname,S3.starttimeId as bookTimeStartId,
            S3.endtimeId as bookTimeEndId,S2.detial as bookTimeStart,S4.detial as bookTimeEnd,S3.bookday
             FROM yy.mroom S1,yy.time S2,yy.reserve S3,yy.time S4 where S1.roomid=S3.roomid and S2.tid=S3.starttimeId
             and S4.tid=S3.endtimeId and S3.rid = #roomBookId#
        ]]>
 </select>

 

主要还是之前数据库设计的不好，字段名称不够统一。如果没有加上标记为红色的那些字段的话，model里面的getter、setter方法不能进行赋值。