MyBatis动态SQL小tips

  <!--待修复的任务/查询/模糊查询/按companyId查询-->
  <select id="needRepairLikeQuery_listPage" parameterType="page" resultType="pd">
    SELECT
    cl.id AS id,
    cl.col_borrowerName AS colBorrowername,
    cl.col_borrowerIdcard AS colBorroweridcard,
    cl.qq AS qq,
    cl.phone AS phone,
    cc.com_name AS comName,
    ci.down_report_count AS downReportCount
    FROM
    com_customer_company_c_index AS ci INNER JOIN col_loan AS cl ON cl.id = ci.clid
    INNER JOIN com_company AS cc ON cl.col_company =cc.com_id
    <if test="pd.search != null and pd.search.length()>0">
      WHERE cl.col_borrowerName LIKE '%${pd.search}%' OR
      cl.col_borrowerIdcard LIKE '%${pd.search}%' OR
      cl.phone LIKE '%${pd.search}%'
    </if>
    <if test="pd.companyId!=null and pd.companyId != '-1'">
      AND
      cl.col_company = '${pd.companyId}'
    </if>
    AND
    cl.col_status = 0
    ORDER BY cl.id DESC
  </select>

1/<if test="">中的多条件用and/or链接而非&&\||

2/有时候""是不等于null的,用String的.length()限制一下