mycat是不支持多表联合删除的 ,如下面语句
<delete id="orderOTDelete" parameterType="java.util.Date">
delete from t_order ,t_order_item
where t_order.order_time < #{oTime}
</delete>
所以就想到先将时间达到规定删除的数据的id查询出来,再分别删除两张表中对应id的数据
String orderId = applicationContext.getBean(orderMapper.class).DeleteFindOrderId(oTime);
applicationContext.getBean(orderMapper.class).DeleteOrderByOrderIdFrom_t_order(orderId);
applicationContext.getBean(orderMapper.class).DeleteOrderByOrderIdFrom_t_order_item(orderId);
xml语句
<select id="DeleteFindOrderId" parameterType="java.util.Date" resultType="java.lang.String">
select order_id from t_order where t_order.order_time < #{oTime};
</select>
<delete