SpringBoot———实现增删改查操作

SpringBoot———实现增删改查操作

文章目录

前言

提示：以下是本篇文章正文内容，下面案例可供参考

一、创建一个springboot项目工程

二、准备一个数据库表

createtable dept(
    id intunsignedprimarykeyauto_incrementcomment,
    name varchar(10)notnulluniquecomment  
    create_time datetimenotnullcomment  
    update_time datetimenotnullcomment  '
)

2.配置pom.xml文件，引入依赖的包

代码如下（示例）：

<?xml version="1.0" encoding="UTF-8"?><projectxmlns="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实体类

packagecom.example.tliaswebmanagement.com.itheima.pojo;/**
 * @Author 小浩
 * @Date 2023/10/25 17:51
 * @PackageName:com.example.tliaswebmanagement.com.itheima.pojo
 * @ClassName: PageBean
 * @Description  实体类
 */importlombok.AllArgsConstructor;importlombok.Data;importlombok.NoArgsConstructor;importjava.time.LocalDate;@Data@AllArgsConstructor@NoArgsConstructorpublicclassDept{privateInteger id;//IDprivateString name;//部门名称privateLocalDate createTime;//创建时间privateLocalDate updateTime;// 修改时间}

1、创建DeptController

packagecom.example.tliaswebmanagement.com.itheima.controller;importcom.example.tliaswebmanagement.com.itheima.pojo.Dept;importcom.example.tliaswebmanagement.com.itheima.pojo.Result;importcom.example.tliaswebmanagement.com.itheima.service.DeptService;importlombok.extern.slf4j.Slf4j;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.*;importjava.util.List;/**
 * 部门管理Controller
 */@Slf4j//lombok提供了日志@RestController@RequestMapping("/depts")publicclassDeptController{@AutowiredprivateDeptService deptService;/**
     * 查询部门数据
     *
     * @return
     */@GetMappingpublicResultlist(){
        log.info("查询全部部门数据");//调用service查询部门数据List<Dept> list = deptService.list();returnResult.success(list);}/**
     * 通过id删除部门id
     *
     * @param id
     * @return
     */@DeleteMapping("/{id}")publicResultdelete(@PathVariableInteger id){
        log.info("根据id删除部门：{}", id);//调用service删除部门
        deptService.delete(id);returnResult.success();}/**
     * 新增部门
     *
     * @param dept
     * @return
     */@PostMappingpublicResultadd(@RequestBodyDept dept){
        log.info("新增部门：{}", dept);//调用service新增部门
        deptService.add(dept);returnResult.success();}/**
     * 修改部门
     *
     * @return
     */@PutMappingpublicResultupdate(Dept dept){
        log.info("修改部门");//调用service修改部门
        deptService.update(dept);returnResult.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
     */voiddelete(Integer id);/**
     * 新增部门
     * @param dept
     */voidadd(Dept dept);/**
     * 修改部门
     * @param dept
     */intupdate(Dept dept);

3、创建一个 DeptServiceImpl实现类

packagecom.example.tliaswebmanagement.com.itheima.service.impl;/**
 * @Author 小浩
 * @Date 2023/10/25 17:51
 * @PackageName:com.example.tliaswebmanagement.com.itheima.pojo
 * @ClassName: PageBean
 * @Description  实体类
 */importcom.example.tliaswebmanagement.com.itheima.mapper.DeptMapper;importcom.example.tliaswebmanagement.com.itheima.pojo.Dept;importcom.example.tliaswebmanagement.com.itheima.service.DeptService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.time.LocalDate;importjava.util.List;@ServicepublicclassDeptServiceImplimplementsDeptService{@AutowiredprivateDeptMapper deptMapper;/**
     * 查询全部部门
     * @return
     */@OverridepublicList<Dept>list(){return deptMapper.list();}/**
     * 根据id删除部门
     * @param id
     */@Overridepublicvoiddelete(Integer id){
        deptMapper.deleteById(id);}/**
     * 新增部门
     * @param dept
     */@Overridepublicvoidadd(Dept dept){

        dept.setCreateTime(LocalDate.now());
        dept.setUpdateTime(LocalDate.now());
        deptMapper.insert(dept);}/**
     * 修改部门
     * @param dept
     */@Overridepublicintupdate(Dept dept){returndeptMapper.Update(dept);}}

4、创建DeptMapper接口

packagecom.example.tliaswebmanagement.com.itheima.mapper;importcom.example.tliaswebmanagement.com.itheima.pojo.Dept;importorg.apache.ibatis.annotations.*;importjava.util.List;/**
 * @Author 小浩
 * @Date 2023/10/25 15:56
 * @PackageName:com.example.tliaswebmanagement.com.itheima.mapper
 * @ClassName: DeptMapper
 * @Description
 *//**
 * 部门管理
 */@MapperpublicinterfaceDeptMapper{//查询全部部门@Select("select  * from  dept")List<Dept>list();/**
     * 根据id删除部门
     *
     * @param id
     */@Delete("delete from dept where id = #{id}")voiddeleteById(Integer id);/**
     * 新增部门
     * @param dept
     */@Insert("insert into  dept(name, create_time, update_time) values (#{name},#{createTime},#{updateTime})")voidinsert(Dept dept);/**
     * 修改部门信息
     * @param
     */@Update("update  dept set create_time = #{createTime}, update_time = #{updateTime}  where id = #{id}")intUpdate(Dept dept);}

最后在运行项目在postman测试