| | |
| | | </where>
|
| | | </select>
|
| | |
|
| | | <select id="select${ClassName}ById" parameterType="${pkColumn.javaType}" resultMap="#if($table.sub)${ClassName}${subClassName}Result#else${ClassName}Result#end">
|
| | | <select id="select${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}" resultMap="#if($table.sub)${ClassName}${subClassName}Result#else${ClassName}Result#end">
|
| | | #if($table.crud || $table.tree)
|
| | | <include refid="select${ClassName}Vo"/>
|
| | | where ${pkColumn.columnName} = #{${pkColumn.javaField}}
|
| | |
| | | where ${pkColumn.columnName} = #{${pkColumn.javaField}}
|
| | | </update>
|
| | |
|
| | | <delete id="delete${ClassName}ById" parameterType="${pkColumn.javaType}">
|
| | | <delete id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}">
|
| | | delete from ${tableName} where ${pkColumn.columnName} = #{${pkColumn.javaField}}
|
| | | </delete>
|
| | |
|
| | | <delete id="delete${ClassName}ByIds" parameterType="String">
|
| | | <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String">
|
| | | delete from ${tableName} where ${pkColumn.columnName} in
|
| | | <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")">
|
| | | #{${pkColumn.javaField}}
|
| | |
| | | </foreach>
|
| | | </delete>
|
| | |
|
| | | <delete id="delete${subClassName}By${subTableFkClassName}" parameterType="Long">
|
| | | <delete id="delete${subClassName}By${subTableFkClassName}" parameterType="${pkColumn.javaType}">
|
| | | delete from ${subTableName} where ${subTableFkName} = #{${subTableFkclassName}}
|
| | | </delete>
|
| | |
|