<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[AlexKate的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/AlexKate</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; AlexKate]]></copyright><item><title><![CDATA[MySQL 存储过程，游标双重循环]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/90232799</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/90232799</guid><author>AlexKate</author><pubDate>Wed, 15 May 2019 11:37:43 +0800</pubDate><description><![CDATA[-- 等价于JAVA双重for循环
CREATE DEFINER=`root`@`%` PROCEDURE `ref_view_rp_jk_day_1`(IN time VARCHAR(20))
BEGIN

DECLARE ename VARCHAR(100);
DECLARE starttime VARCHAR(100);
DECLARE  endtime  VARCHAR(100);

D...]]></description><category></category></item><item><title><![CDATA[win10设置开机自动自动]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/84761604</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/84761604</guid><author>AlexKate</author><pubDate>Mon, 03 Dec 2018 13:50:10 +0800</pubDate><description><![CDATA[将启动项快捷方式拉入此路径即可：

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\StartUp]]></description><category></category></item><item><title><![CDATA[Object转list,拿原来实体类的属性值]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/82589931</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/82589931</guid><author>AlexKate</author><pubDate>Mon, 10 Sep 2018 15:08:33 +0800</pubDate><description><![CDATA[
Object object = map.get(&quot;Customerlist&quot;);
				List&amp;lt;CustomerVo&amp;gt; vos = new Gson().fromJson(new Gson().toJson(object), new TypeToken&amp;lt;List&amp;lt;CustomerVo&amp;gt;&amp;gt;(){}.getType());
				for (CustomerV...]]></description><category></category></item><item><title><![CDATA[SQL_mode设置]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/82152815</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/82152815</guid><author>AlexKate</author><pubDate>Tue, 28 Aug 2018 18:53:51 +0800</pubDate><description><![CDATA[
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=&quot;C:\develop\mysql-5.7.22-winx64&quot;
# 设置mysql数据库的数据的存放目录
datadir=&quot;C:\develop\mysql-5.7.22-winx6...]]></description><category></category></item><item><title><![CDATA[layer与iframe 间值的相互传递]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/80352343</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/80352343</guid><author>AlexKate</author><pubDate>Thu, 17 May 2018 16:05:39 +0800</pubDate><description><![CDATA[在A页添加
1 &amp;lt;input id=&quot;handle_status&quot; value=&quot;&quot; hidden=&quot;hidden&quot;&amp;gt;

js代码layer.open({
                    type: 2,
                    title: '检测点添加',
//                    closeBtn: false,
            ...]]></description><category></category></item><item><title><![CDATA[原生SQL分组查询]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/79801590</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/79801590</guid><author>AlexKate</author><pubDate>Tue, 03 Apr 2018 12:41:08 +0800</pubDate><description><![CDATA[SELECT
	t.time,
	COUNT(t.time) count
FROM
	(
		SELECT
			substring(alarm.occurtime, 1, 10) time,
			alarm.equiprecorddwid dwid,
			alarm.alarmmode,
			alarm.equiprecorditemname
		FROM
			`eqm_alarm_ev...]]></description><category></category></item><item><title><![CDATA[原生SQL]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/79761194</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/79761194</guid><author>AlexKate</author><pubDate>Fri, 30 Mar 2018 17:53:45 +0800</pubDate><description><![CDATA[SELECT
	config.dwid,
	config.dwname,
	config.displaycode,
	config.displayname,
	gather.origclass
FROM
	`eqm_equipdisplayconfig` config
LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwi...]]></description><category></category></item><item><title><![CDATA[原生SQL组建查询]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/79743074</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/79743074</guid><author>AlexKate</author><pubDate>Thu, 29 Mar 2018 15:10:50 +0800</pubDate><description><![CDATA[String sql = &quot;SELECT gather.dwid,gather.dwname,recorditem.unit,record.id equiprecordid,record.equipname FROM eqm_equipgather_item gather LEFT JOIN eqm_equiprecord_item recorditem ON gather.equiprecord...]]></description><category></category></item><item><title><![CDATA[前端界面的按钮赋值与状态勾选]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/79742953</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/79742953</guid><author>AlexKate</author><pubDate>Thu, 29 Mar 2018 15:08:25 +0800</pubDate><description><![CDATA[1.赋值fieldName: '状态',
			                field: 'status',
			                format: function(val) {
			                	if(val==2){
			                		return &quot;启用&quot;;
			                	}else{
			    ...]]></description><category></category></item><item><title><![CDATA[SQL排序返回指定个数结果的VO映射]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/79317204</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/79317204</guid><author>AlexKate</author><pubDate>Mon, 12 Feb 2018 15:53:03 +0800</pubDate><description><![CDATA[一、原生SQLSELECT	*FROM	(		SELECT			cpointname AS cpointname,			equipname AS equipname,			COUNT(equipname) AS num		FROM			iis_defect_info d		WHERE			d.deptid IN ('37', '38')		AND d.tenantid = 9		GROUP BY	...]]></description><category></category></item><item><title><![CDATA[Excel PDF报表的导出]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78702149</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78702149</guid><author>AlexKate</author><pubDate>Sun, 03 Dec 2017 16:12:44 +0800</pubDate><description><![CDATA[1.Excel---PDF
@Action("report_exportXls")
	public String exportXls() throws IOException {
		// 查询出 满足当前条件 结果数据
		List wayBills = wayBillService.findWayBills(model);

		// 生成Excel文件
		HSSFWorkbook hss]]></description><category></category></item><item><title><![CDATA[针对不同浏览器，进行附件名的编码]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78701681</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78701681</guid><author>AlexKate</author><pubDate>Sun, 03 Dec 2017 15:03:41 +0800</pubDate><description><![CDATA[1.下载文件时，针对不同浏览器，进行附件名的编码
import java.io.IOException;
import java.net.URLEncoder;

import sun.misc.BASE64Encoder;

public class FileUtils {
		/**
		 * 下载文件时，针对不同浏览器，进行附件名的编码
		 * 
		 * @param filename]]></description><category></category></item><item><title><![CDATA[JQuery和JS对象的相互转换：]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78642031</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78642031</guid><author>AlexKate</author><pubDate>Mon, 27 Nov 2017 09:55:27 +0800</pubDate><description><![CDATA[1.JQuery 转 JS：
        $().get(0)
        $()[0]
    

2. JS 转 JQuery:
        $(js对象)
相互转换,是为了调对方对象的属性或方法.]]></description><category></category></item><item><title><![CDATA[JS中5种原始数据类型]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78641983</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78641983</guid><author>AlexKate</author><pubDate>Mon, 27 Nov 2017 09:51:59 +0800</pubDate><description><![CDATA[1.js中5种原始数据类型
    number：整数/小数/NaN
    string：
    boolean：
    null：
    undefined：
2.js中会存在自动类型转换：当js引擎发现给的数据类型和需要的数据类型不一致时，会自动类型转换
   其他类型转为boolean
            * string--boolean：除了空字符串("")，]]></description><category></category></item><item><title><![CDATA[异步请求与同步请求之间的转换]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78635237</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78635237</guid><author>AlexKate</author><pubDate>Sun, 26 Nov 2017 00:19:59 +0800</pubDate><description><![CDATA[1.同步请求表单提交

提交

2.异步提交表单请求
提交
提交

function mysubmit() {
   var param = $("#orderForm").serializeJson();
   $.post("order_add.action", param, function() {
       alert("success");
   })；
/]]></description><category></category></item><item><title><![CDATA[form表单登录异步ajax校验]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78598545</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78598545</guid><author>AlexKate</author><pubDate>Wed, 22 Nov 2017 00:55:11 +0800</pubDate><description><![CDATA[第一步:准备用户登录的html页面




	
		
		
		我的速运-登陆

		
		

		
		
		
		
		

		
			function loginindex() {
				if (document.getElementById("telephone").value == '' || document.getElementById("password").value ==]]></description><category></category></item><item><title><![CDATA[html页面之间的数据传递]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78578309</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78578309</guid><author>AlexKate</author><pubDate>Sun, 19 Nov 2017 23:29:09 +0800</pubDate><description><![CDATA[1.第一个页面携带数据---?id="+rows[0].id;
var rows = $("#grid").datagrid('getSelections');
	if (rows.length == 1) {
		location.href = "promotion_add.html?id="+rows[0].id;
	} else {
	$.messager.alert("警告", "请选择]]></description><category></category></item><item><title><![CDATA[kindEditor中提交内容数据库为空问题]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78573572</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78573572</guid><author>AlexKate</author><pubDate>Sun, 19 Nov 2017 11:59:17 +0800</pubDate><description><![CDATA[1.KindEditor 工作原理
隐藏原来 textarea 文本框，生成 iframe，在 iframe 里面进行编辑


Note

KindEditor的可视化操作在新创建的iframe上执行，代码模式下的textarea框也是新创建的，所以最后提交前需要执行 
sync() 将HTML数据设置到原来的textarea。KindEditor在默认情况下自动寻找textarea]]></description><category></category></item><item><title><![CDATA[绝对路径与相对路径在上传文件中的对比]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78572660</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78572660</guid><author>AlexKate</author><pubDate>Sun, 19 Nov 2017 09:01:33 +0800</pubDate><description><![CDATA[相对路径与绝对路径在上传文件中的对比
System.out.println("文件:" + imgFile);
System.out.println("文件名:" + imgFileFileName);
System.out.println("文件类型:" + imgFileContentType);
文件:D:\JavaEE\workspace_maven\bos2.0\bos_mana]]></description><category></category></item><item><title><![CDATA[kindEditor_upload的文件上传]]></title><link>https://blog.youkuaiyun.com/AlexKate/article/details/78570835</link><guid>https://blog.youkuaiyun.com/AlexKate/article/details/78570835</guid><author>AlexKate</author><pubDate>Sat, 18 Nov 2017 20:06:11 +0800</pubDate><description><![CDATA[1.文件上传必备三属性
    private File imgFile;//上传文件
    private String imgFileFileName;//文件的名称
    private String imgFileContentType;//文件的类型
2.提供的方法
    public void setImgFile(File imgFile) {
        th]]></description><category></category></item></channel></rss>