这里将会介绍怎么去搭建一个简单增删改查的Springboot项目,认真看完我相信你一定能够学会,并且附有完整代码;

目录

  • 一、搭建数据库
    • 1.建数据库
    • 2.建表
  • 二、新建IDEA项目
  • 三、连接数据库
    • 1.编写文件
    • 2.连接MySQL
  • 四、写代码
    • pojo层
    • mapper层
    • Service层
    • Controller层
    • 写mapper层的映射文件
  • 五、测试
    • Apifox测试结果(没Apifox直接跳过)
    • 网页测试
  • 六、完整代码
    • UserController
    • UserMapper
    • User
    • UserService
    • UserMapper.xml
    • application.properties
    • pom.xml

一、搭建数据库

首先要进行增删改查肯定是要有供操作的数据库;

这里我是用的SQLyog来搭建的,随便用什么都可以,只要能确保给项目一个配套的数据库就行;

1.建数据库

CREATE DATABASE springBoot;

2.建表

CREATE TABLE USER(NAME VARCHAR(30),id INT(11),sex VARCHAR(10)) DEFAULT CHARSET=utf8

二、新建IDEA项目

打开IDEA,创建一个新项目,准备开始动手


然后选择插件



点击创建

在pom.xml里导入Lombok依赖

org.projectlomboklombok

然后搭建四层架构
controller,mapper,pojo,service


创建mapper的映射文件

三、连接数据库

1.编写文件

在resources包下找到application.properties,将如下代码写入:

spring.datasource.username=rootspring.datasource.password=adminspring.datasource.url=jdbc:mysql://localhost:3306/mybatis" />

2.连接MySQL


选择我们之前建好的数据库

点击Apply和OK后,我们就可以看到我们连接了数据库

四、写代码

经过前面的准备工作后终于可以开始写代码了;

这里我就只介绍一个接口(查找所有用户),其他的都是差不多的流程,文章末尾附完整代码

pojo层


实体类里的属性要与数据表一一对应;

mapper层

查询所有用户是要返回多个User,所以用List;

Service层


先用@Autowired注入userMapper;

然后声明方法;

Controller层


同样注入

然后调用Service层

写mapper层的映射文件

将查询的SQL语句写上

到此这个接口就算是写完了;

五、测试

我建议是拿Apifox来测试,自己拿网页测试也行;

先手动添加一些数据到数据库里去;

Apifox测试结果(没Apifox直接跳过)

网页测试

注:一定要先让项目保持运行状态

打开浏览器,访问接口路径:

http://localhost:8080/queryUserList

六、完整代码

UserController

package com.example.springboot.controller;import com.example.springboot.pojo.User;import com.example.springboot.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestControllerpublic class UserController {@AutowiredUserService userService;@GetMapping ("/queryUserList")public List<User> queryUserList(){return userService.queryUserList();}@GetMapping ("queryUserById")public User queryUserById(int user_id){return userService.queryUserById(user_id);}@GetMapping("/addUser")public String addUser(User user){return userService.addUser(user);}@GetMapping("/deleteUserById")public String deleteUserById(int id){return userService.deleteUserById(id);}}

UserMapper

package com.example.springboot.mapper;import com.example.springboot.pojo.User;import org.apache.ibatis.annotations.Mapper;import org.springframework.stereotype.Repository;import java.util.List;@Mapper@Repositorypublic interface UserMapper {List<User> queryUserList();User queryUserById(int id);void addUser(User user);void deleteUserById(int id);}

User

package com.example.springboot.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;@Data@NoArgsConstructor@AllArgsConstructorpublic class User {private String name;private int id;private String sex;}

UserService

package com.example.springboot.service;import com.example.springboot.mapper.UserMapper;import com.example.springboot.pojo.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;@Servicepublic class UserService {@AutowiredUserMapper userMapper;public List<User> queryUserList(){return userMapper.queryUserList();}public User queryUserById(int id){User user= userMapper.queryUserById(id);return user;}public String addUser(User user){userMapper.addUser(user);return "新增成功";}public String deleteUserById(int id){userMapper.deleteUserById(id);return "删除成功";}}

UserMapper.xml

<" />="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.example.springboot.mapper.UserMapper"><select id="queryUserList" resultType="User">select * from springboot.user</select><select id="queryUserById" resultType="User" parameterType="int">select * from springboot.user where id = #{id};</select><insert id="addUser">insert into springboot.user (name, id, sex) VALUES (#{name},#{id},#{sex})</insert><delete id="deleteUserById">delete from springboot.user where id=#{id}</delete></mapper>

application.properties

spring.datasource.username=rootspring.datasource.password=adminspring.datasource.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver#??mybatismybatis.type-aliases-package=com.example.springboot.pojomybatis.mapper-locations=classpath:mybatis/mapper/*.xmlserver.port=8080

pom.xml

<?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>springBoot</artifactId><version>0.0.1-SNAPSHOT</version><name>springBoot</name><description>springBoot</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><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.1</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>com.mysql</groupId><artifactId>mysql-connector-j</artifactId><scope>runtime</scope></dependency><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.springboot.Application</mainClass><skip>true</skip></configuration><executions><execution><id>repackage</id><goals><goal>repackage</goal></goals></execution></executions></plugin></plugins></build></project>