SpringBoot+MyBatis+Spring技术整合实现商品模块的增删查改操作

业务描述

基于Spring,MyBatis,SpringBoot,Thymeleaf技术实现商品模块的增删查改操作。

项目环境初始化

准备工作

所需软件
1.MySQL(5.7)
2.JDK(1.8)
3.Maven(3.6.3)
4.STS(4.7.1)

数据库初始化

打开mysql控制台,创建数据库并插入记录,步骤如下
1:登录mysql
mysql -uroot -proot
2.设置控制台编码
set names utf8;
3.创建数据库、数据表并插入表记录
drop database if exists tbbrand;
create datatase dbbrand defalut character set utf8;
use dbbrand;
create table tb_brand(
id int primary key auto_increment;
name varchar(20) not null;
remark text;
createdTime datetime not null);
insert into tb_brand(null,'TCL','verygood',now());
insert into tb_brand(null,'理想','verygood',now());
insert into tb_brand(null,'华为','ok',now());
insert into tb_brand(null,'小米','verygood',now());
insert into tb_brand(null,'创维','very ok',now());

创建项目并添加依赖

基于Spring Initializr创建
5f1d091cc2996510fca3d2828bcb97a.png
添加依赖
5b1b488d8b5e54edbec29cc13c198cf.png
点击next选择项目工作空间

项目配置文件内容初始化

#server
server.port=80 //修改服务器端口
#server.servlet.context-path=/
#spring datasource
spring.datasource.url=jdbc:mysql:///dbgoods?serverTimezone=GMT%2B8&characterEncoding=utf8 //指定数据库连接地址
spring.datasource.username=root
spring.datasource.password=root

#spring mybatis
//指定mapper配置文件地址
mybatis.mapper-locations=classpath:/mapper/*/*.xml

#spring logging
//设置日志级别
logging.level.com.cy=debug

#spring thymeleaf
spring.thymeleaf.prefix=classpath:/templates/pages/
spring.thymeleaf.suffix=.html
spring.thymeleaf.cache=false

项目API架构设计

9eb001b8b06b2dc47401adf1b2baa25.png

商品查询业务实现

业务时序分析

查询所有商品,其业务时序分析,如图所示:78d41b21d62411c93a546d34a4d32d7.png

POJO类定义

定义Brand对象,用于封装从数据库查询到的商品信息

public class Brand{
private Integer id;
private String name;
private String remark;
private Date createTime;

public void setId(Integer id){
this.id=id;
}
public int getId(){
return id;
}
public void setName(String name){
this.name=name;
}
public String getId(){
return name;
}
public void setRemark(String remark){
this.remark=remark;
}
public String getRemark(){
return remark;
}
public Date getCreatedTime() {

    return createdTime;
}
public void setCreatedTime(Date createdTime) {
    this.createdTime = createdTime;
}
@Override

public String toString() {

    return "Brand{" +
            "id=" + id +
            ", name='" + name + ''' +
            ", remark='" + remark + ''' +
            ", createdTime=" + createdTime +
            '}';
}

}

Dao接口方法及映射定义

public interface BrandDao(){
@Select("select * from tb_brands)
List<Brand> findBrands();
}

评论

暂无评论