<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[nicepuppy的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/nicepuppy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; nicepuppy]]></copyright><item><title><![CDATA[【无标题】]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/142916832</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/142916832</guid><author>nicepuppy</author><pubDate>Mon, 14 Oct 2024 13:59:59 +0800</pubDate><description><![CDATA[后来恍然大悟发现是自己sql拼写问题，因为之前一直使用mysql开发，使用CONCAT函数拼接模糊插叙的时候都是CONCAT(‘%’，？，‘%’)直接这么拼写的，但是想起Oracle中并不支持这么拼写，需要将CONCAT(‘%’，？，‘%’) 改写成CONCAT(CONCAT(‘%’，？)，‘%’)，因为在Oracle中CONCAT函数每次只能进行两个字符串的拼接，两个以上就会报错。今天在开发中在给一个sql加查询条件的时候遇到ORA-00909：参数个数无效 报错，然后去查看sql发现参数并没有问题。]]></description><category></category></item><item><title><![CDATA[Expected positional parameter count: 1, actual parameters: []]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/115861239</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/115861239</guid><author>nicepuppy</author><pubDate>Mon, 19 Apr 2021 11:37:49 +0800</pubDate><description><![CDATA[Expected positional parameter count: 1, actual parameters: []

这问题看上去像sql语句中？的个数与实际的参数个数不匹配，实际问题是使用了hql，hql中字段与表映射中的字段大小写不一致导致的。
]]></description><category></category></item><item><title><![CDATA[帆软 按钮添加点击事件请求别的系统接收返回值]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/114090928</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/114090928</guid><author>nicepuppy</author><pubDate>Thu, 25 Feb 2021 16:44:35 +0800</pubDate><description><![CDATA[var count = parseInt($("tr[tridx=0]", "div.content-container").children().eq(0).html());//获取第一行第一个单元格数据（共多少行）
var json = []; // 定义一个json对象
for (var i = 3; i &lt; 3 + count; i++) {//因为数据是从第4行开始的，下标从0开始，所以循环从i=3开始
 var matchid = $("tr[tridx=" + i + "]",...]]></description><category></category></item><item><title><![CDATA[eclipse项目无缘无故出现叹号]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/101370978</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/101370978</guid><author>nicepuppy</author><pubDate>Wed, 25 Sep 2019 16:17:42 +0800</pubDate><description><![CDATA[eclipse项目无缘无故出现叹号，并且不是build path中包的问题，运行没问题，但是看着不舒服



我把项目从eclipse中删除（注意：别选上文件，）然后再从workspace中将项目重新导入，问题解决

出现这个问题的原因是我之前从别的项目中引用了一个包，源包被我删除了，虽然我把项目buildpath重新构建了，eclipse重启后从

菜单window-show view下的...]]></description><category></category></item><item><title><![CDATA[企业微信群聊机器人]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/100063245</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/100063245</guid><author>nicepuppy</author><pubDate>Sun, 25 Aug 2019 16:06:29 +0800</pubDate><description><![CDATA[alibaba.json嵌套使用方法]]></description><category></category></item><item><title><![CDATA[删除Centos7 中原有的java1.8（openjdk）]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/81915349</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/81915349</guid><author>nicepuppy</author><pubDate>Tue, 21 Aug 2018 21:56:21 +0800</pubDate><description><![CDATA[ 

1、查询当前java版本

    java -version

2、查询现有已安装的openjdk模块

    rpm -qa|grep java

3、删除查询到的jdk文件，

    如：yum -y remove *

    yum -y remove python-javapackages-3.4.1-11.el7.noarch
    yum -y remove java-...]]></description><category></category></item><item><title><![CDATA[win10热点无法开启如何解决]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/81161783</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/81161783</guid><author>nicepuppy</author><pubDate>Mon, 23 Jul 2018 09:00:44 +0800</pubDate><description><![CDATA[ 

 

win10热点无法开启问题一直困扰着不少用户们，其主要表现有无法启动承载网络、创建后电脑或手机无法连接Wifi等。为了帮助大家更好地使用windows10系统，下面小编就介绍下具体解决方法。

具体如下:

1、已管理员身份打开cmd，运行以下命令；







2、报错“无法启动承载网络”，进入以太网属性的共享选项卡，勾选如图，其中家庭网络连接则是你开启的热点适配器；





3...]]></description><category></category></item><item><title><![CDATA[mySQL 5.7版 解决密码登录失败Access denied for user 'root'@'localhost' (us]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80863836</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80863836</guid><author>nicepuppy</author><pubDate>Sat, 30 Jun 2018 09:02:29 +0800</pubDate><description><![CDATA[                      最近要使用Mysql数据库，所以在网上下载了一个mysql数据库，版本为5.7.10的。安装的过程特别的简单，就是因为过于的简单，所以连密码都已经被随机生成了，导致我们在进行登录时遇到密码登录失败的问题！我也是通过网上查询很多资料，最终将这个问题解决了，所以在此感谢那些分享经验朋友！下面我将我的解决过程跟大家分享一下！也帮助那些还没解决问题的朋友！下面我...]]></description><category></category></item><item><title><![CDATA[sqlserver  “无法删除数据库，因为该数据库当前正在使用“问题解决【引用‘博客园’毒逆天的文章】]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80789032</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80789032</guid><author>nicepuppy</author><pubDate>Sun, 24 Jun 2018 09:04:44 +0800</pubDate><description><![CDATA[图形化方法：命令行方法：123456789101112131415161718192021222324use mastergodeclare@dbname sysnameset@dbname ='BigValuesTest'--这个是要删除的数据库库名declare@s nvarchar(1000)declaretbcursorl...]]></description><category></category></item><item><title><![CDATA[CentOS7 通过YUM安装MySQL5.7]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80691797</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80691797</guid><author>nicepuppy</author><pubDate>Thu, 14 Jun 2018 13:52:50 +0800</pubDate><description><![CDATA[1.进入到要存放安装包的位置cd /home/lnmp 2.查看系统中是否已安装 MySQL 服务，以下提供两种方式：rpm -qa | grep mysqlyum list installed | grep mysql 3.如果已安装则删除 MySQL 及其依赖的包：yum -y remove mysql-libs.x86_64 4.下载mysql57-community-release-el7...]]></description><category></category></item><item><title><![CDATA[linux环境变量配置后报错..-bash: /usr/local/java/jdk1.7.0_55/bin/java: /lib/ld-linux.so.2: bad ELF interpreter]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80688062</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80688062</guid><author>nicepuppy</author><pubDate>Thu, 14 Jun 2018 09:27:32 +0800</pubDate><description><![CDATA[在百度云centos下传输到服务器上jdk安装提示上面错误登录root账户运行命令:yum install glibc.i686 根据提示确认安装就行了,........试试吧!【转载记入】]]></description><category></category></item><item><title><![CDATA[svn配置]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80239557</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80239557</guid><author>nicepuppy</author><pubDate>Tue, 08 May 2018 14:52:36 +0800</pubDate><description><![CDATA[----------------------------------------------------------------------------------------authz配置：[/]zhaocq=rw[/nanguashuwu]lhl=rwdjy=rwlwh=rwzhaocq=rw[/tubeidanci]zhaocq=rwlhl=rwdjy=rwlwh=rw[/project_a...]]></description><category></category></item><item><title><![CDATA[“jquery $(window).scrollTop()”为什么一直是0？]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80234736</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80234736</guid><author>nicepuppy</author><pubDate>Tue, 08 May 2018 09:27:04 +0800</pubDate><description><![CDATA[我想获取滚动条滚动后到顶部的距离，但是为什么“$(window).scrollTop()”获取的一直都是0，感觉好奇怪，我就是要判断滚动条滚动到固定一个div的位置的时候显示效果。该怎么做呢？解决办法：输入下列数值：&amp;lt;script type=&quot;text/javascript&quot;&amp;gt;$(document).ready(function() {$(window).scroll(function...]]></description><category></category></item><item><title><![CDATA[jquery判断数组中是否存在某个元素。]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80190157</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80190157</guid><author>nicepuppy</author><pubDate>Fri, 04 May 2018 09:12:56 +0800</pubDate><description><![CDATA[/** 	 * 使用jquery的inArray方法判断元素是否存在于数组中,该方法返回元素在数组中的下标，如果不存在与数组中，那么返回－１ 	 * @param {Object} arr 数组 	 * @param {Object} value 元素值 	 	 */  var isExists = isInArray2(arrayAttachFromSelectPage,array[i]); 	...]]></description><category></category></item><item><title><![CDATA[action里service不能实例化。]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80124457</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80124457</guid><author>nicepuppy</author><pubDate>Sat, 28 Apr 2018 13:35:43 +0800</pubDate><description><![CDATA[message Unable to instantiate Action, com.qianxunkuaiji.action.VoucherAction, defined for 'addVoucherPage' in namespace '/'Error creating bean with name 'com.qianxunkuaiji.action.VoucherAction': Injec...]]></description><category></category></item><item><title><![CDATA[Centos Svn服务器搭建]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80051546</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80051546</guid><author>nicepuppy</author><pubDate>Mon, 23 Apr 2018 17:34:28 +0800</pubDate><description><![CDATA[系统环境：uname -a
cat /proc/version
lsb_release -a 

CentOS release 6.4 检查已安装版本# rpm -qa subversion卸载旧版本SVN# yum remove subversion安装svn# yum install subversion // yum方式安装SVN 
# mkdir -p /opt/svn/repos // ...]]></description><category></category></item><item><title><![CDATA[linux防火墙放行了端口，但是仍然访问不到]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80051376</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80051376</guid><author>nicepuppy</author><pubDate>Mon, 23 Apr 2018 15:41:36 +0800</pubDate><description><![CDATA[我们的防火墙默认规则如下： 如果防火墙放行了端口，但是仍然访问不到的话，可能是因为添加规则的时候，用的是iptables -A 选项，这样，增加的规则会排列在 第6条 规则后面，虽然service iptables status显示放行了端口，但是实际上，由于第六条规则的原因，新增加的这条并没有起作用。改为使用iptables -I 插入规则即可，将规则添加的 第6条 之前，就可以生效了。 ...]]></description><category></category></item><item><title><![CDATA[修改列名]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/80004306</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/80004306</guid><author>nicepuppy</author><pubDate>Thu, 19 Apr 2018 14:50:09 +0800</pubDate><description><![CDATA[ alter table cash_apply change column  bankcard_id bankid int(11);]]></description><category></category></item><item><title><![CDATA[月份判定在哪个季度]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/79992523</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/79992523</guid><author>nicepuppy</author><pubDate>Wed, 18 Apr 2018 16:26:49 +0800</pubDate><description><![CDATA[（月份 + 2）/ 3取整的数就是季度  ]]></description><category></category></item><item><title><![CDATA[linux mysql导入sql文件]]></title><link>https://blog.youkuaiyun.com/nicepuppy/article/details/79976839</link><guid>https://blog.youkuaiyun.com/nicepuppy/article/details/79976839</guid><author>nicepuppy</author><pubDate>Tue, 17 Apr 2018 16:32:32 +0800</pubDate><description><![CDATA[source 路径/sql文件例source /root/Dump20180413.sql;]]></description><category></category></item></channel></rss>