暑期实习项目——【淘淘商城】感想简记

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_content_category

parent_id = #{parentId,jdbcType=BIGINT},

name = #{name,jdbcType=VARCHAR},

status = #{status,jdbcType=INTEGER},

sort_order = #{sortOrder,jdbcType=INTEGER},

is_parent = #{isParent,jdbcType=BIT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

where id = #{id,jdbcType=BIGINT}

update tb_content_category

set parent_id = #{parentId,jdbcType=BIGINT},

name = #{name,jdbcType=VARCHAR},

status = #{status,jdbcType=INTEGER},

sort_order = #{sortOrder,jdbcType=INTEGER},

is_parent = #{isParent,jdbcType=BIT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP}

where id = #{id,jdbcType=BIGINT}

TbContentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

id, category_id, title, sub_title, title_desc, url, pic, pic2, created, updated

content

select

distinct

,

from tb_content

order by ${orderByClause}

select

distinct

from tb_content

order by ${orderByClause}

select

,

from tb_content

where id = #{id,jdbcType=BIGINT}

delete from tb_content

where id = #{id,jdbcType=BIGINT}

delete from tb_content

insert into tb_content (id, category_id, title,

sub_title, title_desc, url,

pic, pic2, created,

updated, content)

values (#{id,jdbcType=BIGINT}, #{categoryId,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR},

#{subTitle,jdbcType=VARCHAR}, #{titleDesc,jdbcType=VARCHAR}, #{url,jdbcType=VARCHAR},

#{pic,jdbcType=VARCHAR}, #{pic2,jdbcType=VARCHAR}, #{created,jdbcType=TIMESTAMP},

#{updated,jdbcType=TIMESTAMP}, #{content,jdbcType=LONGVARCHAR})

insert into tb_content

id,

category_id,

title,

sub_title,

title_desc,

url,

pic,

pic2,

created,

updated,

content,

#{id,jdbcType=BIGINT},

#{categoryId,jdbcType=BIGINT},

#{title,jdbcType=VARCHAR},

#{subTitle,jdbcType=VARCHAR},

#{titleDesc,jdbcType=VARCHAR},

#{url,jdbcType=VARCHAR},

#{pic,jdbcType=VARCHAR},

#{pic2,jdbcType=VARCHAR},

#{created,jdbcType=TIMESTAMP},

#{updated,jdbcType=TIMESTAMP},

#{content,jdbcType=LONGVARCHAR},

select count(*) from tb_content

update tb_content

id = #{record.id,jdbcType=BIGINT},

category_id = #{record.categoryId,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sub_title = #{record.subTitle,jdbcType=VARCHAR},

title_desc = #{record.titleDesc,jdbcType=VARCHAR},

url = #{record.url,jdbcType=VARCHAR},

pic = #{record.pic,jdbcType=VARCHAR},

pic2 = #{record.pic2,jdbcType=VARCHAR},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

content = #{record.content,jdbcType=LONGVARCHAR},

update tb_content

set id = #{record.id,jdbcType=BIGINT},

category_id = #{record.categoryId,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sub_title = #{record.subTitle,jdbcType=VARCHAR},

title_desc = #{record.titleDesc,jdbcType=VARCHAR},

url = #{record.url,jdbcType=VARCHAR},

pic = #{record.pic,jdbcType=VARCHAR},

pic2 = #{record.pic2,jdbcType=VARCHAR},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

content = #{record.content,jdbcType=LONGVARCHAR}

update tb_content

set id = #{record.id,jdbcType=BIGINT},

category_id = #{record.categoryId,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sub_title = #{record.subTitle,jdbcType=VARCHAR},

title_desc = #{record.titleDesc,jdbcType=VARCHAR},

url = #{record.url,jdbcType=VARCHAR},

pic = #{record.pic,jdbcType=VARCHAR},

pic2 = #{record.pic2,jdbcType=VARCHAR},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_content

category_id = #{categoryId,jdbcType=BIGINT},

title = #{title,jdbcType=VARCHAR},

sub_title = #{subTitle,jdbcType=VARCHAR},

title_desc = #{titleDesc,jdbcType=VARCHAR},

url = #{url,jdbcType=VARCHAR},

pic = #{pic,jdbcType=VARCHAR},

pic2 = #{pic2,jdbcType=VARCHAR},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

content = #{content,jdbcType=LONGVARCHAR},

where id = #{id,jdbcType=BIGINT}

update tb_content

set category_id = #{categoryId,jdbcType=BIGINT},

title = #{title,jdbcType=VARCHAR},

sub_title = #{subTitle,jdbcType=VARCHAR},

title_desc = #{titleDesc,jdbcType=VARCHAR},

url = #{url,jdbcType=VARCHAR},

pic = #{pic,jdbcType=VARCHAR},

pic2 = #{pic2,jdbcType=VARCHAR},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

content = #{content,jdbcType=LONGVARCHAR}

where id = #{id,jdbcType=BIGINT}

update tb_content

set category_id = #{categoryId,jdbcType=BIGINT},

title = #{title,jdbcType=VARCHAR},

sub_title = #{subTitle,jdbcType=VARCHAR},

title_desc = #{titleDesc,jdbcType=VARCHAR},

url = #{url,jdbcType=VARCHAR},

pic = #{pic,jdbcType=VARCHAR},

pic2 = #{pic2,jdbcType=VARCHAR},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP}

where id = #{id,jdbcType=BIGINT}

TbItemCatMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

id, parent_id, name, status, sort_order, is_parent, created, updated

select

distinct

from tb_item_cat

order by ${orderByClause}

select

from tb_item_cat

where id = #{id,jdbcType=BIGINT}

delete from tb_item_cat

where id = #{id,jdbcType=BIGINT}

delete from tb_item_cat

insert into tb_item_cat (id, parent_id, name,

status, sort_order, is_parent,

created, updated)

values (#{id,jdbcType=BIGINT}, #{parentId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR},

#{status,jdbcType=INTEGER}, #{sortOrder,jdbcType=INTEGER}, #{isParent,jdbcType=BIT},

#{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP})

insert into tb_item_cat

id,

parent_id,

name,

status,

sort_order,

is_parent,

created,

updated,

#{id,jdbcType=BIGINT},

#{parentId,jdbcType=BIGINT},

#{name,jdbcType=VARCHAR},

#{status,jdbcType=INTEGER},

#{sortOrder,jdbcType=INTEGER},

#{isParent,jdbcType=BIT},

#{created,jdbcType=TIMESTAMP},

#{updated,jdbcType=TIMESTAMP},

select count(*) from tb_item_cat

update tb_item_cat

id = #{record.id,jdbcType=BIGINT},

parent_id = #{record.parentId,jdbcType=BIGINT},

name = #{record.name,jdbcType=VARCHAR},

status = #{record.status,jdbcType=INTEGER},

sort_order = #{record.sortOrder,jdbcType=INTEGER},

is_parent = #{record.isParent,jdbcType=BIT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

update tb_item_cat

set id = #{record.id,jdbcType=BIGINT},

parent_id = #{record.parentId,jdbcType=BIGINT},

name = #{record.name,jdbcType=VARCHAR},

status = #{record.status,jdbcType=INTEGER},

sort_order = #{record.sortOrder,jdbcType=INTEGER},

is_parent = #{record.isParent,jdbcType=BIT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_item_cat

parent_id = #{parentId,jdbcType=BIGINT},

name = #{name,jdbcType=VARCHAR},

status = #{status,jdbcType=INTEGER},

sort_order = #{sortOrder,jdbcType=INTEGER},

is_parent = #{isParent,jdbcType=BIT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

where id = #{id,jdbcType=BIGINT}

update tb_item_cat

set parent_id = #{parentId,jdbcType=BIGINT},

name = #{name,jdbcType=VARCHAR},

status = #{status,jdbcType=INTEGER},

sort_order = #{sortOrder,jdbcType=INTEGER},

is_parent = #{isParent,jdbcType=BIT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP}

where id = #{id,jdbcType=BIGINT}

TbItemDescMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

item_id, created, updated

item_desc

select

distinct

,

from tb_item_desc

order by ${orderByClause}

select

distinct

from tb_item_desc

order by ${orderByClause}

select

,

from tb_item_desc

where item_id = #{itemId,jdbcType=BIGINT}

delete from tb_item_desc

where item_id = #{itemId,jdbcType=BIGINT}

delete from tb_item_desc

insert into tb_item_desc (item_id, created, updated,

item_desc)

values (#{itemId,jdbcType=BIGINT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP},

#{itemDesc,jdbcType=LONGVARCHAR})

insert into tb_item_desc

item_id,

created,

updated,

item_desc,

#{itemId,jdbcType=BIGINT},

#{created,jdbcType=TIMESTAMP},

#{updated,jdbcType=TIMESTAMP},

#{itemDesc,jdbcType=LONGVARCHAR},

select count(*) from tb_item_desc

update tb_item_desc

item_id = #{record.itemId,jdbcType=BIGINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

item_desc = #{record.itemDesc,jdbcType=LONGVARCHAR},

update tb_item_desc

set item_id = #{record.itemId,jdbcType=BIGINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

item_desc = #{record.itemDesc,jdbcType=LONGVARCHAR}

update tb_item_desc

set item_id = #{record.itemId,jdbcType=BIGINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_item_desc

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

item_desc = #{itemDesc,jdbcType=LONGVARCHAR},

where item_id = #{itemId,jdbcType=BIGINT}

update tb_item_desc

set created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},

item_desc = #{itemDesc,jdbcType=LONGVARCHAR}

where item_id = #{itemId,jdbcType=BIGINT}

update tb_item_desc

set created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP}

where item_id = #{itemId,jdbcType=BIGINT}

TbItemMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

and ${criterion.condition}

and ${criterion.condition} #{criterion.value}

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

and ${criterion.condition}

#{listItem}

id, title, sell_point, price, num, barcode, image, cid, status, created, updated

select

distinct

from tb_item

order by ${orderByClause}

select

from tb_item

where id = #{id,jdbcType=BIGINT}

delete from tb_item

where id = #{id,jdbcType=BIGINT}

delete from tb_item

insert into tb_item (id, title, sell_point,

price, num, barcode,

image, cid, status,

created, updated)

values (#{id,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{sellPoint,jdbcType=VARCHAR},

#{price,jdbcType=BIGINT}, #{num,jdbcType=INTEGER}, #{barcode,jdbcType=VARCHAR},

#{image,jdbcType=VARCHAR}, #{cid,jdbcType=BIGINT}, #{status,jdbcType=TINYINT},

#{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP})

insert into tb_item

id,

title,

sell_point,

price,

num,

barcode,

image,

cid,

status,

created,

updated,

#{id,jdbcType=BIGINT},

#{title,jdbcType=VARCHAR},

#{sellPoint,jdbcType=VARCHAR},

#{price,jdbcType=BIGINT},

#{num,jdbcType=INTEGER},

#{barcode,jdbcType=VARCHAR},

#{image,jdbcType=VARCHAR},

#{cid,jdbcType=BIGINT},

#{status,jdbcType=TINYINT},

#{created,jdbcType=TIMESTAMP},

#{updated,jdbcType=TIMESTAMP},

select count(*) from tb_item

update tb_item

id = #{record.id,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sell_point = #{record.sellPoint,jdbcType=VARCHAR},

price = #{record.price,jdbcType=BIGINT},

num = #{record.num,jdbcType=INTEGER},

barcode = #{record.barcode,jdbcType=VARCHAR},

image = #{record.image,jdbcType=VARCHAR},

cid = #{record.cid,jdbcType=BIGINT},

status = #{record.status,jdbcType=TINYINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP},

update tb_item

set id = #{record.id,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sell_point = #{record.sellPoint,jdbcType=VARCHAR},

price = #{record.price,jdbcType=BIGINT},

num = #{record.num,jdbcType=INTEGER},

barcode = #{record.barcode,jdbcType=VARCHAR},

image = #{record.image,jdbcType=VARCHAR},

cid = #{record.cid,jdbcType=BIGINT},

status = #{record.status,jdbcType=TINYINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_item

title = #{title,jdbcType=VARCHAR},

sell_point = #{sellPoint,jdbcType=VARCHAR},

price = #{price,jdbcType=BIGINT},

num = #{num,jdbcType=INTEGER},

barcode = #{barcode,jdbcType=VARCHAR},

image = #{image,jdbcType=VARCHAR},

cid = #{cid,jdbcType=BIGINT},

status = #{status,jdbcType=TINYINT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。

深知大多数前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!

因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。

img

既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上前端开发知识点,真正体系化!

由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!

如果你觉得这些内容对你有帮助,可以扫码获取!!(备注:前端)

结尾

正式学习前端大概 3 年多了,很早就想整理这个书单了,因为常常会有朋友问,前端该如何学习,学习前端该看哪些书,我就讲讲我学习的道路中看的一些书,虽然整理的书不多,但是每一本都是那种看一本就秒不绝口的感觉。

以下大部分是我看过的,或者说身边的人推荐的书籍,每一本我都有些相关的推荐语,如果你有看到更好的书欢迎推荐呀。

戳这里免费领取前端学习资料

/update>

update tb_item

set id = #{record.id,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sell_point = #{record.sellPoint,jdbcType=VARCHAR},

price = #{record.price,jdbcType=BIGINT},

num = #{record.num,jdbcType=INTEGER},

barcode = #{record.barcode,jdbcType=VARCHAR},

image = #{record.image,jdbcType=VARCHAR},

cid = #{record.cid,jdbcType=BIGINT},

status = #{record.status,jdbcType=TINYINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

update tb_item

title = #{title,jdbcType=VARCHAR},

sell_point = #{sellPoint,jdbcType=VARCHAR},

price = #{price,jdbcType=BIGINT},

num = #{num,jdbcType=INTEGER},

barcode = #{barcode,jdbcType=VARCHAR},

image = #{image,jdbcType=VARCHAR},

cid = #{cid,jdbcType=BIGINT},

status = #{status,jdbcType=TINYINT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP},
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。

深知大多数前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!

因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。

[外链图片转存中…(img-mFrprw0J-1714371177872)]

[外链图片转存中…(img-jP1zBWPg-1714371177872)]

既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上前端开发知识点,真正体系化!

[外链图片转存中…(img-tNsm9NfJ-1714371177872)]

由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!

如果你觉得这些内容对你有帮助,可以扫码获取!!(备注:前端)

[外链图片转存中…(img-RyCzaOw7-1714371177873)]

结尾

正式学习前端大概 3 年多了,很早就想整理这个书单了,因为常常会有朋友问,前端该如何学习,学习前端该看哪些书,我就讲讲我学习的道路中看的一些书,虽然整理的书不多,但是每一本都是那种看一本就秒不绝口的感觉。

以下大部分是我看过的,或者说身边的人推荐的书籍,每一本我都有些相关的推荐语,如果你有看到更好的书欢迎推荐呀。

戳这里免费领取前端学习资料

前端学习书籍导图-1

  • 11
    点赞
  • 23
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值