Skip to content

Instantly share code, notes, and snippets.

update WCMChnlDoc set DocChannel=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京'));
update WCMChnlDoc set ChnlId=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京')) and Modal=1;
update WCMDocument set DocChannel=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京'));
update wcmmetatablehaierstore set ChannelId=7102 where (qdlx='社区店' and gongmao='北京')
create procedure `testdb`()
begin
declare v_uid bigint(22);
declare v_code varchar(100);
declare v_value varchar(100);
declare _done TINYINT(1) default 0;
declare cur_user cursor for select id from `cdb_faqs`;
declare continue handler for not found set _done = 1;
open cur_user;
<?xml version="1.0" encoding="gb2312"?>
<modules>
<module id="0">
<group>主框架</group>
<name>0. 主程序框架</name>
<url>#</url>
<img>images/homepage/0.png</img>
<target />
</module>
<module id="1">
@ethanfu
ethanfu / gist:4231913
Created December 7, 2012 08:55
index.js
/**
* Created with IntelliJ IDEA.
* User: ethan
* Date: 12-12-7
* Time: 下午12:43
* To change this template use File | Settings | File Templates.
*/
(function(window){
var index = {
version : "0.1.0",
String queryCondition = null;
if (request.getAttribute("queryCondition") != null) {
queryCondition = request.getAttribute("queryCondition").toString();
} else {
queryCondition = request.getParameter("queryCondition");
}
PageVo pageVo = Helper.findPageVo(request);
if (pageVo != null) {
pageVo = Helper.updatePageVo(pageVo, request);
} else {
package org.synergy.service.platform;
/**
* Created with IntelliJ IDEA.
* User: Junyan
* Date: 13-2-6
* Time: 下午9:08
*/
import org.apache.commons.dbcp.BasicDataSource;
//回写表单
//可以处理select,但是不允许select的option的value出现","字符
function writeBackValue(inputName) {
if (form.elements[inputName] == undefined) {
return false;
}
if (form.elements[inputName].value != undefined) { //如果有value属性,直接赋值
form.elements[inputName].value = mForm[inputName];
jQuery("#" + inputName).val(mForm[inputName]);
}
* 史萊姆的第一個家 *
* 軟體資訊 --- 每日更新 *
* 軟體下載 --- 教學文件 *
* 免費資源 --- 郵件共享 *
* 史萊姆的第一個家 *
* 軟體資訊 --- 每日更新 *
* 軟體下載 --- 教學文件 *
* 免費資源 --- 郵件共享 *
@ethanfu
ethanfu / gist:5626004
Last active December 17, 2015 14:39
场景是这样的很多jsp文件中有writeTable的方法,这个方法其中有两个参数,需要把第二个参数替换下,例如:writeTableTop('<fmt:message key="orderlist"/>','<venus:base/>/'); 其中第一个参数是变量,每个调用的可能是不一致的,但是第二个<venus:base/>都是完全一样的,不过在整个页面中<venus:base/>缺不是唯一的。 我的思路就是利用双重for循环,先找到writeTable的文件,然后把在这些文件中把行号打印出来,这样就在相应的文件替换相应行号的那个字符串就可以了,主要利用了<venus:base/〉页面不唯一,但是本行内是唯一的特点。测试数据页面可以参照:https://gist.github.com…
for f in `find . -type f -name "*.jsp" | xargs grep -rl writeTable`; do
for l in `grep -n writeTable ${f} | awk -F: '{print $1}'`; do
sed -e "${l}s/<venus:base\/>/<venus:base\/>\/themes\/<venus:theme\/>\//" $f
done
done
@ethanfu
ethanfu / gist:5628050
Created May 22, 2013 14:41
示例jsp
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ include file="/jsp/include/global.jsp" %>
<fmt:bundle basename="gap.dd.dd_resource" prefix="gap.dd.">
<script src="<%=request.getContextPath()%>/dwr/interface/TreeControl.js" type="text/javascript"></script>
<%@ include file="/jsp/dd/include/dwr.jsp" %>
<%@ include file="/jsp/dd/include/jquery.jsp" %>
<script type="text/javascript" src="<venus:base/>/js/dd/common.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/dd/basedata/basedata.js"></script>
<script language="javascript" src="<venus:base/>/js/dd/gap-ajaxList-tree.js"></script>
<STYLE TYPE="text/css" >