最后
开源分享:【大厂前端面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】
❤️ 谢谢支持,喜欢的话别忘了 关注、点赞哦。
(也是根据上面的逆向工程自动生成
的)
TbContentCategoryMapper.java
package com.taotao.mapper;
import com.taotao.pojo.TbContentCategory;
import com.taotao.pojo.TbContentCategoryExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
public interface TbContentCategoryMapper {
int countByExample(TbContentCategoryExample example);
int deleteByExample(TbContentCategoryExample example);
int deleteByPrimaryKey(Long id);
int insert(TbContentCategory record);
int insertSelective(TbContentCategory record);
List selectByExample(TbContentCategoryExample example);
TbContentCategory selectByPrimaryKey(Long id);
int updateByExampleSelective(@Param(“record”) TbContentCategory record, @Param(“example”) TbContentCategoryExample example);
int updateByExample(@Param(“record”) TbContentCategory record, @Param(“example”) TbContentCategoryExample example);
int updateByPrimaryKeySelective(TbContentCategory record);
int updateByPrimaryKey(TbContentCategory record);
}
TbContentMapper.java
package com.taotao.mapper;
import com.taotao.pojo.TbContent;
import com.taotao.pojo.TbContentExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
public interface TbContentMapper {
int countByExample(TbContentExample example);
int deleteByExample(TbContentExample example);
int deleteByPrimaryKey(Long id);
int insert(TbContent record);
int insertSelective(TbContent record);
List selectByExampleWithBLOBs(TbContentExample example);
List selectByExample(TbContentExample example);
TbContent selectByPrimaryKey(Long id);
int updateByExampleSelective(@Param(“record”) TbContent record, @Param(“example”) TbContentExample example);
int updateByExampleWithBLOBs(@Param(“record”) TbContent record, @Param(“example”) TbContentExample example);
int updateByExample(@Param(“record”) TbContent record, @Param(“example”) TbContentExample example);
int updateByPrimaryKeySelective(TbContent record);
int updateByPrimaryKeyWithBLOBs(TbContent record);
int updateByPrimaryKey(TbContent record);
}
TbItemCatMapper.java
package com.taotao.mapper;
import com.taotao.pojo.TbItemCat;
import com.taotao.pojo.TbItemCatExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
public interface TbItemCatMapper {
int countByExample(TbItemCatExample example);
int deleteByExample(TbItemCatExample example);
int deleteByPrimaryKey(Long id);
int insert(TbItemCat record);
int insertSelective(TbItemCat record);
List selectByExample(TbItemCatExample example);
TbItemCat selectByPrimaryKey(Long id);
int updateByExampleSelective(@Param(“record”) TbItemCat record, @Param(“example”) TbItemCatExample example);
int updateByExample(@Param(“record”) TbItemCat record, @Param(“example”) TbItemCatExample example);
int updateByPrimaryKeySelective(TbItemCat record);
int updateByPrimaryKey(TbItemCat record);
}
TbContentCategoryMapper.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_content_category
order by ${orderByClause}
select
from tb_content_category
where id = #{id,jdbcType=BIGINT}
delete from tb_content_category
where id = #{id,jdbcType=BIGINT}
delete from tb_content_category
insert into tb_content_category (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_content_category
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_content_category
update tb_content_category
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_content_category
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_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
总结
为了帮助大家更好温习重点知识、更高效的准备面试,特别整理了《前端工程师面试手册》电子稿文件。
内容包括html,css,JavaScript,ES6,计算机网络,浏览器,工程化,模块化,Node.js,框架,数据结构,性能优化,项目等等。
包含了腾讯、字节跳动、小米、阿里、滴滴、美团、58、拼多多、360、新浪、搜狐等一线互联网公司面试被问到的题目,涵盖了初中级前端技术点。
前端面试题汇总
开源分享:【大厂前端面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】
JavaScript
性能
linux
{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
总结
为了帮助大家更好温习重点知识、更高效的准备面试,特别整理了《前端工程师面试手册》电子稿文件。
内容包括html,css,JavaScript,ES6,计算机网络,浏览器,工程化,模块化,Node.js,框架,数据结构,性能优化,项目等等。
包含了腾讯、字节跳动、小米、阿里、滴滴、美团、58、拼多多、360、新浪、搜狐等一线互联网公司面试被问到的题目,涵盖了初中级前端技术点。
前端面试题汇总
开源分享:【大厂前端面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】
JavaScript
性能
linux