存储过程编写和调用

<!--查询日期表记录-->
    <!--<select id="selectTransFlowByDay" resultType="com.test.bank.pojo.data.TransFlow">
        create procedure p11(IN tb varchar(25),transdt varchar(25))
        begin
        set @sqlStr=concat('select
        term_ip,
        device_id,
        dept_card_no,
        qr_code from ',tb,' where trans_dt=',transdt);
        PREPARE stmt from @sqlStr ;
        EXECUTE stmt ;
        end;
</select>-->

<delete id="deleteProcedure"  parameterType="java.lang.Object">
     DROP PROCEDURE IF EXISTS p11;
</delete>
   <!-- /*{call p10(#{tb},#{transdt})}*/-->
<select id="selectExec" resultType="com.test.bank.pojo.data.TransFlow" parameterType="java.lang.Object" statementType="CALLABLE">
   {call p11(#{transdt})}
</select>