<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[WSSQYHW的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/WSSQYHW</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; WSSQYHW]]></copyright><item><title><![CDATA[DECLARE CURSOR 才允许使用 FOR UPDATE 子句]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/156692911</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/156692911</guid><author>WSSQYHW</author><pubDate>Wed, 07 Jan 2026 17:31:57 +0800</pubDate><description><![CDATA[参数核心作用和本次错误的关系用账号密码登录 SQL Server无关，仅为连接认证配置启用服务器端游标，兼容FOR UPDATE语法核心修复项，绕过 SQL Server 的语法校验简单说：你加的参数里，是“解药”，它通过改变 JDBC 驱动处理结果集的方式，兼容了 Seata 生成的FOR UPDATE语句，解决了 SQL Server 的语法错误；而只是常规的身份验证配置，不影响错误修复。]]></description><category></category></item><item><title><![CDATA[Mysql insert into select from 报错division by 0]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/125874600</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/125874600</guid><author>WSSQYHW</author><pubDate>Tue, 19 Jul 2022 16:17:50 +0800</pubDate><description><![CDATA[Mysql division by 0 报错]]></description><category></category></item><item><title><![CDATA[还原数据库到新建数据库中]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/116142873</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/116142873</guid><author>WSSQYHW</author><pubDate>Mon, 26 Apr 2021 09:09:35 +0800</pubDate><description><![CDATA[移库——还原数据库到新建数据库中
新建数据库后
避免遇到错误
error:因为数据库正在使用，所以无法获得对数据库的独占访问权
执行：
 use master
ALTER DATABASE [datebase] SET OFFLINE WITH ROLLBACK IMMEDIATE

避免错误：
sql2008“备份集中的数据库备份与现有的xxx数据库不同”
RESTORE DATABASE xxxx     -- xxxx-改为你自己的数据名称
FROM DISK = 'D:\db\xxxx.bak'  ]]></description><category></category></item><item><title><![CDATA[泛型报错]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/104393711</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/104393711</guid><author>WSSQYHW</author><pubDate>Wed, 19 Feb 2020 15:19:12 +0800</pubDate><description><![CDATA[List&lt;Map&lt;String,String&gt;&gt; maps =  (List&lt;Map&lt;String,String&gt;&gt;) json.get(“list”);//获取前端的行数据MAP集合
这边我将前端传输的值直接变成Map&lt;String,String&gt;的一个集合 定死了为String型 结果前端传输的值为INT时则无法获取值 且用类型转换都...]]></description><category></category></item><item><title><![CDATA[查询表——条件是分组的第一个]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/102822568</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/102822568</guid><author>WSSQYHW</author><pubDate>Wed, 30 Oct 2019 16:53:07 +0800</pubDate><description><![CDATA[SELECT * from
(SELECT ROW_NUMBER() OVER(PARTITION BY O.firstno ORDER BY O.id ASC) AS Row_Index,* 
FROM (select  OW.*,st.code code2 from busness_product_order_outdata OW
LEFT JOIN (SELECT DISTINCT name...]]></description><category></category></item><item><title><![CDATA[a标间内onclick传值 值错误 坑！]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/102822455</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/102822455</guid><author>WSSQYHW</author><pubDate>Wed, 30 Oct 2019 16:51:09 +0800</pubDate><description><![CDATA[a标签内部传值问题 会出现传值不是你想要的值 出现一些偏差
问题详解：
https://blog.youkuaiyun.com/Readiay/article/details/50947311

]]></description><category></category></item><item><title><![CDATA[jquery中一个new的对象给两个集合赋值，一个集合值改变 另外一个集合值会发生变化]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/102398796</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/102398796</guid><author>WSSQYHW</author><pubDate>Tue, 08 Oct 2019 17:36:08 +0800</pubDate><description><![CDATA[代码如下 若不用两个对象则会出现更改任一集合中的值 两个集合值一起发生变化
$.each(stockDetails, function(i, item){
			//设置a 为0则不同 为1 则相同合并
			var a = 0;
			var b = 0;
			//将传来了json数据实例化 生存bbb对象
			var arr=new classA(item.warehousename,it...]]></description><category></category></item><item><title><![CDATA[为已存在的表增加字段和补数据]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/101531017</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/101531017</guid><author>WSSQYHW</author><pubDate>Fri, 27 Sep 2019 13:57:02 +0800</pubDate><description><![CDATA[SELECT * FROM  price WHERE ddate &gt;=CONVERT(varchar(100), dateadd(month, -1, getdate()), 120) 

查询上月的今日日期 且格式化为yyyymm
-- 主计量单位插入
INSERT INTO base_storage_inrecord_copy1 
(id,mid,code,num,warehouse,c...]]></description><category></category></item><item><title><![CDATA[MUI 页面返回不清值，页面返回出现锁定button现象]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/99672947</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/99672947</guid><author>WSSQYHW</author><pubDate>Fri, 16 Aug 2019 10:29:57 +0800</pubDate><description><![CDATA[之前用 window.close(); window.location.reload(“outStock.html”);MUI 页面返回后不清值，页面返回出现锁定button现象现在在Ajax成功后改为
if (req.success == "1") {
	mui.alert("提交成功", "提示",function() {
	   plus.webview.currentWebview().c...]]></description><category></category></item><item><title><![CDATA[Mybatis动态SQL集合插入返回id]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/99672691</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/99672691</guid><author>WSSQYHW</author><pubDate>Fri, 16 Aug 2019 10:22:46 +0800</pubDate><description><![CDATA[&lt;insert id="insterOutMaterials" useGeneratedKeys="true" keyProperty="id"&gt;
        INSERT INTO base_storage_outrecord_flow (mid,code,num,warehouse,ctime,batch,orderid,unit,orderno,type,isborrow,c...]]></description><category></category></item><item><title><![CDATA[有则修改，无则新增索引版本（加强版2）]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/95599811</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/95599811</guid><author>WSSQYHW</author><pubDate>Fri, 12 Jul 2019 11:15:08 +0800</pubDate><description><![CDATA[有则修改，无则新增 一条sql语句 效率更快版本
&lt;insert id="insterOutMaterials"&gt;
        &lt;foreach collection="storageOutrecords" item="item" index="index"  separator=";"&gt;
            MERGE INTO base_storage_outr...]]></description><category></category></item><item><title><![CDATA[转载VS断点操作]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/91969053</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/91969053</guid><author>WSSQYHW</author><pubDate>Fri, 14 Jun 2019 13:50:11 +0800</pubDate><description><![CDATA[Visual Studio调试器调试
当代码不能正常运行时，可以通过调试定位错误。常用的程序调试操作包括设置断点、开始、中断和停止程序的执行、单步执行程序以及使程序运行到指定的位置。下面将对这几种常用的程序调试操作进行详细地介绍。
1．断点操作
断点通知调试器，使应用程序在某点上（暂停执行）或某情况发生时中断。发生中断时，称程序和调试器处于中断模式。进入中断模式并不会终止或结束程序的执行，所有元素...]]></description><category></category></item><item><title><![CDATA[多表查询求和重复问题解决————且一同解决了int类型减去null类型出现null的问题！！！]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/90762427</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/90762427</guid><author>WSSQYHW</author><pubDate>Tue, 04 Jun 2019 08:40:56 +0800</pubDate><description><![CDATA[有A、B、C三表 表与表关系为 A–&gt;B 为一对多  A–&gt;C为 一对一 三表联查求和 会出现 A表数据重复问题 解决办法  子查询 ！！ 三层 SELECT DISTINCT  亲测 有效
    SELECT DISTINCT (q.id),q.code,q.name,q.batch,SUM(q.total),q.total2 FROM
    (SELECT DISTINCT (...]]></description><category></category></item><item><title><![CDATA[Mybatis中循环执行SQL中存在就更新，不存在就插入代码！！！]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/90368634</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/90368634</guid><author>WSSQYHW</author><pubDate>Mon, 20 May 2019 08:47:06 +0800</pubDate><description><![CDATA[&lt;insert id="all"&gt;
        &lt;foreach collection="workno" item="item" index="index"  separator=";"&gt;
            IF EXISTS(SELECT * FROM busness_labortime WHERE   userid = (SELECT id FROM base...]]></description><category></category></item><item><title><![CDATA[当idea项目遇到无法出现树形结构时的解决方法]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/89530569</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/89530569</guid><author>WSSQYHW</author><pubDate>Fri, 26 Apr 2019 08:39:42 +0800</pubDate><description><![CDATA[按下列步骤操作：

关闭IDEA，
2.然后删除项目文件夹下的.idea文件夹
3.重新用IDEA工具打开项目 Open…
来自于https://blog.youkuaiyun.com/weixin_41045798/article/details/80201818
有效果！


...]]></description><category></category></item><item><title><![CDATA[MySQL 分组后取每组前N条数据（天猫项目）]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/89101095</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/89101095</guid><author>WSSQYHW</author><pubDate>Mon, 08 Apr 2019 18:36:25 +0800</pubDate><description><![CDATA[SQL：
select * from emp as a where 3&gt; (select count(*) from emp where deptno = a.deptno and sal &lt; a.sal  )  order by a.deptno ,a.sal


解析SQL：
3&gt;…
目的是获取前三条数据，可以多次修改
emp where deptno = a.deptno
...]]></description><category></category></item><item><title><![CDATA[Mybatis中入到参数问题]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/88966171</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/88966171</guid><author>WSSQYHW</author><pubDate>Tue, 02 Apr 2019 11:04:03 +0800</pubDate><description><![CDATA[问题：

原因： 传参有多个时发生！！
解决：
解决办法：
（1）直接把值改成数字
&lt;select id="LoginUser" parameterType="String" resultMap="userMap"&gt;
  SELECT * FROM user where emplnumb = #{0} and password=#{1}
&lt;/select&gt;

（2）在变量上...]]></description><category></category></item><item><title><![CDATA[Tmall项目中更新图片遇到浏览器缓存问题]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/88964120</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/88964120</guid><author>WSSQYHW</author><pubDate>Tue, 02 Apr 2019 10:02:19 +0800</pubDate><description><![CDATA[用java解决浏览器的缓存问题
对html页面和jsp最好都加一些设置对于HTM网页，加入：
&lt;meta HTTP-EQUIV="pragma" CONTENT="no-cache"&gt;

&lt;meta HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate"&gt;

&lt;meta HTTP-EQUIV="ex...]]></description><category></category></item><item><title><![CDATA[MissAsia项目官网总结]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/88707682</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/88707682</guid><author>WSSQYHW</author><pubDate>Thu, 21 Mar 2019 10:01:54 +0800</pubDate><description><![CDATA[MissAsia官网项目中遇到了诸多问题：
问题一 动态页面 在赞助商一栏中不知其具体个数，却需要无线循环的滚动！
解决代码  运用了swiper！！
							&lt;script&gt;
							    var appendNumber = 6;
							    var prependNumber = 1;
							    var swiper = new Swiper(...]]></description><category></category></item><item><title><![CDATA[前端页面图片js冲突与js顺序问题]]></title><link>https://blog.youkuaiyun.com/WSSQYHW/article/details/88707532</link><guid>https://blog.youkuaiyun.com/WSSQYHW/article/details/88707532</guid><author>WSSQYHW</author><pubDate>Thu, 21 Mar 2019 09:55:22 +0800</pubDate><description><![CDATA[问题如下：

在官网就进入时，会有几率出现想要的轮播图无法实现的问题，这是轮播图与下方多个轮播插件非同一插件而出现的冲突bug！！！
修改为同一插件swiper后  出现问题，上方轮播图js不生效
问题解决  因为是用ajax来进行的动态页面拼接，所以要注意js的排放顺序！！！

...]]></description><category></category></item></channel></rss>