从入门到入门-Spring Boot-CRUD+Transactional

最新推荐文章于 2025-06-02 16:23:14 发布

Andy2019

最新推荐文章于 2025-06-02 16:23:14 发布

阅读量532

点赞数

CC 4.0 BY-SA版权

分类专栏： Spring Boot

本文链接：https://blog.youkuaiyun.com/Andy2019/article/details/77036921

Spring Boot 专栏收录该内容

25 篇文章

订阅专栏

本文介绍了一个使用Spring Boot结合JPA实现的简单应用案例，包括pom.xml配置文件中添加Mysql和JPA依赖的方法，以及如何在application.yml中配置数据库连接信息等内容。

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

pom.xml 主要添加Mysql和JPA依赖

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.example</groupId>
	<artifactId>sbd</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>sbd</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.6.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<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>
		</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>

application.yml 配置数据库连接信息和TOMCAT端口

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test
    username: root
    password: 123456
  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
server:
  port: 8888

SbdApplication.java SpringBoot 启动类

package com.example.sbd;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class SbdApplication {

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

UserController.java 控制器，主要用于请求跳转

package com.example.sbd.controller;

import com.example.sbd.dao.UserRespository;
import com.example.sbd.entity.User;
import com.example.sbd.service.UserService;
import com.example.sbd.vo.UserVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * 在用POSTMAN时
 * PUT 方式 提交参数要用"x-www-form-urlencoded"
 * POST方式 提交参数要用form-data
 *
 * JSON方式 参数用@RequestBody
 */
@RestController
public class UserController {


    @Autowired
    private UserService userService;

    /**
     * 查询所有用户列表
     * @return
     */
    @GetMapping(value = "/users")
    public List<User> UserList(){
        return userService.findAll();
    }

    /**
     * 添加一个用户

     * 注意是POST提交 (FORM表单提交)
     * @param name
     * @param age
     * @return
     */
    @PostMapping(value = "/users")
    public User UserAdd(@RequestParam("name") String name, @RequestParam("age") Integer age){
        UserVO user = new UserVO();
        user.setName(name);
        user.setAge(age);
        return userService.addUser(user);
    }

    /**
     * 添加一个用户(使用JSON方式传递参数)
     * @param uservo
     * @return
     */
    @PostMapping(value = "/usersJson")
    public User UserAdd2(@RequestBody UserVO uservo){
        return userService.addUser(uservo);
    }

    /**
     * 查询一个用户
     * @param id
     * @return
     */
    @GetMapping(value = "/users/{id}")
    public User UserFindOne(@PathVariable("id") Integer id){
        return userService.findUser(id);
    }
    /**
     * 更新用户信息
     *
     */
    @PutMapping(value = "/users/{id}")
    public User UserUpdate(@PathVariable("id") Integer id,@RequestParam("name") String name, @RequestParam("age") Integer age){
        UserVO userVO = new UserVO();
        userVO.setId(id);
        userVO.setAge(age);
        userVO.setName(name);
       return userService.updateUser(userVO);
    }

    /**
     * 删除一个用户
     */
    @DeleteMapping(value = "/users/{id}")
    public void UserDelete(@PathVariable("id") Integer id){
        userService.deleteUser(id);
    }

    /**
     * 通过年龄查询用户
     */
    @GetMapping(value = "/users/age/{age}")
    public List<User> UserListByAge(@PathVariable("age") Integer age){
        return userService.findByAge(age);
    }

    @PostMapping(value = "/users/two")
    public void UserTwo(){
        userService.insertTwo();
    }
}

UserService Service类，主要用于业务逻辑处理

package com.example.sbd.service;

import com.example.sbd.dao.UserRespository;
import com.example.sbd.entity.User;
import com.example.sbd.vo.UserVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.transaction.Transactional;
import java.util.List;

@Service
public class UserService {

    @Autowired
    private UserRespository userRespository;


    public List<User> findAll(){
        return userRespository.findAll();
    }

    public User addUser(UserVO userVO){
        User user = new User();
        user.setAge(userVO.getAge());
        user.setName(userVO.getName());
        return userRespository.save(user);
    }

    public User findUser(Integer id){
        return userRespository.findOne(id);
    }

    public User updateUser(UserVO userVO){
        User user = new User();
        user.setId(userVO.getId());
        user.setName(userVO.getName());
        user.setAge(userVO.getAge());
        return userRespository.save(user);
    }

    public void deleteUser(Integer id){
        userRespository.delete(id);
    }
    public List<User> findByAge(Integer age){
        return userRespository.findByAge(age);
    }
    @Transactional
    public void insertTwo(){
        User userA = new User();
        userA.setName("JERRY");
        userA.setAge(9);
        userRespository.save(userA);

        User userB = new User();
        userB.setName("TOM");
        userB.setAge(18);
        userRespository.save(userB);
    }
}

UserRespository 主要用户数据库操作

package com.example.sbd.dao;


import com.example.sbd.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface UserRespository extends JpaRepository<User,Integer> {

    //通过年龄查询
    List<User> findByAge(Integer age);
}

User entity类，用于生成表结构

package com.example.sbd.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

@Entity
public class User {
    @Id
    @GeneratedValue
    private Integer id;
    private String name;
    private Integer age;

    public User(){

    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

UserVO 用于接收前端或HTTP传递参数

package com.example.sbd.vo;

public class UserVO {
    private Integer id;
    private String name;
    private Integer age;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }
}

恭喜你，编码结束！！！！！！！！！

最后使用POSTMAN工具进行测试，不会POSTMAN工具使用的，请自行学习！！！！！！！！

如果实在不想COPY代码、或自己敲代码，源码下载地址http://download.youkuaiyun.com/download/andy2019/9927433

关于注解使用参看http://www.cnblogs.com/qq78292959/p/3760702.html