<if test="passengerQuery.orderByColumn == null || passengerQuery.orderByColumn == ''||passengerQuery.ascDesc == null || passengerQuery.ascDesc == ''"> order by <if test="passengerQuery.samePhoneNumberTblScmPassengerIds != null and passengerQuery.samePhoneNumberTblScmPassengerIds.size>0"> CASE WHEN id in <foreach collection="passengerQuery.samePhoneNumberTblScmPassengerIds" item="itemCode" index="index" open="(" separator="," close=")"> #{itemCode} </foreach> </if> THEN 0 ELSE 1 END,b.handle_deadline asc,DATE_FORMAT(b.flight_date,'%Y-%m-%d') desc,convert(b.psg_name using gbk),b.id </if>这样写会报错吗?
时间: 2024-02-14 11:11:28 浏览: 31
这段代码存在一些问题,主要是if语句的嵌套和条件判断不完整。具体来说,if语句中缺少一个else分支,另外在第6行缺少一个关闭的标签。正确的代码如下:
```
<if test="passengerQuery.orderByColumn == null || passengerQuery.orderByColumn == ''||passengerQuery.ascDesc == null || passengerQuery.ascDesc == ''">
order by
<if test="passengerQuery.samePhoneNumberTblScmPassengerIds != null and passengerQuery.samePhoneNumberTblScmPassengerIds.size>0">
CASE WHEN id in
<foreach collection="passengerQuery.samePhoneNumberTblScmPassengerIds" item="itemCode" index="index" open="(" separator="," close=")">
#{itemCode}
</foreach>
END,
</if>
b.handle_deadline asc,
DATE_FORMAT(b.flight_date,'%Y-%m-%d') desc,
convert(b.psg_name using gbk),
b.id
</if>
```
这样修改后,就可以避免语法错误了。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)