mybatis 调用存储过程

写法1：exec

@Select("EXEC pro_out_report #{card},#{name},#{bithday} ")
String queryReportBy(@Param(value="card")String card,
@Param(value="name")String name,@Param(value="bithday")String bithday);

写法2：call

//@Options(statementType = StatementType.CALLABLE) 
@Select("{call pro_receive_sample(#{currentYear},#{deptId})}")
List<Map> proReceiveSample(String deptId, int currentYear);

注意：call调用的存储过程需要用花括号包围

顶

0