- 博客(17)
- 资源 (1)
- 收藏
- 关注
原创 CentOS7 离线安装系统软件
1、首先查看Linux 的系统版本号cat /etc/redhat-release2、下载相应版本的镜像文件下载地址:http://vault.centos.org/7.2.1511/isos/x86_64/把7.2.1511改成你的相对版本号,我这里选择种子文件下载,速度还可以。3、解压CentOS7操作系统安装镜像,进入到CentOS-7.2-1511-x86_64-DVD\Pac...
2019-12-08 19:47:01
1003
原创 java包自启动配置
1、cd /usr/lib/systemd/system2、新建开机自启脚本 vi xxx-service.service#!/bin/sh[Unit]Description=serverCenter-serviceAfter=syslog.target network.target remote-fs.target nss-lookup.target[Service]Type=f...
2019-12-03 14:51:14
186
原创 MYSQL5.7版本安装教程
安装:转自https://segmentfault.com/a/1190000003049498检测系统是否存在mysqlyum list installed | grep mysql删除mysql依赖项yum -y remove mysql-libs.x86_643.给CentOS添加rpm源,并且选择较新的源wget dev.mysql.com/get/mysql-communi...
2019-10-10 18:55:41
358
原创 MYSQL5.7版本卸载教程
卸载方法:1.快速删除yum remove mysql mysql-server mysql-libs mysql-server2.查找残留文件rpm -qa | grep -i mysql将查询出来的文件逐个删除,如:yum remove mysql-community-common-5.7.20-1.el6.x86_644.查找残留目录whereis mysql逐条删除目录...
2019-10-10 18:54:15
235
原创 mybatis动态传入order by 参数的正确方式
正确方式:ORDER BY #{shop_id} 换成 ORDER BY ${shop_id}备注: #{shop_id}是过滤列值, ¥{shop_id}是过滤列名
2019-06-28 15:52:18
3891
4
原创 MYSQL数据累加后出现断层问题
断层描述:断层的SQL为:WITH temp AS (SELECT SUBSTR(T.entry_time FROM 1 FOR 7) AS cal_month, COUNT(1) AS per_monthFROM ziguang-personnal.employee TWHERE T.status = 1AND YEAR(NOW())>= SUBSTR(T.entry_time...
2019-06-27 17:19:49
651
转载 mysql 按月分组累计统计数据,纯sql实现的一个方法
转载至:https://blog.csdn.net/guoleiding888/article/details/54426052在网上查阅了很多方法,我尝试了用后台java,但实现起来比较麻烦,最后自己探索用纯sql来实现,记录起来分享下。mysql 按月分组累计统计数据,想得到如下的结果,如下图:【year_and_month】- 显示按月分组查询的字段【count_per_month...
2019-06-27 15:44:41
3435
转载 JAVA将时间加/减8小时
SimpleDateFormat sdfFormat = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);Date dateStart;Date dateEnd;try {dateStart = sdfFormat.parse(“2019-01-01 00:00:00");dateEnd = sdfFormat.parse(“2019-02-01 ...
2019-05-23 20:41:53
19002
转载 ES报错Result window is too large问题处理
我在使用Elasticsearch进行search查询的过程中,出现了Result window is too large问题。这里简单做一个报错复现In [1]: import requestsIn [2]: requests.get(‘http://127.0.0.1:9200/cmdb-now/_search?page=1&size=10000000’).json()Out[...
2019-05-19 10:47:45
1309
原创 JAVA将带时区的时间格式字符串转换成yyyy-MM-dd HH:mm:ss格式字符串
public static void main(String[] args) {try{// SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd’T’HH:mm:ss.SSS’+’”);// Date date = sdf.parse(“2019-05-14T13:49:23.047+08...
2019-05-15 11:43:46
7750
转载 MYSQL中如何以0.5为单位进行四舍五入计算
方案1:select (case when A-cast(A as signed)>0.5 then cast(cast(A as signed) as decimal)+0.5else cast(cast(A as signed) as decimal) end ) as col1from t1方案2:DECLARE @T TABLE(Col1 DECIMAL(18,2))IN...
2019-05-08 09:53:02
1917
原创 no applicable action for [springProfile], current ElementPath is [[configuration][springProfile]]
09:39:22,934 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@11:100 - no applicable action for [springProperty], current ElementPath is [[configuration][springProperty]]09:39:22,940 |-ERROR in ...
2019-05-07 14:14:46
9613
2
原创 【Spring Cloud】服务启动过程中连接Fetching config from server at : http://localhost:8888
1、微服务启动报错:2019-05-06 15:10:31.436 INFO 20248 — [ restartedMain] c.c.c.ConfigServicePropertySourceLocator : Fetching config from server at : http://localhost:88882019-05-06 15:10:32.533 INFO 20248...
2019-05-06 16:51:23
17854
8
转载 jdk8的特性stream().map()
转:https://blog.csdn.net/sanchan/article/details/70753645java8的optional的使用:http://www.jdon.com/idea/java/using-optional-effectively-in-java-8.htmlhttp://www.runoob.com/java/java8-optional-class.htm...
2019-05-05 15:04:36
9859
转载 Intellij – 无法使用较新的Java 8类 – 错误:“API的用法记录为@since 1.8+
IDEA软件报错内容:问题描述我试图在我的java 8代码库中使用java.lang.function.Function,但是我在Intellij中收到以下错误。Usage of API documented as @since 1.6+ This inspection finds all usages of methods that have @since tag in their do...
2019-05-05 15:01:50
1587
转载 spring boot 使用 MyBatis编译报错-元素内容必须由格式正确的字符数据或标记组成.
报错内容:Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation. Cause: org.a...
2019-05-05 11:00:09
957
原创 SpringCloud搭建Feign遇到的坑
在feign启动类中要加入scanbasePackages注解,org.bi.service对应的路径是@FeignClient注解所在的路径@SpringBootApplication(scanBasePackages = “org.bi.service”)当遇到多个参数时,需要为每个参数添加@PathVariable注解,否则在启动编译时报错,提body类型的入参太多。...
2018-12-13 20:08:15
1186
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人