- 博客(11)
- 收藏
- 关注
RSS订阅原创 按月统计上报情况
按照部门、过去12个月做统计,区分已上报数，本月无数据，已发送提醒; 当月无数据留0自己写的最啰嗦最长最没效率的SQL...SELECTcc.com_id AS com_id,v.`month` AS `month`,cc.com_name AS com_name,cc.user_id AS user_id,IFNULL(t1.count, 0) AS `monthly_
2017-03-15 15:24:34
444
原创 MyBatis动态SQL小tips
SELECT cl.id AS id, cl.col_borrowerName AS colBorrowername, cl.col_borrowerIdcard AS colBorroweridcard, cl.qq AS qq, cl.phone AS phone, cc.com_name AS comName, ci.down_repo
2016-11-26 15:10:08
257
原创 点击整行选定checkbox
// 点击整行选定checkbox$('.trs').on('click' , function(){ var check = $(this).find("input[type='checkbox']"); if ($(check).is(':checked')) { $(check).prop('checked', false); } else { $(check).prop('
2016-11-26 12:47:32
1587
1
原创 form的action和Excel下载按钮提交的不是同一个url
// 判断是否有数据if (request.getParameterNames().toString().contains("data")){ Map dataMap = new HashMap(); List titles = new ArrayList(); titles.add("姓名"); //1 titles.add("身份证号码"); //2
2016-11-25 18:30:08
545
转载 全选反选
全选 / 反选 // 全选\反选 $(document).ready(function () { $('.i-checks').iCheck({ checkboxClass: 'icheckbox_square-green', radioClass: 'iradio_square-green' }); }); function
2016-11-25 18:24:41
402
转载 MySQL 时间条件查询
格式描述%a缩写星期名%b缩写月名%c月，数值%D带有英文前缀的月中的天%d月的天，数值(00-31)%e月的天，数值(0-31)%f微秒%H小时 (00-23)%h小时 (0
2016-06-29 12:17:57
1040
原创 java,MongoDB,Mapreduce
MongoOperations mongoOps = new MongoTemplate(new SimpleMongoDbFactory(new Mongo(), "test"));//连接本地商圈库 String map = "//..."; String reduce = "//..."; DBCollection dbCollection
2016-05-06 15:00:25
413
原创 Spring通过JavaScript操作MongoDB
MongoOperations mongoOps = new MongoTemplate(new SimpleMongoDbFactory(new Mongo(), "test"));//连接本地商圈库 CommandResult commandResult = mongoOps.getCollection("location").getDB().doEval(SCRIPTS);/
2016-05-06 14:57:19
558
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人