<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[故不积跬步，无以至千里。]]></title><description><![CDATA[九层之台 起于累土 千里之行 始于足下]]></description><link>https://blog.youkuaiyun.com/su12345su</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; su12345su]]></copyright><item><title><![CDATA[vs2022在win11系统无法使用快捷键F11 热键冲突]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/141709850</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/141709850</guid><author>su12345su</author><pubDate>Fri, 30 Aug 2024 09:57:45 +0800</pubDate><description><![CDATA[win11系统热键与vs2022热键冲突]]></description><category></category></item><item><title><![CDATA[java 字符串集合 按照指定顺序排序]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50760030</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50760030</guid><author>su12345su</author><pubDate>Wed, 12 Jul 2023 14:48:26 +0800</pubDate><description><![CDATA[java 字符串集合 按照指定顺序排序]]></description><category></category></item><item><title><![CDATA[mysql8导出转储sql导入mysql5.7出错1273]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/127055010</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/127055010</guid><author>su12345su</author><pubDate>Mon, 26 Sep 2022 15:54:54 +0800</pubDate><description><![CDATA[mysql8导出转储sql导入mysql5.7出错1273]]></description><category></category></item><item><title><![CDATA[让Gradle支持中文 -- 关于 "编码 GBK 的不可映射字符"错误的解决]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/105226891</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/105226891</guid><author>su12345su</author><pubDate>Tue, 31 Mar 2020 17:08:14 +0800</pubDate><description><![CDATA[&lt;div class="blog-content-box"&gt;
  &lt;div class="article-header-box"&gt;
    &lt;div class="article-header"&gt;
      &lt;div class="article-title-box"&gt;
        &lt;h1 clas...]]></description><category></category></item><item><title><![CDATA[mysql 数据类型 date  和 datetime 注意]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/77750404</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/77750404</guid><author>su12345su</author><pubDate>Thu, 31 Aug 2017 17:50:52 +0800</pubDate><description><![CDATA[在 mysql中
date 的数据类型格式是 

  yyyy-MM-dd   例如 2017-08-31
datetime 的数据类型格式是  

  yyyy-MM-dd HH:mm:ss   例如2017-08-31 00:00:00  2017-08-31
 08:00:00




recreation_yard_price 的表结构 中date 的数据类型是 d]]></description><category></category></item><item><title><![CDATA[修改mysql 数据库的 表的列的备注信息]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/77056392</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/77056392</guid><author>su12345su</author><pubDate>Thu, 10 Aug 2017 16:33:10 +0800</pubDate><description><![CDATA[1 
INFORMATION_SCHEMA提供了访问数据库元数据的方式。
元数据是关于数据的数据，如数据库名或表名，列的数据类型，或访问权限等。有些时候用于表述该信息的其他术语包括“数据词典”和“系统目录”。
具体可已参考在线mysq api文档 ： http://tool.oschina.net/apidocs/apidoc?api=mysql-5.1-zh



然后 COLUM]]></description><category></category></item><item><title><![CDATA[mysql  case when]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/72781475</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/72781475</guid><author>su12345su</author><pubDate>Sat, 27 May 2017 15:00:20 +0800</pubDate><description><![CDATA[mysql  case when 
SELECT id,`code`,descript,descript_en ,date_begin,date_end,CASE points_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END AS points_rule,points,CASE nights_rule WHEN 1 THEN '小于' WHE]]></description><category></category></item><item><title><![CDATA[TreeMap<K,V> 映射的使用 TreeMap 排序]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/56290708</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/56290708</guid><author>su12345su</author><pubDate>Tue, 21 Feb 2017 18:11:23 +0800</pubDate><description><![CDATA[需求 ：会员计划   会员等级  先按照 会员计划的listorder 排序 再按照会员等级的listorder排序
排序 获取最高的  获得最高级别的卡 最高会员计划 ListOrder 最高会员等级 listOrder 最高卡号 ORDER BY obj.id DESC


public class Sort62 {
	public static void main(String[] ]]></description><category></category></item><item><title><![CDATA[mysql存储过程 函数积累GROUP_CONCAT(expr)]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/55102821</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/55102821</guid><author>su12345su</author><pubDate>Tue, 14 Feb 2017 18:07:30 +0800</pubDate><description><![CDATA[GROUP_CONCAT(expr) 
该函数返回带有来自一个组的连接的非NULL值的字符串结果。其完整的语法如下所示：  
GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,]]></description><category></category></item><item><title><![CDATA[linux 安装 jdk maven svn]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/53784844</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/53784844</guid><author>su12345su</author><pubDate>Wed, 21 Dec 2016 15:47:22 +0800</pubDate><description><![CDATA[1 查看linux系统信息
cat /proc/version
   uname -a
   lsb_release -a
   cat /etc/issue
2 可以看到 是  centos 6.5  64 位的系统
3 下载所需要的安装包
4 svn的安装是这样：
参考 ：http://www.cnblogs.com/davidgu/archive/2013/02/01/288945]]></description><category></category></item><item><title><![CDATA[mysql sql-syntax-prepared-statements  变量做表名&& 字符函数]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/52997699</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/52997699</guid><author>su12345su</author><pubDate>Tue, 01 Nov 2016 17:09:53 +0800</pubDate><description><![CDATA[http://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html
sql 片段DELIMITER $$

USE `portal_group`$$

DROP PROCEDURE IF EXISTS `proc_sync_data`$$

CREATE DEFINER=`root`@`%` PROCEDURE `]]></description><category></category></item><item><title><![CDATA[mysql 判断是否是特定db下的table && 实体类转表]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/52997193</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/52997193</guid><author>su12345su</author><pubDate>Tue, 01 Nov 2016 16:33:36 +0800</pubDate><description><![CDATA[判断是否是特定db下的table    var_data_from 中是否存在var_entity  retrun   1 存在 0 不存在
DELIMITER $$

USE `portal_group`$$

DROP FUNCTION IF EXISTS `fc_sync_data`$$

CREATE DEFINER=`root`@`localhost` FUNCTION `fc_syn]]></description><category></category></item><item><title><![CDATA[ireport 中文乱码无法显示]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50916825</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50916825</guid><author>su12345su</author><pubDate>Thu, 17 Mar 2016 20:33:21 +0800</pubDate><description><![CDATA[目录
1 ireport中文乱码问题 中文不显示...
2
1 我的电脑 –控制面板—字体 黑体...
2
2 安装字体...
4
3生成字体 jar.
6
4重启---------ireport.
6
5设置中文 属性时注意设置以下三项...
7
6生成的jar文件要添加到项目lib下...
7
 
 
1 ireport中文乱码问题 中文不显示
1 我的电脑]]></description><category></category></item><item><title><![CDATA[sql server 统计各省份人数前几名和其他]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50899869</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50899869</guid><author>su12345su</author><pubDate>Tue, 15 Mar 2016 20:55:56 +0800</pubDate><description><![CDATA[----1 统计公司各省份人数 取前7个 其他----
select * from 
(		--统计前7个省份的人数
		(select  top 7 torigo, COUNT(*) tcount from person_info group by torigo order by tcount desc )
	--合并查询结果 合并其他省份的人数
	union 
		(		--合并第8名之后的]]></description><category></category></item><item><title><![CDATA[log4j]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50740055</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50740055</guid><author>su12345su</author><pubDate>Thu, 25 Feb 2016 19:43:26 +0800</pubDate><description><![CDATA[http://it.oyksoft.com/log4j/]]></description><category></category></item><item><title><![CDATA[sql server 判断时间段是否重叠]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50686577</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50686577</guid><author>su12345su</author><pubDate>Thu, 18 Feb 2016 15:41:50 +0800</pubDate><description><![CDATA[--判断 加班 时间段 是否重叠
--工号0100993 加班 加班日期  2016-01-09  起始时间08:30  结束时间17:30
select count(*) tcount from (
select case when (
('08:30''08:30')  --在原有时间段之前
 or ('08:30'>=tendtime and '17:30'>'08:30'))    --在]]></description><category></category></item><item><title><![CDATA[sql server 计算男女比例 百分比]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50581991</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50581991</guid><author>su12345su</author><pubDate>Mon, 25 Jan 2016 17:23:40 +0800</pubDate><description><![CDATA[--分组列出性别  计算男女各人数 和所占比例
select tsex ,count(*) from person_info where ttype='在职人员' group by tsex
--总人数
select count(*) from person_info
--占比
select cast( convert (decimal(18,2),100*cast(count(*) as flo]]></description><category></category></item><item><title><![CDATA[sql server存储过程]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/50539143</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/50539143</guid><author>su12345su</author><pubDate>Mon, 18 Jan 2016 21:01:23 +0800</pubDate><description><![CDATA[use Test2;
--创建测试books表
create table books (
    book_id int identity(1,1) primary key,
    book_name varchar(20),
    book_price float,
    book_auth varchar(10)
);
--插入测试数据
insert into books (book_n]]></description><category></category></item><item><title><![CDATA[Arraylist HashMap HashSet 遍历]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/49024649</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/49024649</guid><author>su12345su</author><pubDate>Sat, 10 Oct 2015 17:32:52 +0800</pubDate><description><![CDATA[http://www.yee4.com/blog/187.html/3
http://blog.youkuaiyun.com/vozon/article/details/5458370

public class Coll {
//	Collection coll=,,,
//	迭代器写法
//	Iterator iter = coll.iterator();
//	while(iter.hashNex]]></description><category></category></item><item><title><![CDATA[为克隆使用序列化]]></title><link>https://blog.youkuaiyun.com/su12345su/article/details/49004117</link><guid>https://blog.youkuaiyun.com/su12345su/article/details/49004117</guid><author>su12345su</author><pubDate>Fri, 09 Oct 2015 20:21:53 +0800</pubDate><description><![CDATA[http://coach.iteye.com/blog/854072
http://www.cnblogs.com/rollenholt/archive/2011/09/09/2172094.html

/*
 * 为克隆使用序列化，
 * 直接将对象序列化到输出流中，然后将其读回，这样产生的新对象是对现有对象的一个深拷贝
 * 在此过程中，不必将对象写出到文件，可以用ByteArrayOu]]></description><category></category></item></channel></rss>