springcloud微服务实现增删改查

最新推荐文章于 2023-12-17 20:53:36 发布

努力前行的小coder

最新推荐文章于 2023-12-17 20:53:36 发布

阅读量1.1w

点赞数 7

CC 4.0 BY-SA版权

分类专栏： springcloud学习文章标签：微服务 springcloud实现增删改查

本文链接：https://blog.youkuaiyun.com/FindHuni/article/details/85049506

springcloud学习专栏收录该内容

23 篇文章

订阅专栏

本文介绍如何使用Spring Boot结合JPA在微服务架构中实现数据的增删改查操作，通过纯注解方式简化开发流程，提供了一个具体的项目实例包括pom.xml配置、实体类定义、DAO层、Service层及Controller层的实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

随着微服务的出现，我们开发的效率比之前也快了很多，相比传统的开发模式，微服务提供的更加便捷，使我们开发人员开发速度有了很大的提高，为此我相比之前写的结合springcloud结合mybati实现增删改查。这一次写了一个纯注解方式来实现简单的增删改查。

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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.7.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.csq.study</groupId>
    <artifactId>study</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>study</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>


    <repositories>
        <repository>
            <id>spring-snapshots</id>
            <name>SpringSnapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <snapshots>
                <enabled>true</enabled>
            </snapshots>
        </repository>
        <repository>
            <id>spring-milestones</id>
            <name>SpringMilestones</name>
            <url>https://repo.spring.io/milestone</url>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </repository>
    </repositories>

    <pluginRepositories>
        <pluginRepository>
            <id>spring-snapshots</id>
            <name>SpringSnapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <snapshots>
                <enabled>true</enabled>
            </snapshots>
        </pluginRepository>
        <pluginRepository>
            <id>spring-milestones</id>
            <name>SpringMilestones</name>
            <url>https://repo.spring.io/milestone</url>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </pluginRepository>
    </pluginRepositories>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

建表脚本：

DROP DATABASE IF EXISTS "user" ;
CREATE TABLE `user` (
  `id` INT(11) DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `age` INT(11) DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', '张三', '22'), ('2', '李四', '23'),('3', '王五', '22'), ('4', '赵六', '23');

User对象

package com.csq.study;
 

@Entity
@Table(name="user")
public class User {
 
	
	@Id
	int id;
	String name;
	int age;
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
	
 
}

Result 返回结果对象

public class Result {
	private boolean flag;//是否成功
	private Integer code;// 返回码
	private String message;//返回信息
	private Object data;// 返回数据
set/get ... 构造方法  略 
}

StatusCode 响应状态

public class StatusCode {
	public static final int OK=20000;//成功
	public static final int ERROR =20001;//失败
	public static final int LOGINERROR =20002;//用户名或密码错误
	public static final int ACCESSERROR =20003;//权限不足
	public static final int REMOTEERROR =20004;//远程调用失败
	public static final int REPERROR =20005;//重复操作
}

utils 中的id生成工具类：

Dao

dao
/**
 * JpaRepository提供了基本的增删改查
   JpaSpecificationExecutor用于做复杂的条件查询
 * @author HUNI
 */
public interface UserDao extends JpaRepository<User, Integer>,
    JpaSpecificationExecutor<User>{
}

service层



@Service
public class UserService {
    @Autowired
    UserDao userDao;


    /**
     * 查询全部
     *
     * @return
     */
    public List<User> findAll() {
        return userDao.findAll();
    }

    /**
     * 根据Id查询
     *
     * @param id
     * @return
     */
    public User findById(Integer id) {
        return userDao.findById(id).get();
    }

    /**
     * 增加标签
     *
     * @param user
     */
    public void add(User user) {
        user.setId(UUID.randomUUID().hashCode());
        userDao.save(user);
    }

    /**
     * 更新标签
     *
     * @param user
     */
    public void update(User user) {

        userDao.save(user);
    }

    /**
     * 删除标签
     *
     * @param id
     */
    public void deteleById(Integer id) {
        userDao.deleteById(id);
    }
}

controller



@RestController
@RequestMapping("user")
public class UserController {
    @Autowired
    private UserService userService;



    @RequestMapping(method= RequestMethod.GET)
    public Result findAll(){
        Result result = new Result(true, StatusCode.OK,"查询成功", userService.findAll());
        return result;
    }

    @RequestMapping(value="/{id}", method=RequestMethod.GET)
    public Result findById(@PathVariable Integer id){
        Result result = new Result(true,StatusCode.OK,"查询成功",  userService.findById(id));
        return result;
    }

    @RequestMapping(method=RequestMethod.POST)
    public Result add(@RequestBody User user){
        userService.add(user);
        Result result = new Result(true,StatusCode.OK,"添加成功");
        return result;
    }

    @RequestMapping(value="/{id}",method=RequestMethod.PUT)
    public Result update(@RequestBody  User user,@PathVariable Integer id){
        user.setId(id);
        userService.update(user);
        Result result = new Result(true,StatusCode.OK,"修改成功");
        return result;
    }

    @RequestMapping(value="/{id}", method=RequestMethod.DELETE)
    public Result deleteById(@PathVariable Integer id){
        userService.deteleById(id);
        Result result = new Result(true,StatusCode.OK,"删除成功");
        return result;
    }
}

快速启动类

@SpringBootApplication
public class BaseApplication {
	public static void main(String[] args) {
		SpringApplication.run(BaseApplication.class, args);
	}


}

配置文件application.yml

server:
 port: 9001  #服务端口
 datasource:
   driverClassName: com.mysql.jdbc.Driver
   url: jdbc:mysql://localhost:3306/user?Unicode=true&characterEncoding=utf-8  #连接额数据库 
   username: root   #数据库用户
   password: root  #数据库密码
 jpa:
   database: mysql 
   show‐sql: true
   generate‐ddl: true

使用postman测试结果，看是否正确

此处就不贴测试结果了，大家自己测试看看你写的是否可以跑的通。

测试结果: