<!--查询日期表记录--> <!--<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>