修改ruoyi-改为sgd

fuyongxin

2026-06-03 1cb2e46cb3f7d55a5e1a3235255828fa6a203f62

修改ruoyi-改为sgd

 ruoyi-common/ruoyi-common-core/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 ruoyi-common/ruoyi-common-datascope/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 ruoyi-common/ruoyi-common-log/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 ruoyi-common/ruoyi-common-redis/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 ruoyi-common/ruoyi-common-security/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 ruoyi-common/ruoyi-common-swagger/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

File was deleted

 sgd-auth/src/main/resources/banner.txt

File was renamed from ruoyi-auth/src/main/resources/banner.txt
@@ -1,10 +1,10 @@
Spring Boot Version: ${spring-boot.version}

Spring Application Name: ${spring.application.name}

                            _                        _    _     
                           (_)                      | |  | |    
 _ __  _   _   ___   _   _  _  ______   __ _  _   _ | |_ | |__  
| '__|| | | | / _ \ | | | || ||______| / _` || | | || __|| '_ \ 
| |   | |_| || (_) || |_| || |        | (_| || |_| || |_ | | | |

|_|    \__,_| \___/  \__, ||_|         \__,_| \__,_| \__||_| |_|

                      __/ |                                     
Spring Boot Version: ${spring-boot.version}
Spring Application Name: ${spring.application.name}
                            _                        _    _     
                           (_)                      | |  | |    
 _ __  _   _   ___   _   _  _  ______   __ _  _   _ | |_ | |__  
| '__|| | | | / _ \ | | | || ||______| / _` || | | || __|| '_ \ 
| |   | |_| || (_) || |_| || |        | (_| || |_| || |_ | | | |
|_|    \__,_| \___/  \__, ||_|         \__,_| \__,_| \__||_| |_|
                      __/ |                                     
                     |___/                                      

 sgd-auth/src/main/resources/bootstrap.yml

File was renamed from ruoyi-auth/src/main/resources/bootstrap.yml
@@ -1,30 +1,30 @@
# Tomcat

server: 
  port: 9200



# Spring

spring: 
  application:

    # 应用名称

    name: ruoyi-auth

  profiles:

    # 环境配置

    active: dev

  cloud:

    nacos:

      discovery:

        # 服务注册地址

        server-addr: 127.0.0.1:8848

        username: nacos

        password: nacos

      config:

        # 配置中心地址

        server-addr: 127.0.0.1:8848

        username: nacos

        password: nacos

  config:

    # 配置文件格式

    file-extension: yml

    import:

      - nacos:application-${spring.profiles.active}.${spring.config.file-extension}

      - nacos:${spring.application.name}-${spring.profiles.active}.${spring.config.file-extension}

# Tomcat
server: 
  port: 9200

# Spring
spring: 
  application:
    # 应用名称
    name: sgd-auth
  profiles:
    # 环境配置
    active: dev
  cloud:
    nacos:
      discovery:
        # 服务注册地址
        server-addr: 127.0.0.1:8848
        username: nacos
        password: nacos
      config:
        # 配置中心地址
        server-addr: 127.0.0.1:8848
        username: nacos
        password: nacos
  config:
    # 配置文件格式
    file-extension: yml
    import:
      - nacos:application-${spring.profiles.active}.${spring.config.file-extension}
      - nacos:${spring.application.name}-${spring.profiles.active}.${spring.config.file-extension}

 sgd-auth/src/main/resources/logback.xml

 sgd-common/sgd-common-core/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1 @@
com.sgd.common.core.utils.SpringUtils

 sgd-common/sgd-common-datascope/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1 @@
com.sgd.common.datascope.aspect.DataScopeAspect

 sgd-common/sgd-common-log/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1,2 @@
com.sgd.common.log.service.AsyncLogService
com.sgd.common.log.aspect.LogAspect

 sgd-common/sgd-common-redis/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1,2 @@
com.sgd.common.redis.configure.RedisConfig
com.sgd.common.redis.service.RedisService

 sgd-common/sgd-common-security/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1,5 @@
com.sgd.common.security.config.WebMvcConfig
com.sgd.common.security.service.TokenService
com.sgd.common.security.aspect.PreAuthorizeAspect
com.sgd.common.security.aspect.InnerAuthAspect
com.sgd.common.security.handler.GlobalExceptionHandler

 sgd-common/sgd-common-swagger/src/main/resources/META-INF/spring/org.springframework.boot.autoconfigure.AutoConfiguration.imports

New file
@@ -0,0 +1 @@
com.sgd.common.swagger.config.SpringDocAutoConfiguration

 sgd-modules/sgd-gen/src/main/resources/mapper/generator/GenTableColumnMapper.xml

File was renamed from ruoyi-modules/ruoyi-gen/src/main/resources/mapper/generator/GenTableColumnMapper.xml
@@ -1,128 +1,128 @@
<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.ruoyi.gen.mapper.GenTableColumnMapper">



    <resultMap type="GenTableColumn" id="GenTableColumnResult">

        <id     property="columnId"       column="column_id"      />

        <result property="tableId"        column="table_id"       />

        <result property="columnName"     column="column_name"    />

        <result property="columnComment"  column="column_comment" />

        <result property="columnType"     column="column_type"    />

        <result property="javaType"       column="java_type"      />

        <result property="javaField"      column="java_field"     />

        <result property="isPk"           column="is_pk"          />

        <result property="isIncrement"    column="is_increment"   />

        <result property="isRequired"     column="is_required"    />

        <result property="isInsert"       column="is_insert"      />

        <result property="isEdit"         column="is_edit"        />

        <result property="isList"         column="is_list"        />

        <result property="isQuery"        column="is_query"       />

        <result property="queryType"      column="query_type"     />

        <result property="htmlType"       column="html_type"      />

        <result property="dictType"       column="dict_type"      />

        <result property="sort"           column="sort"           />

        <result property="createBy"       column="create_by"      />

        <result property="createTime"     column="create_time"    />

        <result property="updateBy"       column="update_by"      />

        <result property="updateTime"     column="update_time"    />

    </resultMap>



    <sql id="selectGenTableColumnVo">

        select column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_by, create_time, update_by, update_time from gen_table_column

    </sql>



    <select id="selectGenTableColumnListByTableId" parameterType="GenTableColumn" resultMap="GenTableColumnResult">

        <include refid="selectGenTableColumnVo"/>

        where table_id = #{tableId}

        order by sort

    </select>



    <select id="selectDbTableColumnsByName" parameterType="String" resultMap="GenTableColumnResult">

        select column_name, (case when (is_nullable = 'no' <![CDATA[ && ]]> column_key != 'PRI') then '1' else null end) as is_required, (case when column_key = 'PRI' then '1' else '0' end) as is_pk, ordinal_position as sort, column_comment, (case when extra = 'auto_increment' then '1' else '0' end) as is_increment, column_type

        from information_schema.columns where table_schema = (select database()) and table_name = (#{tableName})

        order by ordinal_position

    </select>



    <insert id="insertGenTableColumn" parameterType="GenTableColumn" useGeneratedKeys="true" keyProperty="columnId">

        insert into gen_table_column (

            <if test="tableId != null and tableId != ''">table_id,</if>

            <if test="columnName != null and columnName != ''">column_name,</if>

            <if test="columnComment != null and columnComment != ''">column_comment,</if>

            <if test="columnType != null and columnType != ''">column_type,</if>

            <if test="javaType != null and javaType != ''">java_type,</if>

            <if test="javaField != null  and javaField != ''">java_field,</if>

            <if test="isPk != null and isPk != ''">is_pk,</if>

            <if test="isIncrement != null and isIncrement != ''">is_increment,</if>

            <if test="isRequired != null and isRequired != ''">is_required,</if>

            <if test="isInsert != null and isInsert != ''">is_insert,</if>

            <if test="isEdit != null and isEdit != ''">is_edit,</if>

            <if test="isList != null and isList != ''">is_list,</if>

            <if test="isQuery != null and isQuery != ''">is_query,</if>

            <if test="queryType != null and queryType != ''">query_type,</if>

            <if test="htmlType != null and htmlType != ''">html_type,</if>

            <if test="dictType != null and dictType != ''">dict_type,</if>

            <if test="sort != null">sort,</if>

            <if test="createBy != null and createBy != ''">create_by,</if>

            create_time

         )values(

            <if test="tableId != null and tableId != ''">#{tableId},</if>

            <if test="columnName != null and columnName != ''">#{columnName},</if>

            <if test="columnComment != null and columnComment != ''">#{columnComment},</if>

            <if test="columnType != null and columnType != ''">#{columnType},</if>

            <if test="javaType != null and javaType != ''">#{javaType},</if>

            <if test="javaField != null and javaField != ''">#{javaField},</if>

            <if test="isPk != null and isPk != ''">#{isPk},</if>

            <if test="isIncrement != null and isIncrement != ''">#{isIncrement},</if>

            <if test="isRequired != null and isRequired != ''">#{isRequired},</if>

            <if test="isInsert != null and isInsert != ''">#{isInsert},</if>

            <if test="isEdit != null and isEdit != ''">#{isEdit},</if>

            <if test="isList != null and isList != ''">#{isList},</if>

            <if test="isQuery != null and isQuery != ''">#{isQuery},</if>

            <if test="queryType != null and queryType != ''">#{queryType},</if>

            <if test="htmlType != null and htmlType != ''">#{htmlType},</if>

            <if test="dictType != null and dictType != ''">#{dictType},</if>

            <if test="sort != null">#{sort},</if>

            <if test="createBy != null and createBy != ''">#{createBy},</if>

            sysdate()

         )

    </insert>



    <update id="updateGenTableColumn" parameterType="GenTableColumn">

        update gen_table_column

        <set>

            <if test="columnComment != null">column_comment = #{columnComment},</if>

            <if test="javaType != null">java_type = #{javaType},</if>

            <if test="columnType != null">column_type = #{columnType},</if>

            <if test="javaField != null">java_field = #{javaField},</if>

            <if test="isInsert != null">is_insert = #{isInsert},</if>

            <if test="isEdit != null">is_edit = #{isEdit},</if>

            <if test="isList != null">is_list = #{isList},</if>

            <if test="isQuery != null">is_query = #{isQuery},</if>

            <if test="isRequired != null">is_required = #{isRequired},</if>

            <if test="queryType != null">query_type = #{queryType},</if>

            <if test="htmlType != null">html_type = #{htmlType},</if>

            <if test="dictType != null">dict_type = #{dictType},</if>

            <if test="sort != null">sort = #{sort},</if>

            <if test="updateBy != null">update_by = #{updateBy},</if>

            update_time = sysdate()

        </set>

        where column_id = #{columnId}

    </update>



    <delete id="deleteGenTableColumnByIds" parameterType="Long">

        delete from gen_table_column where table_id in

        <foreach collection="array" item="tableId" open="(" separator="," close=")">

            #{tableId}

        </foreach>

    </delete>

    
    <delete id="deleteGenTableColumns">

        delete from gen_table_column where column_id in

        <foreach collection="list" item="item" open="(" separator="," close=")">

            #{item.columnId}

        </foreach>

    </delete>



<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sgd.gen.mapper.GenTableColumnMapper">

    <resultMap type="GenTableColumn" id="GenTableColumnResult">
        <id     property="columnId"       column="column_id"      />
        <result property="tableId"        column="table_id"       />
        <result property="columnName"     column="column_name"    />
        <result property="columnComment"  column="column_comment" />
        <result property="columnType"     column="column_type"    />
        <result property="javaType"       column="java_type"      />
        <result property="javaField"      column="java_field"     />
        <result property="isPk"           column="is_pk"          />
        <result property="isIncrement"    column="is_increment"   />
        <result property="isRequired"     column="is_required"    />
        <result property="isInsert"       column="is_insert"      />
        <result property="isEdit"         column="is_edit"        />
        <result property="isList"         column="is_list"        />
        <result property="isQuery"        column="is_query"       />
        <result property="queryType"      column="query_type"     />
        <result property="htmlType"       column="html_type"      />
        <result property="dictType"       column="dict_type"      />
        <result property="sort"           column="sort"           />
        <result property="createBy"       column="create_by"      />
        <result property="createTime"     column="create_time"    />
        <result property="updateBy"       column="update_by"      />
        <result property="updateTime"     column="update_time"    />
    </resultMap>

    <sql id="selectGenTableColumnVo">
        select column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_by, create_time, update_by, update_time from gen_table_column
    </sql>

    <select id="selectGenTableColumnListByTableId" parameterType="GenTableColumn" resultMap="GenTableColumnResult">
        <include refid="selectGenTableColumnVo"/>
        where table_id = #{tableId}
        order by sort
    </select>

    <select id="selectDbTableColumnsByName" parameterType="String" resultMap="GenTableColumnResult">
        select column_name, (case when (is_nullable = 'no' <![CDATA[ && ]]> column_key != 'PRI') then '1' else null end) as is_required, (case when column_key = 'PRI' then '1' else '0' end) as is_pk, ordinal_position as sort, column_comment, (case when extra = 'auto_increment' then '1' else '0' end) as is_increment, column_type
        from information_schema.columns where table_schema = (select database()) and table_name = (#{tableName})
        order by ordinal_position
    </select>

    <insert id="insertGenTableColumn" parameterType="GenTableColumn" useGeneratedKeys="true" keyProperty="columnId">
        insert into gen_table_column (
            <if test="tableId != null and tableId != ''">table_id,</if>
            <if test="columnName != null and columnName != ''">column_name,</if>
            <if test="columnComment != null and columnComment != ''">column_comment,</if>
            <if test="columnType != null and columnType != ''">column_type,</if>
            <if test="javaType != null and javaType != ''">java_type,</if>
            <if test="javaField != null  and javaField != ''">java_field,</if>
            <if test="isPk != null and isPk != ''">is_pk,</if>
            <if test="isIncrement != null and isIncrement != ''">is_increment,</if>
            <if test="isRequired != null and isRequired != ''">is_required,</if>
            <if test="isInsert != null and isInsert != ''">is_insert,</if>
            <if test="isEdit != null and isEdit != ''">is_edit,</if>
            <if test="isList != null and isList != ''">is_list,</if>
            <if test="isQuery != null and isQuery != ''">is_query,</if>
            <if test="queryType != null and queryType != ''">query_type,</if>
            <if test="htmlType != null and htmlType != ''">html_type,</if>
            <if test="dictType != null and dictType != ''">dict_type,</if>
            <if test="sort != null">sort,</if>
            <if test="createBy != null and createBy != ''">create_by,</if>
            create_time
         )values(
            <if test="tableId != null and tableId != ''">#{tableId},</if>
            <if test="columnName != null and columnName != ''">#{columnName},</if>
            <if test="columnComment != null and columnComment != ''">#{columnComment},</if>
            <if test="columnType != null and columnType != ''">#{columnType},</if>
            <if test="javaType != null and javaType != ''">#{javaType},</if>
            <if test="javaField != null and javaField != ''">#{javaField},</if>
            <if test="isPk != null and isPk != ''">#{isPk},</if>
            <if test="isIncrement != null and isIncrement != ''">#{isIncrement},</if>
            <if test="isRequired != null and isRequired != ''">#{isRequired},</if>
            <if test="isInsert != null and isInsert != ''">#{isInsert},</if>
            <if test="isEdit != null and isEdit != ''">#{isEdit},</if>
            <if test="isList != null and isList != ''">#{isList},</if>
            <if test="isQuery != null and isQuery != ''">#{isQuery},</if>
            <if test="queryType != null and queryType != ''">#{queryType},</if>
            <if test="htmlType != null and htmlType != ''">#{htmlType},</if>
            <if test="dictType != null and dictType != ''">#{dictType},</if>
            <if test="sort != null">#{sort},</if>
            <if test="createBy != null and createBy != ''">#{createBy},</if>
            sysdate()
         )
    </insert>

    <update id="updateGenTableColumn" parameterType="GenTableColumn">
        update gen_table_column
        <set>
            <if test="columnComment != null">column_comment = #{columnComment},</if>
            <if test="javaType != null">java_type = #{javaType},</if>
            <if test="columnType != null">column_type = #{columnType},</if>
            <if test="javaField != null">java_field = #{javaField},</if>
            <if test="isInsert != null">is_insert = #{isInsert},</if>
            <if test="isEdit != null">is_edit = #{isEdit},</if>
            <if test="isList != null">is_list = #{isList},</if>
            <if test="isQuery != null">is_query = #{isQuery},</if>
            <if test="isRequired != null">is_required = #{isRequired},</if>
            <if test="queryType != null">query_type = #{queryType},</if>
            <if test="htmlType != null">html_type = #{htmlType},</if>
            <if test="dictType != null">dict_type = #{dictType},</if>
            <if test="sort != null">sort = #{sort},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            update_time = sysdate()
        </set>
        where column_id = #{columnId}
    </update>

    <delete id="deleteGenTableColumnByIds" parameterType="Long">
        delete from gen_table_column where table_id in
        <foreach collection="array" item="tableId" open="(" separator="," close=")">
            #{tableId}
        </foreach>
    </delete>
    
    <delete id="deleteGenTableColumns">
        delete from gen_table_column where column_id in
        <foreach collection="list" item="item" open="(" separator="," close=")">
            #{item.columnId}
        </foreach>
    </delete>

</mapper>

 sgd-modules/sgd-gen/src/main/resources/mapper/generator/GenTableMapper.xml

File was renamed from ruoyi-modules/ruoyi-gen/src/main/resources/mapper/generator/GenTableMapper.xml
@@ -1,210 +1,210 @@
<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.ruoyi.gen.mapper.GenTableMapper">



    <resultMap type="GenTable" id="GenTableResult">

        <id     property="tableId"        column="table_id"          />

        <result property="tableName"      column="table_name"        />

        <result property="tableComment"   column="table_comment"     />

        <result property="subTableName"   column="sub_table_name"    />

        <result property="subTableFkName" column="sub_table_fk_name" />

        <result property="className"      column="class_name"        />

        <result property="tplCategory"    column="tpl_category"      />

        <result property="tplWebType"     column="tpl_web_type"      />

        <result property="packageName"    column="package_name"      />

        <result property="moduleName"     column="module_name"       />

        <result property="businessName"   column="business_name"     />

        <result property="functionName"   column="function_name"     />

        <result property="functionAuthor" column="function_author"   />

        <result property="formColNum"     column="form_col_num"      />

        <result property="genType"        column="gen_type"          />

        <result property="genPath"        column="gen_path"          />

        <result property="options"        column="options"           />

        <result property="createBy"       column="create_by"         />

        <result property="createTime"     column="create_time"       />

        <result property="updateBy"       column="update_by"         />

        <result property="updateTime"     column="update_time"       />

        <result property="remark"         column="remark"            />

        <collection  property="columns"   javaType="java.util.List"  resultMap="GenTableColumnResult" />

    </resultMap>

	
    <resultMap type="GenTableColumn" id="GenTableColumnResult">

        <id     property="columnId"       column="column_id"      />

        <result property="tableId"        column="table_id"       />

        <result property="columnName"     column="column_name"    />

        <result property="columnComment"  column="column_comment" />

        <result property="columnType"     column="column_type"    />

        <result property="javaType"       column="java_type"      />

        <result property="javaField"      column="java_field"     />

        <result property="isPk"           column="is_pk"          />

        <result property="isIncrement"    column="is_increment"   />

        <result property="isRequired"     column="is_required"    />

        <result property="isInsert"       column="is_insert"      />

        <result property="isEdit"         column="is_edit"        />

        <result property="isList"         column="is_list"        />

        <result property="isQuery"        column="is_query"       />

        <result property="queryType"      column="query_type"     />

        <result property="htmlType"       column="html_type"      />

        <result property="dictType"       column="dict_type"      />

        <result property="sort"           column="sort"           />

        <result property="createBy"       column="create_by"      />

        <result property="createTime"     column="create_time"    />

        <result property="updateBy"       column="update_by"      />

        <result property="updateTime"     column="update_time"    />

    </resultMap>

	
    <sql id="selectGenTableVo">

        select table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, tpl_web_type, package_name, module_name, business_name, function_name, function_author, form_col_num, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark from gen_table

    </sql>

    
    <select id="selectGenTableList" parameterType="GenTable" resultMap="GenTableResult">

        <include refid="selectGenTableVo"/>

        <where>

            <if test="tableName != null and tableName != ''">

                AND lower(table_name) like lower(concat('%', #{tableName}, '%'))

            </if>

            <if test="tableComment != null and tableComment != ''">

                AND lower(table_comment) like lower(concat('%', #{tableComment}, '%'))

            </if>

            <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 -->

                AND date_format(create_time,'%Y%m%d') &gt;= date_format(#{params.beginTime},'%Y%m%d')

            </if>

            <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->

                AND date_format(create_time,'%Y%m%d') &lt;= date_format(#{params.endTime},'%Y%m%d')

            </if>

        </where>

    </select>



    <select id="selectDbTableList" parameterType="GenTable" resultMap="GenTableResult">

        select table_name, table_comment, create_time, update_time from information_schema.tables

        where table_schema = (select database())

        AND table_name NOT LIKE 'qrtz\_%' AND table_name NOT LIKE 'gen\_%'

        AND table_name NOT IN (select table_name from gen_table)

        <if test="tableName != null and tableName != ''">

            AND lower(table_name) like lower(concat('%', #{tableName}, '%'))

        </if>

        <if test="tableComment != null and tableComment != ''">

            AND lower(table_comment) like lower(concat('%', #{tableComment}, '%'))

        </if>

        <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 -->

            AND date_format(create_time,'%Y%m%d') &gt;= date_format(#{params.beginTime},'%Y%m%d')

        </if>

        <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->

            AND date_format(create_time,'%Y%m%d') &lt;= date_format(#{params.endTime},'%Y%m%d')

        </if>

        order by create_time desc

    </select>

	
    <select id="selectDbTableListByNames" resultMap="GenTableResult">

        select table_name, table_comment, create_time, update_time from information_schema.tables

        where table_name NOT LIKE 'qrtz\_%' and table_name NOT LIKE 'gen\_%' and table_schema = (select database())

        and table_name in

        <foreach collection="array" item="name" open="(" separator="," close=")">

             #{name}

        </foreach> 
    </select>

	
    <select id="selectTableByName" parameterType="String" resultMap="GenTableResult">

        select table_name, table_comment, create_time, update_time from information_schema.tables

        where table_comment <![CDATA[ <> ]]> '' and table_schema = (select database())

        and table_name = #{tableName}

    </select>

	
    <select id="selectGenTableById" parameterType="Long" resultMap="GenTableResult">

        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.gen_type, t.gen_path, t.options, t.remark,

               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort

        FROM gen_table t

             LEFT JOIN gen_table_column c ON t.table_id = c.table_id

        where t.table_id = #{tableId} order by c.sort

    </select>

	
    <select id="selectGenTableByName" parameterType="String" resultMap="GenTableResult">

        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.gen_type, t.gen_path, t.options, t.remark,

               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort

        FROM gen_table t

             LEFT JOIN gen_table_column c ON t.table_id = c.table_id

        where t.table_name = #{tableName} order by c.sort

    </select>

	
    <select id="selectGenTableAll" parameterType="String" resultMap="GenTableResult">

        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.options, t.remark,

               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort

        FROM gen_table t

             LEFT JOIN gen_table_column c ON t.table_id = c.table_id

        order by c.sort

    </select>

	
    <insert id="insertGenTable" parameterType="GenTable" useGeneratedKeys="true" keyProperty="tableId">

        insert into gen_table (

            <if test="tableName != null">table_name,</if>

            <if test="tableComment != null and tableComment != ''">table_comment,</if>

            <if test="className != null and className != ''">class_name,</if>

            <if test="tplCategory != null and tplCategory != ''">tpl_category,</if>

            <if test="tplWebType != null and tplWebType != ''">tpl_web_type,</if>

            <if test="packageName != null and packageName != ''">package_name,</if>

            <if test="moduleName != null and moduleName != ''">module_name,</if>

            <if test="businessName != null and businessName != ''">business_name,</if>

            <if test="functionName != null and functionName != ''">function_name,</if>

            <if test="functionAuthor != null and functionAuthor != ''">function_author,</if>

            <if test="formColNum != null">form_col_num,</if>

            <if test="genType != null and genType != ''">gen_type,</if>

            <if test="genPath != null and genPath != ''">gen_path,</if>

            <if test="remark != null and remark != ''">remark,</if>

             <if test="createBy != null and createBy != ''">create_by,</if>

            create_time

         )values(

            <if test="tableName != null">#{tableName},</if>

            <if test="tableComment != null and tableComment != ''">#{tableComment},</if>

            <if test="className != null and className != ''">#{className},</if>

            <if test="tplCategory != null and tplCategory != ''">#{tplCategory},</if>

            <if test="tplWebType != null and tplWebType != ''">#{tplWebType},</if>

            <if test="packageName != null and packageName != ''">#{packageName},</if>

            <if test="moduleName != null and moduleName != ''">#{moduleName},</if>

            <if test="businessName != null and businessName != ''">#{businessName},</if>

            <if test="functionName != null and functionName != ''">#{functionName},</if>

            <if test="functionAuthor != null and functionAuthor != ''">#{functionAuthor},</if>

            <if test="formColNum != null">#{formColNum},</if>

            <if test="genType != null and genType != ''">#{genType},</if>

            <if test="genPath != null and genPath != ''">#{genPath},</if>

            <if test="remark != null and remark != ''">#{remark},</if>

             <if test="createBy != null and createBy != ''">#{createBy},</if>

            sysdate()

         )

    </insert>

    
    <update id="updateGenTable" parameterType="GenTable">

        update gen_table

        <set>

            <if test="tableName != null">table_name = #{tableName},</if>

            <if test="tableComment != null and tableComment != ''">table_comment = #{tableComment},</if>

            <if test="subTableName != null">sub_table_name = #{subTableName},</if>

            <if test="subTableFkName != null">sub_table_fk_name = #{subTableFkName},</if>

            <if test="className != null and className != ''">class_name = #{className},</if>

            <if test="functionAuthor != null and functionAuthor != ''">function_author = #{functionAuthor},</if>

            <if test="formColNum != null">form_col_num = #{formColNum},</if>

            <if test="genType != null and genType != ''">gen_type = #{genType},</if>

            <if test="genPath != null and genPath != ''">gen_path = #{genPath},</if>

            <if test="tplCategory != null and tplCategory != ''">tpl_category = #{tplCategory},</if>

            <if test="tplWebType != null and tplWebType != ''">tpl_web_type = #{tplWebType},</if>

            <if test="packageName != null and packageName != ''">package_name = #{packageName},</if>

            <if test="moduleName != null and moduleName != ''">module_name = #{moduleName},</if>

            <if test="businessName != null and businessName != ''">business_name = #{businessName},</if>

            <if test="functionName != null and functionName != ''">function_name = #{functionName},</if>

            <if test="options != null and options != ''">options = #{options},</if>

            <if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if>

            <if test="remark != null">remark = #{remark},</if>

            update_time = sysdate()

        </set>

        where table_id = #{tableId}

    </update>

    
    <delete id="deleteGenTableByIds" parameterType="Long">

        delete from gen_table where table_id in 
        <foreach collection="array" item="tableId" open="(" separator="," close=")">

            #{tableId}

        </foreach>

    </delete>



<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sgd.gen.mapper.GenTableMapper">

    <resultMap type="GenTable" id="GenTableResult">
        <id     property="tableId"        column="table_id"          />
        <result property="tableName"      column="table_name"        />
        <result property="tableComment"   column="table_comment"     />
        <result property="subTableName"   column="sub_table_name"    />
        <result property="subTableFkName" column="sub_table_fk_name" />
        <result property="className"      column="class_name"        />
        <result property="tplCategory"    column="tpl_category"      />
        <result property="tplWebType"     column="tpl_web_type"      />
        <result property="packageName"    column="package_name"      />
        <result property="moduleName"     column="module_name"       />
        <result property="businessName"   column="business_name"     />
        <result property="functionName"   column="function_name"     />
        <result property="functionAuthor" column="function_author"   />
        <result property="formColNum"     column="form_col_num"      />
        <result property="genType"        column="gen_type"          />
        <result property="genPath"        column="gen_path"          />
        <result property="options"        column="options"           />
        <result property="createBy"       column="create_by"         />
        <result property="createTime"     column="create_time"       />
        <result property="updateBy"       column="update_by"         />
        <result property="updateTime"     column="update_time"       />
        <result property="remark"         column="remark"            />
        <collection  property="columns"   javaType="java.util.List"  resultMap="GenTableColumnResult" />
    </resultMap>
	
    <resultMap type="GenTableColumn" id="GenTableColumnResult">
        <id     property="columnId"       column="column_id"      />
        <result property="tableId"        column="table_id"       />
        <result property="columnName"     column="column_name"    />
        <result property="columnComment"  column="column_comment" />
        <result property="columnType"     column="column_type"    />
        <result property="javaType"       column="java_type"      />
        <result property="javaField"      column="java_field"     />
        <result property="isPk"           column="is_pk"          />
        <result property="isIncrement"    column="is_increment"   />
        <result property="isRequired"     column="is_required"    />
        <result property="isInsert"       column="is_insert"      />
        <result property="isEdit"         column="is_edit"        />
        <result property="isList"         column="is_list"        />
        <result property="isQuery"        column="is_query"       />
        <result property="queryType"      column="query_type"     />
        <result property="htmlType"       column="html_type"      />
        <result property="dictType"       column="dict_type"      />
        <result property="sort"           column="sort"           />
        <result property="createBy"       column="create_by"      />
        <result property="createTime"     column="create_time"    />
        <result property="updateBy"       column="update_by"      />
        <result property="updateTime"     column="update_time"    />
    </resultMap>
	
    <sql id="selectGenTableVo">
        select table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, tpl_web_type, package_name, module_name, business_name, function_name, function_author, form_col_num, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark from gen_table
    </sql>
    
    <select id="selectGenTableList" parameterType="GenTable" resultMap="GenTableResult">
        <include refid="selectGenTableVo"/>
        <where>
            <if test="tableName != null and tableName != ''">
                AND lower(table_name) like lower(concat('%', #{tableName}, '%'))
            </if>
            <if test="tableComment != null and tableComment != ''">
                AND lower(table_comment) like lower(concat('%', #{tableComment}, '%'))
            </if>
            <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 -->
                AND date_format(create_time,'%Y%m%d') &gt;= date_format(#{params.beginTime},'%Y%m%d')
            </if>
            <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->
                AND date_format(create_time,'%Y%m%d') &lt;= date_format(#{params.endTime},'%Y%m%d')
            </if>
        </where>
    </select>

    <select id="selectDbTableList" parameterType="GenTable" resultMap="GenTableResult">
        select table_name, table_comment, create_time, update_time from information_schema.tables
        where table_schema = (select database())
        AND table_name NOT LIKE 'qrtz\_%' AND table_name NOT LIKE 'gen\_%'
        AND table_name NOT IN (select table_name from gen_table)
        <if test="tableName != null and tableName != ''">
            AND lower(table_name) like lower(concat('%', #{tableName}, '%'))
        </if>
        <if test="tableComment != null and tableComment != ''">
            AND lower(table_comment) like lower(concat('%', #{tableComment}, '%'))
        </if>
        <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 -->
            AND date_format(create_time,'%Y%m%d') &gt;= date_format(#{params.beginTime},'%Y%m%d')
        </if>
        <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->
            AND date_format(create_time,'%Y%m%d') &lt;= date_format(#{params.endTime},'%Y%m%d')
        </if>
        order by create_time desc
    </select>
	
    <select id="selectDbTableListByNames" resultMap="GenTableResult">
        select table_name, table_comment, create_time, update_time from information_schema.tables
        where table_name NOT LIKE 'qrtz\_%' and table_name NOT LIKE 'gen\_%' and table_schema = (select database())
        and table_name in
        <foreach collection="array" item="name" open="(" separator="," close=")">
             #{name}
        </foreach> 
    </select>
	
    <select id="selectTableByName" parameterType="String" resultMap="GenTableResult">
        select table_name, table_comment, create_time, update_time from information_schema.tables
        where table_comment <![CDATA[ <> ]]> '' and table_schema = (select database())
        and table_name = #{tableName}
    </select>
	
    <select id="selectGenTableById" parameterType="Long" resultMap="GenTableResult">
        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.gen_type, t.gen_path, t.options, t.remark,
               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort
        FROM gen_table t
             LEFT JOIN gen_table_column c ON t.table_id = c.table_id
        where t.table_id = #{tableId} order by c.sort
    </select>
	
    <select id="selectGenTableByName" parameterType="String" resultMap="GenTableResult">
        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.gen_type, t.gen_path, t.options, t.remark,
               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort
        FROM gen_table t
             LEFT JOIN gen_table_column c ON t.table_id = c.table_id
        where t.table_name = #{tableName} order by c.sort
    </select>
	
    <select id="selectGenTableAll" parameterType="String" resultMap="GenTableResult">
        SELECT t.table_id, t.table_name, t.table_comment, t.sub_table_name, t.sub_table_fk_name, t.class_name, t.tpl_category, t.tpl_web_type, t.package_name, t.module_name, t.business_name, t.function_name, t.function_author, t.form_col_num, t.options, t.remark,
               c.column_id, c.column_name, c.column_comment, c.column_type, c.java_type, c.java_field, c.is_pk, c.is_increment, c.is_required, c.is_insert, c.is_edit, c.is_list, c.is_query, c.query_type, c.html_type, c.dict_type, c.sort
        FROM gen_table t
             LEFT JOIN gen_table_column c ON t.table_id = c.table_id
        order by c.sort
    </select>
	
    <insert id="insertGenTable" parameterType="GenTable" useGeneratedKeys="true" keyProperty="tableId">
        insert into gen_table (
            <if test="tableName != null">table_name,</if>
            <if test="tableComment != null and tableComment != ''">table_comment,</if>
            <if test="className != null and className != ''">class_name,</if>
            <if test="tplCategory != null and tplCategory != ''">tpl_category,</if>
            <if test="tplWebType != null and tplWebType != ''">tpl_web_type,</if>
            <if test="packageName != null and packageName != ''">package_name,</if>
            <if test="moduleName != null and moduleName != ''">module_name,</if>
            <if test="businessName != null and businessName != ''">business_name,</if>
            <if test="functionName != null and functionName != ''">function_name,</if>
            <if test="functionAuthor != null and functionAuthor != ''">function_author,</if>
            <if test="formColNum != null">form_col_num,</if>
            <if test="genType != null and genType != ''">gen_type,</if>
            <if test="genPath != null and genPath != ''">gen_path,</if>
            <if test="remark != null and remark != ''">remark,</if>
             <if test="createBy != null and createBy != ''">create_by,</if>
            create_time
         )values(
            <if test="tableName != null">#{tableName},</if>
            <if test="tableComment != null and tableComment != ''">#{tableComment},</if>
            <if test="className != null and className != ''">#{className},</if>
            <if test="tplCategory != null and tplCategory != ''">#{tplCategory},</if>
            <if test="tplWebType != null and tplWebType != ''">#{tplWebType},</if>
            <if test="packageName != null and packageName != ''">#{packageName},</if>
            <if test="moduleName != null and moduleName != ''">#{moduleName},</if>
            <if test="businessName != null and businessName != ''">#{businessName},</if>
            <if test="functionName != null and functionName != ''">#{functionName},</if>
            <if test="functionAuthor != null and functionAuthor != ''">#{functionAuthor},</if>
            <if test="formColNum != null">#{formColNum},</if>
            <if test="genType != null and genType != ''">#{genType},</if>
            <if test="genPath != null and genPath != ''">#{genPath},</if>
            <if test="remark != null and remark != ''">#{remark},</if>
             <if test="createBy != null and createBy != ''">#{createBy},</if>
            sysdate()
         )
    </insert>
    
    <update id="updateGenTable" parameterType="GenTable">
        update gen_table
        <set>
            <if test="tableName != null">table_name = #{tableName},</if>
            <if test="tableComment != null and tableComment != ''">table_comment = #{tableComment},</if>
            <if test="subTableName != null">sub_table_name = #{subTableName},</if>
            <if test="subTableFkName != null">sub_table_fk_name = #{subTableFkName},</if>
            <if test="className != null and className != ''">class_name = #{className},</if>
            <if test="functionAuthor != null and functionAuthor != ''">function_author = #{functionAuthor},</if>
            <if test="formColNum != null">form_col_num = #{formColNum},</if>
            <if test="genType != null and genType != ''">gen_type = #{genType},</if>
            <if test="genPath != null and genPath != ''">gen_path = #{genPath},</if>
            <if test="tplCategory != null and tplCategory != ''">tpl_category = #{tplCategory},</if>
            <if test="tplWebType != null and tplWebType != ''">tpl_web_type = #{tplWebType},</if>
            <if test="packageName != null and packageName != ''">package_name = #{packageName},</if>
            <if test="moduleName != null and moduleName != ''">module_name = #{moduleName},</if>
            <if test="businessName != null and businessName != ''">business_name = #{businessName},</if>
            <if test="functionName != null and functionName != ''">function_name = #{functionName},</if>
            <if test="options != null and options != ''">options = #{options},</if>
            <if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if>
            <if test="remark != null">remark = #{remark},</if>
            update_time = sysdate()
        </set>
        where table_id = #{tableId}
    </update>
    
    <delete id="deleteGenTableByIds" parameterType="Long">
        delete from gen_table where table_id in 
        <foreach collection="array" item="tableId" open="(" separator="," close=")">
            #{tableId}
        </foreach>
    </delete>

</mapper>