Mybatis关于动态排序#{}${}问题

<if test="orderField !=null and orderField != '' ">
    order by t.#{orderField}  #{orderType}
</if>

<if test="orderField !=null and orderField != '' ">
    order by t.${orderField}  ${orderType}
</if>

import com.fasterxml.jackson.annotation.JSONFORMat;
import com.fasterxml.jackson.annotation.jsonIgnore;
import java.io.Serializable;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;


public class BaseEntity implements Serializable
{
    private static final long serialVersionUID = 1L;

    
    private String orderField;

    
    private String orderType;

    
    private String searchValue;

    
    private String createBy;

    
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    
    private String updateBy;

    
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date updateTime;

    
    private String remark;

    
    @JsonIgnore
    private String beginTime;

    
    @JsonIgnore
    private String endTime;

    
    private Map<String, Object> params;
}


@Entity
@Getter
@Setter
@Table(name = "tb_director")
public class Director extends BaseEntity {
    
     
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
   
     
    @Column(name = "director_name", unique = true)
    private String directorName;

    
    @Column(name = "director_adress", unique = true)
    private String directorAdress;
}

  <!-- 查询店长信息 -->
  <sql id="selectDirectorVo">
     select id, director_name,director_adress,director_num,director_create_time,director_up_time,openId
         from tb_director
  </sql>
  <!-- 查询条件 -->
  <sql id="sqlwhereSearch">
         <where>
             <if test="directorName !=null and directorName !=''">
                      AND director_name like concat('%', #{directorName}, '%')
             </if>
             <if test="openId !=null and openId !=''">
                      AND openId=#{openId}
            </if>
                <if test="id !=null and id !=''">
                      AND id=#{id}
            </if>
            <if test="beginTime != null and beginTime != ''"><!-- 开始时间检索 -->
                      AND date_format(directorCreateTime,'%y%m%d') &gt;= date_format(#{beginTime},'%y%m%d')
            </if>
            <if test="endTime != null and endTime != ''"><!-- 结束时间检索 -->
                      AND date_format(directorCreateTime,'%y%m%d') &lt;= date_format(#{endTime},'%y%m%d')
            </if>
            </where>
            <!-- 根据传入字段动态过滤 -->
            <if test="orderField !=null and orderField != '' ">
                        order by ${orderField}  ${orderType}
            </if>
        </sql>
  <!-- 根据条件查询店长 -->
  <select id="sel" parameterType="Director" resultMap="DirectorResult">
                <include refid="selectDirectorVo"/>
                <include refid="sqlwhereSearch"/>
        </select>

<if test="orderField !=null and orderField != '' ">
    order by
    <choose>
        <when test="orderField == 'directorName'">
            director_name ${orderType}
        </when>
        <when test="orderField == 'openId'">
            openId ${orderType}
        </when>
        <otherwise>
            create_time ${orderType}
        </otherwise>
    </choose>
</if>