mybatis调用mysql 存储过程

1.创建存储过程

##V1.0,2019-10-18
DROP PROCEDURE IF EXISTS p_baoxiao_daishenpi ;
CREATE PROCEDURE p_baoxiao_daishenpi(comNum VARCHAR(50))
BEGIN
DECLARE userId INT;
SELECT User_ID INTO userId FROM UserT WHERE COM_NUM =comNum;
SELECT ab.id,ut.User_Name,ab.AMOUNT,app.PROJECT_NAME,ab.APPLY_DATE,ab.BILL_NUM,ab.CONTENT_ID FROM T_ACCOUNT_PREMISSION_ITEM tapi 
LEFT JOIN T_ACCOUNT_BASICINFO ab ON tapi.ITEM_ACCOUNT_ID=ab.ID 
LEFT JOIN UserT ut ON ab.APPLICANT=ut.User_ID 
LEFT JOIN T_ACCOUNT_PERMISSION_PROJECT app ON ab.ITEM_ID=app.ID  
WHERE TASK_USER=userId AND STATES=0 AND APPROVE_VALIDITY=1;
END;

2.mybatis配置文件

<resultMap id="DaishenpiFirst" type="mis.baoxiao.forms.DaishenpiFirstForm">
  <id column="id" jdbcType="INTEGER" property="id"></id>
  <result column="User_Name" jdbcType="VARCHAR" property="userName"></result>
  <result column="AMOUNT" jdbcType="FLOAT" property="amount"></result>
  <result column="PROJECT_NAME" jdbcType="VARCHAR" property="projectName"></result>
  <result column="APPLY_DATE" jdbcType="TIMESTAMP" property="applyDate"></result>
  <result column="BILL_NUM" jdbcType="VARCHAR" property="billNum"></result>
  <result column="CONTENT_ID" jdbcType="INTEGER" property="contentId"></result>
</resultMap>
<select id="searchBaoxiaoDaishenpiProcedure_First" parameterType="java.lang.String" resultMap="DaishenpiFirst" statementType="CALLABLE">
  <![CDATA[
      call p_baoxiao_daishenpi(#{comNum,mode=IN,jdbcType=VARCHAR});
      ]]>
</select>

3.调用

结果封装类：

package mis.baoxiao.forms;

public class DaishenpiFirstForm {
    //报销单id，报销人，报销金额，支出科目，申请日期，相关宴请金额，报销单号
    private Integer id;
    private String userName;
    private Float amount;
    private String projectName;
    private String applyDate;
    private String billNum;
    private Integer contentId;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public Float getAmount() {
        return amount;
    }

    public void setAmount(Float amount) {
        this.amount = amount;
    }

    public String getProjectName() {
        return projectName;
    }

    public void setProjectName(String projectName) {
        this.projectName = projectName;
    }

    public String getApplyDate() {
        return applyDate;
    }

    public void setApplyDate(String applyDate) {
        this.applyDate = applyDate;
    }

    public String getBillNum() {
        return billNum;
    }

    public void setBillNum(String billNum) {
        this.billNum = billNum;
    }

    public Integer getContentId() {
        return contentId;
    }

    public void setContentId(Integer contentId) {
        this.contentId = contentId;
    }
}

调用类
//输入参数：工号；输出：待审批列表,
// 显示字段：报销人，报销金额，支出科目，申请日期，报销单号，相关宴请金额，报销单号
@RequestMapping(value = "/searchBaoxiaoDaishenpiFormList",method = RequestMethod.POST)
public List<DaishenpiFirstForm> searchBaoxiaoDaishenpiFormList(@RequestParam String comNum){
    List<DaishenpiFirstForm> list= accountPremissionItemMapper.searchBaoxiaoDaishenpiProcedure_First(comNum);
    return list;
}