mybatis-plus如何重写sql多表联查及可以使用模糊查询

1、controller省略

2、创建一个包含你所需要所有字段的实体类

3. service层

=== 分页条件之前怎么写现在还怎么写！===

4 、dao层/mapper层

5、mapper层

  <resultMap id="ClazzMap" type="com.tenli.entity.Teachers">
      <id column="id" property="id"/>
      <result column="is_deleted" property="isDeleted"/>
  </resultMap>

<select id="selectAllTeacher" resultType="java.util.List" resultMap="ClazzMap">
     SELECT e.id, u.mobile,u.sex,u.age,e.career,e.is_deleted,e.intro,e.`name`,e.`level` from edu_teacher e,ucenter_member u where u.id=e.id
     <if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
       ****and  ${ew.sqlSegment}****模糊查询条件
     </if>
  </select>
  ```