摘要: public ResultData getCcessToken(String param) { RequestParam req = null; Map<String, Object> parmap = null; try { req = gm.jsonToAnyObject(param, Requ 阅读全文
posted @ 2019-10-12 11:33 雨后丶云初霁 阅读(512) 评论(0) 推荐(0) 编辑
摘要: 右键 run as maven build 在goals中输入 dependency:copy-dependencies -DoutputDirectory=lib 阅读全文
posted @ 2019-09-28 09:38 雨后丶云初霁 阅读(110) 评论(0) 推荐(0) 编辑
摘要: select * from Part_information where substring(waishi2,1,charindex('m',waishi2)-1) != deepth 阅读全文
posted @ 2019-09-11 09:27 雨后丶云初霁 阅读(756) 评论(0) 推荐(0) 编辑
摘要: SELECT slnname, (SELECT REVERSE(LEFT (REVERSE(projectid),LOCATE('G', REVERSE(projectid)) - 1))) AS numb FROM pmaunew ORDER BY numb 其他分割:https://www.cn 阅读全文
posted @ 2019-07-28 20:06 雨后丶云初霁 阅读(1129) 评论(0) 推荐(0) 编辑
摘要: select table_schema,table_name from information_schema.columns where column_name = '字段名' 阅读全文
posted @ 2019-07-19 12:21 雨后丶云初霁 阅读(480) 评论(0) 推荐(0) 编辑
摘要: // 创建用户CREATE user '[用户名]'@'localhost'(本地访问Only) / '[用户名]'@'%'(可以外部访问) IDENTIFIED BY '[密码]'; // 授权用户CRUD以及创建表的权限GRANT SELECT, INSERT, UPDATE, DELETE, 阅读全文
posted @ 2019-07-06 11:33 雨后丶云初霁 阅读(822) 评论(0) 推荐(0) 编辑
摘要: public void insertBeach(Object obj) { Gson gsobj = new Gson(); @SuppressWarnings("unchecked") Map<String, Object> jsonStringToMap = gsobj.fromJson(obj 阅读全文
posted @ 2019-06-19 13:26 雨后丶云初霁 阅读(177) 评论(0) 推荐(0) 编辑
摘要: --查询当天: select * from info where DateDiff(dd,datetime,getdate())=0 --查询24小时内的: select * from info where DateDiff(hh,datetime,getDate())<=24 --查询本周记录se 阅读全文
posted @ 2019-06-16 13:29 雨后丶云初霁 阅读(444) 评论(0) 推荐(0) 编辑
摘要: package proxy; import java.lang.reflect.InvocationHandler;import java.lang.reflect.Method;import java.lang.reflect.Parameter; public class MyInvocatio 阅读全文
posted @ 2019-06-16 13:26 雨后丶云初霁 阅读(856) 评论(0) 推荐(0) 编辑
摘要: vim usr/bin/zdbf.sh #!/bin/sh # Database infoDB_USER="root"DB_PASS="password"DB_HOST="ip" DB_USER1="root"DB_PASS1="password"DB_HOST1="ip2" # Database 阅读全文
posted @ 2019-03-30 14:06 雨后丶云初霁 阅读(284) 评论(0) 推荐(0) 编辑