• Home
• com.base4j
• base4j-mybatis
• 1.1.8
• source code
• mysql.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.mysql.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}"/>
                
            
        
    
    

    
        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'}'},
                
                
                    DEFAULT,
                
            
        
        
    

    
        insert into ${name}
        
        <#list entityClassColumns as column>
            ${column.column},
        
        
        VALUES
        
        
        <#list entityClassColumns as column>
            
            ${r'#{'}record.${column.property}<#if column.jdbcTypeName??>, jdbcType=${column.jdbcTypeName}${r'}'},
            
            
                DEFAULT,
            
        
        
        
    

    
        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}'}