文章 - 学习

MyBatisPlus连表使用Wrapper

```SELECTa.*,b.xFROMa,b${ew.customSqlSegment}page(Pagepage,Wrapperew)```**注意：条件名称必须`ew`**

2022年05月10日 MyBatisPlus Wrapper 连表
web.xml常用配置

```www.acgist.comindex.jspindex.htmlencodingFilterorg.springframework.web.filter.CharacterEncodingFilterencodingUTF-8encodingFilter/*adminFiltercom.acgist.web.filter.AdminFilteradminFilter/admin/*pageCachingFilternet.sf.ehcache.constructs.web.filter.SimplePageCachingFiltersuppressStackTracesfalsecacheNamepageCachepageCachingFilter/imagepageCachingFilter/articlepageCachingFilter/common/*pageCachingFilter/index.jspcontextConfigLocationclasspath*:/applicationContext.xmlmvcorg.springframework.web.servlet.Dispat...

2022年05月10日 web.xml
Tomcat常用配置

##server.xml``````##配置日志```#LicensedtotheApacheSoftwareFoundation(ASF)underoneormore#contributorlicenseagreements.SeetheNOTICEfiledistributedwith#thisworkforadditionalinformationregardingcopyrightownership.#TheASFlicensesthisfiletoYouundertheApacheLicense,Version2.0#(the"License");youmaynotusethisfileexceptincompliancewith#theLicense.YoumayobtainacopyoftheLicenseat##http://www.apache.org/licenses/LICENSE-2.0##Unlessrequiredbyapplicablelaworagreedtoinwriting,software#distributedundertheLicenseisdistributedon...

2022年05月10日 Tomcat
systemd常用配置

配置`linux`服务`vi/etc/systemd/system/service.service`内容：```[Unit]Description=描述信息After=network.targetnetwork-online.targetWants=network.targetnetwork-online.target[Service]User=root#forking：本身就是后台进程Type=simple|forking|notifyKillMode=processExecStart=启动命令ExecReload=/bin/kill-HUP$MAINPIDExecStop=/bin/kill-QUIT$MAINPID#always：如果不是关闭自动重启Restart=no|always|on-failureRestartSec=5s[Install]WantedBy=multi-user.target```然后加载服务：```systemctldaemon-reload```配置里面所有命令需要使用完整路径，否者可能提示下面错误：```May0915:44:02acgistsystemd[1]:servi...

2022年05月10日 systemd
Ehcache常用配置

``````

2022年05月10日 Ehcache
nginx常用配置

```usernginx;worker_processes1;pid/var/run/nginx.pid;error_log/var/log/nginx/error.logwarn;events{useepoll;worker_connections65536;}http{include/etc/nginx/mime.types;include/etc/nginx/conf.d/*.conf;default_typeapplication/octet-stream;gzipon;gzip_typestext/xmlimage/x-icontext/javascripttext/csstext/plainimage/gifimage/jpegimage/pngimage/jpgapplication/jsonapplication/x-javascriptimage/svg+xmlapplication/vnd.ms-fontobjectapplication/x-font-ttffont/opentypefont/x-woff;gzip_min_length1k;log_formatmain'$remote_...

2022年05月10日 nginx
MySQL常用配置

```[client]port=3306socket=/tmp/mysql.sockdefault-character-set=utf8mb4[mysql]no-auto-rehashdefault-character-set=utf8mb4[mysqld]port=3306user=mysqlsocket=/tmp/mysql.sock#安装目录：可以忽略basedir=/usr/local/mysql-5.7.26#数据目录：初始化后不能修改datadir=/home/mysql/dataserver-id=1bind-address=0.0.0.0log-bin=mysql-binbinlog_format=mixedcollation-server=utf8mb4_general_cicharacter-set-server=utf8mb4lower_case_table_names=1max_connections=512key_buffer_size=16Mtable_open_cache=128sort_buffer_size=2Mread_buffer_size=2Mnet_buffer_le...

2022年05月10日 MySQL
Maven常用配置

```sonatype_releasesacgistpasswordsonatype_snapshotsacgistpasswordrepo0centralaliyunhttps://maven.aliyun.com/repository/centralrepo1centralHumanReadableNameforthisMirror.http://repo1.maven.org/maven2/repo2centralHumanReadableNameforthisMirror.http://repo2.maven.org/maven2/nexus*localhttp://192.168.1.100:9999/nexus/content/groups/public/gpggpgpasswordnexusnexusPublicRepositorieshttp://centraltruetruenexusPublicRepositorieshttp://centraltruetruegpgnexus```

2022年05月10日 Maven
logback常用配置

```${system.name}${system.path}/${system.name}.log${system.history}${system.path}/%d{yyyy-MM,aux}/${system.name}.%d{yyyy-MM-dd}.log.gz${system.buffer}false${system.charset}${system.pattern}${system.queue}true0${system.charset}${system.pattern}```

2022年05月10日 logback
log4j常用配置

```log4j.rootLogger=info,FILE,Console#这个选项用于控制监控logger的日志不会输出到rootlogger，否则无论会产生许多重复的数据，同时也会影响性能log4j.additivity.monitorLogger=false#文件log4j.appender.FILE=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.FILE.File=logs/www.acgist.com.loglog4j.appender.FILE.Append=truelog4j.appender.FILE.layout=org.apache.log4j.PatternLayoutlog4j.appender.FILE.BufferedIO=truelog4j.appender.FILE.BufferSize=8192log4j.appender.FILE.layout.ConversionPattern=[www.acgist.com]%d%-10r%-10p[%t]%40c%x--%m%nlog4j.appender.FILE.e...

2022年05月10日 log4j
docker常用配置

##配置加速```vi/etc/docker/daemon.json{"registry-mirrors":["https://docker.mirrors.ustc.edu.cn"]}systemctlrestartdocker```

2022年05月10日 docker
docker-compose常用配置

```version:"3.1"services:redis:container_name:redisimage:redis:6.2.6restart:alwaysprivileged:truecommand:redis-server/etc/redis/redis.confports:-6379:6379volumes:-/etc/localtime:/etc/localtime:ro-$PWD/redis/data:/data-$PWD/redis/redis.conf:/etc/redis/redis.confenvironment:-TZ=Asia/Shanghainacos:container_name:nacosimage:nacos/nacos-server:v2.0.3restart:alwaysprivileged:trueports:-8848:8848-9848:9848volumes:-/etc/localtime:/etc/localtime:ro-$PWD/nacos/logs/:/home/nacos/logs-$PWD/nacos/init.d/custom.propertie...

2022年05月10日 docker-compose
Linux加载Java图形验证码错误

错误信息：```Causedby:java.lang.reflect.InvocationTargetException:nullatjava.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)atjava.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)atjava.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)atjava.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)atjava.base/java.lang.reflect.Construct...

2022年05月08日 Linux Java 验证码
解决方向代理错误

使用`iframe`提示错误：```MixedContent:Thepageat'https://www.acgist.com'wasloadedoverHTTPS,butrequestedaninsecureformaction'http://www.acgist.com'.Thisrequesthasbeenblocked;thecontentmustbeservedoverHTTPS.````Tomcat`配置：```````SpringBoot`配置：```tomcat:remoteip:host-header:X-Forwarded-Hostprotocol-header:X-Forwarded-Protoremote-ip-header:X-Forwarded-Forprotocol-header-https-value:https```

2022年05月08日 iframe nginx tomcat SpringBoot
feign oauth2

```hystrix:command:default:execution:isolation:strategy:SEMAPHORE@Bean@ConditionalOnMissingBeanpublicRequestInterceptorfeignRequestInterceptor(){returnnewRequestInterceptor(){//privatefinalStringBEARER_TOKEN_TYPE="Bearer";privatefinalStringAUTHORIZATION_HEADER="Authorization";@Overridepublicvoidapply(RequestTemplaterequestTemplate){finalRequestAttributesrequestAttributes=RequestContextHolder.currentRequestAttributes();if(requestAttributes!=null){finalHttpServletRequestrequest=((ServletRequestAttributes)requ...

2022年05月07日 feign oauth2
Chrome不自动跳转HTTPS

```chrome://net-internals/#hsts```删除自动跳转域名

2022年05月06日 Chrome
CentOS7安装Redis

```yuminstallepel-releaseyuminstallredissystemctlenableredissystemctlstartredis```

2022年05月06日 CentOS redis
idea yml maven filter @@配置不能替换

eclipse正常替换，idea需要添加依赖：```org.yamlsnakeyaml```

2022年04月29日 idea yml maven filter
复杂SQL

##分组组内统计```selectname,count(*),count(score=60ornull),count(score=90ornull),count(score=100ornull)fromt_usergroupbyname;```注意：这里`ornull`必须填写##分区函数```partitionby```##条件```(casewhen...then...when...then...end)```

2022年04月29日 SQL
minio okhttp错误

找了好久错误结果是配置了jvm参数xss的问题：```java.lang.StackOverflowErroratorg.springframework.boot.loader.LaunchedURLClassLoader.loadClass(LaunchedURLClassLoader.java:151)atjava.base/java.lang.ClassLoader.loadClass(UnknownSource)atokhttp3.internal.Util.(Util.kt:595)atokhttp3.HttpUrl$Builder.parse$okhttp(HttpUrl.kt:1239)atokhttp3.HttpUrl$Companion.get(HttpUrl.kt:1633)atokhttp3.HttpUrl$Companion.parse(HttpUrl.kt:1642)atokhttp3.HttpUrl.parse(HttpUrl.kt)atio.minio.MinioClient$Builder.getBaseUrl(MinioClient.java:2791)atio.minio....

2022年04月28日 minio okhttp

1 2 3 4 ...27