• Home
• com.base4j
• base4j-mybatis
• 1.3.0
• source code
• oracle.ftl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.base4j.mybatis.sql.template.ftl.oracle.ftl Maven / Gradle / Ivy

<#if cache?? && cache == "MYBATIS">
    


    
    <#list entityClassColumns as column>
        <#if column.id>
            jdbcType="${column.jdbcTypeName}"
                property="${column.property}"/>
        
    
    <#list entityClassColumns as column>
        <#if !column.id>
            jdbcType="${column.jdbcTypeName}"
                    property="${column.property}"/>
        
    
    <#list mybatisAssociations as association>
        
            <#list association.resultMap as result>
                <#if result.id>
                    jdbcType="${result.jdbcTypeName}"
                        property="${result.property}"/>
                
            
            <#list association.resultMap as result>
                <#if !result.id>
                    jdbcType="${result.jdbcTypeName}"
                            property="${result.property}"/>
                
            
        
    
    <#list mybatisConnections as connection>
        
            <#list connection.resultMap as result>
                <#if result.id>
                    jdbcType="${result.jdbcTypeName}"
                        property="${result.property}"/>
                
            
            <#list connection.resultMap as result>
                <#if !result.id>
                    jdbcType="${result.jdbcTypeName}"
                            property="${result.property}"/>
                
            
        
    
    

    
        
            
                
                    select SEQ_${name}_ID.NEXTVAL as ID from DUAL
                
                
                <#list entityClassPKColumns as column>
                    select ${r'#{'}${column.property}<#if column.jdbcTypeName??>
                    ,jdbcType=${column.jdbcTypeName}${r'}'} as ID from DUAL
                
                
            
        

        insert into ${name}

        
        <#list entityClassColumns as column>
            <#if column.id>
            ${column.column},
            <#else>
                
                ${column.column},
                
            
        
        
        
        <#list entityClassColumns as column>
            <#if column.id>
                
                ${r'#{'}${column.property}<#if column.jdbcTypeName??>, jdbcType=${column.jdbcTypeName}${r'}'},
                
            <#else >
                
                ${r'#{'}${column.property}<#if column.jdbcTypeName??>, jdbcType=${column.jdbcTypeName}${r'}'},
                
            
        
        
    

    
        
        INSERT ALL
        
            INTO ${name}
            
            <#list entityClassColumns as column>
                
                    ${column.column},
                
            
            
            VALUES
            
            <#list entityClassColumns as column>
                
                    ${r'#{'}record.${column.property}<#if column.jdbcTypeName??>, jdbcType=${column.jdbcTypeName}${r'}'},
                
            
            
        
        SELECT 1 FROM DUAL
    

    
        update ${name}
        
        <#list entityClassColumns as column>
            <#if !column.id>
            ${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
                jdbcType=${column.jdbcTypeName}${r'}'},
            
        
        
        
        <#list entityClassPKColumns as column>
        ${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
            jdbcType=${column.jdbcTypeName}${r'}'} and
        
        
    

    
        update ${name}
        
        <#list entityClassColumns as column>
            <#if !column.id>
                
                ${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
                    jdbcType=${column.jdbcTypeName}${r'}'},
                
            
        
        
        
        <#list entityClassPKColumns as column>
        ${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
            jdbcType=${column.jdbcTypeName}${r'}'} and
        
        
    

    
        update ${name}
        
        <#list entityClassColumns as column>
            <#if !column.id>
            ${column.column} = ${r'#{record.'}${column.property}<#if column.jdbcTypeName??>
                ,jdbcType=${column.jdbcTypeName}${r'}'},
            
        
        
        
            
                
                    
                        
                            
                                
                                    
                                        and ${r'${criterion.condition}'}
                                    
                                    
                                        and ${r'${criterion.condition} #{criterion.value}'}
                                    
                                    
                                        and ${r'${criterion.condition} #{criterion.value} and #{criterion.secondValue}'}
                                    
                                    
                                        and ${r'${criterion.condition}'}
                                        
                                        ${r'#{listItem}'}
                                        
                                    
                                
                            
                        
                    
                    
                        1 = -1
                    
                
            
        
        
            
                1 = -1
            
        

    

    
        
            update ${name}
            
            <#list entityClassColumns as column>
                
                ${column.column} = ${r'#{record.'}${column.property}<#if column.jdbcTypeName??>,
                    jdbcType=${column.jdbcTypeName}${r'}'},
                
            
            
            
                
                    
                        
                            
                                
                                    
                                        
                                            and ${r'${criterion.condition}'}
                                        
                                        
                                            and ${r'${criterion.condition} #{criterion.value}'}
                                        
                                        
                                            and ${r'${criterion.condition} #{criterion.value} and #{criterion.secondValue}'}
                                        
                                        
                                            and ${r'${criterion.condition}'}
                                            
                                            ${r'#{listItem}'}
                                            
                                        
                                    
                                
                            
                        
                        
                            1 = -1
                        
                    
                
            
            
                
                    1 = -1
                
            
        
    

    
        delete from ${name}
        
        <#list entityClassPKColumns as column>
        ${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
            jdbcType=${column.jdbcTypeName}${r'}'} and
        
        
    

    
        delete from ${name}
        
            
                
                    
                    
                
            
        
        
            
                1 = -1
            
        
    

    
        select
        
        <#list entityClassColumns as column>
        ${name}.${column.column},
        
        
        from ${name}
        
        <#list entityClassPKColumns as column>
        ${name}.${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
            jdbcType=${column.jdbcTypeName}${r'}'} and
        
        
    

    
        select
        
        <#list entityClassColumns as column>
        ${name}.${column.column},
        
        <#list mybatisAssociations as association>
            <#list association.resultMap as result>
            ${association.property}.${result.column} as ${association.property}_${result.column},
            
        
        <#list mybatisConnections as connection>
            <#list connection.resultMap as result>
            ${connection.property}.${result.column} as ${connection.property}_${result.column},
            
        
        
        from ${name}
    <#list mybatisAssociations as association>
    ${association.joinCondition}
    
    <#list mybatisConnections as connection>
    ${connection.joinCondition}
    
        
        <#list entityClassPKColumns as column>
        ${name}.${column.column} = ${r'#{'}${column.property}<#if column.jdbcTypeName??>,
            jdbcType=${column.jdbcTypeName}${r'}'} and
        
        
    

    
        select
        
            
                ${name}
                    .${r'${selectColumn}'}
            
            
                
                <#list entityClassColumns as column>
                ${name}.${column.column},
                
                
            
        
        from ${name}
        
            
                
                    
                
            
            
                ORDER BY ${r'${orderByClause}'}
            
        
    

    
        select
        
            
                ${name}
                    .${r'${selectColumn}'}
            
            
                
                <#list entityClassColumns as column>
                ${name}.${column.column},
                
                <#list mybatisAssociations as association>
                    <#list association.resultMap as result>
                    ${association.property}.${result.column} as ${association.property}_${result.column},
                    
                
                <#list mybatisConnections as connection>
                    <#list connection.resultMap as result>
                    ${connection.property}.${result.column} as ${connection.property}_${result.column},
                    
                
                
            
        
        from ${name}
        <#list mybatisAssociations as association>
        ${association.joinCondition}
        
        <#list mybatisConnections as connection>
        ${connection.joinCondition}
        
        
            
                
                    
                
            
            
                ORDER BY ${r'${orderByClause}'}
            
        
    

    
        select distinct
        
            
                ${name}
                    .${r'${selectColumn}'}
            
            
                
                <#list entityClassColumns as column>
                ${name}.${column.column},
                
                
            
        
        from ${name}
        
            
                
                    
                
            
        
    

    
        select distinct
        
            
                ${name}
                    .${r'${selectColumn}'}
            
            
                
                <#list entityClassColumns as column>
                ${name}.${column.column},
                
                <#list mybatisAssociations as association>
                    <#list association.resultMap as result>
                    ${association.property}.${result.column} as ${association.property}_${result.column},
                    
                
                <#list mybatisConnections as connection>
                    <#list connection.resultMap as result>
                    ${connection.property}.${result.column} as ${connection.property}_${result.column},
                    
                
                
            
        
        from ${name}
    <#list mybatisAssociations as association>
    ${association.joinCondition}
    
    <#list mybatisConnections as connection>
    ${connection.joinCondition}
    
        
            
                
                    
                
            
        
    

    
        select
        count(*)
        from ${name}
        
            
                
                    
                
            
        
    

    
    
        
            1 = -1
        
    

    
    
        
            
                
                    
                        
                            and ${r'${criterion.condition}'}
                        
                        
                            and ${name}.${r'${criterion.condition} #{criterion.value}'}
                        
                        
                            and ${name}.${r'${criterion.condition} #{criterion.value} and #{criterion.secondValue}'}
                        
                        
                            and ${name}.${r'${criterion.condition}'}
                            
                            ${r'#{listItem}'}