Stringtest(Stringhql){QueryTranslatorImpltranslator=newQueryTranslatorImpl("queryIdentifier",hql,Collections.EMPTY_MAP,(SessionFactoryImplementor)getSessionFactory());translator.compile(Collections.EM
以管理员身份运行cmd,cdD:\mysql5.7.5m15winx64\binmysqldinitializeinsecureuser=mysqlmysqldinstallnetstartMySQLmysqlurootpalteruser'root'@'localhost'identifiedby'123456';commit;
重新定义range分区表:ALTERTABLEcfg_logDROPPRIMARYKEY,ADDPRIMARYKEY(unid,create_date)USINGBTREE;Altertablecfg_logpartitionbyrange(YEARWEEK(create_date))(partitionp1valueslessthan(202001),partitionp2valueslesst
mysqldinitializeconsolemysqldinstallnetstartmysqlmysqlurootpalteruser'root'@'localhost'identifiedby'123456';commit;
logs.idea.gittargetdist.mvn.classpath.factorypath.apt_generated.project.settings.springBeans.sts4cache.iws.iml.iprThumbs.dbehthumbs.dbDesktop.ini.DS_Store.lognode_modules/.pdb.DS_Storelocalenvfiles.en
<!https://mvnrepository.com/artifact/org.apache.commons/commonstext<dependency<groupIdorg.apache.commons</groupId<artifactIdcommonstext</artifactId<version1.9</version</dependencyStringEscapeUtils.une
将任意mysql一个版本中bin/mysql.exe，复制到指定目录下。如d:\mysql:cdd:\mysqlmysqlh192.168.0.110urootp1233showdatabases;usetest1;
usernobody;worker_processes1;error_loglogs/error.log;error_loglogs/error.lognotice;error_loglogs/error.loginfo;pidlogs/nginx.pid;events{worker_connections1024;}http{includemime.types;default_typeappli
server{listen8082;server_namelocalhost;charsetkoi8r;access_loglogs/host.access.logmain;location/{root/home/a8082/dist/;indexindex.htmlindex.htm;try_filesuriuri//index.html;}error_page404/404.html;redi
打开vim/etc/docker/daemon.json（若没有自行创建）{"registrymirrors":"https://docker.mirrors.ustc.edu.cn"}重启一下dockersystemctlrestartdocker
打开idea,若初次打开，先免费试用。然后在idea主界面，将ideevalresetter2.1.6.zip直接拖放来。会提示重启，若没提示，自己重启下。重启后，在菜单【Help】【EvalReset】,按钮【Reload】刷新界面上的显示信息。按钮【Reset】点击后会询问是否重置试用信息并重启IDE。选择Yes则执行重置操作并重启IDE生效.勾选项【Autoresetbeforeperres
mysql8下载：https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL8.0/zip包安装的，启动服务时，提示：服务没有响应控制功能msi安装的，提示requiresviusalstudio2019x64redistributable解决方案：安装viusalstudio2019x64下载地址：链接：https://pan.baidu
若：netstat:未找到命令，则安装：yumyinstallnettoolsnetstattunlpgrep端口号t(tcp)仅显示tcp相关选项u(udp)仅显示udp相关选项n拒绝显示别名，能显示数字的全部转化为数字l仅列出在Listen(监听)的服务状态p显示建立相关链接的程序名netstattunlpgrep8080
yumyinstallwget
批量拼接修改字段的字符集：SELECTCONCAT('ALTERTABLE',TABLE_SCHEMA,'.',TABLE_NAME,'MODIFYCOLUMN',COLUMN_NAME,'',COLUMN_TYPE,'CHARACTERSETutf8mb4COLLATEutf8mb4_general_ciCOMMENT"',COLUMN_COMMENT,'";')as'sql'FROMinfor
worker_processes1;events{worker_connections1024;}http{includemime.types;default_typeapplication/octetstream;sendfileon;keepalive_timeout65;upstreamnoticeapp{server127.0.0.1:9002;server127.0.0.1:9003;}
url='http://localhost:9002/api/external/test1'code=curlconnecttimeout5m5Io/dev/null/sw%{http_code}urldt="date'+%Y%m%d%H:%M:%S'"if((code200))thenecho"dtcode=code"/opt/notice2/logs/a.logexit0elseecho"dt
mapperUserselectNickNameAndUserId(@Param(Constants.WRAPPER)LambdaQueryWrapper<UserqueryWrapper);mapper.xml<selectid="selectNickNameAndUserId"resultType="com.example.demo.entity.User"select<iftest="ew!
JSONField注解在属性上，作用为：属性的名称与转为toString的名称不一样时，使用该注解。例如：@JSONField(name="user_id")privateStringuserId;当userId="a";使用：JSON.toJSONString(entity)输出为：{"user_id":"a"}JsonProperty作用：当接口请求或前端请求，实体类为参数。属性名与请求的名称
使用注解@RestControllerAdvice新建自定义类：/desc@authorcjq@date2022/10/11/@RestControllerAdvice(value={"com.xxx.sjcj"},annotations={ResultWrapper.class})publicclassCustomResponseBodyAdviceimplementsResponseBodyA
定义一个拦截器：@ComponentpublicclassSjcjInterceptorimplementsHandlerInterceptor{@OverridepublicbooleanpreHandle(HttpServletRequestrequest,HttpServletResponseresponse,Objecthandler)throwsException{if(!(handle
定义ContextHolderContextHolder用来存放和获取线程变量中的用户id、用户名称、Token等信息。/获取当前线程变量中的用户id、用户名称、Token等信息注意：必须在网关通过请求头的方法传入，同时在Interceptor拦截器设置值。否则这里无法获取/publicclassSecurityContextHolder{privatestaticfinalTransmittab
会出现这样的错，因为我在拦截器中：PrintWriterout=response.getWriter();然后拦截器返回true.请求继续走到controller中。controller返回又要获取Writer，此时就会报错。因此，拦截器返回true时，不能有response.getWriter();的调用。把该语句写在false的处理块中。
代码1：for(vari=1;i<=5;i){setTimeout(functiontimer(){console.log(i);},i＊1000);}正常情况下，我们对这段代码行为的预期是分别输出数字1～5，每秒一次，每次一个。但实际上，这段代码在运行时会以每秒一次的频率输出五次6。代码2：for(vari=1;i<=5;i){(function(){setTimeout(functiontim
mysql报错：1ofSELECTlistisnotinGROUPBYclause解决：SETGLOBALsql_mode=(SELECTREPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));这个设置，重启后，会失效。mysql8直接在安装的根目录新建my.ini内容为：mysqldsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_
下载地址：http://mirrors.hust.edu.cn/apache/zookeeper/2)下载后解压到一个目录：eg:D:\Java\Tool\zookeeper3.4.103)在zookeeper3.4.10目录下，新建文件夹，并命名(eg:data).(路径为：D:\Java\Tool\zookeeper3.4.10\conf\data)4)进入Zookeeper设置目录，eg:D
vinginx.conf在gzipon;之后添加：upstreamorg.tonny.balance{server127.0.0.1:8081weight=1;server127.0.0.1:8082weight=1;}在server节点下：location/{roothtml;indexindex.htmlindex.htm;proxy_passhttp://org.tonny.balance}
SELECTa.,e.userNameaschatUser,e.contentascontent,e.chatTimeaschatTimeFROMgp_groupASaLEFTJOIN(SELECTb.FROMchat_contentbLEFTJOIN(SELECTMAX(c.id)ASid,c.groupUnidFROMchat_contentcGROUPBYc.groupUnid)ASdONd
wgetichttp://dev.mysql.com/get/mysql57communityreleaseel710.noarch.rpmyumyinstallmysql57communityreleaseel710.noarch.rpmyumyinstallmysqlcommunityserversystemctlstartmysqld.service查看状态：systemctlstatusm
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
