Springboot + Thymeleaf_springboot+thymeleaf项目-CSDN博客

本文链接：https://blog.csdn.net/tiaopimao3185/article/details/130787370

工程结构
在这里插入图片描述

maven依赖

<!-- Spring Boot Starter -->
<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <!-- Spring Boot Starter Thymeleaf -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-thymeleaf</artifactId>
    </dependency>

    <!-- Spring Boot Starter Data JPA -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>

    <!-- MySQL Connector -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

    <!-- HikariCP (连接池) -->
    <dependency>
        <groupId>com.zaxxer</groupId>
        <artifactId>HikariCP</artifactId>
    </dependency>
</dependencies>

数据库配置

# 数据库连接配置
spring.datasource.url=jdbc:mysql://localhost/数据库名称?useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

# JPA配置
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

pojo

import javax.persistence.*;

@Entity
@Table(name = "member")
public class Member {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String username;
    private Integer age;
    private String gender;

    // Getters and Setters
    // ...
}

index.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Member Management</title>
</head>
<body>
<h2>Member Management</h2>

<!-- 显示成员列表 -->
<table>
    <tr>
        <th>ID</th>
        <th>Username</th>
        <th>Age</th>
        <th>Gender</th>
        <th></th>
        <th></th>
    </tr>
    <tr th:each="member : ${members}">
        <td th:text="${member.id}"></td>
        <td th:text="${member.username}"></td>
        <td th:text="${member.age}"></td>
        <td th:text="${member.gender}"></td>
        <td><a th:href="@{/edit/{id}(id=${member.id})}">Edit</a></td>
        <td><a th:href="@{/delete/{id}(id=${member.id})}">Delete</a></td>
    </tr>
</table>

<hr>

<!-- 添加或编辑成员表单 -->
<form th:object="${member}" th:action="@{/save}" method="post">
    <input type="hidden" th:field="*{id}">

    <label for="username">Username:</label>
    <input type="text" id="username" th:field="*{username}" required>

    <label for="age">Age:</label>
    <input type="number" id="age" th:field="*{age}" required>

    <label for="gender">Gender:</label>
    <select id="gender" th:field="*{gender}" required>
        <option value="MALE">Male</option>
        <option value="FEMALE">Female</option>
    </select>

    <button type="submit">Save</button>
</form>
</body>
</html>

service

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface MemberRepository extends JpaRepository<Member, Long> {
}

controller

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;

@Controller
public class MemberController {
    @Autowired
    private MemberRepository memberRepository;

    // 显示成员列表
    @GetMapping("/")
    public String showMemberList(Model model) {
        model.addAttribute("members", memberRepository.findAll());
        return "index";
    }

    // 处理添加/编辑成员的表单提交
    @PostMapping("/save")
    public String saveMember(@ModelAttribute Member member) {
        memberRepository.save(member);
        return "redirect:/";
    }

    // 编辑成员
    @GetMapping("/edit/{id}")
    public String showEditForm(@PathVariable("id") Long id, Model model) {
        Member member = memberRepository.findById(id)
                .orElseThrow(() -> new IllegalArgumentException("Invalid member ID: " + id));
        model.addAttribute("member", member);
        return "index";
    }

    // 删除成员
    @GetMapping("/delete/{id}")
    public String deleteMember(@PathVariable("id") Long id) {
        memberRepository.deleteById(id);
        return "redirect:/";
    }

    // 添加下面这个方法
    @ModelAttribute("member")
    public Member getMember() {
        return new Member();
    }
}