添加列清除

whycxzp

2021-07-15 38bd3114c0ee3b8acb3e0fdd4b85671b62603c31

添加列清除

 src/main/java/com/whyc/Application.java

@@ -33,6 +33,7 @@
        ClearTableService service = (ClearTableService) applicationContext.getBean("clearTableService");
        service.clearTable();
        service.dropTable();
        service.clearColumn();
        int sleepSeconds = 5;
        System.out.println("清除/删除操作完成,"+sleepSeconds+"秒后自动退出程序...");
        try {

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

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

import com.whyc.dto.TableDTO;
import org.apache.ibatis.annotations.Update;

import java.util.List;

@@ -13,4 +14,7 @@
    List<TableDTO> findTableListLike(List<TableDTO> tableList);

    List<TableDTO> findAllTables();

    @Update("update db_battinf.tb_battinf set PublicKeyX = '',PublicKeyY = '',KeyID= '' where num !=0")
    void clearColumn();
}

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

@@ -168,4 +168,7 @@
        return mapper.findTableListLike(tableList);
    }

    public void clearColumn() {
        mapper.clearColumn();
    }
}

 src/main/resources/config/application.yml

@@ -11,7 +11,7 @@
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
#    url: jdbc:mysql://192.168.10.71:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
#    url: jdbc:mysql://192.168.10.221:3360?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
#    url: jdbc:mysql://192.168.10.79:3360?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
#    url: jdbc:mysql://192.168.10.222:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
#    url: jdbc:mysql://118.89.139.230:3360/db_user?characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
    username: root
@@ -40,7 +40,7 @@
    map-underscore-to-camel-case: true
    cache-enabled: false
    #mybatis日志输出
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    #log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
pagehelper:
  helper-dialect: mysql
  reasonable: true

 src/main/resources/config/logback.xml

@@ -36,13 +36,13 @@
    </appender>

    <!--mybatis log configure-->
    <logger name="com.apache.ibatis" level="TRACE"/>
    <logger name="java.sql.Connection" level="DEBUG"/>
    <logger name="java.sql.Statement" level="DEBUG"/>
    <logger name="java.sql.PreparedStatement" level="DEBUG"/>
    <logger name="com.apache.ibatis" level="INFO"/>
    <logger name="java.sql.Connection" level="INFO"/>
    <logger name="java.sql.Statement" level="INFO"/>
    <logger name="java.sql.PreparedStatement" level="INFO"/>

    <!-- 开发环境日志输出级别 -->
    <root level="DEBUG">
    <root level="INFO">
        <appender-ref ref="STDOUT" />
        <appender-ref ref="FILE"/>
    </root>