<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[sharionlee]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sharionlee</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sharionlee]]></copyright><item><title><![CDATA[IntelliJ IDEA RunDebug Configurations没有Sprin Boot On update action]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/124813399</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/124813399</guid><author>sharionlee</author><pubDate>Tue, 17 May 2022 08:40:58 +0800</pubDate><description><![CDATA[场景描述：
使用On update action，选择 Update resources后，修改前端代码后不用重启服务自动编译生效



问题描述：

新安装idea后，Run/Debug Configurations 没有Sprin Boot On update action





处理方法：

File - settings - plugins,搜索spring，将spring相关的插件全部安装，将原有的 启动入口删除，重新运行即可




...]]></description><category></category></item><item><title><![CDATA[Git分支回退到指定提交位置]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/103637687</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/103637687</guid><author>sharionlee</author><pubDate>Fri, 20 Dec 2019 19:36:39 +0800</pubDate><description><![CDATA[步骤：

1、找到要回退的提交记录编号

2、执行git reset --hard 提交记录编号

3、git push-u-f origin master;

完成回退操作。

若提示：You are not allowed to force push code to a protected branch on this project

分支受保护

解决方法：

(备注：先记录下 分支...]]></description><category></category></item><item><title><![CDATA[Mybatis-plus 修改数据时若入参为空不会拼接 set 字段]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/103637587</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/103637587</guid><author>sharionlee</author><pubDate>Fri, 20 Dec 2019 19:30:55 +0800</pubDate><description><![CDATA[问题描述：本地调试会拼接，服务器不会拼接 set 字段名=””

解决方法：操作实体字段加上策略：strategy = FieldStrategy.IGNORED

服务器异常日志脚本：update 表 where (bus_id = ?)

正确效果为：update 表 set 字段=”” where (bus_id = ?)

示例代码：


Wrapper&lt;ModuleUserPo...]]></description><category></category></item><item><title><![CDATA[MySql中 order by将列的数值以自定义顺序排序]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/100020025</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/100020025</guid><author>sharionlee</author><pubDate>Thu, 22 Aug 2019 17:29:19 +0800</pubDate><description><![CDATA[需求描述：将已接收状态排序到最后

数据库字段：status （0未接收，1已接收，2已退回）



分析：常用的asc/desc已经不能满足

因此采用：order by case when x=1 then r1 when x=2 then r2 else x end

例如：


select 

t.status

from tablet t
ORDER BY
	CASE
WHEN t....]]></description><category></category></item><item><title><![CDATA[springboot controller返回对象到前端]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/98584443</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/98584443</guid><author>sharionlee</author><pubDate>Tue, 06 Aug 2019 08:47:40 +0800</pubDate><description><![CDATA[技术栈：
Springboot + SpringMVC + Thymeleaf

1、controller部分代码


@RequestMapping("moduleViewPage")
    private String moduleViewPage(@RequestParam String qyId, @RequestParam String khmc
                   ...]]></description><category></category></item><item><title><![CDATA[layui 或者layer 父页面获取子页面数据 或者子页面获取父页面操作方法]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/98486904</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/98486904</guid><author>sharionlee</author><pubDate>Mon, 05 Aug 2019 14:44:54 +0800</pubDate><description><![CDATA[// 父页面获取子页面的iframe
var frameId = $(layero).find("iframe").attr('id');

// 父页面获取子页面指定的id数据
var id = $(window.frames[frameId].document).find("#typecoupon").val();


// 子页面的数据赋值给父页面指定的id
$(window.par...]]></description><category></category></item><item><title><![CDATA[oracle自动备份bat脚本]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/44488563</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/44488563</guid><author>sharionlee</author><pubDate>Fri, 20 Mar 2015 10:52:00 +0800</pubDate><description><![CDATA[编写bat脚本：
@echo off
set sid=192.168.1.88/ORCL
set username=WPLAT1217
set password=WPLAT1217
set connect=%username%/%password%@%sid%  
%请先建立databak2dmp文件夹然后执行%
set back_path=d:\databak2dmp
set date_str]]></description><category></category></item><item><title><![CDATA[统计员工全年各月、季度、年度的任务得分]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/44487355</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/44487355</guid><author>sharionlee</author><pubDate>Fri, 20 Mar 2015 09:51:00 +0800</pubDate><description><![CDATA[统计员工全年各月、季度、年度的任务得分
实现效果：


实现代码（传入参数年，例如：2014）：

	<select id="querytaskEmpStaticsTaskScoreForManage" parameterClass="map" resultClass="dto"
		remapResults="true">
		select a.username,t.a,t.b,t.c]]></description><category></category></item><item><title><![CDATA[cn_win_srv_2003_r2_enterprise_x64_with_sp2下载地址及序列号]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/44338597</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/44338597</guid><author>sharionlee</author><pubDate>Tue, 17 Mar 2015 10:40:19 +0800</pubDate><description><![CDATA[cn_win_srv_2003_r2_enterprise_x64_with_sp2下载地址及序列号  
序列号：
MM72Q-QBVRW-JGDB6-94C22-GR8YJ
RYCR6-T7Y6M-2TVHK-C2YW3-7TYQ8
V893X-4RHCY-6PPH8-8VMT6-W97QT
HMWM9-2883J-HGGGC-FDBRX-XHHQT 
下载地址：
ed2k://|]]></description><category></category></item><item><title><![CDATA[oracle日期计算]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/40919159</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/40919159</guid><author>sharionlee</author><pubDate>Sat, 08 Nov 2014 11:40:41 +0800</pubDate><description><![CDATA[oracle日期计算]]></description><category></category></item><item><title><![CDATA[Extjs日期控件选择计算日期差值]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/39395859</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/39395859</guid><author>sharionlee</author><pubDate>Fri, 19 Sep 2014 11:25:46 +0800</pubDate><description><![CDATA[{
	xtype : 'datetimefield',
	format : 'Y-m-d H:i:s',// 日期格式化
	fieldLabel : '数据完工日期', // 标签
	id : 'sjwgrq',
	name : 'sjwgrq', // name:后台根据此name属性取值
	emptyText : '请选择日期',
	allowBlank : false,
	anchor : ]]></description><category></category></item><item><title><![CDATA[JAVA获取文件后缀]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/30493799</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/30493799</guid><author>sharionlee</author><pubDate>Fri, 13 Jun 2014 15:52:59 +0800</pubDate><description><![CDATA[/**
    * 获取文件后缀名
    * @param s 文件名
    * @param split 分隔字符
    * @return 分隔字符.后缀名
    */
    @SuppressWarnings("unused")
	private static  String getExtName(String s, char split) {
        int i = s.]]></description><category></category></item><item><title><![CDATA[正则表达式过滤特殊字符]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/30493227</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/30493227</guid><author>sharionlee</author><pubDate>Fri, 13 Jun 2014 15:48:41 +0800</pubDate><description><![CDATA[/**
	 *  正则表达式过滤特殊字符  
	 * @param str
	 * @return
	 * @throws PatternSyntaxException
	 */
    public static String StringFilter(String str)   throws PatternSyntaxException{      
		// 只允许字母和数字        ]]></description><category></category></item><item><title><![CDATA[将汉字转换为全拼]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/30491971</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/30491971</guid><author>sharionlee</author><pubDate>Fri, 13 Jun 2014 15:40:26 +0800</pubDate><description><![CDATA[将汉字zhuanh]]></description><category></category></item><item><title><![CDATA[oracle冷备份与恢复]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/17376325</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/17376325</guid><author>sharionlee</author><pubDate>Tue, 17 Dec 2013 14:17:37 +0800</pubDate><description><![CDATA[windows7系统崩溃，重启电脑一直系统修复，也没有修复成功！所以就重装windows7系统。
1、将原来的D:\oracle\product\10.2.0的目录重命名为D:\oraclebak\product\10.2.0
2、安装oracle目录仍然是D:\oracle\product\10.2.0
3、安装实例直至安装完成。
4、将oracle开头的服务全部停止掉，将新安装的ora]]></description><category></category></item><item><title><![CDATA[Oracle ora-01536：超出表空间“users"的空间限额]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/17170307</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/17170307</guid><author>sharionlee</author><pubDate>Fri, 06 Dec 2013 17:17:39 +0800</pubDate><description><![CDATA[ora-01536：超出表空间“users"的空间限额



ora-1536 是指的你建表的那个user 所能使用的空间没有了，不是那个表所在的tablespace 没有free space 了。你需要做的是给那个user 对那个tablespace 有更多的space 可以使用。


  解决办法增大能够使用的表空间数或授予无限制的使用权限
 ALTER USER 用户 QUO]]></description><category></category></item><item><title><![CDATA[ExtJS中给表格中某列的行值添加tool-tips]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/17162939</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/17162939</guid><author>sharionlee</author><pubDate>Fri, 06 Dec 2013 10:52:35 +0800</pubDate><description><![CDATA[1.ExtJS中给grid添加一个悬停提示,鼠标放到grid给予提示

// 定义列模型
	var cm = new Ext.grid.ColumnModel([
			rownum,
			{
				header : '操作',
				dataIndex : 'id',
				hidden : false,
				renderer : function(value, cellmeta]]></description><category></category></item><item><title><![CDATA[EXT.NET GridPanel 鼠标经过列位置tip提示内容]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/16842865</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/16842865</guid><author>sharionlee</author><pubDate>Wed, 20 Nov 2013 13:38:40 +0800</pubDate><description><![CDATA[鼠标经过列位置tip显示列内容（参考Ext.NET Examples Explorer【GridPanel Row with ToolTip】）：
JS:
             
        var showTip = function () {
            var rowIndex = GridPanel1.view.findRowIndex(this.triggerEle]]></description><category></category></item><item><title><![CDATA[JQuery Mobile实现动态下拉框代码]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/14223269</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/14223269</guid><author>sharionlee</author><pubDate>Wed, 06 Nov 2013 10:30:19 +0800</pubDate><description><![CDATA[JSP页面代码：


﻿




${sysTitle}
<link rel="stylesheet"
	href="./resource/jqm1.2/css/themes/default/jquery.mobile-1.2.0.min.css">










	
		

			返回
			${itemname}

		
		
			<form method="post"]]></description><category></category></item><item><title><![CDATA[Ext.Net.SelectBox菜单联动]]></title><link>https://blog.youkuaiyun.com/sharionlee/article/details/9283247</link><guid>https://blog.youkuaiyun.com/sharionlee/article/details/9283247</guid><author>sharionlee</author><pubDate>Tue, 09 Jul 2013 16:43:54 +0800</pubDate><description><![CDATA[效果图：


后台： 
private void init()
        { 
DataTable gzflDt = bll.GetGZFLSelectBoxList();
            Store3.DataSource = gzflDt;//工作分类
            Store3.DataBind();
            if (gzflDt.R]]></description><category></category></item></channel></rss>