1111

whyclxw

2024-11-29 e49211749baec2db5b6924f212175197de118238

1111

 .idea/workspace.xml

@@ -4,7 +4,7 @@
    <option name="autoReloadType" value="SELECTIVE" />
  </component>
  <component name="ChangeListManager">
    <list default="true" id="a14d0098-28a9-483d-a1c0-ac163d5acb18" name="Default Changelist" comment="111" />
    <list default="true" id="a14d0098-28a9-483d-a1c0-ac163d5acb18" name="Default Changelist" comment="222" />
    <option name="SHOW_DIALOG" value="false" />
    <option name="HIGHLIGHT_CONFLICTS" value="true" />
    <option name="HIGHLIGHT_NON_ACTIVE_CHANGELIST" value="false" />
@@ -55,6 +55,7 @@
  <component name="RecentsManager">
    <key name="CopyFile.RECENT_KEYS">
      <recent name="E:\GitWorkSpace\F15KS380F220\src\main\resources" />
      <recent name="E:\GitWorkSpace\F15KS380F220\src" />
      <recent name="E:\GitWorkSpace\F15KS380F220\src\main\java" />
    </key>
  </component>
@@ -77,7 +78,7 @@
      <updated>1732846666166</updated>
      <workItem from="1732846667277" duration="1065000" />
      <workItem from="1732847916385" duration="300000" />
      <workItem from="1732848277773" duration="9000" />
      <workItem from="1732848277773" duration="317000" />
    </task>
    <task id="LOCAL-00001" summary="111">
      <created>1732848124481</created>

 src/.gitignore

New file
@@ -0,0 +1,7 @@
/.idea/
/target/
.idea
target/
/src/main/webapp/
F15KS380F220.iml
.class

 src/main/java/com/whyc/controller/UserInfController.java

@@ -19,9 +19,8 @@

    @ApiOperation(value = "查询所有用户信息",notes = "排除uid在100以内的(100以内默认是管理员)")
    @GetMapping("getAllUser")
    public Response getAllUser(@RequestParam(required = false) String uname,@RequestParam(required = false) String realName,@RequestParam(required = false) Integer role
            ,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllUser(uname,realName,role,pageCurr,pageSize);
    public Response getAllUser(@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllUser(pageCurr,pageSize);
    }

    @ApiOperation(value = "查询所有用户信息(不分页用于包机组)")

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

@@ -11,7 +11,7 @@
    //判断是否存在普通用户(uid>100)，若无,初始为1001
    int judgeUname();
    //查询所有用户信息
    List<UserInf> getAllUser(@Param("uname")String uname,@Param("realName")String realName,@Param("role")Integer role);
    List<UserInf> getAllUser();
    //查询100~1000中最大的uid
    String getIn1000();
    //创建100~1000的id表,不存在则创建

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

@@ -30,9 +30,9 @@
    private UserInfMapper mapper;

    //查询所有用户信息
    public Response getAllUser(String uname,String realName,Integer role, int pageCurr, int pageSize) {
    public Response getAllUser(int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        List<UserInf> list=mapper.getAllUser(uname,realName,role);
        List<UserInf> list=mapper.getAllUser();
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"数据返回");
    }

 src/main/resources/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>

 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.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>

 src/main/resources/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>