| | |
| | | <trim prefix="(" suffix=")" suffixOverrides=",">
|
| | | #foreach($column in $columns)
|
| | | #if($column.columnName != $pkColumn.columnName || !$pkColumn.increment)
|
| | | <if test="$column.javaField != null #if($column.javaType == 'String' ) and $column.javaField != ''#end">$column.columnName,</if>
|
| | | <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName,</if>
|
| | | #end
|
| | | #end
|
| | | </trim>
|
| | | <trim prefix="values (" suffix=")" suffixOverrides=",">
|
| | | #foreach($column in $columns)
|
| | | #if($column.columnName != $pkColumn.columnName || !$pkColumn.increment)
|
| | | <if test="$column.javaField != null #if($column.javaType == 'String' ) and $column.javaField != ''#end">#{$column.javaField},</if>
|
| | | <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">#{$column.javaField},</if>
|
| | | #end
|
| | | #end
|
| | | </trim>
|
| | |
| | | <trim prefix="SET" suffixOverrides=",">
|
| | | #foreach($column in $columns)
|
| | | #if($column.columnName != $pkColumn.columnName)
|
| | | <if test="$column.javaField != null #if($column.javaType == 'String' ) and $column.javaField != ''#end">$column.columnName = #{$column.javaField},</if>
|
| | | <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName = #{$column.javaField},</if>
|
| | | #end
|
| | | #end
|
| | | </trim>
|