|  |  | 
 |  |  |     </select> | 
 |  |  |  | 
 |  |  |     <select id="selectJhyInfoList" resultType="com.xzx.gc.user.vo.JhyInfoListVo"> | 
 |  |  |         select * from xzx_jhy_info | 
 |  |  |         select *,CREATED_TIME createTime from xzx_jhy_info | 
 |  |  |         <where> | 
 |  |  |             1=1 | 
 |  |  |             <if test="record.name != null and record.name != ''"> | 
 |  |  |                 and (username like CONCAT(CONCAT(#{record.name}, '%'), '%') or phone=#{record.phone}) | 
 |  |  |             </if> | 
 |  |  |             <if test="record.isJhy != null and record.name != ''"> | 
 |  |  |             <if test="record.isJhy != null and record.isJhy != ''"> | 
 |  |  |                 and is_jhy=#{record.isJhy} | 
 |  |  |             </if> | 
 |  |  |             <if test="record.status != null"> |