templates.mapper.MapperImpl.ftl Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of autoplsp Show documentation
Maven plugin to generate Java classes from StoredProcedure and Functions in Database
There is a newer version: 1.8.20
<#if header>
/*
 * Copyright (C) 2019 Yadickson Soto
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see .
 */

package ${javaPackage}.${repositoryFolderName};

<#if proc.hasInput>
import ${javaPackage}.${domainFolderName}.${proc.className}IN;

<#if proc.hasOutput>
import ${javaPackage}.${domainFolderName}.${proc.className}OUT;

<#list proc.parameters as parameter>
<#if parameter.resultSet || parameter.returnResultSet>
import ${javaPackage}.${domainFolderName}.${parameter.javaTypeName};


import ${javaPackage}.${repositoryFolderName}.sp.${proc.className}SP;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Repository;

<#if documentation>
/**
 * Mapper implementation for <#if proc.function>function<#else>stored procedure.
 *
 * ${proc.fullName}
 *
 * @author @GENERATOR.NAME@
 * @version @GENERATOR.VERSION@
 */

@Repository
@SuppressWarnings({"rawtypes", "unchecked", "deprecated"})
final class ${proc.className}MapperImpl implements ${proc.className}Mapper {

    private final ${proc.className}SP sp;

<#if documentation>
    /**
     * Setter for jdbcTemplate.
     *
     * @param pjdbcTemplate jdbcTemplate
     */

    public ${proc.className}MapperImpl(@Qualifier("${jdbcTemplate}") final ${proc.className}SP sp) {
        this.sp = sp;
    }

<#if documentation>
    /**
     * Execute stored procedure.
     *
     * <#if proc.hasInput>@param params input parameters
     * <#if proc.hasOutput>@return output parameters
     * @throws SQLException if error.
     */

    @Override
    public <#if proc.hasOutput>${proc.className}OUT<#else>void execute(<#if proc.hasInput>final ${proc.className}IN params) throws SQLException {

        java.util.Map mparams = new java.util.HashMap();
        <#if proc.hasOutput>
        java.util.Map r;
        

        try {
        <#list proc.inputParameters as parameter>
        <#if parameter.object || parameter.array>
            mparams.put("${parameter.prefix}${parameter.name}", params.get${parameter.propertyName}().processObject(org.springframework.jdbc.datasource.DataSourceUtils.getConnection(jdbcTemplate.getDataSource())));
        <#else>
            mparams.put("${parameter.prefix}${parameter.name}", params.get${parameter.propertyName} ());
        
        
        <#if !proc.hasOutput>
            this.sp.execute(mparams);
        } catch ( Exception ex ) {
            throw new java.sql.SQLException(ex);
        }
        
        <#if proc.hasOutput>
            r = this.sp.runExecute(mparams);
        } catch ( Exception ex ) {
            throw new java.sql.SQLException(ex);
        }

        java.util.Map m = evaluateResult(r);

        ${proc.className}OUT result = new ${proc.className}OUT();

        try {
        <#list proc.outputParameters as parameter>
        <#if parameter.clob >
            java.sql.Clob clob${parameter.propertyName} = ( java.sql.Clob ) m.get("${parameter.prefix}${parameter.name}");
            String string${parameter.propertyName} = null;

            if (clob${parameter.propertyName} != null) {
                java.io.Reader reader${parameter.propertyName} = clob${parameter.propertyName}.getCharacterStream();
                java.io.StringWriter writer${parameter.propertyName} = new java.io.StringWriter();
                org.apache.commons.io.IOUtils.copy(reader${parameter.propertyName}, writer${parameter.propertyName});
                string${parameter.propertyName} = writer${parameter.propertyName}.toString();
                clob${parameter.propertyName}.free();
            }

            result.set${parameter.propertyName}( string${parameter.propertyName} );
        <#elseif parameterblob >
            java.sql.Blob blob${parameter.propertyName} = ( java.sql.Blob ) m.get("${parameter.prefix}${parameter.name}");
            byte [] bytes${parameter.propertyName} = null;

            if (blob${parameter.propertyName} != null) {
                java.io.InputStream input${parameter.propertyName} = blob${parameter.propertyName}.getBinaryStream();
                java.io.ByteArrayOutputStream output${parameter.propertyName} = new java.io.ByteArrayOutputStream();
                org.apache.commons.io.IOUtils.copy(input${parameter.propertyName}, output${parameter.propertyName});
                bytes${parameter.propertyName} = output${parameter.propertyName}.toByteArray("${encode}");
                blob${parameter.propertyName}.free();
            }

            result.set${parameter.propertyName}( bytes${parameter.propertyName} );
        <#elseif parameter.resultSet || parameter.returnResultSet>
            result.set${parameter.propertyName}((java.util.List<${parameter.javaTypeName}>) m.get("${parameter.prefix}${parameter.name}"));
        <#else>
            result.set${parameter.propertyName}((${parameter.javaTypeName}) m.get("${parameter.prefix}${parameter.name}"));
        
        
        } catch ( Exception ex ) {
            throw new java.sql.SQLException(ex);
        }

        return result;
        
    }
    <#if proc.hasOutput>

<#if documentation>
    /**
     * Evaluate output parameters from database.
     *
     * @param result map to evaluate.
     * @throws SQLException if error.
     */

    private java.util.Map evaluateResult(final java.util.Map result) throws SQLException {

        if (result == null) {
            return null;
        }
        <#list proc.outputParameters as parameter>
          <#if parameter.number && (parameter.position > 0) && parameter.name == outParameterCode >
          <#assign pCode="${parameter.name}">
          
        
        <#list proc.outputParameters as parameter>
          <#if parameter.string && (parameter.position > 0) && parameter.name == outParameterMessage >
          <#assign pMessage="${parameter.name}">
          
        
        <#if pCode?? && pMessage?? >

        Number code;
        String description;
        int val;

        try {
            code = (Number) result.get("${pCode}");
            description = (String) result.get("${pMessage}");
            val = code.intValue();
        } catch ( Exception ex ) {
            throw new java.sql.SQLException(ex);
        }

        if (val != 0) {
            throw new java.sql.SQLException(description, null, val);
        }
        

        return result;
    }
    
}