使用ibatis自定义排序sql，在java设置排序字段

1.排序使用自动生成PO
service实现层：
public List<Sd3pBusinessCooperationPO> getSd3pBusinessCooperationList() {
Sd3pBusinessCooperationExample example = new Sd3pBusinessCooperationExample();
example.createCriteria().andDelFlagIsNotNull().andDelFlagEqualTo("1").andBusinessTypeEqualTo(SdCommonCode.BUSINESS_TYPE_B);
example.setOrderByClause(" VENDER_NAME ");
List<Sd3pBusinessCooperationPO> sd3pBusinessCooperationList = sd3pBusinessCooperationDAO.selectByExample(example);
return sd3pBusinessCooperationList;
DAO实现层：
public List selectByExample(Sd3pBusinessCooperationExample example) {
List list = getSqlMapClientTemplate().queryForList("SD_3P_BUSINESS_COOPERATION.abatorgenerated_selectByExample", example);
return list;
}
SQL语句：
<select id="abatorgenerated_selectByExample" parameterClass="com.coo8.erp.sd.app.sdthirdparty.model.po.Sd3pBusinessCooperationExample" resultMap="abatorgenerated_Sd3pBusinessCooperationResult">
select VENDER_ID, VENDER_NAME, NICK_NAME, VENDER_SECRET, INVOICE_TYPE, BUSINESS_TYPE, DEL_FLAG,
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3
from SD_3P_BUSINESS_COOPERATION
<isParameterPresent>
<include refid="SD_3P_BUSINESS_COOPERATION.abatorgenerated_Example_Where_Clause" />
<isNotNull property="orderByClause">
order by $orderByClause$
</isNotNull>
</isParameterPresent>
</select>