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},
where id = #{id,jdbcType=BIGINT}
update tb_item
set 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}
where id = #{id,jdbcType=BIGINT}
generatorConfig.xml
<?xml version="1.0" encoding="UTF-8"?><jdbcConnection driverClass=“com.mysql.jdbc.Driver”
connectionURL=“jdbc:mysql://localhost:3306/taotao” userId=“root”
password=“root”>
<javaModelGenerator targetPackage=“com.taotao.pojo”
targetProject=“.\src”>
<sqlMapGenerator targetPackage=“com.taotao.mapper”
targetProject=“.\src”>
<javaClientGenerator type=“XMLMAPPER”
targetPackage=“com.taotao.mapper”
targetProject=“.\src”>
最后
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数初中级Android工程师,想要提升技能,往往是自己摸索成长,自己不成体系的自学效果低效漫长且无助。
因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Android开发知识点!不论你是刚入门Android开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
Generator>
<jdbcConnection driverClass=“com.mysql.jdbc.Driver”
connectionURL=“jdbc:mysql://localhost:3306/taotao” userId=“root”
password=“root”>
<javaModelGenerator targetPackage=“com.taotao.pojo”
targetProject=“.\src”>
<sqlMapGenerator targetPackage=“com.taotao.mapper”
targetProject=“.\src”>
<javaClientGenerator type=“XMLMAPPER”
targetPackage=“com.taotao.mapper”
targetProject=“.\src”>
最后
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数初中级Android工程师,想要提升技能,往往是自己摸索成长,自己不成体系的自学效果低效漫长且无助。
因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
[外链图片转存中…(img-lIWdVBLY-1715257178288)]
[外链图片转存中…(img-CRhbGsSZ-1715257178289)]
[外链图片转存中…(img-EYUECYJV-1715257178289)]
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Android开发知识点!不论你是刚入门Android开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!