使用SpringWeb+Thymeleaf完成web项目备忘录的编写,使用MVC三层架构,功能有首页为备忘录列表,点击添加跳转到添加页面,添加完成后返回到列表页面并显示出来,列表页面中包括删除和修改操作,全部代码
时间: 2024-05-01 12:22:34 浏览: 147
很抱歉,我无法为您提供全部代码。但是,我可以为您提供一个大致的框架和代码片段。
1. 首先,我们需要创建一个Maven项目,并添加所需的依赖项。
```
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>runtime</scope>
</dependency>
```
2. 接下来,我们需要定义一个数据模型类 Memo。
```
public class Memo {
private int id;
private String title;
private String content;
private Date createTime;
// 省略 getter 和 setter 方法
}
```
3. 然后,我们需要定义一个数据访问层 MemoRepository。
```
@Repository
public class MemoRepository {
@Autowired
private JdbcTemplate jdbcTemplate;
public List<Memo> findAll() {
String sql = "SELECT id, title, content, create_time FROM memo ORDER BY create_time DESC";
return jdbcTemplate.query(sql, new MemoRowMapper());
}
public Memo findById(int id) {
String sql = "SELECT id, title, content, create_time FROM memo WHERE id = ?";
return jdbcTemplate.queryForObject(sql, new Object[]{id}, new MemoRowMapper());
}
public void save(Memo memo) {
String sql = "INSERT INTO memo (title, content, create_time) VALUES (?, ?, ?)";
jdbcTemplate.update(sql, memo.getTitle(), memo.getContent(), memo.getCreateTime());
}
public void update(Memo memo) {
String sql = "UPDATE memo SET title = ?, content = ? WHERE id = ?";
jdbcTemplate.update(sql, memo.getTitle(), memo.getContent(), memo.getId());
}
public void delete(int id) {
String sql = "DELETE FROM memo WHERE id = ?";
jdbcTemplate.update(sql, id);
}
}
class MemoRowMapper implements RowMapper<Memo> {
@Override
public Memo mapRow(ResultSet rs, int rowNum) throws SQLException {
Memo memo = new Memo();
memo.setId(rs.getInt("id"));
memo.setTitle(rs.getString("title"));
memo.setContent(rs.getString("content"));
memo.setCreateTime(rs.getDate("create_time"));
return memo;
}
}
```
4. 然后,我们需要定义一个业务逻辑层 MemoService。
```
@Service
public class MemoService {
@Autowired
private MemoRepository memoRepository;
public List<Memo> findAll() {
return memoRepository.findAll();
}
public Memo findById(int id) {
return memoRepository.findById(id);
}
public void save(Memo memo) {
memoRepository.save(memo);
}
public void update(Memo memo) {
memoRepository.update(memo);
}
public void delete(int id) {
memoRepository.delete(id);
}
}
```
5. 接下来,我们需要定义一个控制器层 MemoController。
```
@Controller
public class MemoController {
@Autowired
private MemoService memoService;
@GetMapping("/")
public String index(Model model) {
List<Memo> memos = memoService.findAll();
model.addAttribute("memos", memos);
return "index";
}
@GetMapping("/add")
public String add(Model model) {
model.addAttribute("memo", new Memo());
return "add";
}
@PostMapping("/save")
public String save(@ModelAttribute Memo memo) {
memo.setCreateTime(new Date());
memoService.save(memo);
return "redirect:/";
}
@GetMapping("/edit/{id}")
public String edit(@PathVariable int id, Model model) {
Memo memo = memoService.findById(id);
model.addAttribute("memo", memo);
return "edit";
}
@PostMapping("/update")
public String update(@ModelAttribute Memo memo) {
memoService.update(memo);
return "redirect:/";
}
@GetMapping("/delete/{id}")
public String delete(@PathVariable int id) {
memoService.delete(id);
return "redirect:/";
}
}
```
6. 最后,我们需要定义 Thymeleaf 模板页面。
index.html
```
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Memo List</title>
</head>
<body>
<h1>Memo List</h1>
<table>
<thead>
<tr>
<th>Title</th>
<th>Create Time</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<tr th:each="memo : ${memos}">
<td th:text="${memo.title}"></td>
<td th:text="${memo.createTime}"></td>
<td>
<a th:href="@{/edit/{id}(id=${memo.id})}">Edit</a>
<a th:href="@{/delete/{id}(id=${memo.id})}">Delete</a>
</td>
</tr>
</tbody>
</table>
<a href="/add">Add Memo</a>
</body>
</html>
```
add.html
```
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Add Memo</title>
</head>
<body>
<h1>Add Memo</h1>
<form method="post" th:action="@{/save}">
<div>
<label for="title">Title:</label>
<input type="text" id="title" name="title" required th:field="*{title}">
</div>
<div>
<label for="content">Content:</label>
<textarea id="content" name="content" required th:field="*{content}"></textarea>
</div>
<div>
<button type="submit">Save</button>
<a href="/">Cancel</a>
</div>
</form>
</body>
</html>
```
edit.html
```
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Edit Memo</title>
</head>
<body>
<h1>Edit Memo</h1>
<form method="post" th:action="@{/update}">
<input type="hidden" name="id" th:value="${memo.id}">
<div>
<label for="title">Title:</label>
<input type="text" id="title" name="title" required th:value="${memo.title}">
</div>
<div>
<label for="content">Content:</label>
<textarea id="content" name="content" required th:text="${memo.content}"></textarea>
</div>
<div>
<button type="submit">Save</button>
<a href="/">Cancel</a>
</div>
</form>
</body>
</html>
```
注意:上述代码片段仅供参考,具体实现可能因项目需求而异。另外,此项目使用了内存数据库 H2,如果需要使用其他数据库,请自行修改配置。
阅读全文