<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[weixin_43471939的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/weixin_43471939</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; weixin_43471939]]></copyright><item><title><![CDATA[mysql根据唯一列删除表中重复行（mysql5.5.31-log）]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/138616236</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/138616236</guid><author>weixin_43471939</author><pubDate>Thu, 09 May 2024 15:33:03 +0800</pubDate><description><![CDATA[行明细重复，删除多余行明细保留并最新的一行记录。]]></description><category></category></item><item><title><![CDATA[下载服务器文件到.zip压缩中导出]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/131248795</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/131248795</guid><author>weixin_43471939</author><pubDate>Fri, 16 Jun 2023 16:42:34 +0800</pubDate><description><![CDATA[将文件夹中文件加入压缩包]]></description><category></category></item><item><title><![CDATA[Mysql忘记密码]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/127455441</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/127455441</guid><author>weixin_43471939</author><pubDate>Fri, 21 Oct 2022 23:33:40 +0800</pubDate><description><![CDATA[mysql忘记密码]]></description><category></category></item><item><title><![CDATA[mysql锁表、事务锁查询与杀死]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/123734237</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/123734237</guid><author>weixin_43471939</author><pubDate>Fri, 25 Mar 2022 14:20:25 +0800</pubDate><description><![CDATA[提示：使用navicat的mysql修改、删除、新增时卡住，一直转圈，最后找了半天发现是事务锁了。

文章目录前言一、查询锁表与杀死二、查询事务锁与杀死

前言

提示：以下是本篇文章正文内容，下面案例可供参考
一、查询锁表与杀死
  ![状态列为：waiting表示正在执行](https://img-blog.csdnimg.cn/14933ba17c5144839c42f27f4075dfa2.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,.]]></description><category></category></item><item><title><![CDATA[IDea中maven项目实现对接企查查、启信宝案例]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122844140</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122844140</guid><author>weixin_43471939</author><pubDate>Wed, 09 Feb 2022 16:45:45 +0800</pubDate><description><![CDATA[IDea中maven项目实现对接企查查、启信宝案例]]></description><category></category></item><item><title><![CDATA[正则表达式入门案例]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122726758</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122726758</guid><author>weixin_43471939</author><pubDate>Fri, 28 Jan 2022 10:25:29 +0800</pubDate><description><![CDATA[正则表达式入门实战案例]]></description><category></category></item><item><title><![CDATA[SQL SERVER字符串截取，SQL SERVER根据指定字符截取]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122697382</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122697382</guid><author>weixin_43471939</author><pubDate>Wed, 26 Jan 2022 11:24:47 +0800</pubDate><description><![CDATA[SQL SERVER字符串截取，SQL SERVER根据指定字符截取]]></description><category></category></item><item><title><![CDATA[IDEA2021.3使用VUE遇到的坑，解决办法总结]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122534100</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122534100</guid><author>weixin_43471939</author><pubDate>Mon, 17 Jan 2022 10:35:33 +0800</pubDate><description><![CDATA[IDEA2021.3开发VUE遇到的坑，IDEA开发VUE配置，IDEA的VUE配置]]></description><category></category></item><item><title><![CDATA[spring boot启动端口占用]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122467390</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122467390</guid><author>weixin_43471939</author><pubDate>Thu, 13 Jan 2022 09:53:29 +0800</pubDate><description><![CDATA[端口占用解决办法]]></description><category></category></item><item><title><![CDATA[nacos启动失败，Nacos Server did not start because dumpservice bean construction failure : No DataSource s]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122456462</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122456462</guid><author>weixin_43471939</author><pubDate>Wed, 12 Jan 2022 16:36:08 +0800</pubDate><description><![CDATA[今天早上电脑重启，windows下的nacos启动时一直报:

Nacos Server did not start because dumpservice bean construction failure : No DataSource set

网上找了大把资料发现和都不太一样，于是我总结了3个可能会出现这个错误的地方：
1.nacos服务器的配置文件：检查数据库链接
x盘:\nacos\conf\application配置文件，（博主不是这个原因）。
2.当前网络环境太差，快连上的时候已经链接超时了]]></description><category></category></item><item><title><![CDATA[最新版本IDEA启动报错:命令行太长2021.3之后之后的版本]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/122434442</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/122434442</guid><author>weixin_43471939</author><pubDate>Tue, 11 Jan 2022 15:52:14 +0800</pubDate><description><![CDATA[最新版idea命令行过长]]></description><category></category></item><item><title><![CDATA[plsql存储过程批量去除列、字段的换行符，空格]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/118972921</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/118972921</guid><author>weixin_43471939</author><pubDate>Wed, 21 Jul 2021 18:14:59 +0800</pubDate><description><![CDATA[无意中发现从后台小脚本中取的值报错了！！！
一开始还以为是var存储的值超标了，
经过仔细查看，
发现数据中含有换行符，导致页面展示失败，
理论上var存储的值是无限的，10M、20M
话不多说：我的jsp代码如下：
&lt;% if(addressdata1!=null &amp;&amp; addressdata1.size()&gt;0){
		String hospitalname="";
			for(int i=0;i&lt;addressdata1.size();i++){
				HashM]]></description><category></category></item><item><title><![CDATA[HTML/JSP下拉框改变触发jquery方法获取值]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/118806466</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/118806466</guid><author>weixin_43471939</author><pubDate>Fri, 16 Jul 2021 16:36:58 +0800</pubDate><description><![CDATA[1.给下拉框设置ID或name属性

2.改变值触发
$("[name='terminaladdress']").change(function(){
//获取下拉框的文本
	var addresstext=$("select[name='terminaladdress'] option:selected").text();
//获取下拉框的值
	var addresstext=$("select[name='terminaladdress'] option:selected").val();
});

j]]></description><category></category></item><item><title><![CDATA[MySql插入时分秒]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/117337084</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/117337084</guid><author>weixin_43471939</author><pubDate>Thu, 27 May 2021 20:31:30 +0800</pubDate><description><![CDATA[MySql插入时分秒
网上看了很多文章结果发现是我字段类型不对!
MySql有带时分秒的字段不是DATE而是datetime
把字段类型改为datetime
接着使用：NOW()；

代码如下：
INSERT INTO `user_student` (
  `account`,
  `username`,
  `userpassword`,
  `createdate`,
  `beforepassword`,
  `reserved1`,
  `reserved2`,
  `lastupdatedate`]]></description><category></category></item><item><title><![CDATA[oracle ORA-2800密码过期PLSQL查看更改]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/110492326</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/110492326</guid><author>weixin_43471939</author><pubDate>Wed, 02 Dec 2020 17:34:01 +0800</pubDate><description><![CDATA[oracle ORA-2800用户密码密码过期更改
查询过期时间：
--#username 为用户名
SELECT * FROM dba_users where username='orderprd'

更改默认有效期：
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

成功后如下所示：

]]></description><category></category></item><item><title><![CDATA[oracle、plsql分页排序]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/108636004</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/108636004</guid><author>weixin_43471939</author><pubDate>Thu, 17 Sep 2020 09:49:37 +0800</pubDate><description><![CDATA[oracle、plsql分页排序
1.使用rownum列，查询时加入该字段（非表字段），我也不知怎么描述，下面举个栗子吧！
--sql执行顺序是从内二外的，下面sql套了三层
select * from (select rownum as row_id,aa.* from  (select a.id,a.name,a.createdate from a order by a.createdate desc)  aa) where row_id=1
--’第一层筛选并排序结果集。
--第二层使用rownum进]]></description><category></category></item><item><title><![CDATA[html、jsp禁用输入框或单选按钮并颜色为灰色]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/108620721</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/108620721</guid><author>weixin_43471939</author><pubDate>Wed, 16 Sep 2020 14:00:14 +0800</pubDate><description><![CDATA[html、jsp禁用输入框或单选按钮并颜色为灰色
禁用文本框有以下2中方法
&lt;!--可以同时使用--&gt;
&lt;input disabled="disabled" type="text" id="text1" value="test2"/&gt;
&lt;input style="pointer-events: none;" id="text2" type="radio" /&gt;
&lt;!--jquer添加标签元素--&gt;
&lt;script&gt;
	$('#text1').att]]></description><category></category></item><item><title><![CDATA[Html5+query动态显示系统时间]]></title><link>https://blog.youkuaiyun.com/weixin_43471939/article/details/108193056</link><guid>https://blog.youkuaiyun.com/weixin_43471939/article/details/108193056</guid><author>weixin_43471939</author><pubDate>Mon, 24 Aug 2020 09:26:34 +0800</pubDate><description><![CDATA[Html5+query动态显示系统时间
直接上代码：
var add=setInterval("getTime()",1000);
    //stop()这个函数主要是清除设置的定时器
    function stop() {
        clearInterval(add);
    }
    //这个函数主要是获取时间然后写入div中
    function getTime() {
        var date=new Date();//创建date对象，获取时间
		var datei]]></description><category></category></item></channel></rss>