摘要:
UPDATE scrm.t_contacts t SET t.MAIN_USER_ID = ( SELECT IF ( u.`PARENT_ID` = '0', u.`ID`, u.`PARENT_ID` ) MAIN_USER_ID FROM `user-center`.tb_user u ...
阅读全文
posted @ 2018-06-26 14:28
wanhua.wu
阅读(147)
推荐(0)
摘要:
#!/usr/bin/python # -*- coding: UTF-8 -*- import MySQLdb import traceback import time # 测试环境脚本 - 批量从Mysql主表导出数据到Mycat子表 # Mysql: 打开数据库连接 mysqlDB = MySQLdb.connect(host="47.91", port=3306, user="s"...
阅读全文
posted @ 2018-06-26 09:14
wanhua.wu
阅读(3004)
推荐(0)
摘要:
#!/usr/bin/python # -*- coding: UTF-8 -*- import MySQLdb import traceback # 测试环境脚本 - 批量填充时间线表中的主账号 # UserCenter: 打开数据库连接 userCenterDB = MySQLdb.connect(host="47.90", port=3306, user="r", passwd="l...
阅读全文
posted @ 2018-06-26 09:13
wanhua.wu
阅读(1023)
推荐(0)
摘要:
{"cookie":"39828d2f-bffc-4818-883d-2e627f0b274d","shopId":"306072209435180713","platform":0,"viewDate":{$gte:1529567243000,$lte:1529636122171}} {viewDate:-1}
阅读全文
posted @ 2018-06-22 10:59
wanhua.wu
阅读(115)
推荐(0)
摘要:
http://cron.qqe2.com/
阅读全文
posted @ 2018-06-20 16:40
wanhua.wu
阅读(94)
推荐(0)
摘要:
Mycat在进行修改操作的时候,偶尔会发生空指针异常! 解决: 修改条件添加:分表字段
阅读全文
posted @ 2018-06-15 09:50
wanhua.wu
阅读(694)
推荐(0)
摘要:
依赖地址:https://sourceforge.net/projects/mysqlpythonwinx64py272/?source=typ_redirect 参考:https://www.jianshu.com/p/9acc85d0ff16 命令行:
阅读全文
posted @ 2018-06-14 16:52
wanhua.wu
阅读(2584)
推荐(0)
摘要:
https://blog.csdn.net/win7system/article/details/53333094 批量插入mycat无法确认数据具体插入到那个表,所以得先指定分表字段
阅读全文
posted @ 2018-06-05 14:20
wanhua.wu
阅读(981)
推荐(0)
摘要:
http://m635674608.iteye.com/blog/2387781
阅读全文
posted @ 2018-06-01 10:17
wanhua.wu
阅读(130)
推荐(0)
摘要:
http://www.cnblogs.com/larryzeal/p/5874103.html
阅读全文
posted @ 2018-05-29 19:01
wanhua.wu
阅读(98)
推荐(0)
摘要:
import org.apache.commons.lang.StringEscapeUtils; String locationInfo = StringEscapeUtils.unescapeJavaScript(locationInfo);
阅读全文
posted @ 2018-05-23 20:25
wanhua.wu
阅读(2797)
推荐(0)
摘要:
引用:http://www.cnblogs.com/cnlmgsoft/archive/2013/03/27/2984201.html tomcat-users.xml 配置 一:tomcat6配置管理员信息 1:打开tomcat6下的~/conf/tomcat-users.xml文件,关于用户角色
阅读全文
posted @ 2018-05-17 11:45
wanhua.wu
阅读(524)
推荐(0)
摘要:
/** * 线程配置 */ public enum SystemMsgSendConfig { ; public static final int POOL_MAXIMUM_SIZE = 10; public static final int POOL_KEEP_ALIVE_TIME = 1; public static final int POOL_AW...
阅读全文
posted @ 2018-05-14 16:32
wanhua.wu
阅读(164)
推荐(0)
摘要:
private ExecutorService executorService; @PostConstruct public void init() { // 初始化线程池 executorService = Executors.newFixedThreadPool(5); } executorService...
阅读全文
posted @ 2018-05-14 16:13
wanhua.wu
阅读(110)
推荐(0)
摘要:
lambda表达式有个限制,那就是只能引用 final 或 final 局部变量,这就是说不能在lambda内部修改定义在域外的变量。 Compile time error : local variables referenced from a lambda expression must be f
阅读全文
posted @ 2018-05-14 14:43
wanhua.wu
阅读(198)
推荐(0)
摘要:
update t_mail_marketing set `STATUS` = 1 where ID in ( select b.PARENT_ID from (SELECT DISTINCT a.PARENT_ID from t_mail_marketing a where a.`STATUS`=1 and a.PARENT_ID IS NOT NULL and a.PARENT_ID>0)b...
阅读全文
posted @ 2018-04-25 17:31
wanhua.wu
阅读(97)
推荐(0)
摘要:
List userVOList = userCenterFacade.getAllUserListByParentId(clientContactsAddForm.getMainUserId()); List userIdList = userVOList.stream().map(e->e.getId()).collect(Collectors.toList()); ...
阅读全文
posted @ 2018-04-20 10:50
wanhua.wu
阅读(1225)
推荐(0)
摘要:
public static final Map signMap = new HashMap(); static { for (EnumGold gen : EnumSet.allOf(EnumGold.class)) { signMap.put(gen.getSign(), gen); } }
阅读全文
posted @ 2018-04-08 10:14
wanhua.wu
阅读(527)
推荐(0)
摘要:
//对所有的数据进行查询 solrQuery.setQuery("*:*"); //设置页数 solrQuery.setStart((Math.max(page, 1) - 1) * pageSize); //设置页码,返回0条,只要统计信息 solrQuery.setRows(pageSize);
阅读全文
posted @ 2018-03-15 18:05
wanhua.wu
阅读(157)
推荐(0)
摘要:
telnet 127.0.0.1:20881
阅读全文
posted @ 2018-03-14 15:21
wanhua.wu
阅读(138)
推荐(0)
摘要:
一,cat命令 1,先确定指定行数: cat -n catalina.out | grep "推广失败" 2,查指定行数-往后5000行: cat -n catalina.out | tail -n +21054456 | head -n 5000 3,指定行数-100到300行: cat -n c
阅读全文
posted @ 2018-03-14 15:00
wanhua.wu
阅读(226)
推荐(0)
摘要:
<warSourceExcludes>${static.path}</warSourceExcludes> 例子: <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war
阅读全文
posted @ 2018-03-01 10:56
wanhua.wu
阅读(397)
推荐(0)
摘要:
/** * 获取随机1-10个通宝币 * @return */ private Long getPullNewGold() { /** * 拉新活动: * 1,每拉新一个人一次性 随机给予直接上级1-10个通宝币 * 8 - 5 - 1 - 2 - 10...
阅读全文
posted @ 2018-02-10 14:20
wanhua.wu
阅读(105)
推荐(0)
摘要:
Long.toString((userPOJO.getId() + 50000L), 36)
阅读全文
posted @ 2018-02-06 16:52
wanhua.wu
阅读(185)
推荐(0)
摘要:
AND CREATE_TIME>=DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CREATE_TIME>=DATE_SUB(CURDATE(),INTERVAL 15 DAY) AND CREATE_TIME>...
阅读全文
posted @ 2018-01-23 13:30
wanhua.wu
阅读(210)
推荐(0)
摘要:
【nginx.conf】 _________________________________________________________________________________________________________________________________________
阅读全文
posted @ 2018-01-18 10:40
wanhua.wu
阅读(292)
推荐(0)
摘要:
iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-port 8080
阅读全文
posted @ 2018-01-04 16:36
wanhua.wu
阅读(148)
推荐(0)
摘要:
nc -v 47.96.10.242 6379
阅读全文
posted @ 2017-12-16 15:44
wanhua.wu
阅读(100)
推荐(0)
摘要:
[root@localhost bin]# pwd /usr/local/nexus-2.14.0-01/bin [root@localhost bin]# cp nexus /etc/rc.d/init.d/ [root@localhost bin]# cd /etc/rc.d/init.d/ [root@localhost init.d]# ls functions jexec ne...
阅读全文
posted @ 2017-12-16 14:55
wanhua.wu
阅读(293)
推荐(0)
摘要:
http://wiki.eclipse.org/Older_Versions_Of_Eclipse
阅读全文
posted @ 2017-12-14 20:39
wanhua.wu
阅读(443)
推荐(0)
摘要:
WxConfigService wxConfigService = SpringContextHolder.getBean("wxConfigService");
阅读全文
posted @ 2017-11-10 15:41
wanhua.wu
阅读(167)
推荐(0)
摘要:
find . -name "*.java" -or -name "*.xml"|xargs grep -v "^$"|wc -l
阅读全文
posted @ 2017-10-11 11:54
wanhua.wu
阅读(145)
推荐(0)
摘要:
curl -d "phone=18668247775&password=12345&verifyCode=1234&invitationCode=UUID-1234-1234-1234" http://localhost:1111/user/register
阅读全文
posted @ 2017-09-23 16:43
wanhua.wu
阅读(691)
推荐(0)
posted @ 2017-09-23 16:43
wanhua.wu
阅读(129)
推荐(0)
摘要:
ps aux | grep 'nginx' | awk '{print $2}' | xargs kill -9
阅读全文
posted @ 2017-09-11 13:56
wanhua.wu
阅读(94)
推荐(0)
摘要:
1,在tomcat的startup.sh文件中添加一下内容(文件startup.sh在博客文件中即可查到) declare -x CATALINA_OPTS="-server -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_
阅读全文
posted @ 2017-09-02 18:11
wanhua.wu
阅读(269)
推荐(0)
摘要:
/** * 获取json数据中所有key */ function fetchResponseInfo(responseInfo){ //判断是否为空 if((!responseInfo || responseInfo.length <= 0)) { return; } //获取model var jsonCo...
阅读全文
posted @ 2017-09-02 12:23
wanhua.wu
阅读(5595)
推荐(0)
摘要:
参考: http://m.blog.csdn.net/zhengxiangwen/article/details/68927330 http://www.zyall.com/format_json.html 一,格式化显示 1,必须在pre标签中 <pre style="width:100%;hei
阅读全文
posted @ 2017-09-02 08:14
wanhua.wu
阅读(10662)
推荐(0)
摘要:
问题: 在Eclipse中使用Jetty插件经常需要配置Environment参数,一个个配置效率过低 解决方法: 可以通过直接修改Eclipse的隐藏文件来配置,只需复制粘贴 1,找到Eclipse对应项目的工作空间目录下的文件: 文件名一般为[项目名]-web.launch EclipsePro
阅读全文
posted @ 2017-08-23 15:50
wanhua.wu
阅读(761)
推荐(0)
摘要:
参考: http://825635381.iteye.com/blog/2331174
阅读全文
posted @ 2017-08-13 18:13
wanhua.wu
阅读(102)
推荐(0)