首先，我们需要创建一个
数据库，包含两个
表：部门
表（department）和员工
表（employee）。
建
表语句如下：
```
sql
CREATE DATABASE IF NOT EXISTS `company`;
USE `company`;
CREATE TABLE IF NOT EXISTS `department` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `employee` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`gender` char(1) NOT NULL,
`birthday` date NOT NULL,
`department_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `department_id` (`department_id`),
CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`department_id`) REFERENCES `department` (`id`)
);
```
然后，我们可以使用Spring Boot和Thymeleaf来实现部门
表和员工
表的
增删改查操作。
在Spring Boot中，我们可以使用JPA来
操作数据库，同时使用Thymeleaf来实现页面的渲染。
首先，我们需要在pom.xml文件中添加以下依赖：
```xml
<dependencies>
<!-- Spring Boot Web -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- Spring Data JPA -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- My
SQL JDBC Driver -->
<dependency>
<groupId>my
sql</groupId>
<artifactId>my
sql-connector-java</artifactId>
</dependency>
<!-- Thymeleaf -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
</dependencies>
```
然后，我们需要在application.properties文件中配置
数据库连接信息：
```
spring.datasource.url=jdbc:my
sql://localhost:3306/company
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.my
sql.jdbc.Driver
spring.jpa.show-
sql=true
spring.jpa.hibernate.
ddl-auto=update
spring.thymeleaf.cache=false
```
接下来，我们需要创建实体类Department和Employee，对应
数据库中的department和employee
表：
```java
@Entity
@Table(name = "department")
public class Department {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(name = "name")
private String name;
// getter and setter
}
@Entity
@Table(name = "employee")
public class Employee {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(name = "name")
private String name;
@Column(name = "gender")
private String gender;
@Column(name = "birthday")
private Date birthday;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "department_id")
private Department department;
// getter and setter
}
```
然后，我们需要创建DepartmentRepository和EmployeeRepository接口，继承JpaRepository接口，用于
操作数据库：
```java
public interface DepartmentRepository extends JpaRepository<Department, Long> {
}
public interface EmployeeRepository extends JpaRepository<Employee, Long> {
}
```
接下来，我们需要创建DepartmentController和EmployeeController类，用于处理请求和响应：
```java
@Controller
@RequestMapping("/department")
public class DepartmentController {
@Autowired
private DepartmentRepository departmentRepository;
@GetMapping("/list")
public String list(Model model) {
List<Department> departments = departmentRepository.findAll();
model.addAttribute("departments", departments);
return "department/list";
}
@GetMapping("/add")
public String add(Model model) {
Department department = new Department();
model.addAttribute("department", department);
return "department/form";
}
@PostMapping("/save")
public String save(@ModelAttribute("department") Department department) {
departmentRepository.save(department);
return "redirect:/department/list";
}
@GetMapping("/edit/{id}")
public String edit(@PathVariable("id") Long id, Model model) {
Department department = departmentRepository.findById(id)
.orElseThrow(() -> new IllegalArgumentException("Invalid department Id:" + id));
model.addAttribute("department", department);
return "department/form";
}
@GetMapping("/delete/{id}")
public String delete(@PathVariable("id") Long id) {
Department department = departmentRepository.findById(id)
.orElseThrow(() -> new IllegalArgumentException("Invalid department Id:" + id));
departmentRepository.delete(department);
return "redirect:/department/list";
}
}
@Controller
@RequestMapping("/employee")
public class EmployeeController {
@Autowired
private EmployeeRepository employeeRepository;
@Autowired
private DepartmentRepository departmentRepository;
@GetMapping("/list")
public String list(Model model) {
List<Employee> employees = employeeRepository.findAll();
model.addAttribute("employees", employees);
return "employee/list";
}
@GetMapping("/add")
public String add(Model model) {
Employee employee = new Employee();
List<Department> departments = departmentRepository.findAll();
model.addAttribute("employee", employee);
model.addAttribute("departments", departments);
return "employee/form";
}
@PostMapping("/save")
public String save(@ModelAttribute("employee") Employee employee) {
employeeRepository.save(employee);
return "redirect:/employee/list";
}
@GetMapping("/edit/{id}")
public String edit(@PathVariable("id") Long id, Model model) {
Employee employee = employeeRepository.findById(id)
.orElseThrow(() -> new IllegalArgumentException("Invalid employee Id:" + id));
List<Department> departments = departmentRepository.findAll();
model.addAttribute("employee", employee);
model.addAttribute("departments", departments);
return "employee/form";
}
@GetMapping("/delete/{id}")
public String delete(@PathVariable("id") Long id) {
Employee employee = employeeRepository.findById(id)
.orElseThrow(() -> new IllegalArgumentException("Invalid employee Id:" + id));
employeeRepository.delete(employee);
return "redirect:/employee/list";
}
}
```
最后，我们需要创建部门
表和员工
表的页面，使用Thymeleaf进行渲染：
```html
<!-- department/list.html -->
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Department List</title>
</head>
<body>
<h1>Department List</h1>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Action</th>
</tr>
<tr th:each="department : ${departments}">
<td th:text="${department.id}"></td>
<td th:text="${department.name}"></td>
<td>
<a th:href="@{/department/edit/{id}(id=${department.id})}">Edit</a>
<a th:href="@{/department/delete/{id}(id=${department.id})}">Delete</a>
</td>
</tr>
</table>
<a th:href="@{/department/add}">Add Department</a>
</body>
</html>
<!-- department/form.html -->
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Add Department</title>
</head>
<body>
<h1>Add Department</h1>
<form action="/department/save" method="post">
<input type="hidden" th:field="*{id}">
<label for="name">Name:</label>
<input type="text" id="name" th:field="*{name}">
<input type="submit" value="Save">
</form>
<a th:href="@{/department/list}">Back to List</a>
</body>
</html>
<!-- employee/list.html -->
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Employee List</title>
</head>
<body>
<h1>Employee List</h1>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Birthday</th>
<th>Department</th>
<th>Action</th>
</tr>
<tr th:each="employee : ${employees}">
<td th:text="${employee.id}"></td>
<td th:text="${employee.name}"></td>
<td th:text="${employee.gender}"></td>
<td th:text="${#dates.format(employee.birthday, 'yyyy-MM-dd')}"></td>
<td th:text="${employee.department.name}"></td>
<td>
<a th:href="@{/employee/edit/{id}(id=${employee.id})}">Edit</a>
<a th:href="@{/employee/delete/{id}(id=${employee.id})}">Delete</a>
</td>
</tr>
</table>
<a th:href="@{/employee/add}">Add Employee</a>
</body>
</html>
<!-- employee/form.html -->
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Add Employee</title>
</head>
<body>
<h1>Add Employee</h1>
<form action="/employee/save" method="post">
<input type="hidden" th:field="*{id}">
<label for="name">Name:</label>
<input type="text" id="name" th:field="*{name}">
<br>
<label for="gender">Gender:</label>
<input type="text" id="gender" th:field="*{gender}">
<br>
<label for="birthday">Birthday:</label>
<input type="date" id="birthday" th:field="*{birthday}">
<br>
<label for="department">Department:</label>
<select id="department" th:field="*{department}">
<option th:each="department : ${departments}" th:value="${department}" th:text="${department.name}" th:selected="${employee.department == department}"></option>
</select>
<br>
<input type="submit" value="Save">
</form>
<a th:href="@{/employee/list}">Back to List</a>
</body>
</html>
```
至此，我们就完成了使用Spring Boot和Thymeleaf实现部门
表和员工
表的
增删改查操作。
430
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
