<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Cxy_357的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Cxy_357</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Cxy_357]]></copyright><item><title><![CDATA[Sublime Text3 插件安装、卸载]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82794056</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82794056</guid><author>Cxy_357</author><pubDate>Thu, 20 Sep 2018 21:49:08 +0800</pubDate><description><![CDATA[ 

一、Package Control组件安装

按Ctrl+ ~(此符号为tab按键上面的按键) 调出console（注：避免热键冲突） ，粘贴以下代码到命令行并回车：


import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urll...]]></description><category></category></item><item><title><![CDATA[官方文档]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82784319</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82784319</guid><author>Cxy_357</author><pubDate>Thu, 20 Sep 2018 11:39:16 +0800</pubDate><description><![CDATA[ 

文档
			地址链接
		MySQL的官方手册
			
			https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html

			https://dev.mysql.com/doc/internals/en/
			
		SQLExec API
			http://www1.udel.edu/CIS/software/...]]></description><category></category></item><item><title><![CDATA[java代码执行.Sql脚本文件]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82769635</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82769635</guid><author>Cxy_357</author><pubDate>Wed, 19 Sep 2018 11:31:40 +0800</pubDate><description><![CDATA[java 执行sql脚本有3种方式 (ant、ibatis、ScriptRunner)

一、Ant 提供了 SQLExec 组件可以支持SQL文件的执行，测试后效果不错。

sqlExec 在线API：

http://www1.udel.edu/CIS/software/dist/apache-ant-1.6.5/docs/manual/api/org/apache/tools/ant/tas...]]></description><category></category></item><item><title><![CDATA[SQLServer常用函数]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82700956</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82700956</guid><author>Cxy_357</author><pubDate>Fri, 14 Sep 2018 12:23:43 +0800</pubDate><description><![CDATA[1. CAST(param AS FLOAT) : 强制转型    


-- 示例脚本，计算男女比
SELECT COUNT(*),(SELECT COUNT(*)FROM AAM_ORIGINAL_USER WHERE GENDER ='女性'),COUNT(*)/(SELECT COUNT(*)FROM AAM_ORIGINAL_USER WHERE GENDER ='女性')
FROM A...]]></description><category></category></item><item><title><![CDATA[HashMap之KeySet、entrySet]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82391277</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82391277</guid><author>Cxy_357</author><pubDate>Tue, 04 Sep 2018 22:05:24 +0800</pubDate><description><![CDATA[
package test;

import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Map.Entry;

/**
 * HashMap是一种无序的存储结构，是基于哈希表Map的实现
 * KeySet :键的集合，Set里面的类型即Key的类型。
 * entryS...]]></description><category></category></item><item><title><![CDATA[Java Excel (POI) 【待完善】]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82382978</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82382978</guid><author>Cxy_357</author><pubDate>Tue, 04 Sep 2018 14:26:00 +0800</pubDate><description><![CDATA[
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextStri...]]></description><category></category></item><item><title><![CDATA[前台往后台传值中文乱码 （修改Tomcat->Server.xml未生效）- 解决方法]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82229223</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82229223</guid><author>Cxy_357</author><pubDate>Thu, 30 Aug 2018 23:00:07 +0800</pubDate><description><![CDATA[解决方法：

 

1. 将server中的项目移除(目的：防止由于项目未移除存在缓存，导致修改的配置文件不生效)；



2. 修改tomcat安装目录下的server.xml文件，添加：URIEncoding=&quot;UTF-8&quot;



3. 执行bin目录下的shutdown.bat 和 startup.bat。（例如：D:\Ksoftware\apache-tomcat-7.0.59\bin）
...]]></description><category></category></item><item><title><![CDATA[数据库优化之 Explan（待补充）]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82222204</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82222204</guid><author>Cxy_357</author><pubDate>Thu, 30 Aug 2018 15:28:28 +0800</pubDate><description><![CDATA[

 


Explan分析器使用方法：

             TABLE：显示这一行的数据是关于哪张表的
            SIMPLE：简单SELECT(不使用UNION或子查询等)
           PRIMARY：最外面的SELECT
             UNION：UNION中的第二个或后面的SELECT语句
      UNION RESULT：UNION的结果
...]]></description><category></category></item><item><title><![CDATA[HashMap相关方法]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82192729</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82192729</guid><author>Cxy_357</author><pubDate>Wed, 29 Aug 2018 21:04:11 +0800</pubDate><description><![CDATA[
package test;

import java.util.HashMap;

public class TestHashMap {
	public static void main(String[] args) {
		
		HashMap&amp;lt;Integer,String&amp;gt; stringMap = new HashMap&amp;lt;Integer,String&amp;gt;();
		
	...]]></description><category></category></item><item><title><![CDATA[ArrayList 相关方法]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82192179</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82192179</guid><author>Cxy_357</author><pubDate>Wed, 29 Aug 2018 20:29:33 +0800</pubDate><description><![CDATA[
package test;

import java.util.ArrayList;
import java.util.List;

public class TestArrayList {
	
	//主函数，方法的入口
	public static void main(String[] args){
		List&amp;lt;String&amp;gt; testList = new ArrayList&amp;l...]]></description><category></category></item><item><title><![CDATA[SqlServer实现mysql中GROUP_CONCAT函数]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82190771</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82190771</guid><author>Cxy_357</author><pubDate>Wed, 29 Aug 2018 18:37:47 +0800</pubDate><description><![CDATA[
-- 新建测试表
CREATE TABLE temp(id int, value varchar(10));

-- 插入测试数据
INSERT INTO temp VALUES(1, 'aa'); 
INSERT INTO temp VALUES(1, 'bb'); 
INSERT INTO temp VALUES(2, 'cc'); 
INSERT INTO temp VALUES(2, '...]]></description><category></category></item><item><title><![CDATA[常用的java开发快捷键]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82184732</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82184732</guid><author>Cxy_357</author><pubDate>Wed, 29 Aug 2018 16:04:06 +0800</pubDate><description><![CDATA[效果
			具体操作
		快速输入public static void main()
			输入main, 然后键盘 ALT+/ 提示的第一项
		快速输入System.out.println()
			输入syso，然后键盘 ALT+/ 直接出来System.out.println(); 
		转换为小写
			选中单词，Alt+shif+Y
		转换为大写
			选中单词，Alt+shif+X...]]></description><category></category></item><item><title><![CDATA[数组中元素增加、删除、去重]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/82177675</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/82177675</guid><author>Cxy_357</author><pubDate>Wed, 29 Aug 2018 09:06:25 +0800</pubDate><description><![CDATA[
package test;

import java.util.ArrayList;
import java.util.List;

public class TestOfArrayOperate {
	
	public static void main(String [] args) {
        testA();
        System.out.println(&quot;========...]]></description><category></category></item><item><title><![CDATA[Bubble Sort 优化]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/81292955</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/81292955</guid><author>Cxy_357</author><pubDate>Mon, 30 Jul 2018 21:58:46 +0800</pubDate><description><![CDATA[
package com.test;
import java.util.Arrays;

public class testBubbleSort {
	
private static void sort(int array[]){
	int tmp  = 0;
	for(int i = 0; i &amp;lt; array.length; i++){
	        for(int j = 0; j ...]]></description><category></category></item><item><title><![CDATA[java之数组操作]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/81292660</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/81292660</guid><author>Cxy_357</author><pubDate>Mon, 30 Jul 2018 21:41:22 +0800</pubDate><description><![CDATA[1. 删除数组中的重复元素： 


package com.test;
import java.util.ArrayList;
import java.util.List;

public class removeElementFromArray{
	
	private static void removeElement(Integer arr[]){
		List&amp;lt;Integer&amp;gt; ...]]></description><category></category></item><item><title><![CDATA[java基础优秀文章摘要 -（不断更新）]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/81228306</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/81228306</guid><author>Cxy_357</author><pubDate>Thu, 26 Jul 2018 21:44:38 +0800</pubDate><description><![CDATA[冒泡排序及优化
	https://blog.youkuaiyun.com/csdnnews/article/details/81187659
	
	（String）强转和Object.toString()、String.valueOf(Object)的区别:
	https://blog.youkuaiyun.com/qq496013218/article/details/75226727?locationNum=3&amp;am...]]></description><category></category></item><item><title><![CDATA[Sublime快捷键总结]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/81059570</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/81059570</guid><author>Cxy_357</author><pubDate>Mon, 16 Jul 2018 09:07:12 +0800</pubDate><description><![CDATA[﻿﻿ Ctrl+D 选词 （反复按快捷键，即可继续向下同时选中下一个相同的文本进行同时编辑） Ctrl+G 跳转到相应的行 Ctrl+J 合并行（已选择需要合并的多行时） Ctrl+L 选择整行（按住-继续选择下行） Ctrl+M 光标移动至括号内开始或结束的位置 Ctrl+T 词互换 Ctrl+U 软撤销 Ctrl+P 查找当前项目中的文件和快速搜索；输入 @ 查找文件主标题/函数；或者输入 :...]]></description><category></category></item><item><title><![CDATA[Oracle工具函数总结]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/78282322</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/78282322</guid><author>Cxy_357</author><pubDate>Thu, 19 Oct 2017 11:07:13 +0800</pubDate><description><![CDATA[-- 1. 获取目标字符出现的位置
语法：
instr('要检索的字符串','目标字符串','开始位置');
instr('要检索的字符串','目标字符串','开始位置','第几次出现');


例子：
SELECT instr('AAA-BBB-CCC','-',1) FROM dual;-- '-'第一次出现的位置,4
SELECT instr('AAA-BBB-CCC','-]]></description><category></category></item><item><title><![CDATA[Mysql查询时区分大小写]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/52805963</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/52805963</guid><author>Cxy_357</author><pubDate>Thu, 13 Oct 2016 13:21:46 +0800</pubDate><description><![CDATA[MySQL默认的查询也不区分大小写。但是有些时候我们查询时需要区分大小写，经过看别人的文章，发现多加个单词就好了！


1. 不区分大小写的情况：




2. 匹配大写的情况：




3. 匹配小写的情况：




4. 建表时需要区分大小写的情况：]]></description><category></category></item><item><title><![CDATA[遍历List,删除元素]]></title><link>https://blog.youkuaiyun.com/Cxy_357/article/details/52198232</link><guid>https://blog.youkuaiyun.com/Cxy_357/article/details/52198232</guid><author>Cxy_357</author><pubDate>Sat, 13 Aug 2016 11:05:56 +0800</pubDate><description><![CDATA[遍历删除List中的元素有很多种方法，当运用不当的时候就会产生问题。下面主要看看以下几种遍历删除List中元素的形式：

1.通过增强的for循环删除符合条件的多个元素

2.通过增强的for循环删除符合条件的一个元素

3.通过普通的for删除删除符合条件的多个元素

4.通过Iterator进行遍历删除符合条件的多个元素

 



[java] view
 pl]]></description><category></category></item></channel></rss>