基于Springboot实现对分类、标签的增删改查
Springboot实现自动生成数据库表、登录注销以及分类展示
源码已上传至Github:项目源码
一、对分类的增删改查
对分类的查询在上一篇文章里面已经完成了,下面主要是完成增删改功能
(一)增加分类与编辑分类
这次的增加与修改一起实现了,通过前端页面传来的id,判断是对分类添加还是编辑,如果id=-1,则为添加,如果不为-1则为编辑
TypeController.java部分代码
@GetMapping("input/{id}")
public String input(@PathVariable Long id,Model model){
Type type=null;
if(id!=-1){
type= typeService.findTypeById(id);
}else {
type=new Type();
}
model.addAttribute("type",type);
return "admin/types-input";
}
@PostMapping("input")
public String input(Type type){
typeService.input(type);
return "redirect:/admin/types";
}
TypeService.java及TypeServiceImpl.java部分代码
Type findTypeById(Long id);
void input(Type type);
@Override
public Type findTypeById(Long id) {
return typeDao.getOne(id);
}
@Override
public void input(Type type) {
typeDao.save(type);
}
(二)删除分类
通过从前端页面传来的分类Id删除数据库中的数据
TypeController.java部分代码
```java
@RequestMapping("delete/{id}")
public String delete(@PathVariable Long id){
typeService.deleteById(id);
return "redirect:/admin/types";
}
TypeService.java及TypeServiceImpl.java部分代码
void deleteById(Long id);
@Override
public void deleteById(Long id) {
typeDao.deleteById(id);
}
具体实现代码如下:
TypeController.java
package com.wzx.controller;
import com.wzx.po.Type;
import com.wzx.service.TypeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.web.PageableDefault;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping("/admin/types")
public class TypeController {
@Autowired
private TypeService typeService;
@RequestMapping
public String list(@PageableDefault(size = 5,sort = {"id"},direction = Sort.Direction.DESC) Pageable pageable, Model model){
Page<Type> page=typeService.listType(pageable);
model.addAttribute("page",page);
return "admin/types";
}
@RequestMapping("delete/{id}")
public String delete(@PathVariable Long id){
typeService.deleteById(id);
return "redirect:/admin/types";
}
@GetMapping("input/{id}")
public String input(@PathVariable Long id,Model model){
Type type=null;
if(id!=-1){
type= typeService.findTypeById(id);
}else {
type=new Type();
}
model.addAttribute("type",type);
return "admin/types-input";
}
@PostMapping("input")
public String input(Type type){
typeService.input(type);
return "redirect:/admin/types";
}
}
TypeService.java
package com.wzx.service;
import com.wzx.po.Type;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import java.util.List;
import java.util.Optional;
public interface TypeService {
Page<Type> listType(Pageable pageable);
void deleteById(Long id);
Type findTypeById(Long id);
void input(Type type);
List<Type> listType();
List<Type> findTop(int i);
}
TypeServiceImpl.java
package com.wzx.service.impl;
import com.wzx.dao.TypeDao;
import com.wzx.po.Type;
import com.wzx.service.TypeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.stereotype.Service;
import java.util.List;
import java.util.Optional;
@Service
public class TypeServiceImpl implements TypeService {
@Autowired
private TypeDao typeDao;
@Override
public Page<Type> listType(Pageable pageable) {
return typeDao.findAll(pageable);
}
@Override
public void deleteById(Long id) {
typeDao.deleteById(id);
}
@Override
public Type findTypeById(Long id) {
return typeDao.getOne(id);
}
@Override
public void input(Type type) {
typeDao.save(type);
}
@Override
public List<Type> listType() {
return typeDao.findAll();
}
@Override
public List<Type> findTop(int i) {
Sort sort= Sort.by(Sort.Direction.DESC,"newsList.size");
Pageable pageable = PageRequest.of(0, i, sort);
return typeDao.findTop(pageable);
}
}
TypeDao.java
package com.wzx.dao;
import com.wzx.po.Type;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import java.util.List;
public interface TypeDao extends JpaRepository<Type,Long> {
@Query("select t from Type t")
List<Type> findTop(Pageable pageable);
}
types-input.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head th:replace="admin/_fragments :: head(~{::title})">
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>分类新增</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/semantic-ui/2.2.4/semantic.min.css">
<link rel="stylesheet" href="../../static/lib/editormd/css/editormd.min.css">
<link rel="stylesheet" href="../../static/css/me.css">
</head>
<body>
<!--导航-->
<nav th:replace="admin/_fragments :: menu(2)" class="ui inverted attached segment m-padded-tb-mini m-shadow-small" >
<div class="ui container">
<div class="ui inverted secondary stackable menu">
<h2 class="ui teal header item">管理后台</h2>
<a href="#" class="active m-item item m-mobile-hide">新闻</a>
<a href="#" class=" m-item item m-mobile-hide">分类</a>
<a href="#" class="m-item item m-mobile-hide">标签</a>
<div class="right m-item m-mobile-hide menu">
<div class="ui dropdown item">
<div class="text">
<img class="ui avatar image" src="../static/images/wechat.jpg">
hualili
</div>
<i class="dropdown icon"></i>
<div class="menu">
<a href="#" class="item">注销</a>
</div>
</div>
</div>
</div>
</div>
<a href="#" class="ui menu toggle black icon button m-right-top m-mobile-show">
<i class="sidebar icon"></i>
</a>
</nav>
<div class="ui attached pointing menu">
<div class="ui container">
<div class="right menu">
<a href="#" th:href="@{/admin/types/input}" class="active item">新增</a>
<a href="#" th:href="@{/admin/types}" class="teal item">列表</a>
</div>
</div>
</div>
<!--中间内容-->
<div class="m-container-small m-padded-tb-big">
<div class="ui container">
<form action="#" method="post" th:object="${type}" th:action="@{/admin/types/input}" class="ui form">
<input type="hidden" name="id" th:value="*{id}">
<div class=" field">
<div class="ui left labeled input">
<label class="ui teal basic label">名称</label>
<input type="text" name="name" placeholder="分类名称" th:value="*{name}" >
</div>
</div>
<div class="ui error message"></div>
<div class="ui right aligned container">
<button type="button" class="ui button" onclick="window.history.go(-1)" >返回</button>
<button class="ui teal submit button">提交</button>
</div>
</form>
</div>
</div>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<!--底部footer-->
<footer th:replace="admin/_fragments :: footer" class="ui inverted vertical segment m-padded-tb-massive">
<div class="ui center aligned container">
<div class="ui inverted divided stackable grid">
<div class="three wide column">
<div class="ui inverted link list">
<div class="item">
<img src="../../static/images/wechat.jpg" class="ui rounded image" alt="" style="width: 110px">
</div>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced " >最新新闻</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">联系我</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">Email:liuhuali@163.com</a>
<a href="#" class="item m-text-thin">QQ:liuhuali</a>
</div>
</div>
<div class="seven wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">news</h4>
<p class="m-text-thin m-text-spaced m-opacity-mini">消息即狭义的新闻,它是对新近发生的有社会意义并引起公众兴趣的事实的简短报道。因此,真实性、时效性及文字少、篇幅小成为消息的基本特征...</p>
</div>
</div>
<div class="ui inverted section divider"></div>
<p class="m-text-thin m-text-spaced m-opacity-tiny">Copyright © 2016 - 2017 liuhuali Designed by liuhuali</p>
</div>
</footer>
<script src="https://cdn.jsdelivr.net/npm/jquery@3.2/dist/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/semantic-ui/2.2.4/semantic.min.js"></script>
<script src="../../static/lib/editormd/editormd.min.js" th:src="@{/lib/editormd/editormd.min.js}"></script>
<script>
$('.menu.toggle').click(function () {
$('.m-item').toggleClass('m-mobile-hide');
});
$('.ui.dropdown').dropdown({
on : 'hover'
});
$('.ui.form').form({
fields : {
title : {
identifier: 'name',
rules: [{
type : 'empty',
prompt: '请输入分类名称'
}]
}
}
});
</script>
</body>
</html>
二、对标签的增删改查
与对分类的增删改查类似
(一)在controller中新建TagController.java
package com.wzx.controller;
import com.wzx.po.Tag;
import com.wzx.po.Type;
import com.wzx.service.TagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.web.PageableDefault;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping("/admin/tags")
public class TagController {
@Autowired
private TagService tagService;
@RequestMapping
public String list(@PageableDefault(size = 5,sort = {"id"},direction = Sort.Direction.DESC) Pageable pageable, Model model){
Page<Tag> page=tagService.listTag(pageable);
model.addAttribute("page",page);
return "admin/tags";
}
@GetMapping("{id}/delete")
public String delete(@PathVariable Long id){
tagService.deleteById(id);
return "redirect:/admin/tags";
}
@GetMapping("input/{id}")
public String toInput(@PathVariable Long id,Model model){
Tag tag=null;
if(id!=-1){
tag= tagService.findTagById(id);
}else {
tag=new Tag();
}
model.addAttribute("tag",tag);
return "admin/tags-input";
}
@PostMapping("input")
public String input(Tag tag){
tagService.input(tag);
return "redirect:/admin/tags";
}
}
(二)在service中新建TagService和TagServiceImpl
TagService.java
package com.wzx.service;
import com.wzx.po.Tag;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import java.util.List;
public interface TagService {
Page<Tag> listTag(Pageable pageable);
void deleteById(Long id);
Tag findTagById(Long id);
void input(Tag tag);
List<Tag> listTag();
List<Tag> findTagByTagId(String tagIds);
String getTagIds(List<Tag> tags);
}
TagServiceImpl.java
package com.wzx.service.impl;
import com.wzx.dao.TagDao;
import com.wzx.po.Tag;
import com.wzx.service.TagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;
import java.util.ArrayList;
import java.util.List;
@Service
public class TagServiceImpl implements TagService {
@Autowired
private TagDao tagDao;
@Override
public Page<Tag> listTag(Pageable pageable) {
return tagDao.findAll(pageable);
}
@Override
public void deleteById(Long id) {
tagDao.deleteById(id);
}
@Override
public Tag findTagById(Long id) {
return tagDao.getOne(id);
}
@Override
public void input(Tag tag) {
tagDao.save(tag);
}
@Override
public List<Tag> listTag() {
return tagDao.findAll();
}
@Override
public List<Tag> findTagByTagId(String tagIds) {
List<Long> ids=new ArrayList<>();
if(!StringUtils.isEmpty(tagIds)){
String[] str=tagIds.split(",");
for(String s:str){
if(!StringUtils.isEmpty(s)){
ids.add(new Long(s));
}
}
}
return tagDao.findAllById(ids);
}
@Override
public String getTagIds(List<Tag> tags) {
StringBuffer ids=new StringBuffer();
if(!tags.isEmpty()){
boolean flag=false;
for(Tag t:tags){
if(flag){
ids.append(",");
ids.append(t.getId());
}else {
ids.append(t.getId());
flag=true;
}
}
}
return ids.toString();
}
}
(三)在dao 包中新建TagDao继承JapRepository
TagDao.java
package com.wzx.dao;
import com.wzx.po.Tag;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import java.util.List;
public interface TagDao extends JpaRepository<Tag,Long> {
}
(四)前端页面
tags.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head th:replace="admin/_fragments :: head(~{::title})">
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>标签管理</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/semantic-ui/2.2.4/semantic.min.css">
<link rel="stylesheet" href="../../static/css/me.css">
</head>
<body>
<!--导航-->
<nav th:replace="admin/_fragments :: menu(3)" class="ui inverted attached segment m-padded-tb-mini m-shadow-small" >
<div class="ui container">
<div class="ui inverted secondary stackable menu">
<h2 class="ui teal header item">管理后台</h2>
<a href="#" class="active m-item item m-mobile-hide">新闻</a>
<a href="#" class=" m-item item m-mobile-hide">分类</a>
<a href="#" class="m-item item m-mobile-hide">标签</a>
<div class="right m-item m-mobile-hide menu">
<div class="ui dropdown item">
<div class="text">
<img class="ui avatar image" src="../static/images/wechat.jpg">
hualili
</div>
<i class="dropdown icon"></i>
<div class="menu">
<a href="#" class="item">注销</a>
</div>
</div>
</div>
</div>
</div>
<a href="#" class="ui menu toggle black icon button m-right-top m-mobile-show">
<i class="sidebar icon"></i>
</a>
</nav>
<div class="ui attached pointing menu">
<div class="ui container">
<div class="right menu">
<a href="#" class="item">新增</a>
<a href="#" class="teal active item">列表</a>
</div>
</div>
</div>
<!--中间内容-->
<div class="m-container-small m-padded-tb-big">
<div class="ui container">
<div class="ui success message" th:unless="${#strings.isEmpty(message)}">
<i class="close icon"></i>
<div class="header">提示:</div>
<p th:text="${message}">恭喜,操作成功!</p>
</div>
<table class="ui compact teal table">
<thead>
<tr>
<th></th>
<th>名称</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<tr th:each="type,iterStat : ${page.content}">
<td th:text="${iterStat.count}">1</td>
<td th:text="${type.name}">刻意练习清单</td>
<td>
<a href="#" th:href="@{/admin/tags/input/{id}(id=${type.id})}" class="ui mini teal basic button">编辑</a>
<a href="#" th:href="@{/admin/tags/{id}/delete(id=${type.id})}" class="ui mini red basic button">删除</a>
</td>
</tr>
</tbody>
<tfoot>
<tr>
<th colspan="6" >
<div class="ui mini pagination menu" th:if="${page.totalPages}>1" >
<a class=" item" th:href="@{/admin/tags(page=${page.number}-1)}" th:unless="${page.first}">上一页</a>
<a class=" item" th:href="@{/admin/tags(page=${page.number}+1)}" th:unless="${page.last}">下一页</a>
</div>
<a href="#" th:href="@{/admin/tags/input/{id}(id=-1)}" class="ui mini right floated teal basic button">新增</a>
</th>
</tr>
</tfoot>
</table>
</div>
</div>
<br>
<br>
<!--底部footer-->
<footer th:replace="admin/_fragments :: footer" class="ui inverted vertical segment m-padded-tb-massive">
<div class="ui center aligned container">
<div class="ui inverted divided stackable grid">
<div class="three wide column">
<div class="ui inverted link list">
<div class="item">
<img src="../../static/images/wechat.jpg" class="ui rounded image" alt="" style="width: 110px">
</div>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced " >最新新闻</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">联系我</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">Email:liuhuali@163.com</a>
<a href="#" class="item m-text-thin">QQ:liuhuali</a>
</div>
</div>
<div class="seven wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">news</h4>
<p class="m-text-thin m-text-spaced m-opacity-mini">消息即狭义的新闻,它是对新近发生的有社会意义并引起公众兴趣的事实的简短报道。因此,真实性、时效性及文字少、篇幅小成为消息的基本特征。...</p>
</div>
</div>
<div class="ui inverted section divider"></div>
<p class="m-text-thin m-text-spaced m-opacity-tiny">Copyright © 2016 - 2017 liuhuali Designed by liuhuali</p>
</div>
</footer>
<script src="https://cdn.jsdelivr.net/npm/jquery@3.2/dist/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/semantic-ui/2.2.4/semantic.min.js"></script>
<script src="../../static/lib/editormd/editormd.min.js" th:src="@{/lib/editormd/editormd.min.js}"></script>
<script>
$('.menu.toggle').click(function () {
$('.m-item').toggleClass('m-mobile-hide');
});
$('.ui.dropdown').dropdown({
on : 'hover'
});
//消息提示关闭初始化
$('.message .close')
.on('click', function () {
$(this)
.closest('.message')
.transition('fade');
});
</script>
</body>
</html>
tags-input.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head th:replace="admin/_fragments :: head(~{::title})">
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>标签新增</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/semantic-ui/2.2.4/semantic.min.css">
<link rel="stylesheet" href="../../static/css/me.css">
</head>
<body>
<!--导航-->
<nav th:replace="admin/_fragments :: menu(3)" class="ui inverted attached segment m-padded-tb-mini m-shadow-small" >
<div class="ui container">
<div class="ui inverted secondary stackable menu">
<h2 class="ui teal header item">管理后台</h2>
<a href="#" class="active m-item item m-mobile-hide">新闻</a>
<a href="#" class=" m-item item m-mobile-hide">分类</a>
<a href="#" class="m-item item m-mobile-hide">标签</a>
<div class="right m-item m-mobile-hide menu">
<div class="ui dropdown item">
<div class="text">
<img class="ui avatar image" src="../static/images/wechat.jpg">
hualili
</div>
<i class="dropdown icon"></i>
<div class="menu">
<a href="#" class="item">注销</a>
</div>
</div>
</div>
</div>
</div>
<a href="#" class="ui menu toggle black icon button m-right-top m-mobile-show">
<i class="sidebar icon"></i>
</a>
</nav>
<div class="ui attached pointing menu">
<div class="ui container">
<div class="right menu">
<a href="#" th:href="@{/admin/tags/input}" class="active item">新增</a>
<a href="#" th:href="@{/admin/tags}" class="teal item">列表</a>
</div>
</div>
</div>
<!--中间内容-->
<div class="m-container-small m-padded-tb-big">
<div class="ui container">
<form action="#" method="post" th:object="${tag}" th:action="@{/admin/tags/input}" class="ui form">
<input type="hidden" name="id" th:value="*{id}">
<div class=" field">
<div class="ui left labeled input">
<label class="ui teal basic label">名称</label>
<input type="text" name="name" placeholder="分类名称" th:value="*{name}" >
</div>
</div>
<div class="ui error message"></div>
<div class="ui right aligned container">
<button type="button" class="ui button" onclick="window.history.go(-1)" >返回</button>
<button class="ui teal submit button">提交</button>
<input type="submit">
</div>
</form>
</div>
</div>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<!--底部footer-->
<footer th:replace="admin/_fragments :: footer" class="ui inverted vertical segment m-padded-tb-massive">
<div class="ui center aligned container">
<div class="ui inverted divided stackable grid">
<div class="three wide column">
<div class="ui inverted link list">
<div class="item">
<img src="../../static/images/wechat.jpg" class="ui rounded image" alt="" style="width: 110px">
</div>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced " >最新新闻</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
<a href="#" class="item m-text-thin">用户故事(User Story)</a>
</div>
</div>
<div class="three wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">联系我</h4>
<div class="ui inverted link list">
<a href="#" class="item m-text-thin">Email:liuhuali@163.com</a>
<a href="#" class="item m-text-thin">QQ:liuhuali</a>
</div>
</div>
<div class="seven wide column">
<h4 class="ui inverted header m-text-thin m-text-spaced ">news</h4>
<p class="m-text-thin m-text-spaced m-opacity-mini">消息即狭义的新闻,它是对新近发生的有社会意义并引起公众兴趣的事实的简短报道。因此,真实性、时效性及文字少、篇幅小成为消息的基本特征...</p>
</div>
</div>
<div class="ui inverted section divider"></div>
<p class="m-text-thin m-text-spaced m-opacity-tiny">Copyright © 2016 - 2017 liuhuali Designed by liuhuali</p>
</div>
</footer>
<script>
$('.menu.toggle').click(function () {
$('.m-item').toggleClass('m-mobile-hide');
});
$('.ui.dropdown').dropdown({
on : 'hover'
});
$('.ui.form').form({
fields : {
title : {
identifier: 'name',
rules: [{
type : 'empty',
prompt: '请输入标签名称'
}]
}
}
});
</script>
</body>
</html>
三、运行截图
查询标签
编辑分类
新增标签
删除标签