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前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合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 年多了,很早就想整理这个书单了,因为常常会有朋友问,前端该如何学习,学习前端该看哪些书,我就讲讲我学习的道路中看的一些书,虽然整理的书不多,但是每一本都是那种看一本就秒不绝口的感觉。
以下大部分是我看过的,或者说身边的人推荐的书籍,每一本我都有些相关的推荐语,如果你有看到更好的书欢迎推荐呀。