MyBatis动态SQL小tips

来源：互联网发布：厦门关键词优化编辑：程序博客网时间：2024/05/18 01:06

  <!--待修复的任务/查询/模糊查询/按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()限制一下

0 0