MyBatis 存储过程

龙贝子

已于 2023-02-20 14:14:45 修改

阅读量449

点赞数

分类专栏： JAVA 文章标签： mybatis mybatisPlus

于 2023-02-20 14:13:04 首次发布

本文链接：https://blog.csdn.net/qq_30624649/article/details/129123256

版权

在mybatis中调用存储过程

1.创建EnvironmentUpMapper.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cloudtop.core.service.EnvironmentUpService">
    <!-- 上报年度报告封面及扉页数据   存储过程的名字sel_analyze_post_login_info-->
    <select id="ReportCoverAndTitleData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.sel_analyze_post_login_info(#{loginName,mode=IN},#{loginPassword,mode=IN})} where "rrId"=#{rrId}
    </select>
    <!--上报专业名词及术语解释数据-->
    <select id="ReportNounExplanationData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from environment.api_noun_explanation(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报关键环境信息提要数据-->
    <select id="ReportEnvironmentalInfoData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from environment.api_key_environmental_info(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报企业基本信息数据-->
    <select id="ReportEnterpriseInfoData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.api_enterprise_info(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报生产工艺和产品信息数据-->
    <select id="ReportProductionInfoData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.api_production_info(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报企业生态环境行政许可情况数据-->
    <select id="ReportAdministrativeLicenseInfoData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.api_api_administrative_license_info_info(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报环境保护税数据-->
    <select id="ReportProtectionTaxPaymentData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.api_protection_tax_payment(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}
    </select>
    <!--上报环境污染责任保险数据-->
    <select id="ReportEnvironmentInsureListData" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
        select * from  environment.api_insurance_info(#{inBachId,mode=IN},#{inReportType ,mode=IN}) where "rrId"=#{rrId}