• Home
• org.jiuwo
• jiuwo-generator
• 1.0.0
• source code
• MapperTemplate.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.

ftl.MapperTemplate.ftl Maven / Gradle / Ivy

    
    <#list fieldList as pro>
        <#if pro.isPk == 1>
        
        <#else>
        
        
    
    

    
        <#list fieldList as pro>
            ${pro.name}<#if pro_has_next>,
        
    

    
        INSERT INTO
    ${tableName}
        (
                <#list fieldList as pro>
                    <#if pro.isIdentity==0>
                        ${pro.name}<#if pro_has_next>,
                    
                
        )
        VALUES
        (
                <#list fieldList as pro>
                    <#if pro.isIdentity==0>
                        <#if pro.name=="gmt_create" || pro.name=="gmt_modify">
                now()<#if pro_has_next>,
                        <#else>
                            ${r'#'}{${pro.proName}}<#if pro_has_next>,
                        
                    
                
        )
    

    
        UPDATE
    ${tableName}
        SET
        <#list fieldList as pro>
            <#if pro.isIdentity==0>
                <#if pro.name=="gmt_modify">
                    ${pro.name} = now()<#if pro_has_next>,
                <#else>
                    ${pro.name} = ${r'#'}{${pro.proName}}<#if pro_has_next>,
                
            
        
        WHERE
    ${fieldPk.name}=${r'#'}{${fieldPk.proName}}
    

    
        DELETE FROM ${tableName} WHERE ${fieldPk.name}=${r'#'}{${fieldPk.proName}}
    

    
        SELECT
        
        FROM
    ${tableName}
        WHERE
    ${fieldPk.name}=${r'#'}{${fieldPk.proName}}