'备注信息'

whyclxw

2024-12-02 03fc71fd32c563c7c1e38c76e8a751f2b9c678bc

'备注信息'

 .idea/workspace.xml

@@ -4,7 +4,14 @@
    <option name="autoReloadType" value="SELECTIVE" />
  </component>
  <component name="ChangeListManager">
    <list default="true" id="a14d0098-28a9-483d-a1c0-ac163d5acb18" name="Default Changelist" comment="222" />
    <list default="true" id="a14d0098-28a9-483d-a1c0-ac163d5acb18" name="Default Changelist" comment="控制管理">
      <change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" />
      <change beforePath="$PROJECT_DIR$/target/classes/com/whyc/F15KS380F220Application.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/whyc/F15KS380F220Application.class" afterDir="false" />
      <change beforePath="$PROJECT_DIR$/target/classes/com/whyc/controller/UserInfController.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/whyc/controller/UserInfController.class" afterDir="false" />
      <change beforePath="$PROJECT_DIR$/target/classes/com/whyc/mapper/UserInfMapper.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/whyc/mapper/UserInfMapper.class" afterDir="false" />
      <change beforePath="$PROJECT_DIR$/target/classes/com/whyc/service/UserInfService.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/whyc/service/UserInfService.class" afterDir="false" />
      <change beforePath="$PROJECT_DIR$/target/classes/com/whyc/swagger/SwaggerConfig4Knife.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/whyc/swagger/SwaggerConfig4Knife.class" afterDir="false" />
    </list>
    <option name="SHOW_DIALOG" value="false" />
    <option name="HIGHLIGHT_CONFLICTS" value="true" />
    <option name="HIGHLIGHT_NON_ACTIVE_CHANGELIST" value="false" />
@@ -13,6 +20,7 @@
  <component name="FileTemplateManagerImpl">
    <option name="RECENT_TEMPLATES">
      <list>
        <option value="Interface" />
        <option value="Class" />
      </list>
    </option>
@@ -30,7 +38,9 @@
    </option>
  </component>
  <component name="ProjectId" id="2pVMCzMGbHr2TZn6WguW9oZhLop" />
  <component name="ProjectLevelVcsManager" settingsEditedManually="true" />
  <component name="ProjectLevelVcsManager" settingsEditedManually="true">
    <ConfirmationsSetting value="2" id="Add" />
  </component>
  <component name="ProjectViewState">
    <option name="showExcludedFiles" value="false" />
    <option name="showLibraryContents" value="true" />
@@ -58,8 +68,24 @@
      <recent name="E:\GitWorkSpace\F15KS380F220\src" />
      <recent name="E:\GitWorkSpace\F15KS380F220\src\main\java" />
    </key>
    <key name="CopyClassDialog.RECENTS_KEY">
      <recent name="com.whyc.pojo.db_power_fk_rt" />
      <recent name="com.whyc.webSocket" />
      <recent name="com.whyc.pojo.db_power_fk_inf" />
    </key>
  </component>
  <component name="RunManager">
    <configuration default="true" type="ArquillianJUnit" factoryName="" nameIsGenerated="true">
      <option name="arquillianRunConfiguration">
        <value>
          <option name="containerStateName" value="" />
        </value>
      </option>
      <option name="TEST_OBJECT" value="class" />
      <method v="2">
        <option name="Make" enabled="true" />
      </method>
    </configuration>
    <configuration name="F15KS380F220Application" type="SpringBootApplicationConfigurationType" factoryName="Spring Boot">
      <module name="F15KS380F220" />
      <option name="SPRING_BOOT_MAIN_CLASS" value="com.whyc.F15KS380F220Application" />
@@ -79,6 +105,11 @@
      <workItem from="1732846667277" duration="1065000" />
      <workItem from="1732847916385" duration="300000" />
      <workItem from="1732848277773" duration="317000" />
      <workItem from="1732848624057" duration="654000" />
      <workItem from="1732857500097" duration="19000" />
      <workItem from="1732860181060" duration="4125000" />
      <workItem from="1733099662574" duration="826000" />
      <workItem from="1733121120977" duration="3199000" />
    </task>
    <task id="LOCAL-00001" summary="111">
      <created>1732848124481</created>
@@ -87,7 +118,42 @@
      <option name="project" value="LOCAL" />
      <updated>1732848124481</updated>
    </task>
    <option name="localTasksCounter" value="2" />
    <task id="LOCAL-00002" summary="1111">
      <created>1732848649420</created>
      <option name="number" value="00002" />
      <option name="presentableId" value="LOCAL-00002" />
      <option name="project" value="LOCAL" />
      <updated>1732848649420</updated>
    </task>
    <task id="LOCAL-00003" summary="实时信息推送">
      <created>1732864438700</created>
      <option name="number" value="00003" />
      <option name="presentableId" value="LOCAL-00003" />
      <option name="project" value="LOCAL" />
      <updated>1732864438700</updated>
    </task>
    <task id="LOCAL-00004" summary="控制管理">
      <created>1732864604722</created>
      <option name="number" value="00004" />
      <option name="presentableId" value="LOCAL-00004" />
      <option name="project" value="LOCAL" />
      <updated>1732864604722</updated>
    </task>
    <task id="LOCAL-00005" summary="无需登录过滤">
      <created>1733099859076</created>
      <option name="number" value="00005" />
      <option name="presentableId" value="LOCAL-00005" />
      <option name="project" value="LOCAL" />
      <updated>1733099859076</updated>
    </task>
    <task id="LOCAL-00006" summary="控制管理">
      <created>1733127601614</created>
      <option name="number" value="00006" />
      <option name="presentableId" value="LOCAL-00006" />
      <option name="project" value="LOCAL" />
      <updated>1733127601614</updated>
    </task>
    <option name="localTasksCounter" value="7" />
    <servers />
  </component>
  <component name="TypeScriptGeneratedFilesManager">
@@ -107,6 +173,10 @@
  </component>
  <component name="VcsManagerConfiguration">
    <MESSAGE value="111" />
    <option name="LAST_COMMIT_MESSAGE" value="111" />
    <MESSAGE value="1111" />
    <MESSAGE value="实时信息推送" />
    <MESSAGE value="无需登录过滤" />
    <MESSAGE value="控制管理" />
    <option name="LAST_COMMIT_MESSAGE" value="控制管理" />
  </component>
</project>

 target/classes/com/whyc/F15KS380F220Application.class

Binary files differ

 target/classes/com/whyc/controller/PowerFkInfController.class

Binary files differ

 target/classes/com/whyc/controller/PowerSetparmController.class

Binary files differ

 target/classes/com/whyc/controller/UserInfController.class

Binary files differ

 target/classes/com/whyc/mapper/PowerFkInfMapper.class

Binary files differ

 target/classes/com/whyc/mapper/PowerSetparmMapper.class

Binary files differ

 target/classes/com/whyc/mapper/PowerStateMapper.class

Binary files differ

 target/classes/com/whyc/mapper/UserInfMapper.class

Binary files differ

 target/classes/com/whyc/pojo/db_power_fk_inf/PowerFkInf.class

Binary files differ

 target/classes/com/whyc/pojo/db_power_fk_rt/PowerSetparm.class

Binary files differ

 target/classes/com/whyc/pojo/db_power_fk_rt/PowerState.class

Binary files differ

 target/classes/com/whyc/service/PowerFkInfService.class

Binary files differ

 target/classes/com/whyc/service/PowerSetparmService.class

Binary files differ

 target/classes/com/whyc/service/PowerStateService.class

Binary files differ

 target/classes/com/whyc/service/UserInfService.class

Binary files differ

 target/classes/com/whyc/swagger/SwaggerConfig4Knife.class

Binary files differ

 target/classes/com/whyc/webSocket/PowerInfRtSocket$1.class

Binary files differ

 target/classes/com/whyc/webSocket/PowerInfRtSocket.class

Binary files differ

 target/classes/mapper/0Mapper.xml

New file
@@ -0,0 +1,6 @@
<?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" >


</mapper>

 target/classes/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.String">
        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>

 target/classes/mapper/UserInfMapper.xml

New file
@@ -0,0 +1,41 @@
<?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.UserInfMapper">
    <update id="createNumber">
        CREATE TABLE if not exists db_user.temp_numbers (unumber INT);
    </update>
    <update id="setUnumber">
        ${sql}
    </update>
    <select id="existTable" resultType="java.lang.String">
        select
            table_name
        from `INFORMATION_SCHEMA`.`TABLES`
        where table_name = 'temp_numbers'
          and TABLE_SCHEMA = 'db_user'
    </select>

    <select id="selectSnId" resultType="java.lang.String">
        select usnid from db_user.tb_user_inf where uname=#{uname} limit 1
    </select>
    <select id="judgeUname" resultType="java.lang.Integer">
        select count(*) from  db_user.tb_user_inf where uid>100
    </select>
    <select id="getAllUser" resultType="UserInf">
        select uid,uname,udownload_role,create_time from db_user.tb_user_inf
        <where>
             uid>100
        </where>
        order by create_time desc
    </select>
    <select id="getIn1000" resultType="java.lang.String">
        SELECT min(unumber)
        FROM db_user.temp_numbers t
        WHERE t.unumber NOT IN (SELECT uid FROM db_user.tb_user_inf);
    </select>
    <select id="getMaxUid" resultType="java.lang.String">
        SELECT max(uid)
        FROM db_user.tb_user_inf  where uid>1000
    </select>

</mapper>