SpringBoot———实现增删改查操作
前言
提示：以下是本篇文章正文内容，下面案例可供参考
一、创建一个springboot项目工程
二、准备一个数据库表
create table dept(
id int unsigned primary key auto_increment comment,
name varchar(10) not null unique comment
create_time datetime not null comment
update_time datetime not null comment '
)
2.配置pom.xml文件，引入依赖的包
代码如下（示例）：文章来源：https://www.toymoban.com/news/detail-788185.html
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>tlias-web-management</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>tlias-web-management</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.6.13</spring-boot.version>
</properties>
<dependencies>
<!-- web起步依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- mybatis起步依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<!-- mysql驱动包-->
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<!-- Lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!-- springboot单元测试-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>${spring-boot.version}</version>
<configuration>
<mainClass>com.example.tliaswebmanagement.TliasWebManagementApplication</mainClass>
<skip>true</skip>
</configuration>
<executions>
<execution>
<id>repackage</id>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
3.在resources写application.propertiesl配置文件，连接数据库
# 应用服务 WEB 访问端口
server.port=8080
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#数据库连接的url
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useSSL=false&serverTimezone=UTC
#连接数据库的用户名
spring.datasource.username=root
#连接数据库的密码
spring.datasource.password=root
#配置mybatis的日志，指定输出到控制台
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#开启mybatis的驼峰命名自动映射开关。a_column ------>aColumn
mybatis.configuration.map-underscore-to-camel-case=true
三、创建一个Dept实体类
package com.example.tliaswebmanagement.com.itheima.pojo;
/**
* @Author 小浩
* @Date 2023/10/25 17:51
* @PackageName:com.example.tliaswebmanagement.com.itheima.pojo
* @ClassName: PageBean
* @Description 实体类
*/
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.time.LocalDate;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Dept {
private Integer id; //ID
private String name; //部门名称
private LocalDate createTime; //创建时间
private LocalDate updateTime; // 修改时间
}
1、创建DeptController
package com.example.tliaswebmanagement.com.itheima.controller;
import com.example.tliaswebmanagement.com.itheima.pojo.Dept;
import com.example.tliaswebmanagement.com.itheima.pojo.Result;
import com.example.tliaswebmanagement.com.itheima.service.DeptService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
/**
* 部门管理Controller
*/
@Slf4j //lombok提供了日志
@RestController
@RequestMapping("/depts")
public class DeptController {
@Autowired
private DeptService deptService;
/**
* 查询部门数据
*
* @return
*/
@GetMapping
public Result list() {
log.info("查询全部部门数据");
//调用service查询部门数据
List<Dept> list = deptService.list();
return Result.success(list);
}
/**
* 通过id删除部门id
*
* @param id
* @return
*/
@DeleteMapping("/{id}")
public Result delete(@PathVariable Integer id) {
log.info("根据id删除部门：{}", id);
//调用service删除部门
deptService.delete(id);
return Result.success();
}
/**
* 新增部门
*
* @param dept
* @return
*/
@PostMapping
public Result add(@RequestBody Dept dept) {
log.info("新增部门：{}", dept);
//调用service新增部门
deptService.add(dept);
return Result.success();
}
/**
* 修改部门
*
* @return
*/
@PutMapping
public Result update(Dept dept) {
log.info("修改部门");
//调用service修改部门
deptService.update(dept);
return Result.success();
}
}
2、创建DeptService接口
/**
* @Author 小浩
* @Date 2023/10/25 17:51
* @PackageName:com.example.tliaswebmanagement.com.itheima.pojo
* @ClassName: PageBean
* @Description 实体类
*/
/**
* 查询全部部门数据
* @return
*/
List<Dept> list();
/**
* 删除部门
* @return
*/
void delete(Integer id);
/**
* 新增部门
* @param dept
*/
void add(Dept dept);
/**
* 修改部门
* @param dept
*/
int update(Dept dept);
3、创建一个 DeptServiceImpl实现类
package com.example.tliaswebmanagement.com.itheima.service.impl;
/**
* @Author 小浩
* @Date 2023/10/25 17:51
* @PackageName:com.example.tliaswebmanagement.com.itheima.pojo
* @ClassName: PageBean
* @Description 实体类
*/
import com.example.tliaswebmanagement.com.itheima.mapper.DeptMapper;
import com.example.tliaswebmanagement.com.itheima.pojo.Dept;
import com.example.tliaswebmanagement.com.itheima.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.time.LocalDate;
import java.util.List;
@Service
public class DeptServiceImpl implements DeptService {
@Autowired
private DeptMapper deptMapper;
/**
* 查询全部部门
* @return
*/
@Override
public List<Dept> list() {
return deptMapper.list();
}
/**
* 根据id删除部门
* @param id
*/
@Override
public void delete(Integer id) {
deptMapper.deleteById(id);
}
/**
* 新增部门
* @param dept
*/
@Override
public void add(Dept dept) {
dept.setCreateTime(LocalDate.now());
dept.setUpdateTime(LocalDate.now());
deptMapper.insert(dept);
}
/**
* 修改部门
* @param dept
*/
@Override
public int update(Dept dept) {
return deptMapper.Update(dept);
}
}
4、创建DeptMapper接口
package com.example.tliaswebmanagement.com.itheima.mapper;
import com.example.tliaswebmanagement.com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.*;
import java.util.List;
/**
* @Author 小浩
* @Date 2023/10/25 15:56
* @PackageName:com.example.tliaswebmanagement.com.itheima.mapper
* @ClassName: DeptMapper
* @Description
*/
/**
* 部门管理
*/
@Mapper
public interface DeptMapper {
//查询全部部门
@Select("select * from dept")
List<Dept> list();
/**
* 根据id删除部门
*
* @param id
*/
@Delete("delete from dept where id = #{id}")
void deleteById(Integer id);
/**
* 新增部门
* @param dept
*/
@Insert("insert into dept(name, create_time, update_time) values (#{name},#{createTime},#{updateTime})")
void insert(Dept dept);
/**
* 修改部门信息
* @param
*/
@Update("update dept set create_time = #{createTime}, update_time = #{updateTime} where id = #{id}")
int Update(Dept dept);
}
最后在运行项目在postman测试
文章来源地址https://www.toymoban.com/news/detail-788185.html
到了这里，关于SpringBoot———实现增删改查操作的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
