<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_36617310的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_36617310</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_36617310]]></copyright><item><title><![CDATA[微信native-v3版支付对接流程及demo]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/133738803</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/133738803</guid><author>qq_36617310</author><pubDate>Thu, 19 Oct 2023 17:46:12 +0800</pubDate><description><![CDATA[【代码】微信native-v3版支付对接流程及demo。]]></description><category></category></item><item><title><![CDATA[mysql同一个数据值，获取最新的一条数据]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/127103279</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/127103279</guid><author>qq_36617310</author><pubDate>Thu, 29 Sep 2022 11:03:01 +0800</pubDate><description><![CDATA[745454545454545454545]]></description><category></category></item><item><title><![CDATA[mysql查询树节点]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/123337052</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/123337052</guid><author>qq_36617310</author><pubDate>Mon, 07 Mar 2022 19:57:21 +0800</pubDate><description><![CDATA[SELECT T2.*,T1.lvl
FROM ( 
        SELECT 
                @r AS _id, 
                (SELECT @r := parent_id FROM 数据库的表名 WHERE id = _id) AS parent_id, 
                @l := @l + 1 AS lvl 
        FROM 
                (SELECT @r := '当前节点的ID', @l := 0) .]]></description><category></category></item><item><title><![CDATA[Mysql获取表结构数据，包括表的注释和字段的注释，可用于导出表结构数据]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/105836206</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/105836206</guid><author>qq_36617310</author><pubDate>Wed, 29 Apr 2020 11:37:40 +0800</pubDate><description><![CDATA[--查看表的元信息
select * from TABLES where TABLE_SCHEMA='数据库名称' and TABLE_NAME='表名称'


--获取完整结构数据 

SELECT
table_name 表名,
(select table_comment from TABLES where TABLE_SCHEMA='数据库名称' and TABLE_NAME=aa.tab...]]></description><category></category></item><item><title><![CDATA[docker安装并解决mysql大小写敏感设置]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/105630058</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/105630058</guid><author>qq_36617310</author><pubDate>Mon, 20 Apr 2020 11:03:09 +0800</pubDate><description><![CDATA[进入docker中mysql
docker exec -it 容器id /bin/bash

需要修改的文件
/etc/mysql/mysql.conf.d/mysqld.cnf
需要在这个文件最后添加这一行参数
lower_case_table_names=1

操作方式

cat &gt;&gt; /etc/hosts&lt;&lt;EOF
lower_case_table_names=1
...]]></description><category></category></item><item><title><![CDATA[vue转换时间字符串格式适应ios及安卓]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/104745673</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/104745673</guid><author>qq_36617310</author><pubDate>Mon, 09 Mar 2020 09:10:17 +0800</pubDate><description><![CDATA[1.vue中先引入npm install moment --save

2.创建utils/dateUtils.js工具类


export function formatDate(date, fmt) {
  if (/(y+)/.test(fmt)) {
    fmt = fmt.replace(RegExp.$1, (date.getFullYear() + '').substr(4 - ...]]></description><category></category></item><item><title><![CDATA[图片、文字、录音（mp3）、视频、位置（定位）]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/97628104</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/97628104</guid><author>qq_36617310</author><pubDate>Mon, 29 Jul 2019 10:54:09 +0800</pubDate><description><![CDATA[[{

"from": "p_66710934266241832",

"type": "text",

"text": "Hello world！Hello 云信开发者。我是你在云信Demo上的第一个好友。如果还没添加其他好友进行消息收发测试，那就发给我试试吧！",

"time": "1562168470369",

"sendOrReceive": "receive",
...]]></description><category></category></item><item><title><![CDATA[ftp安装CentOS7和ubuntu]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/86467559</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/86467559</guid><author>qq_36617310</author><pubDate>Mon, 29 Jul 2019 10:49:31 +0800</pubDate><description><![CDATA[1、有问题时完全卸载vsftpd

sudo apt-get purge vsftpd

2、安装vsftpd

sudo apt-get install vsftpd

3、创建ftp用户

方法一：直接在系统设置添加用户
方法二：
创建用户目录 sudo mkdir /opt/uftp
创建用户 sudo useradd -d /opt/uftp -s /bin/bash alanftp
修改...]]></description><category></category></item><item><title><![CDATA[springmvc使用ftp上传文件]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/89399993</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/89399993</guid><author>qq_36617310</author><pubDate>Mon, 29 Jul 2019 10:48:29 +0800</pubDate><description><![CDATA[@RequestMapping(value = "uploadImg.do", method = RequestMethod.POST)
	@ResponseBody
    public Map&lt;String, Object&gt;  fileUpload(@RequestParam(value = "files") MultipartFile file[], HttpServletRe...]]></description><category></category></item><item><title><![CDATA[windows7 tomcat7配置https]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/94561397</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/94561397</guid><author>qq_36617310</author><pubDate>Wed, 03 Jul 2019 14:37:45 +0800</pubDate><description><![CDATA[&lt;Connector port="8443"
  protocol="org.apache.coyote.http11.Http11Protocol"
 connectionTimeout="20000"
  URIEncoding="UTF-8"
 useBodyEncodingForURI="true"
  SSLEnabled="true"
  sch...]]></description><category></category></item><item><title><![CDATA[数据库避免插入重复数据处理]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/89853863</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/89853863</guid><author>qq_36617310</author><pubDate>Sun, 05 May 2019 19:50:10 +0800</pubDate><description><![CDATA[oracle :

insert
when (not exists (select id from t_company_staff where name='赵国军4')) then
into t_company_staff (name,status,APPLIEDTYPE) select '赵国军4',2,1 from dual;



或者

insert
into t_company_st...]]></description><category></category></item><item><title><![CDATA[nginx配置ftp请求]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/89399527</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/89399527</guid><author>qq_36617310</author><pubDate>Fri, 19 Apr 2019 14:30:19 +0800</pubDate><description><![CDATA[nginx.conf

开启权限

user root

配置



server {
    listen    8000;
  
    server_name localhost;

    location / {
      root  /opt/uftp;
      index index.html index.htm...]]></description><category></category></item><item><title><![CDATA[VMware中的虚拟机改变了IP后无法连接]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/89103689</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/89103689</guid><author>qq_36617310</author><pubDate>Mon, 08 Apr 2019 19:34:04 +0800</pubDate><description><![CDATA[编辑----虚拟网络编辑器---还原默认设置



Ubuntu配置和修改IP地址

1、修改配置文件/etc/network/interfacesroot@ubuntu:~#sudo gedit /etc/network/interfaces

添加以下内容：auto eth0 #设置自动启动eth0接口iface eth0 inet static ...]]></description><category></category></item><item><title><![CDATA[oracle "ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效"的快速解决方法]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/86523392</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/86523392</guid><author>qq_36617310</author><pubDate>Thu, 17 Jan 2019 14:08:17 +0800</pubDate><description><![CDATA[select t2.username, t2.sid, t2.serial#, t2.logon_time
from v$locked_object t1, v$session t2
where t1.session_id = t2.sid
order by t2.logon_time;

alter system kill session 'sid,serial';

把sid、serial对应...]]></description><category></category></item><item><title><![CDATA[maven 工程-> update project 报空指针]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/86011081</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/86011081</guid><author>qq_36617310</author><pubDate>Mon, 07 Jan 2019 16:43:20 +0800</pubDate><description><![CDATA[maven 工程-&amp;gt; update project 报空指针

An internal error occurred during: &quot;Updating Maven Project&quot;. java.lang.NullPointerException

查看pom.xml 里面没有任何错误，结果更新工程时，总是报空指针。

解决办法：删除 .project 和.settings 文件，重新导入工...]]></description><category></category></item><item><title><![CDATA[linux 配置jdk和tomcat环境]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/81112260</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/81112260</guid><author>qq_36617310</author><pubDate>Mon, 24 Dec 2018 19:08:06 +0800</pubDate><description><![CDATA[ 

sudo vim ~/.bashrc

JAVA_HOME=/home/java/jdk7 注意jdk的地址
PATH=$JAVA_HOME/bin:$PATH
CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
TOMCAT_HOME=/home/tomcat/tomcat7

 

 ]]></description><category></category></item><item><title><![CDATA[unbuntu 14.04安装mysql]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/84869520</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/84869520</guid><author>qq_36617310</author><pubDate>Tue, 18 Dec 2018 20:18:56 +0800</pubDate><description><![CDATA[
	 

	
		打开&quot;终端窗口&quot;，输入&quot;sudo apt-get update&quot;--&amp;gt;回车--&amp;gt;&quot;输入root用户的密码&quot;--&amp;gt;回车,就可以了。如果不运行该命令，直接安装mysql,会出现&quot;有几个软件包无法下载，您可以运行apt-get update------&quot;的错误提示，导致无法安装。

		

		
		
		
		安装mysql

		打开&quot;终端窗口&quot;，输入]]></description><category></category></item><item><title><![CDATA[unbuntu14.04 nginx开机自动启动]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/84934734</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/84934734</guid><author>qq_36617310</author><pubDate>Mon, 10 Dec 2018 09:10:00 +0800</pubDate><description><![CDATA[在 /etc/init.d/目录下新建一个nginx脚本文件

执行指令 vi /etc/init.d/nginx  写好脚本后,:wq保存退出

给文件增加可执行权限 chmod +x nginx 

切换到  /etc/init.d/下

 创建软连接  

sysv-rc-conf nginx on

重启系统后 nginx将自动启动

以下为nginx脚步内容 脚本头部的变量可能因系统的不...]]></description><category></category></item><item><title><![CDATA[Windows中，tomcat生成服务后台启动]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/84834120</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/84834120</guid><author>qq_36617310</author><pubDate>Wed, 05 Dec 2018 14:10:45 +0800</pubDate><description><![CDATA[进入tomcat的bin中，进入cmd

输入命令 service install TomcatName

在任务管理器中的服务即可看到服务，或者再在运行输入services.msc 也可看到生成的服务
...]]></description><category></category></item><item><title><![CDATA[oracle导入sql文件，在连接工具中直接执行命令]]></title><link>https://blog.youkuaiyun.com/qq_36617310/article/details/84560312</link><guid>https://blog.youkuaiyun.com/qq_36617310/article/details/84560312</guid><author>qq_36617310</author><pubDate>Tue, 27 Nov 2018 09:27:57 +0800</pubDate><description><![CDATA[@D:\log.sql;]]></description><category></category></item></channel></rss>