mybatis一对一关联查询

public class CardInfo implements java.io.Serializable{
    private int id;
    private String cardNumber;// 时长卡卡号
    private String password;// 卡密
    private int balance;// 此次充时长 单位:秒
    private int oldBalance;// 原余额 单位:秒
    private int nowBalance;// 现余额 单位:秒
    private String createCardTime;
    private String validity;// 有效期yyyy-MM-dd hh:mm:ss
    private String senderSysID;// 系统接入ID
    private String phoneNumber;// 手机号
    private String orderID;// 流水号
    private String token;// 动态令牌。在一定时期内生效，过期自动失效，需要重新鉴权。
    private int createCardCount;// 开卡次数
    private String standby;// 备用字段

    private ApAccount apAccount;

<resultMap type="com.wifiin.backend.wificard.model.CardInfo" id="cardInfo">
           <id property="id" column="id"/>
           <result property="cardNumber" column="card_number"/>
           <result property="password" column="password"/>
           <result property="balance" column="balance"/>
           <result property="oldBalance" column="old_balance"/>
           <result property="nowBalance" column="now_balance"/>
           <result property="createCardTime" column="create_card_time"/>
           <result property="validity" column="validity"/>
           <result property="senderSysID" column="sender_sys_id"/>
           <result property="phoneNumber" column="phone_number"/>
           <result property="orderID" column="order_id"/>
           <result property="token" column="token"/>
           <result property="standby" column="standby"/>
           <association property="apAccount" javaType="com.wifiin.backend.ap.model.ApAccount">
               <id property="id" column="id"/>  
            <result property="apid" column="apid"/>
            <result property="code" column="code"/>
            <result property="name" column="name"/>
            <result property="encryptedPassword" column="encrypted_password"/>
            <result property="os" column="os"/>
            <result property="concurrency" column="concurrency"/>
            <result property="priority" column="priority"/>
            <result property="priority2" column="priority"/>
            <result property="packageType" column="package_type"/>
            <result property="userCategory" column="user_category"/>
            <result property="nation" column="nation"/>
            <result property="province" column="province"/>
            <result property="city" column="city"/>
            <result property="accountVersion" column="account_version"/>
            <result property="accountType" column="account_type"/>
            <result property="consumedMinutes" column="consumed_minutes"/>
            <result property="distributedCount" column="distributed_count"/>
            <result property="failedCount" column="failed_count"/>
            <result property="lastReturnTime" column="last_return_time"/>
            <result property="currentConcurrency" column="current_concurrency"/>
            <result property="authRegion" column="auth_region"/>
            <result property="autoChangePassword" column="auto_change_password"/>
            <result property="nationStr" column="nation_name"/>
            <result property="provinceStr" column="province_name"/>
            <result property="cityStr" column="city_name"/>
            <result property="supplier" column="supplier"/>
            <result property="wlanMinutes" column="wlan_minutes"/>
            <result property="goUpTime" column="uptime"/>
            <result property="invalidTime" column="invalid_time"/>
            <result property="lastEditTime" column="last_edit_time"/>
            <result property="search" column="search"/>
        </association>
   </resultMap>

<select id="queryApaccountCardList" resultMap="cardInfo">
         select   
         card.create_card_time,
         card.card_number,
         card.password
         from wificard_card_info as card,
         ap_account as ap
         <where>
            <if test="beginCreateCardTime!=null">
                AND #{beginCreateCardTime} &lt;= card.create_card_time
            </if>
            <if test="endCreateCardTime!=null">
                AND  card.create_card_time &lt;=#{endCreateCardTime}
            </if>
            <if test="beginCardNumber!=null">
                AND #{beginCardNumber} &lt;=card.card_number
            </if>
            <if test="endCardNumber!=null">
                AND  card.card_number &lt;=#{endCardNumber}
            </if>
            <if test="cardNumber!=null">
                AND  card.card_number=#{cardNumber}
            </if>
            <if test="balance!=0">
                AND card.balance=#{balance}
            </if>
            <if test="apId!=-100">
                AND ap.apid=#{apId}
            </if>
            <if test="available!=-100">
                AND ap.available=#{available}
            </if>
            <if test="os!=-100">
                AND ap.os=#{os}
            </if>
            AND card.card_number=ap.name    
           </where>
           <!-- order by create_card_time DESC,balance DESC,card_number DESC
         limit #{start},#{size} -->
     </select>