<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[zy_whynot的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zy_whynot</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zy_whynot]]></copyright><item><title><![CDATA[! [remote rejected] master -＞ master (pre-receive hook declined)]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/143467945</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/143467945</guid><author>zy_whynot</author><pubDate>Sun, 03 Nov 2024 17:50:07 +0800</pubDate><description><![CDATA[最后出现Ref ‘refs/heads/master’ was rewritten则表示删除成功。根据报错描述，报错的原因是上传文件超过100M，因此我们需要找到此文件删除即可。]]></description><category></category></item><item><title><![CDATA[使用dateutil的parser.parse()格式化时间对象]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/133741403</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/133741403</guid><author>zy_whynot</author><pubDate>Tue, 10 Oct 2023 10:38:07 +0800</pubDate><description><![CDATA[时间串格式转时间]]></description><category></category></item><item><title><![CDATA[pymyslq 批量导入或更新数据]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/132212996</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/132212996</guid><author>zy_whynot</author><pubDate>Thu, 10 Aug 2023 16:37:25 +0800</pubDate><description><![CDATA[【代码】pymyslq 批量导入或更新数据。]]></description><category></category></item><item><title><![CDATA[shell 端口占用 杀死进程]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/126876293</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/126876293</guid><author>zy_whynot</author><pubDate>Thu, 15 Sep 2022 17:50:23 +0800</pubDate><description><![CDATA[shell 端口占用 杀死进程]]></description><category></category></item><item><title><![CDATA[IllegalStateException: No fallbackFactory instance of type class com.zy.service.DeptServiceFallBackF]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/125137716</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/125137716</guid><author>zy_whynot</author><pubDate>Sun, 05 Jun 2022 22:26:13 +0800</pubDate><description><![CDATA[IllegalStateException: No fallbackFactory instance of type class com.zy.service.DeptServiceFallBackFactory found for feign client PROVIDER]]></description><category></category></item><item><title><![CDATA[配置redis支持远程连接]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/125024748</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/125024748</guid><author>zy_whynot</author><pubDate>Sat, 28 May 2022 22:58:59 +0800</pubDate><description><![CDATA[q前提已经安装好redis
1. 配置 redis.conf
vim /usr/local/bin/redis-conf/redis.conf

# 找到 bind 将其注释
#bind 127.0.0.1
# 找到 protected-mode 值改为 no
protected-mode yes 改为 no
 # 设置后台运行
daemonize no 改为 yes
# 设置连接密码 
requirepass redis123

重启redis
# 1. 查看redis服务进程
ps -ef | grep]]></description><category></category></item><item><title><![CDATA[SpringBoot集成Swagger报错：Error starting ApplicationContext. To display the conditions report re-run you]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/124810046</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/124810046</guid><author>zy_whynot</author><pubDate>Mon, 16 May 2022 22:49:07 +0800</pubDate><description><![CDATA[参考：http://www.manongjc.com/detail/26-xgqljammdsnylqt.html
问题描述
之前项目是运行正常的，当我们添加项目SpringBoot中注入了Swagger配置类时，运行报错
@Configuration  // 声明这是一个配置类，并注册到Spring容器
@EnableSwagger2  // 开启Swagger的自动配置
public class SwaggerConfig {
}

报错信息
Error starting ApplicationCont]]></description><category></category></item><item><title><![CDATA[maven导出异常：MapperRegistry、Mapper.xml、mybatis-config.xml]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/123622918</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/123622918</guid><author>zy_whynot</author><pubDate>Sun, 20 Mar 2022 22:18:03 +0800</pubDate><description><![CDATA[1. 错误一
1.1 错误信息
org.apache.ibatis.binding.BindingException: Type interface com.zy.dao.UserDao is not known to the MapperRegistry.

1.2 原因分析
没有Mybatis的核心配置文件Mybatis-config.xml中注册新建的Mapper
1.3 解决方式
在Mybatis的配置文件Mybatis-config.xml中注册新建的UserMapper
&lt;?xml ver]]></description><category></category></item><item><title><![CDATA[servlet已经配置url映射，提示Servlet should have a mapping and cannot resolve Servlet，访问404]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/123057833</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/123057833</guid><author>zy_whynot</author><pubDate>Mon, 21 Feb 2022 22:51:56 +0800</pubDate><description><![CDATA[问题描述
在学习servlet时，写好servlet，并在web.xml配置文件中配置了url映射，如下：
&lt;!DOCTYPE web-app PUBLIC
        "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd" &gt;

&lt;web-app&gt;
    &lt;display-name&gt;Archetype Cre]]></description><category></category></item><item><title><![CDATA[ImportError: dlopen(/Users/quzhen/.conda/envs/supply/lib/python3.6/site-packages/MySQLdb/_mysql.cpyt]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/122302756</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/122302756</guid><author>zy_whynot</author><pubDate>Tue, 04 Jan 2022 14:50:25 +0800</pubDate><description><![CDATA[问题
ImportError: dlopen(/Users/quzhen/.conda/envs/supply/lib/python3.6/site-packages/MySQLdb/_mysql.cpython-36m-darwin.so, 2): Library not loaded: @rpath/libmysqlclient.21.dylib
  Referenced from: /Users/quzhen/.conda/envs/supply/lib/python3.6/site-packages]]></description><category></category></item><item><title><![CDATA[Package ‘importlib-metadata‘ requires a different Python: 3.6.10 not in ‘＞=3.7‘]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/122085759</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/122085759</guid><author>zy_whynot</author><pubDate>Wed, 22 Dec 2021 14:53:29 +0800</pubDate><description><![CDATA[报错
 ERROR: Package 'importlib-metadata' requires a different Python: 3.6.10 not in '&gt;=3.7'
 WARNING: You are using pip version 20.0.2; however, version 21.3.1 is available.
 You should consider upgrading via the '/usr/local/bin/python -m pip install --u]]></description><category></category></item><item><title><![CDATA[sql 排序order by重复数据问题]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121774354</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121774354</guid><author>zy_whynot</author><pubDate>Tue, 07 Dec 2021 17:33:35 +0800</pubDate><description><![CDATA[参考资料
Mysql 分页order by一个相同字段,发现顺序错乱
深挖PostgreSQL中两个（或多个）字段同时order by 时内部的潜在规则
问题
在开发的过程中如果数据特别多，需要做排序分页，如果排序的字段值相同是，就在分页中出现重复的数据。即实际100条的数据，经过排序分页可能会是103条
分析
因为order by之后的字段值相同时，mysql（或者postgreSQL）也不知道该怎么排
解决
在order by之后再加一个字段（最好是唯一的），其目的就告诉mysql当第一个字段重复时，再]]></description><category></category></item><item><title><![CDATA[Python 获取上个月和下个月]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121747899</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121747899</guid><author>zy_whynot</author><pubDate>Mon, 06 Dec 2021 15:22:05 +0800</pubDate><description><![CDATA[import datetime
from dateutil.relativedelta import relativedelta

print(datetime.date.today())
print(datetime.date.today() - relativedelta(months=+1))
print(datetime.date.today() - relativedelta(months=-3)


]]></description><category></category></item><item><title><![CDATA[PYTHON 读取EXCEL表格的数据]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121637306</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121637306</guid><author>zy_whynot</author><pubDate>Tue, 30 Nov 2021 16:59:46 +0800</pubDate><description><![CDATA[参考资料
PYTHON 读取EXCEL表格的数据
# -*- coding: utf-8 -*-
import xlrd
def read_excel():
    # 打开文件
    workbook = xlrd.open_workbook(r'E:\pycharm project\movies.xls')
    # 获取所有sheet
    print workbook.sheet_names() # [u'sheet1', u'sheet2']
    #获取sheet2
    sheet2]]></description><category></category></item><item><title><![CDATA[Python利用PyMySQL操作MySQL数据库]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121637114</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121637114</guid><author>zy_whynot</author><pubDate>Tue, 30 Nov 2021 16:56:58 +0800</pubDate><description><![CDATA[参考资料
利用Python操作MySQL数据库 
安装PyMySQL
pip install PyMySQL

Python操作MySQL的步骤如下

建立数据库连接
通过 cursor() 创建游标对象（pymysql通过游标来执行sql和获取结果）
使用 execute() 执行sql
获取结果（查询）/提交事务（增删改）
关闭游标
关闭连接

update
import pymysql

def update_db(update_sql):
    """更新"""
    # 建立数据库连接
   ]]></description><category></category></item><item><title><![CDATA[mysq联表查询优化：小表驱动大表]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121608851</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121608851</guid><author>zy_whynot</author><pubDate>Mon, 29 Nov 2021 14:45:00 +0800</pubDate><description><![CDATA[参考资料
了解MySQL联表查询中的驱动表，优化查询，以小表驱动大表
MySql小表驱动大表
MySQL高级知识（十六）——小表驱动大表 
背景
有的时候我们在操作数据库时会将两个或多个数据表关联起来通过一些条件筛选数据，在关联表时我们要遵循一些原则，这样会使我们编写的SQL 语句在效率上快很多。
为什么要用小表驱动大表

驱动表的定义
当进行多表连接查询时， [驱动表] 的定义为：


指定了联接条件时，满足查询条件的记录行数少的表为[驱动表]
未指定联接条件时，行数少的表为[驱动表]（Important]]></description><category></category></item><item><title><![CDATA[git 从指定的历史版本切创建分支]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121555682</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121555682</guid><author>zy_whynot</author><pubDate>Fri, 26 Nov 2021 11:17:49 +0800</pubDate><description><![CDATA[参考资料
git从历史版本创建新的分支
背景
开发时我们想基于生产分支创建一个新的分支，在上面修改。但发现生产的版本已经落后生产分支最新版本很多，这个时候我们不能直接把最新的版本发布到生产，因为最新的版本可能别人改的，并没有测试的代码，这样贸然发布到生产太过冒险，有可能会引起生产事故。最保险的做法是从生产分支的生产版本切出一个分支。
解决方案
1、找到对应历史版本的SHA值，如：f5e86fbf455960c40e759c48bb0675b54d808611
2、从历史版本新建分支并切换到新的分支：git ]]></description><category></category></item><item><title><![CDATA[git版本回退]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121555249</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121555249</guid><author>zy_whynot</author><pubDate>Fri, 26 Nov 2021 11:05:55 +0800</pubDate><description><![CDATA[参考资料：
git 回退版本代码之后，强制将本地代码推送至远程仓库
git的版本回退教程
背景
由于代码合并或者被别的代码污染了现有的分支，我们想回退到历史上某个正确的版本
解决
版本回退

通过git log 查看提交的历史记录，版本号

Author: authorName &lt;1001111u89432@qq.com&gt;
Date:   Wed Nov 24 19:23:58 2021 +0800

    Merge branch 'master' into 'feature/update_]]></description><category></category></item><item><title><![CDATA[MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Com]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121355136</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121355136</guid><author>zy_whynot</author><pubDate>Tue, 16 Nov 2021 14:27:47 +0800</pubDate><description><![CDATA[参考资料：
资料1
资料2
错误
# set 值时报错
MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Commands that may modify the data set are disabled. Please check Redis logs for details about the error．

原因
大概意思就是不能持久化吧（网上有人说是内存不]]></description><category></category></item><item><title><![CDATA[golang比较时间大小]]></title><link>https://blog.youkuaiyun.com/zy_whynot/article/details/121336430</link><guid>https://blog.youkuaiyun.com/zy_whynot/article/details/121336430</guid><author>zy_whynot</author><pubDate>Mon, 15 Nov 2021 15:56:30 +0800</pubDate><description><![CDATA[golang中比较时间大小的方法有：Before, After, Equal

可以直接比较 time 类型

t1 := time.Now()
t2 := time.Now()
// 取较大时间
if t2.After(t1) {
   return t2
} else {
   return t1
}


先把当前时间格式化成相同格式的字符串,然后使用time的Before, After, Equal 比较

time1 := "2015-03-20 08:50:29"
time2 := "2015-0]]></description><category></category></item></channel></rss>