Skip to content

Instantly share code, notes, and snippets.

@OneYX
OneYX / 0_reuse_code.js
Created April 7, 2016 17:05
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@OneYX
OneYX / setParmsValue.js
Created April 26, 2016 07:25 — forked from simplelife7/setParmsValue.js
【JS】URL参数活动、设置
//设置URL参数的方法
function setParmsValue(parms, parmsValue) {
var urlstrings = document.URL;
var args = GetUrlParms();
var values = args[parms];
//如果参数不存在,则添加参数
if (values == undefined) {
var query = location.search.substring(1); //获取查询串
//如果Url中已经有参数,则附加参数
if (query) {
mysql设置定时任务
今天遇到了个需要每天定时执行的任务,在mysql数据库里面提供了这样的功能,正好整理下分享出来。
1.首先检查是否开启了定时任务
1 查看event是否开启 : SHOW VARIABLES LIKE '%event_sche%';
2 将事件计划开启 : SET GLOBAL event_scheduler = 1;
3 将事件计划关闭 : SET GLOBAL event_scheduler = 0;
4 关闭事件任务 : ALTER EVENT eventName ON COMPLETION PRESERVE DISABLE;
5 开启事件任务 : ALTER EVENT eventName ON COMPLETION PRESERVE ENABLE;
在做考题的的时候,涉及到分类,虽然不是无限级的,但是,为了以后扩展用,想做成无限级,在网上找找了,一个用存储过程作的,虽然添加,编辑,移动,用的是存储过程,可是在读出来的时候只用了一条Select 语句,感觉挺爽的,下面我把存储过程列出来,我只用到了添加,编辑,没有用到移动。
1,表结构
===================================================
表结构:
表名:Tb_Column
表结构(所有字段非空):
Column_ID int 主键(注:非标识)
Column_Name nvarchar(50)分类名称
@OneYX
OneYX / bookmarks_2017_4_14.html
Created May 9, 2017 03:21
bookmarks_2017_4_14
<!DOCTYPE NETSCAPE-Bookmark-file-1>
<!-- This is an automatically generated file.
It will be read and overwritten.
DO NOT EDIT! -->
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<TITLE>Bookmarks</TITLE>
<H1>Bookmarks</H1>
<DL><p>
<DT><H3 ADD_DATE="1490926463" LAST_MODIFIED="1491563423" PERSONAL_TOOLBAR_FOLDER="true">书签栏</H3>
<DL><p>
@OneYX
OneYX / fetch.js
Created May 9, 2017 09:01
fetch demo js
var token;
fetch("/login", {
method: "POST",
headers: {
"Content-Type": "application/x-www-form-urlencoded"
},
body: "tel=15528801837&password=1"
}).then(function(res) {
if (res.ok) {
token = res.headers.get("x-auth-token");
@OneYX
OneYX / work.txt
Last active May 12, 2017 07:27
工作小记事本
docker pull jhipster/jhipster:v4.2.0
docker run --name jhipster -v ~/jhipster:/home/jhipster/app -v ~/.m2:/home/jhipster/.m2 -p 8080:8080 -p 3000:3000 -p 3001:3001 -d -t jhipster/jhipster:v4.2.0
docker pull jhipster/jhipster-registry:v2.6.0
docker run --name jhipster-registry -p 8761:8761 -d -t jhipster/jhipster-registry:v2.6.0
docker pull jhipster/jhipster-sample-app-gateway:latest
docker run --name jhipster-sample-app-gateway -p 8080:8080 -p 5701:5701 -d -t jhipster/jhipster-sample-app-gateway:latest
docker pull mongo:3.5.5
@OneYX
OneYX / bookmarks_2017_5_9.html
Created May 9, 2017 10:37
bookmarks_2017_5_9.html
<!DOCTYPE NETSCAPE-Bookmark-file-1>
<!-- This is an automatically generated file.
It will be read and overwritten.
DO NOT EDIT! -->
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<TITLE>Bookmarks</TITLE>
<H1>Bookmarks</H1>
<DL><p>
<DT><H3 ADD_DATE="1491090075" LAST_MODIFIED="1493947939" PERSONAL_TOOLBAR_FOLDER="true">书签栏</H3>
<DL><p>
@OneYX
OneYX / coreos-docker.sh
Created June 12, 2017 03:04
CoreOS-Dokcer使用Docker加速器、安装Docker Compose
#!/bin/sh
# 如何使用Docker加速器
# 针对Docker客户端版本大于1.10的用户
# 您可以通过修改daemon配置文件/etc/docker/daemon.json来使用加速器:
sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{
"registry-mirrors": ["https://gpkywf9i.mirror.aliyuncs.com"]
}
@OneYX
OneYX / docker-compose.yml
Created June 12, 2017 03:59
mysql and redis docker-compose.yml
version: '2'
services:
mysql:
image: mysql:5.6
container_name: mysql-5.6
restart: always
ports:
- 3306:3306
volumes: