1688平台API接口开发系列,商品详情,关键词搜索(可高并发)

news/2024/4/25 18:36:20/文章来源:https://blog.csdn.net/Api_k/article/details/129238728

背景

近期,不少电商软件开发者询问我“如何获取商品详情”,有没有接口/API能够快速实现。比如:通过该API可快速获商品的标题、价格、SKU、主图、评价等完整信息,便于一些电商平台、系统的商品管理模块使用。

阿里开放平台自身是不提供此类接口的。那么,在这里统一进行说明,让大家也能快速了解。

架构

采用负载均衡的架构,Hook的方式实现。提供RESTFUL API,支持JAVA、PHP、PYTHON等编程语言使用。测试结果极其稳定,QPS 2,、单次返回平均900ms以内。

onebound.1688.item_get

公共参数

名称类型必须描述
keyString

调用key(必须以GET方式拼接在URL中)

注册Key和secret测试https://o0b.cn/anzexi

secretString调用密钥
api_nameStringAPI接口名称(包括在请求地址中)[item_search,item_get,item_search_shop等]
cacheString[yes,no]默认yes,将调用缓存的数据,速度比较快
result_typeString[json,jsonu,xml,serialize,var_export]返回数据格式,默认为json,jsonu输出的内容中文可以直接阅读可微18179014480
langString[cn,en,ru]翻译语言,默认cn简体中文
versionStringAPI版本

请求参数

请求参数:num_iid=610947572360

参数说明:num_iid:1688商品ID
sales_data:&sales_data=1 获取近30天成交数据
agent:&agent=1 获取1688分销代发价格数据

响应参数

Version: Date:

名称类型必须示例值描述

item

item[]0宝贝详情数据

num_iid

String0610947572360宝贝ID

title

String0厂家直销小米有品Qin2 Pro智能手机学生机老人机备用机小爱同学4G商品标题

desc_short

String0商品简介

price

Float0799.00价格

total_price

Float00

suggestive_price

Float00

orginal_price

Float0799.00原价

nick

String0qin多亲科技卖家昵称

num

Int02191

detail_url

String0https://detail.1688.com/offer/610947572360.html宝贝链接

pic_url

String0https://cbu01.alicdn.com/img/ibank/2020/063/830/13235038360_979836901.jpg宝贝图片

brand

String0MAJE品牌

brandId

Int08879363品牌id

rootCatId

Int00顶级分类ID

cid

Int0124264005

desc

String0

item_imgs

Mix0item_imgs[]商品图片

item_weight

String0

post_fee

Float09.00邮费

express_fee

Float09.00EMS费用

ems_fee

Float09.00物流费用

shipping_to

String0广东广州白云区发货至

video

video[]0商品视频

sample_id

String0

props_name

String00:0:机身内存:64GB;1:0:颜色:铁灰色;1:1:颜色:瓷白色商品属性名

prop_imgs

prop_imgs[]0商品属性图片列表

property_alias

String00:0:64GB;1:0:铁灰色;1:1:瓷白色属性别名

props

Mix0[{"name": "品牌", "value": "other"}]商品详情

total_sold

Int01

scale

Int0

sellUnit

Int0

skus

skus[]0商品规格信息列表

seller_id

Int02206619673102卖家ID

sales

Int0100销售额

shop_id

Int0151372205店铺ID

props_list

Mix0{"0:0": "机身内存:64GB"}商品属性

seller_info

seller_info[]0卖家信息

tmall

Boolean0false是否天猫

data_from

String01688app错误信息

error

String0错误信息

unit

String0部;单位

is_support_mix

Boolean0true

mix_amount

Int030

mix_Begin

Int0

mix_number

Int0

sales_data

Date0

location

String0广东省 深圳市发货地

props_img

Mix0属性图片

sales_info

Mix0

desc_img

Mix0[{"https://cbu01.alicdn.com/img/ibank/2020/560/807/14112708065_979836901.jpg"}]详情图片列表

shop_item

Mix0

relate_items

Mix0

请求示例

Curl PHP PHPsdk JAVA C# Python

-- 请求示例 url 默认请求参数已经URL编码处理 curl -i "https://api-gw.onebound.cn/1688/item_get/?key=<您自己的apiKey>&secret=<您自己的apiSecret>&num_iid=610947572360"

响应示例

{"item": {"num_iid": "610947572360","title": "厂家直销小米有品Qin2 Pro智能手机学生机老人机备用机小爱同学4G","desc_short": "","price": "799.00","total_price": 0,"suggestive_price": 0,"orginal_price": "799.00","nick": "qin多亲科技","num": "1763","detail_url": "https://detail.1688.com/offer/610947572360.html","pic_url": "https://cbu01.alicdn.com/img/ibank/2020/063/830/13235038360_979836901.jpg","brand": "","brandId": "","rootCatId": "","cid": "50903","desc": "<div id=\"offer-template-0\"></div><p><span><span>深圳市多亲科技有限公司(简称&ldquo;多亲科技&rdquo;)成立于2014年9月是国内领先的人工智能硬件解决方案供应商。多亲科技积极推动人工智能技术的创新研发,在人工智能终端设备、系统软件的研发和生产领域,具有深厚的技术沉淀与实力。</span></span></p><p><span>&nbsp;</span></p><p><span>&nbsp; &nbsp; &nbsp; &nbsp; 多亲产品销售网络覆盖全国各地乃至远销海外,欢迎企业定制、团购、经销代理。</span></p><p><span>&nbsp; &nbsp; &nbsp; &nbsp; 优质的产品、过硬的技术、完善的服务、是我们合作双赢的开篇。</span></p><p><span>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span ><strong><span >欢迎有意向者实地考察,垂询电话:13662284449.</span></strong></span></span></p><p><span>&nbsp;</span></p><p><span>温馨提示:</span></p><p><span><span><span>1、可定制--</span></span>承接各种订单订制!为客户定制机身、开机画面、预装软件、包装等定制!</span><br /><span><span><span>2、质量保证--</span></span>本公司专注通讯行业10年,线下线下百花齐放,客户复购率达30%以上。</span><br /><span><span><span>3、价格实惠--</span></span>本店是工厂直供,没有中间商差价,一站到客,薄利多销。</span><br /><span><span><span>4、售后服务--</span></span>本店出售的所有产品均提供1年的质保。因质量原因退换货(非人为因素)30天内换新。</span></p><p>&nbsp;</p><p><span><img alt=\"undefined\" height=\"446.22866894197955\" src=\"https://cbu01.alicdn.com/img/ibank/2020/560/807/14112708065_979836901.jpg\" width=\"790\" /><br /><img alt=\"undefined\" height=\"457.5154730327144\" src=\"https://cbu01.alicdn.com/img/ibank/2020/303/507/14112705303_979836901.jpg\" width=\"790\" /><br /><img alt=\"undefined\" height=\"443.2365499573014\" src=\"https://cbu01.alicdn.com/img/ibank/2020/499/812/14150218994_979836901.jpg\" width=\"790\" /><br /><img alt=\"undefined\" height=\"440.350569675723\" src=\"https://cbu01.alicdn.com/img/ibank/2020/770/128/14199821077_979836901.jpg\" width=\"790\" /><br /></span></p><p><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/588/942/13197249885_979836901.jpg\" /></p><p><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/778/789/13234987877_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/109/489/13234984901_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/156/072/13197270651_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/270/710/13235017072_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/735/999/13234999537_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/549/252/13197252945_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/409/552/13197255904_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/247/935/13278539742_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/355/845/13278548553_979836901.jpg\" /><br /><br /></p><p><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/917/372/13197273719_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/969/099/13234990969_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/175/455/13278554571_979836901.jpg\" /></p><p><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/427/386/13314683724_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/331/365/13278563133_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/654/500/13235005456_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/542/110/13235011245_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/291/020/13235020192_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/329/635/13278536923_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/996/155/13278551699_979836901.jpg\" /></p><p><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/230/920/13235029032_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/464/972/13197279464_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/380/275/13278572083_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/999/462/13197264999_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/868/245/13278542868_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/843/410/13235014348_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/897/200/13235002798_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/914/800/13235008419_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/709/762/13197267907_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/427/545/13278545724_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/741/003/13197300147_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/175/710/13235017571_979836901.jpg\" /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/410/485/13278584014_979836901.jpg\" /><br /><br /><img alt=\"undefined\" src=\"https://cbu01.alicdn.com/img/ibank/2020/863/665/13278566368_979836901.jpg\" /><br /><br /><br /></p>","item_imgs": [{"url": "https://cbu01.alicdn.com/img/ibank/2020/063/830/13235038360_979836901.jpg"},{"url": "https://cbu01.alicdn.com/img/ibank/2020/445/748/13819847544_979836901.jpg"},{"url": "https://cbu01.alicdn.com/img/ibank/2020/487/543/13234345784_979836901.jpg"},{"url": "https://cbu01.alicdn.com/img/ibank/2020/296/695/13418596692_979836901.jpg"},{"url": "https://cbu01.alicdn.com/img/ibank/2020/167/778/13462877761_979836901.jpg"}],"item_weight": "","post_fee": "","express_fee": "","ems_fee": "","shipping_to": "","video": [],"sample_id": "","props_name": "0:0:机身内存:64GB;1:0:颜色:铁灰色;1:1:颜色:瓷白色","prop_imgs": {"prop_img": []},"property_alias": "0:0:64GB;1:0:铁灰色;1:1:瓷白色","props": [{"name": "品牌","value": "多亲"},{"name": "型号","value": "Qin 2 Pro"},{"name": "手机类型","value": "老人手机"},{"name": "外形","value": "直板"},{"name": "主屏尺寸","value": "大屏幕(5.0英寸—5.9英寸)"},{"name": "网络制式","value": "移动4G(TD-LTE),联通/电信4G(FDD-LTE)"},{"name": "操作系统","value": "Android 9.0系统"},{"name": "电池容量","value": "2100"},{"name": "摄像头像素","value": "1200万-1999万"},{"name": "存储卡","value": "支持存储卡"},{"name": "处理器核心","value": "八核"},{"name": "运行内存","value": "2GB"},{"name": "手机版本","value": "大陆行货"},{"name": "售后类型","value": "全国联保"},{"name": "上市时间","value": "2019"},{"name": "适用送礼场合","value": "员工福利,颁奖纪念,广告促销,节日,展销会,公关策划,生日,商务馈赠"},{"name": "3C证书编号","value": "2019161606319519"},{"name": "CPU品牌","value": "展讯"},{"name": "运营商","value": "中国移动,中国电信,中国联通"},{"name": "网络模式","value": "单卡单模"},{"name": "机身内存","value": "64GB"},{"name": "颜色","value": "铁灰色,瓷白色"},{"name": "电信设备进网许可证编号","value": "02-B613-192425"}],"total_sold": "1","scale": "","sellUnit": "","skus": {"sku": [{"price": "799.00","total_price": 0,"sales": "55","properties": "0:0;1:1","properties_name": "0:0:机身内存:64GB;1:1:颜色:瓷白色","quantity": "932","sku_id": "4309097072612","spec_id": "63828b15ad641fdb131775f32e4c050c"},{"price": "799.00","total_price": 0,"sales": "159","properties": "0:0;1:0","properties_name": "0:0:机身内存:64GB;1:0:颜色:铁灰色","quantity": "831","sku_id": "4302217872901","spec_id": "0eb631954bfe8fb00a45824fc6193f2f"}]},"seller_id": "2206619673102","sales": 30,"shop_id": "","props_list": {"0:0": "机身内存:64GB","1:0": "颜色:铁灰色","1:1": "颜色:瓷白色"},"seller_info": {"nick": "qin多亲科技","user_num_id": "2206619673102","sid": "b2b-2206619673102e9470","title": "深圳多亲科技实力卖场","zhuy": "https://winport.m.1688.com/page/index.html?memberId=b2b-2206619673102e9470","shop_name": "qin多亲科技"},"tmall": "","data_from": "1688app","error": "","unit": "部","is_support_mix": null,"mix_amount": null,"mix_begin": null,"mix_number": null,"min_num": "2","sales_data": "","location": "广东省 深圳市","props_img": [],"sales_info": {"seller_num": "","repeat_rate_purchase": "","per_capita_purchases": "","comment_num": "","comment_url": ""},"desc_img": ["https://cbu01.alicdn.com/img/ibank/2020/560/807/14112708065_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/303/507/14112705303_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/499/812/14150218994_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/770/128/14199821077_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/588/942/13197249885_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/778/789/13234987877_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/109/489/13234984901_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/156/072/13197270651_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/270/710/13235017072_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/735/999/13234999537_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/549/252/13197252945_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/409/552/13197255904_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/247/935/13278539742_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/355/845/13278548553_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/917/372/13197273719_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/969/099/13234990969_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/175/455/13278554571_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/427/386/13314683724_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/331/365/13278563133_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/654/500/13235005456_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/542/110/13235011245_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/291/020/13235020192_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/329/635/13278536923_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/996/155/13278551699_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/230/920/13235029032_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/464/972/13197279464_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/380/275/13278572083_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/999/462/13197264999_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/868/245/13278542868_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/843/410/13235014348_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/897/200/13235002798_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/914/800/13235008419_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/709/762/13197267907_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/427/545/13278545724_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/741/003/13197300147_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/175/710/13235017571_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/410/485/13278584014_979836901.jpg","https://cbu01.alicdn.com/img/ibank/2020/863/665/13278566368_979836901.jpg"],"shop_item": [],"relate_items": []}

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.luyixian.cn/news_show_74774.aspx

如若内容造成侵权/违法违规/事实不符,请联系dt猫网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

Python 简单可变、复杂可变、简单不可变、复杂不可变类型的copy、deepcopy的行为

copy模块&#xff1a;copy&#xff1a;浅拷贝deepcopy&#xff1a;深拷贝简单可变类型、复杂可变的copy()、deepcopy()&#xff1a;简单不可变、复杂不可变类型的copy()、deepcopy()&#xff1a;结论&#xff1a;对于简单类型的可变类型copy是深拷贝&#xff0c;改变了该拷贝变…

TIA博途Wincc中自定义配方画面的具体方法示例

TIA博途Wincc中自定义配方画面的具体方法示例 前面和大家分享了通过TIA博途自带的配方视图组态配方功能的具体方法,具体内容可参考以下链接中的内容: TIA PORTAL wincc中配方recipe组态及配方视图的使用方法 但是,使用配方视图的时候感觉不是很方便,同时一部分使用人员也感…

机房运维6大隐患,你中了几个?

随着医院的看诊预约、缴费、打印报告等众多业务转至线上进行&#xff0c;对医院的网络及数据处理能力提出越来越高的要求&#xff0c;那么&#xff0c;机房的稳定、安全运行是医院网络信息系统的关键因素。 机房运维6大隐患 01.电源电力系统不稳定&#xff0c;网络设备运转遭到…

C/C++语法练习之顺序结构篇

名人说&#xff1a; 如果你问一个善于溜冰的人怎样获得成功时&#xff0c; 他会告诉你&#xff1a;“跌倒了&#xff0c;爬起来”&#xff0c;这就是成功。——牛顿 专栏&#xff1a;牛客刷题 顺序结构篇〇、知识引入一、内容1004-学姐的“Helloworld”1005-乘法表1019-hellowo…

TCP粘包|拆包和解决方案

1 产生原因TCP是面向连接的&#xff0c;面向流的&#xff0c;提供高可靠性服务。收发两端&#xff08;客户端和服务端&#xff09;都要有一一成对的socket&#xff0c;因此&#xff0c;发送端为了将多个发给接收端的包&#xff0c;更有效的发给对方&#xff0c;使用了优化算法&…

【算法题】最大矩形面积,单调栈解法

力扣&#xff1a;84. 柱状图中最大的矩形 给定 n 个非负整数&#xff0c;用来表示柱状图中各个柱子的高度。每个柱子彼此相邻&#xff0c;且宽度为 1 。 求在该柱状图中&#xff0c;能够勾勒出来的矩形的最大面积。 题意很简单&#xff0c;翻译一下就是&#xff1a;求该图中…

预训练BERT

与PTB数据集相比&#xff0c;WikiText-2数据集保留了原来的标点符号、大小写和数字&#xff0c;并且比PTB数据集大了两倍多。 我们可以任意访问从WikiText-2语料库中的一对句子生成的预训练&#xff08;遮蔽语言模型和下一句预测&#xff09;样本。 原始的BERT有两个版本&…

BI的作用,体现在企业的哪些方面

对市场异常敏感的商业世界自然不会放过获取数字经济的机会&#xff0c;以国企和央企为首的众多企业开始进行数字化转型&#xff0c;通过信息化建设&#xff0c;部署商业智能BI来完成转型工作。 为什么会出现BI 有一点可能出乎很多人意料&#xff0c;虽然 BI 是因为信息化、数…

智能家居项目(六)之摄像头模块

目录 一、树莓派mipg-streamer实现监控功能调试 1、实现基本思路 2、安装摄像头模块 2.1、在安装sudo apt-get install libv4l-dev 的命令时报错 3、开启摄像头 以下内容是针对树莓派是stretch版本的修改办法&#xff1a; 一、树莓派mipg-streamer实现监控功能调试 1、…

spring boot maven打包jar包太大,怎么办?这个方法解决你的烦恼

在springboot maven项目中&#xff0c;有两种打包方式&#xff0c;一种是war包&#xff0c;一种是jar&#xff0c;今天我们讲一下jar的打包方式。但是在jar包打包只要我们发现&#xff0c;我们的项目jar太大了&#xff0c;每次上传到服务器的时候非常的慢&#xff0c;接下来我们…

大数据处理各组件概念及作用

一、数据采集&#xff1a; 1.1 Flume集群&#xff1a;数据采集工具&#xff0c;如写脚本将不同源端的数据采集后进行数据存储&#xff0c;或推送至Kafka等&#xff1b; 1.2 FTP集群&#xff1a;文件传输工具&#xff1b; 1.3 Kafka集群&#xff1a;消息队列&#xff0c;未避免…

高压放大器在应力波法套筒灌浆密实度检测研究中的应用

实验名称&#xff1a;高压放大器在应力波法套筒灌浆密实度检测研究中的应用研究方向&#xff1a;无损检测测试目的&#xff1a;钢筋套筒灌浆连接技术被广泛应用于装配式建筑节点连接中&#xff0c;但灌浆不密实将导致节点失效的风险。因此&#xff0c;施工中对套筒灌浆的密实度…

Spark 分析计算连续三周登录的用户数

前言&#xff1a;本文用到了窗口函数 range between&#xff0c;可以参考这篇博客进行了解——窗口函数rows between 、range between的使用 创建数据环境 在 MySQL 中创建数据测试表 log_data&#xff1a; create table if not exists log_data( log_id varchar(200) comm…

代码随想录【Day27】| 39. 组合总和、40. 组合总和 II、131. 分割回文串

39. 组合总和 题目链接 题目描述&#xff1a; 给定一个无重复元素的数组 candidates 和一个目标数 target &#xff0c;找出 candidates 中所有可以使数字和为 target 的组合。 candidates 中的数字可以无限制重复被选取。 说明&#xff1a; 所有数字&#xff08;包括 tar…

taobao.top.secret.bill.detail( 服务商的商家解密账单详情查询 )

&#xffe5;免费必须用户授权 服务商的商家解密账单详情查询&#xff0c;仅对90天内的账单提供SLA保障。 公共参数 请求地址: HTTP地址 http://gw.api.taobao.com/router/rest 公共请求参数: 公共响应参数: 请求参数 响应参数 点击获取key和secret 请求示例 TaobaoClient…

js 拖动--动态改变div的宽高大小

index.html 如下&#xff1a;&#xff08;可以新建一个index.html文件直接复制&#xff0c;打开运行&#xff09; <!DOCTYPE html> <html lang"en"> <head> <meta charset"UTF-8"> <meta http-equiv"X-UA-Compatible&qu…

Mybatis源码学习笔记(五)之Mybatis框架缓存机制原理解析

1 Mybatis框架的缓存模块 MyBatis 内置了一个强大的事务性查询缓存机制&#xff0c;它可以非常方便地配置和定制。Mybatis框架中的缓存分为一级缓存和二级缓存&#xff0c;三级缓存基本都要借助自定义缓存或第三方服务来进行实现。但本质上是一样的&#xff0c;都是借助Cache接…

【Python学习笔记】第十九节 Python 面向对象(一)

在现实世界中&#xff0c;随处可见的一种事物就是对象&#xff0c;对象是事物存在的实体&#xff0c;如学生、汽车等。人类解决问题的方式总是将复杂的事物简单化&#xff0c;于是就会思考这些对象都是由哪些部分组成的。通常都会将对象划分为两个部分&#xff0c;即静态部分与…

SSL证书对虚拟主机的用处有哪些?

虚拟主机是指在同一台服务器上&#xff0c;通过不同的域名或IP地址为多个网站提供服务的一种网络主机。而SSL证书则是一种数字证书&#xff0c;它用于加密网站与用户之间的通信&#xff0c;确保数据传输的安全性和完整性。在虚拟主机上&#xff0c;SSL证书有以下几个用处&#…

HiveSql一天一个小技巧:如何巧用分布函数percent_rank()求去掉最大最小值的平均薪水问题

0 问题描述参考链接(3条消息) HiveSql面试题12--如何分析去掉最大最小值的平均薪水&#xff08;字节跳动&#xff09;_莫叫石榴姐的博客-CSDN博客文中已经给出了三种解法&#xff0c;这里我们借助于此题&#xff0c;来研究如何用percent_rank()函数求解&#xff0c;简化解题思路…