<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[w11117的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/w11117</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; w11117]]></copyright><item><title><![CDATA[Java导出word保留样式]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/140926802</link><guid>https://blog.youkuaiyun.com/w11117/article/details/140926802</guid><author>w11117</author><pubDate>Wed, 07 Aug 2024 10:37:08 +0800</pubDate><description><![CDATA[本文主要使用XDocReport +FreeMarker，该技术组合既简单又高效可实现word模板的编辑，docx和doc均可处理，可以动态的生成表格。]]></description><category></category></item><item><title><![CDATA[数字金额转换为人民币中文大写]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/140955921</link><guid>https://blog.youkuaiyun.com/w11117/article/details/140955921</guid><author>w11117</author><pubDate>Tue, 06 Aug 2024 14:53:17 +0800</pubDate><description><![CDATA[【代码】数字金额转换为人民币中文大写。]]></description><category></category></item><item><title><![CDATA[文件类型效验]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/140274982</link><guid>https://blog.youkuaiyun.com/w11117/article/details/140274982</guid><author>w11117</author><pubDate>Mon, 08 Jul 2024 17:39:42 +0800</pubDate><description><![CDATA[【代码】文件类型效验。]]></description><category></category></item><item><title><![CDATA[springsecurity关闭默认登录页面]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/136841329</link><guid>https://blog.youkuaiyun.com/w11117/article/details/136841329</guid><author>w11117</author><pubDate>Tue, 19 Mar 2024 14:13:44 +0800</pubDate><description><![CDATA[【代码】springsecurity关闭默认登录页面。]]></description><category></category></item><item><title><![CDATA[layui表格单元格合并]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/132758478</link><guid>https://blog.youkuaiyun.com/w11117/article/details/132758478</guid><author>w11117</author><pubDate>Fri, 08 Sep 2023 13:40:21 +0800</pubDate><description><![CDATA[layui表格单元格合并]]></description><category></category></item><item><title><![CDATA[SqlServer数据导入mysql数据库]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/130687371</link><guid>https://blog.youkuaiyun.com/w11117/article/details/130687371</guid><author>w11117</author><pubDate>Mon, 15 May 2023 16:29:20 +0800</pubDate><description><![CDATA[【代码】SqlServer数据导入mysql数据库。]]></description><category></category></item><item><title><![CDATA[java千位符]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/126467380</link><guid>https://blog.youkuaiyun.com/w11117/article/details/126467380</guid><author>w11117</author><pubDate>Mon, 22 Aug 2022 15:43:48 +0800</pubDate><description><![CDATA[【代码】java千位符。]]></description><category></category></item><item><title><![CDATA[达梦字符串转换出错]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/126182412</link><guid>https://blog.youkuaiyun.com/w11117/article/details/126182412</guid><author>w11117</author><pubDate>Fri, 05 Aug 2022 17:40:01 +0800</pubDate><description><![CDATA[达梦字符串转换出错]]></description><category></category></item><item><title><![CDATA[layui富文本编译器上传图片]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/121701370</link><guid>https://blog.youkuaiyun.com/w11117/article/details/121701370</guid><author>w11117</author><pubDate>Fri, 03 Dec 2021 16:18:01 +0800</pubDate><description><![CDATA[@RestController
@RequestMapping("/upload")
public class UploadController {

   
    private final static String FILE_SAVE_PATH = "C:/Users/86182/Desktop/第二个CRM权限管理/OA前台/layuimg";

    @RequestMapping("/uploadImg")
    private Object uploadFile(@RequestPara]]></description><category></category></item><item><title><![CDATA[动态类型。]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/121616066</link><guid>https://blog.youkuaiyun.com/w11117/article/details/121616066</guid><author>w11117</author><pubDate>Mon, 29 Nov 2021 18:08:55 +0800</pubDate><description><![CDATA[&lt;div class="layui-form-item" style="width: 80%;"&gt;
				&lt;label class="layui-form-label"&gt;类型&lt;/label&gt;
				&lt;div class="layui-input-block"&gt;
					&lt;select name="lid" id="lid" lay-verify="required"&gt;&lt;/select&gt;
				&lt;/div&gt;
			&l]]></description><category></category></item><item><title><![CDATA[layui批量删除多条数据]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/121615890</link><guid>https://blog.youkuaiyun.com/w11117/article/details/121615890</guid><author>w11117</author><pubDate>Mon, 29 Nov 2021 18:01:18 +0800</pubDate><description><![CDATA[```java
//sql
 &lt;update id="batchStu"&gt;
        delete
        from email
        where id in
        &lt;foreach collection="array" index="no" item="id" open="("
                 separator="," close=")"&gt;
            ${id}
        &lt;/foreach&gt;
.]]></description><category></category></item><item><title><![CDATA[mysql实现行转列]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/114915653</link><guid>https://blog.youkuaiyun.com/w11117/article/details/114915653</guid><author>w11117</author><pubDate>Wed, 17 Mar 2021 09:12:07 +0800</pubDate><description><![CDATA[查询数据表数据：
SELECT * FROM test_tb_grade;

效果如下所示

实现行转列
 -- 实现行转列
-- 先分组
-- 拿名字
-- 拿张三、、、的数学成绩最大值

SELECT user_name ,
MAX(CASE course WHEN '数学' THEN score ELSE 0 END ) 数学,
MAX(CASE course WHEN '语文' THEN score ELSE 0 END ) 语文,
MAX(CASE course WHEN '英语' THEN sc]]></description><category></category></item><item><title><![CDATA[存储过程（习题）计算两数之和、循环、判断、赋值查询。]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/114627902</link><guid>https://blog.youkuaiyun.com/w11117/article/details/114627902</guid><author>w11117</author><pubDate>Wed, 10 Mar 2021 10:32:45 +0800</pubDate><description><![CDATA[存储过程
一 存储过程的优缺点
优点：简化复杂的操作；缺点：如果使用大量存储过程，那么使用这些存储过程的每个连接的内存使用量将会大大增加，不利于逻辑运算。
二、MySQL 中的存储过程
1：创建存储过程，代码如下所示：
-- 创建存储过程
create procedure mypro(in a int,in b int,out sum int)
begin
set sum = a+b;
end;

运行结果如下：

也可以在 Navicat 客户端“函数”节点下查看过程，如下图所示：

（2）调用存储过程，]]></description><category></category></item><item><title><![CDATA[用sql实现1到100能被5整除的数字和]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/114626613</link><guid>https://blog.youkuaiyun.com/w11117/article/details/114626613</guid><author>w11117</author><pubDate>Wed, 10 Mar 2021 09:57:07 +0800</pubDate><description><![CDATA[用sql实现1到100能被5整除的数字和：
CREATE PROCEDURE mypr(out sum int)
BEGIN
DECLARE i int default 0;-- 不可以直接赋值需要加上默认值
SET sum =0;
while i &lt;=100 DO
if i%5=0 then set sum=sum+i;
end if;
set i=i+1;
end while;
end;
call mypr(@s);
SELECT @s;


...]]></description><category></category></item><item><title><![CDATA[mysql 索引、事务]]></title><link>https://blog.youkuaiyun.com/w11117/article/details/114525921</link><guid>https://blog.youkuaiyun.com/w11117/article/details/114525921</guid><author>w11117</author><pubDate>Mon, 08 Mar 2021 11:13:14 +0800</pubDate><description><![CDATA[一、索引
（1）什么是索引？
1：举例来讲就是：索引相当于字典的音序表，如果要查某个字，如果不使用音序表，则需要从几百页中逐页去查。
（2） 索引的优劣势
（1）索引的 优势：可以快速检索，减少 I/O 次数，加快检索速度；根据索引分组和排序，可以加快分组和排序。
（2）索引的 劣势：索引本身也是表，因此会占用存储空间，一般来说，索引表占用的空间是数据表的 1.5 倍；索引表的维护和创建需要时间成本，这个成本随着数据量增大而增大；构建索引会降低数据表的修改操作（删除，
添加，修改）的效率，因为在修改数据表的]]></description><category></category></item></channel></rss>