更新

whycxzp

2025-04-24 c22a5028308bf9f22423bdca85f9b337334103d7

更新

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

@@ -7,15 +7,6 @@

public interface UserMapper extends CustomMapper<User> {

    User getUserInfoByPhoneNumber(@Param("phoneNumber") String phoneNumber);

    int addJudge(@Param("uName") String uName,@Param("uPhoneNumber") String uPhoneNumber);

    List<User> searchCS_All2();

    List<User> getUserInfoByStationId(@Param("stationId") String stationId);


    void updatePasswordsTo3072(List<User> userListWithNewPwd);
    int addJudge(@Param("name") String name,@Param("phoneNumber") String phoneNumber);

}

 src/main/resources/config/application-dev.yml

@@ -25,8 +25,8 @@
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
#    url: jdbc:mysql://localhost:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
    url: jdbc:mysql://192.168.10.79:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
#    url: jdbc:mysql://localhost:3360/db_battery_gwm?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
    url: jdbc:mysql://192.168.10.79:3360/db_battery_gwm?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
    username: root
    password: ENC(0BFKp+nuSlmBu4YAB8U7rn5PoV2QVyGu)
#    username: whyc

 src/main/resources/config/application-prod.yml

@@ -5,14 +5,14 @@
  subType: 1
#服务端口号
server:
  port: 8919
  port: 8080
  serverHeader:
  servlet:
    context-path: /fg
    context-path: /bg
    session:
      timeout: -1
      cookie:
        name: fg_v2
        name: bg
        http-only: true
  tomcat:
    max-http-form-post-size: 102400000
@@ -23,10 +23,8 @@
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
    #    url: jdbc:mysql://192.168.10.79:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://192.168.10.80:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    #    url: jdbc:mysql://118.89.139.230:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
    url: jdbc:mysql://localhost:3360/db_battery_gwm?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useSSL=false
    #    url: jdbc:mysql://192.168.10.79:3360/db_battery_gwm?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
#    username: root
#    password: ENC(0BFKp+nuSlmBu4YAB8U7rn5PoV2QVyGu)
    username: whyc

 src/main/resources/config/logback-spring.xml

@@ -8,12 +8,12 @@

    <!-- 定义文件输出 -->
    <appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>web_logs/fg.log</file>
        <file>web_logs/battery_gwm.log</file>
        <encoder>
            <pattern>%d{yyyy-MM-dd HH:mm:ss} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
        <rollingPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedRollingPolicy">
            <fileNamePattern>web_logs/fg-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
            <fileNamePattern>web_logs/battery_gwm-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
            <maxFileSize>50MB</maxFileSize>
            <maxHistory>30</maxHistory>
        </rollingPolicy>

 src/main/resources/mapper/UserMapper.xml

@@ -1,34 +1,9 @@
<?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.UserMapper" >
    <update id="updatePasswordsTo3072">
        <foreach collection="list" item="item" separator=";">
            update db_user.tb_user_inf set uSnId = #{item.uSnId},upassword = #{item.uSnId} where uId = #{item.uId}
        </foreach>
    </update>

    <select id="addJudge" resultType="int">
        select count(uid) as nums from db_user.tb_user_inf where uname=#{uName} or uMobilephone=#{uPhoneNumber} limit 1
    </select>



    <select id="getUserInfoByPhoneNumber" resultType="com.whyc.pojo.User">
        select * from db_user.tb_user_inf where uMobilephone =#{phoneNumber} limit 1
    </select>
    <select id="searchCS_All2" resultType="com.whyc.pojo.User">
        SELECT uId,uName FROM db_user.tb_user_inf  where uId not in (select distinct uId from db_user.tb_user_permitgroup_data) and uId!=0
        order by uId
    </select>
    <select id="getUserInfoByStationId" resultType="com.whyc.pojo.User">
        select distinct u.uId,u.uName from
        db_user.tb_user_battgroup_baojigroup_battgroup group1,
        db_user.tb_user_battgroup_baojigroup_usr groupUser,
        db_user.tb_user_inf u
        where group1.baoji_group_id = groupUser.baoji_group_id
        and groupUser.uId = u.uId
        and u.uRole != 0
        and group1.StationId = #{stationId}
        select count(id) as nums from db_battery_gwm.tb_user where name=#{name} or phone_number=#{phoneNumber} limit 1
    </select>

</mapper>