尚硅谷：零基础Java教程，实战项目+深度解析SPU&SKU

entrance-tip 已收录资源合集
java
需积分: 0 2 下载量 134 浏览量 更新于2024-09-13 收藏 635KB DOCX 举报
本教程旨在为零基础学习者提供全面、深入的Java后台搭建指导，特别针对Java语言及其最新特性进行讲解，涵盖了JDK 11，同时介绍了Eclipse和IDEA这两种主流的企业开发环境。教程设计精良，循序渐进，注重实践，让学习者在理解理论的同时提升技能。 教程特色包括： 1. 适合零基础：课程从Java语言基础知识开始，逐步深入，每个章节都配有详尽的练习，通过宋老师的生动教学，使学生轻松掌握，避免枯燥无味的传统教学方式。 2. 紧跟技术潮流：课程内容与时俱进，覆盖了Java 8至Java 11的新特性，确保学生学习到最前沿的技术。 3. 深度技术讲解：30天内包含715个小节，涉及数据结构、设计模式和JVM内存结构等深度内容，通过源码级解析，帮助学员理解技术原理，而非仅仅记忆。 4. 实战经验丰富：课程提供了大量的代码示例，包括基础阶段的12720行代码和高级阶段的11684行代码，以及实战项目共计5套，涵盖企业面试真题，具有高度实战价值。 5. 商业场景应用：以谷粒商城为例，讲解了SPU（标准化产品单元）与SKU（库存量单位）的概念，以及销售属性与平台属性的区别和应用场景。通过实际的数据库表结构设计，展示了如何在开发中动态生成下拉菜单，这有助于学员理解和应用到实际项目中。 通过学习本教程，学员不仅可以掌握Java编程技能，还能熟悉企业级开发环境，提升对数据结构和内存管理的理解，并通过丰富的实战项目增强实际操作能力。这对于求职和进一步技术深化都非常有益。

06-尚硅谷_电商项目_spring_尚硅谷_项目_

2021-09-29 上传
6. **05尚硅谷_后台搭建_sku.pdf**：如前所述，SKU是库存单位，这部分可能详细讲解SKU的管理，包括价格、库存等信息。 7. **安装FastDfs.pdf**：FastDFS是一个开源的高性能文件系统，常用于存储和分享大型文件，如...

with tmp_order as ( select user_id, order_stats_struct.sku_id sku_id, order_stats_struct.order_count order_count from dws_user_action_daycount lateral view explode(order_detail_stats) tmp as order_stats_struct where date_format(dt,'yyyy-MM')=date_format('2021-08-16','yyyy-MM') ), tmp_sku as ( select id, tm_id, category1_id, category1_name from dwd_dim_sku_info where dt='2021-08-16' ) insert into table ads_sale_tm_category1_stat_mn select tm_id, category1_id, category1_name, sum(if(order_count>=1,1,0)) buycount, sum(if(order_count>=2,1,0)) buyTwiceLast, sum(if(order_count>=2,1,0))/sum( if(order_count>=1,1,0)) buyTwiceLastRatio, sum(if(order_count>=3,1,0)) buy3timeLast , sum(if(order_count>=3,1,0))/sum( if(order_count>=1,1,0)) buy3timeLastRatio , date_format('2021-08-16' ,'yyyy-MM') stat_mn, '2021-08-16' stat_date from ( select tmp_order.user_id, tmp_sku.category1_id, tmp_sku.category1_name, tmp_sku.tm_id, sum(order_count) order_count from tmp_order join tmp_sku on tmp_order.sku_id=tmp_sku.id group by tmp_order.user_id,tmp_sku.category1_id,tmp_sku.category1_name,tmp_sku.tm_id )tmp group by tm_id, category1_id, category1_name

2023-07-15 上传
然后，使用子查询 "tmp_sku" 从表 "dwd_dim_sku_info" 中选择特定日期（'2021-08-16'）的SKU信息。接下来，将两个子查询的结果进行连接，并按照用户、分类ID、分类名称和品牌ID进行分组。最后，根据分组结果计算购买...

select distinct t1.user_id, friend_favor.sku_id from ( select user1_id user_id, user2_id friend_id from friendship_info union select user2_id, user1_id from friendship_info )t1 left join favor_info friend_favor on t1.friend_id=friend_favor.user_id left join favor_info user_favor on t1.user_id=user_favor.user_id and friend_favor.sku_id=user_favor.sku_id where user_favor.sku_id is null;

2023-05-25 上传
这是一条 SQL 查询语句，它的作用是查找所有用户的好友未收藏的商品。它首先通过 `union` 操作将所有的好友关系整合到一个表中，然后通过左连接找出每个用户的好友收藏的商品，最后通过 `where` 子句排除掉已经被...

UPDATE btp_purchase_order_init_part_details pd ,btp_purchase_order_init_details od set pd.purchase_quantity=pd.purchase_quantity-1, pd.sale_amount=pd.purchase_quantity*1 where od.order_id = 36 and od.commodity_type = 'PT03' and od.id = pd.details_id and pd.sku_code ='SKU0001' and pd.part_type=90011001

2023-06-10 上传
这是一条 SQL 语句，它的作用是更新两张表中的数据。具体来说，它会将 btp_purchase_order_init_part_...另外，btp_purchase_order_init_part_details 表中的 sku_code 等于 'SKU0001'，part_type 等于 90011001。

优化这段代码 let findNoAreasData = []; console.log('findNoAreas res', res); res.datas.data.forEach(x => { // 存在限购地区 if (x.no_areas.length > 0) { x.no_areas.filter(y => { if (y.province_id == this.addrCode.province) { this.goodsDatas.filter(z => { if (z.goods_sku.third_sku_id == y.sku_id) { z.goods_sku.notDelivery = true; if (z.goods_sku.notDelivery) { this.no_areas = true; } } }) } }) } });

2023-06-01 上传
if (noAreasSkuIds.includes(z.goods_sku.third_sku_id)) { z.goods_sku.notDelivery = true; this.no_areas = true; } }); } ``` 这段代码首先使用 `filter` 函数筛选出限购地区中包含当前省份的数据，并使用...

select mg.id, mg.name, mg.category_id, mg.code, mg.brand_id, mg.stock, mg.is_hot_sell, mg.is_shelves, mg.is_new, mg.is_limit_buy_quantity, mg.is_open_group, mg.group_number, mg.group_lowest_price, mg.state, mg.main_pic, mg.keyword, mg.brief_introduction, mg.supply_channel, mg.supplier_id, mg.video_link, mg.description, mg.create_by, mg.create_time, mg.create_org, mg.update_by, mg.update_time, mg.made_in, mg.model, mg.market_price, mg.is_shipping_cost, mg.shipping_cost, mg.is_tax, mg.billing_type, mg.sell_count, (select name from mall_brand where id = mg.brand_id) brand_name, category_name, (select name from mall_supplier where id = mg.supplier_id) supplier_name, shelves_time, (select retail_price,unit_price from mall_goods_sku where goods_id=mg.id limit 1) retail_price,unit_price from mall_goods mg where mg.state = 1 这个sql语句哪里错了

2023-07-15 上传
(select retail_price from mall_goods_sku where goods_id=mg.id limit 1) retail_price, (select unit_price from mall_goods_sku where goods_id=mg.id limit 1) unit_price from mall_goods mg where ...

纠错 select COALESCE(ooc.second_amount,1) /COALESCE(ooc.unit_quantity,1) as cc from ods.ods_durian_loading_task odlt left join ods.ods_durian_loading_sku_item odlsi on odlsi.plan_id=odlt.plan_id left join ods.ods_oms_commodity ooc on ooc.id=odlsi.commodity_id;

2023-06-01 上传
left join ods.ods_durian_loading_sku_item odlsi on odlsi.plan_id = odlt.plan_id left join ods.ods_oms_commodity ooc on ooc.id = odlsi.commodity_id; ``` 如果您仍然遇到问题，请提供更多上下文或错误信息...

SELECT pl.id AS product_line_id, pl.name AS product_line_name, ROUND(SUM(s.price), 2) AS daily_sales, ROUND(SUM(s.price) OVER (PARTITION BY pl.id, DATE_TRUNC('week', o.create_time)), 2) AS weekly_sales, ROUND(SUM(s.price) OVER (PARTITION BY pl.id, DATE_TRUNC('month', o.create_time)), 2) AS monthly_sales, ROUND(SUM(s.price) OVER (PARTITION BY pl.id, DATE_TRUNC('year', o.create_time)), 2) AS yearly_sales FROM ls_order_sku AS od JOIN ls_order AS o ON o.id = od.order_id JOIN ls_sku AS s ON s.id = od.sku_id JOIN ls_spu AS sp ON sp.id = s.spu_id JOIN ls_product_line AS pl ON pl.id = s.product_line_id GROUP BY pl.id, pl.name, DATE_TRUNC('day', o.create_time) ORDER BY pl.id, DATE_TRUNC('day', o.create_time) 这个sql 报 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY pl.id, DATE_TRUNC('week', o.create_time)), 2) AS weekly_sales, ' at line 5 这个错 怎么解决

2023-05-27 上传
JOIN ls_sku AS s ON s.id = od.sku_id JOIN ls_spu AS sp ON sp.id = s.spu_id JOIN ls_product_line AS pl ON pl.id = s.product_line_id GROUP BY pl.id, pl.name, DATE(o.create_time) ORDER BY pl.id, ...

为什么这个SQL：delete from t_bdp_ind_commodity_and_set_sku ss,t_bdp_ind_commodity c where ss.commodity_id = c.commodity_id and c.commodity_id = 3538 and c.commodity_set_id = 8188; 会报这个错误：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',t_bdp_ind_commodity c where ss.commodity_id = c.commodity_id and c.commodity_id' at line 1

2023-05-25 上传
DELETE ss,c FROM t_bdp_ind_commodity_and_set_sku ss JOIN t_bdp_ind_commodity c ON ss.commodity_id = c.commodity_id WHERE c.commodity_id = 3538 AND c.commodity_set_id = 8188; ``` 这个语句将会删除`t_...

优化SQL select round( ohbmc.after_actual_amount/zz,0) cost_moneyi ,count(distinct case when ddp.orig_plan_rid = -1 then null else ddp.orig_plan_rid end) AS orig_num ,array_agg (dlt.state) AS loading_state ,count(DISTINCT CASE WHEN ddp.sale_planid = -1 THEN NULL ELSE ddp.sale_planid END) AS saleid_num--销地已计划数量 ,array_agg(dto.state) AS saletransport_state from ( SELECT id AS origin_planid , unnest(cabinet_rule_id) cabinet_rule_id -- 判断 next_plan_id 本身是空和 next_plan_id 为 {} ,unnest(case when (next_plan_id is null or next_plan_id[1] is null) then ARRAY[-1]::integer[] else next_plan_id end) as sale_planid --销地计划 , case when dp.plan_receiver_id is null then -1 else dp.plan_receiver_id end orig_plan_rid --产地计划 FROM ods.ods_durian_delivery_plan as dp left join ods.ods_hl_commodity_category as hcc on hcc.category_id = dp.category_id WHERE dp.type = 'ORIGIN' AND dp.deleted = 99 AND dp.tenant_id = 1 and cabinet_rule_id='{8}'or cabinet_rule_id='{9}'or cabinet_rule_id='{10000005}'---取白心火龙果 AND hcc.category_name = '火龙果') as ddp LEFT JOIN ods.ods_durian_loading_task AS dlt ON dlt.plan_id = ddp.origin_planid and dlt.plan_type='ORIGIN' AND dlt.deleted = 99 LEFT JOIN ods.ods_durian_transport_order AS dto ON dto.plan_id = ddp.sale_planid AND dto.deleted = 99 LEFT JOIN ods.ods_durian_receipt_task AS drt ON drt.plan_id = ddp.sale_planid AND drt.deleted = 99 LEFT JOIN ods.ods_durian_transport_order AS dto1 ON dto1.plan_id = ddp.sale_planid AND dto1.sort_no = 1 AND dto1.deleted = 99 left join (select odlsi.plan_id,sum(odlsi.quantity) zz from ods.ods_durian_loading_sku_item odlsi group by 1) odlsi on odlsi.plan_id=dlt.plan_id left join (select *, unnest(case when ( odbr.bill_main_id is null or odbr.bill_main_id is null) then ARRAY[-1]::integer[] else odbr.bill_main_id end) bill_main_id_r from ods.ods_durian_bill_rel odbr) odbr on odbr.data_id= dlt.plan_id and odbr.data_type='ORIGIN_FEE' left join ods.ods_hl_bill_main_currency ohbmc on ohbmc.bill_main_id=odbr.bill_main_id_r and ohbmc.deleted=99 group by 1;

2023-06-13 上传
这个SQL查询语句比较复杂，可以考虑以下几种优化方式： 1. 使用JOIN语句代替子查询：可以把子查询转换成JOIN语句，这样可以提高查询的效率。 2. 合理使用索引：根据实际情况，选择合适的索引可以大大提升查询效率...
墨白与海.
  • 粉丝: 10
  • 资源: 92
上传资源 快速赚钱

最新资源