权限组修改

whyclxw

2025-05-15 5077036a10ebfe82feeaa7659557c5853a087f56

权限组修改

 src/main/java/com/whyc/mapper/CommonMapper.java

@@ -1,5 +1,7 @@
package com.whyc.mapper;

import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
@@ -15,13 +17,13 @@
     * @return
     */
    //Object getMaxValue(String schema,String table,String field,String valuePrefix);
    Object getMaxValue(String schema, String table, String field);
    Object getMaxValue(@Param("schema") String schema,@Param("table") String table,@Param("field")  String field);

    boolean existTable(String dbName, String tableName);

    //void truncate(String dbName, String tableName);

    void createTable4AlarmVoiceSet();
    //void createTable4AlarmVoiceSet();

    //void createTable4UserLogByYear(@Param("year") String year);

@@ -39,9 +41,9 @@

    //void insertBatch4DevAlarmDataHistoryByYear(String year, List<DevalarmDataHistory> temp);

    void createBattState_RT_RamDB_Table();
    //void createBattState_RT_RamDB_Table();

    void updateTb_App_Sys_AppServerTable();
    //void updateTb_App_Sys_AppServerTable();

    List<String> getTableListLike(String dbName, String tableLike);


 src/main/java/com/whyc/service/PermitGroupService.java

@@ -69,7 +69,7 @@
            }
        }*/
        //权限组id生成
        int maxValue = (int) commonMapper.getMaxValue("plus_user", "tb_user_permitgroup", "permit_group_id");
        int maxValue = (int) commonMapper.getMaxValue("db_user", "tb_permitgroup", "permit_group_id");
        int newPermitGroupId = maxValue+1;
        permitGroupList.stream().forEach(permitGroup -> permitGroup.setPermitGroupId(newPermitGroupId));
        mapper.insertBatchSomeColumn(permitGroupList);

 src/main/resources/mapper/CommonMapper.xml

New file
@@ -0,0 +1,25 @@
<?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.whyc.mapper.CommonMapper" >


    <select id="getMaxValue" resultType="java.lang.Object">
        select max(${field}) from ${schema}.${table}
    </select>
    <select id="existTable" resultType="java.lang.Boolean">
        select
            table_name
        from `INFORMATION_SCHEMA`.`TABLES`
        where table_name = #{tableName}
        and TABLE_SCHEMA = #{dbName}
    </select>
    <select id="getTableListLike" resultType="java.lang.String">
            select
            table_name
            from `INFORMATION_SCHEMA`.`TABLES`
            where TABLE_SCHEMA = #{dbName}
            and table_name like concat(#{tableLike},'%')
    </select>


</mapper>

 src/main/resources/mapper/PermitGroupUserMapper.xml

@@ -11,8 +11,8 @@
        and tb_permitgroup.permit_item_value=1
    </select>
    <select id="getUserInf" resultType="com.whyc.pojo.db_user.User">
        select u.* from db_user.tb_permitgroup_usr d,db_user.tb_user u
        where u.uid = d.uid
        select u.id,u.name,u.role from db_user.tb_permitgroup_usr d,db_user.tb_user u
        where u.id = d.uid
        and d.permit_group_id = #{permitGroupId}
    </select>
    <select id="getItemList" resultType="java.lang.String">