• Home
• com.lframework
• gen
• 2.0.1
• source code
• query-type-sql.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.

templates.query-type-sql.ftl Maven / Gradle / Ivy

<#if column.queryType == 0>
AND tb.${column.columnName} = ${r"#{vo."}${column.name}${r"}"}
<#elseif column.queryType == 1>
AND tb.${column.columnName} > ${r"#{vo."}${column.name}${r"}"}
<#elseif column.queryType == 2>
AND tb.${column.columnName} >= ${r"#{vo."}${column.name}${r"}"}
<#elseif column.queryType == 3>

<#elseif column.queryType == 4>

<#elseif column.queryType == 5>
AND tb.${column.columnName} != ${r"#{vo."}${column.name}${r"}"}
<#elseif column.queryType == 6>
AND tb.${column.columnName} IN (${r"#{vo."}${column.name}${r"}"})
<#elseif column.queryType == 7>
AND tb.${column.columnName} NOT IN (${r"#{vo."}${column.name}${r"}"})
<#elseif column.queryType == 8>
AND tb.${column.columnName} LIKE CONCAT('%', ${r"#{vo."}${column.name}${r"}"})
<#elseif column.queryType == 9>
AND tb.${column.columnName} LIKE CONCAT(${r"#{vo."}${column.name}${r"}"}, '%')
<#elseif column.queryType == 10>
AND tb.${column.columnName} LIKE CONCAT('%', ${r"#{vo."}${column.name}${r"}"}, '%')