mybatis,springcloud，使用存储过程删除关联用户的所有数据，关联批量删除

1.创建存储函数

CREATE DEFINER=`root`@`%` PROCEDURE `del_data_user`(phone varchar(20))
BEGIN
delete tt from `数据库1`.table_name1 tt,`数据库2`.table_name2 u where tt.user_id=u.user_id and u.mobile=phone;
delete  tt, t FROM `数据库1`.table_name1 u  LEFT JOIN `数据库2`.table_name2 t ON t.user_id=u.user_id  LEFT JOIN `数据库2`.table_name3 tt ON tt.w_id=t.id WHERE u.mobile=phone;
#删除多张关联表
delete tt,t1,t2,t3 from `数据库1`.table_name1 u LEFT JOIN `数据库2`.table_name2 tt on tt.user_id=u.user_id LEFT JOIN `数据库2`.table_name3 t1  ON t1.l_id=tt.l_id LEFT JOIN `数据库2`.table_name4 t2  ON t2.l_id=tt.l_id LEFT JOIN `数据库2`.table_name4 t3  ON t3.l_id=tt.l_id   where u.mobile=phone;
delete tt from `数据库1`.table_name1 tt,`数据库1`.table_name1 ui where tt.u_id = tt.u_id and ui.mobile = phone;
delete tt from  `数据库1`.table_name1 tt where tt.mobile = phone;
END

2.在mybais中调用存储函数

    /**
     * @param phone
     * @return
     */
    Boolean deleteMemberAll(@Param("phone") String phone);

3.在xml中调用

   <delete id="deleteMemberAll" statementType="CALLABLE" parameterType="java.lang.String">
        {
         call del_data_user_copy1 (
         #{phone,jdbcType=VARCHAR,mode=IN})
        }
    </delete>

或者直接用注解的方式

    @Delete("call del_data_user ( #{phone})")
@Options(statementType = StatementType.CALLABLE)
Integer deleteMemberAll(@Param("phone") String phone);

在mysql中调用存储函数

 call del_data_user ("173****124")