- 博客(24)
- 资源 (12)
- 收藏
- 关注
原创 顺丰同城快递配送员轨迹
@ApiOperation(value = "快递查询--配送员轨迹")@PostMapping("/distribution_H5")public R distribution_H5(String orderId){ ProductOrder order=productorderService.getOne(new LambdaQueryWrapper<ProductOrder>().eq(ProductOrder::getOrderID,orderId)); Sfexp.
2020-06-30 09:38:28 1159
原创 顺丰同城快递配置以及签名处理
private String APP_ID="--";private String APP_SECRET="--";private String shop_id="----";/*签名处理*/protected String sign(String content) { String toSign = content + "&" + APP_ID + "&" + APP_SECRET; String md5Result = MD5.getInstance().g.
2020-06-30 09:37:05 1150
原创 顺丰同城快递预下单接口
/*--------------------------------------------------------------------*/@ApiOperation(value = "顺丰预下单")@PostMapping("/PreOrder_add")public R PreOrder_add(Long shopId,Long productId,Long addressID,BigDecimal buyNum){ Shopitem shopitem=shopitemDao.sel.
2020-06-30 09:35:43 1164
原创 sql查询时间段之间的数据(一天、一周等)
TO_DAYS(NOW()) - TO_DAYS(change_time) = 1 // 昨天的数据 change_time 为时间字段TO_DAYS( NOW() ) - TO_DAYS(check_in) = 0 / / 今天的数据 check_in 为时间字段DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= DATE(...
2020-06-30 09:25:31 1059
原创 URLEncoder加密、解密方法
URLEncoder.encode(nickname,"UTF-8"); 加密URLDecoder.decode(nickname,"UTF-8"); 解码
2020-06-30 09:25:16 776
原创 计算两个日期之间啊相差的日期数
Date.prototype.dateDiff = function (objDate2, interval) { var d = this, i = {}, t = d.getTime(), t2 = objDate2.getTime(); i['y'] = objDate2.getFullYear() - d.getFullYear(); i['q'] = i['y'...
2020-06-30 09:25:06 58
原创 datatable数据展示
$(function () { usersJifenHistory.Datatable = $("#usersJifenHistoryDataTable").dataTable({ pageLength: 50, language: { "sProcessing": "处理中...", "sLengthMenu...
2020-06-30 09:24:59 216
原创 js中计算两个时间之间的差值
{ "data" : "createDate", "render":function(data){ return renderDate(data); } }, { "data" ...
2020-06-30 09:24:52 130
原创 sql按照年、月、周、日查看数据
<!--首页交易金额统计 --><!--按照年查看 --> <select id="queryStatByYear" resultMap="StatResultMap" parameterType="Object"> SELECT temp1.yeardate AS yearofdate,TRUNCATE(SUM(temp1.pri..
2020-06-30 09:24:45 281
原创 sql查询多条数据
SELECT IFNULL(TRUNCATE(tudi,2),0.00) AS tudigongxian, IFNULL(TRUNCATE(youhuijing,2),0.00) AS youhuijing, IFNULL(TRUNCATE(choujiang,2),0.00) AS drawMoney, IFNULL(TRUNCATE(tixian,2),0.00) AS...
2020-06-30 09:24:37 1265
原创 手机号正则验证以及344分割
/** * 添加或修改数据 */ @RequestMapping(value="/save",method=RequestMethod.POST) @ResponseBody public RestResult save(EduSchoolMain entity, HttpServletRequest request,HttpServletRes...
2020-06-30 09:24:29 352
原创 js分割手机号和银行卡
银行卡四位一分割use_account = row.use_account.replace(/[\s]/g, '').replace(/(\d{4})(?=\d)/g, "$1 ");手机号(3,4,4)var reg = /^(\d{3})(\d{4})(\d{4})$/;var matches = reg.exec(row.tel);var newNum = matches[...
2020-06-30 09:24:20 224
原创 sql中两个时间比大小
SELECT * FROM cash_recommend WHERE cash_voucher_id =#{cash_voucher_id} AND UNIX_TIMESTAMP(expire_time)&gt;UNIX_TIMESTAMP(NOW())
2020-06-30 09:24:12 283
原创 mysql导入数据时报错处理
SHOW VARIABLES LIKE '%max_allowed_packet%'; // 查看mysql缓存大小SET GLOBAL max_allowed_packet = 50*1024*1024*100;// 将缓存设置的更大
2020-06-30 09:24:05 92
原创 ecipse中jsp页面引入文件
<link rel="stylesheet" type="text/css" href="<%=request.getContextPath() %>/static/plugin/h5/css/ui-base.css"><link rel="stylesheet" type="text/css" href="<%=
2020-06-30 09:23:56 49
原创 mysql中字符串拼接,截取等
IF(u.nick_name!=u.tel,u.nick_name,CONCAT('赚友',RIGHT(u.nick_name, 4))) AS nick_name ,CONCAT(‘**’,'***') 拼接RIGHT(str,4)右边截取几位IFNULL((SELECT TIMESTAMPDIFF(SECOND,p3.date_pick,NOW()) AS du FROM xz_...
2020-06-30 09:23:48 47
原创 js时间格式化,按照年-月-日的格式
var getFormat = function (data){ var date =new Date(data) ; var year = date.getFullYear(); var month = date.getMonth() + 1; var day = date.getDate(); var hours = date.getHours();...
2020-06-30 09:23:41 340
原创 sql查询时间段
<!--近两年 --><select id="selectYear" resultType="Map"> SELECT DATE_FORMAT(u.reg_time,'%Y') AS dataTime FROM users u GROUP BY YEAR(u.reg_time) ORDER BY dataTi...
2020-06-30 09:23:33 173
原创 java中敏感词过滤工具类
//// Source code recreated from a .class file by IntelliJ IDEA// (powered by Fernflower decompiler)//package com.ckpi.utils;import java.util.HashMap;import java.util.HashSet;import java.util.Iterator;import java.util.Map;import java.util.Set;i.
2020-06-30 09:20:10 569
原创 支付宝和微信支付配置类
-------微信public static String wxPayHost = "https://api.mch.weixin.qq.com/pay/unifiedorder";//统一下单接口public static String wxPayQueryHost = "https://api.mch.weixin.qq.com/pay/orderquery";//订单查询public static String wxPayRefundHost = "https://api.mch.weixin.
2020-06-30 09:04:10 225
原创 springboot定时器工具
@Scheduled(fixedRate=30*60*1000) 半小时执行一次@Scheduled(fixedRate=60*60*1000) 一小时执行一次@Scheduled(cron = "0 0 0 * * ?")每日凌晨执行
2020-06-19 20:15:21 285
原创 点击上下箭头对数据排序
public R sort(Long tid, String type) { try { Courescatalog a = getById(tid); if (type.equals("up")) { LambdaQueryWrapper<Courescatalog> qw1 = new LambdaQueryWrapper<>(); qw1.and(it -> it.eq(Coures.
2020-06-10 16:21:49 989
原创 顺丰快递下单接口
/*下单测试接口*/@PostMapping(value = "/test")@ApiOperation(value = "顺风--下单")public R test() throws IOException { //收货人信息 Map<String,Object> receive=new HashMap<>(); receive.put("user_name", URLEncoder.encode("小明")); receive.put(".
2020-06-08 18:43:06 2350 5
原创 经纬度计算相差的公里数
SELECT 6378.138 * 2 * ASIN( SQRT( POW( SIN( ( 36.082551 * PI() / 180 - 36.076996 * PI() / 180 ) / 2 ), 2 ) + COS(36.082551* PI() / 180) * COS(36.076996 * PI() / 180) * POW(...
2020-06-04 17:43:54 1256
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人