现在需求就是根据司机id和查询不为出场的状态
查出该司机是否有派车的状态
这是sql
select (case when count(*)>0 then 1 else 0 end) as cnt
from t_c_msy_customer_send_car_detail
where driverId= '123' and currentState = 9
这是xml的
<select id="getDriverCarCount" resultType="java.lang.Boolean">
select (case when count(*)=0 then 1 else 0 end) as cnt from t_c_msy_customer_send_car_detail
where driverId= #{driverId} and currentState != 9
</select>