实现新增电子书功能
新增电子书时,需要生成全局唯一id,所以这里用到了雪花算法,关于雪花算法,更多可以访问这里。
package com.jepcc.test.service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.jepcc.test.mapper.EbookMapper;
import com.jepcc.test.model.Ebook;
import com.jepcc.test.model.EbookExample;
import com.jepcc.test.req.EbookReq;
import com.jepcc.test.req.EbookSaveReq;
import com.jepcc.test.resp.EbookResp;
import com.jepcc.test.resp.PageResp;
import com.jepcc.test.util.CopyUtil;
import com.jepcc.test.util.SnowFlake;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.ObjectUtils;
import java.util.List;
@Service
public class EbookService {
private static final Logger LOG = LoggerFactory.getLogger(EbookService.class);
@Autowired
private EbookMapper ebookMapper;
@Autowired
private SnowFlake snowFlake;
public PageResp<EbookResp> list(EbookReq req){
EbookExample ebookExample = new EbookExample();
EbookExample.Criteria criteria = ebookExample.or();
if(!ObjectUtils.isEmpty(req.getName())){
criteria.andNameLike("%"+req.getName()+"%");
}
PageHelper.startPage(req.getPage(),req.getSize());
List<Ebook> ebookList = ebookMapper.selectByExample(ebookExample);
PageInfo<Ebook> pageinfo = new PageInfo<>(ebookList);
// LOG.info("总条数:{}",pageinfo.getTotal());
// LOG.info("总页数,{}",pageinfo.getPages());
List<EbookResp> list = CopyUtil.copyList(ebookList,EbookResp.class);
PageResp<EbookResp> pageResp = new PageResp<>();
pageResp.setTotal(pageinfo.getTotal());
pageResp.setList(list);
return pageResp;
}
public void save(EbookSaveReq req){
Ebook ebook = CopyUtil.copy(req,Ebook.class);
if(!ObjectUtils.isEmpty(ebook.getId())){
ebookMapper.updateByPrimaryKey(ebook);
}else{
ebook.setId(snowFlake.nextId());
ebookMapper.insert(ebook);
}
}
}
<template>
<a-layout>
<a-layout-content
:style="{ background: '#fff', padding: '24px', margin: 0, minHeight: '280px' }"
>
<p>
<a-button type="primary" size="large" @click="add">新增</a-button>
</p>
<a-table :columns="columns"
:dataSource="ebooks"
:row-key="record=>record.id"
:pagination="pagination"
:loading="loading"
@change="handleTableChange">
<template #cover="{text:cover}">
<img v-if="cover" :src="cover" alt="avatar">
</template>
<template #action="{text,record}">
<a-space>
<a-button type="primary" @click="edit(record)">编辑</a-button>
<a-button type="danger">删除</a-button>
</a-space>
</template>
</a-table>
</a-layout-content>
</a-layout>
<a-modal
title="电子书表单"
v-model:visible="visible"
:confirm-loading="confirmLoading"
@ok="handleOk"
>
<a-form :model="ebook" :label-col="{span:4}" :wrapper-col="{span:16}">
<a-form-item label="封面">
<a-input v-model:value="ebook.cover" />
</a-form-item>
<a-form-item label="名称">
<a-input v-model:value="ebook.name" />
</a-form-item>
<a-form-item label="分类一">
<a-input v-model:value="ebook.category1Id" />
</a-form-item>
<a-form-item label="分类二">
<a-input v-model:value="ebook.category2Id" />
</a-form-item>
<a-form-item label="描述">
<a-input v-model:value="ebook.description" />
</a-form-item>
</a-form>
</a-modal>
</template>
<script lang="ts">
import { defineComponent,ref,onMounted} from 'vue';
import axios from "axios";
export default defineComponent({
name:"AdminEbook",
setup() {
const ebooks = ref();
const pagination = ref({
current:1,
pageSize:4,
total:0
});
const loading = ref(false);
const columns = [
{
title:"封面",
dataIndex:"cover",
key:"cover",
slots:{customRender:'cover'}
},
{
title:"名称",
key:"name",
dataIndex:"name"
},
{
title:"分类一",
key:"category1Id",
dataIndex:"category1Id"
},
{
title:"分类二",
key:"category2Id",
dataIndex:"category2Id"
},
{
title:"文档数",
key:"docCount",
dataIndex:"docCount"
},
{
title:"阅读数",
key:"viewCount",
dataIndex:"viewCount"
},
{
title:"点赞数",
key:"vouteCount",
dataIndex:"voteCount"
},
{
title:"操作",
key:"action",
dataIndex:"action",
slots:{customRender:'action'}
}
];
const visible = ref(false);
const modalText = ref('test');
const confirmLoading = ref(false);
const ebook= ref({});
const handleQuery = (params:any) => {
loading.value = true;
axios.get("/ebook/list",{params:params}).then(response => {
loading.value = false;
const data = response.data.content;
ebooks.value = data.list;
pagination.value.total = data.total;
pagination.value.current = params.page;
})
};
const handleTableChange = (pagination:any) => {
handleQuery({
page:pagination.current,
size:pagination.pageSize
});
}
const edit = (record:any) => {
visible.value = true;
ebook.value = record;
}
const add = () => {
visible.value = true;
ebook.value = {};
}
const handleOk = () => {
// modalText.value = 'The modal will be closed after two seconds';
// confirmLoading.value = true;
axios.post("/ebook/save",ebook.value).then(response => {
const data = response.data;
if(data.success){
visible.value = false;
confirmLoading.value = false;
handleQuery({
page:pagination.value.current,
size:pagination.value.pageSize
})
}
})
// setTimeout(() => {
// visible.value = false;
// confirmLoading.value = false;
// }, 2000);
};
onMounted(() => {
handleQuery({
page:1,
size:pagination.value.pageSize
});
})
return {
columns,
ebooks,
loading,
pagination,
handleTableChange,
visible,
modalText,
confirmLoading,
edit,
add,
handleOk,
ebook
}
}
})
</script>
<style scoped>
img{
width: 48px;
height: 48px;
}
</style>
实现删除电子书功能
后台添加 删除电子书 接口
package com.jepcc.test.controller;
import com.alibaba.fastjson.JSONObject;
import com.jepcc.test.req.EbookReq;
import com.jepcc.test.req.EbookSaveReq;
import com.jepcc.test.resp.CommonResp;
import com.jepcc.test.resp.EbookResp;
import com.jepcc.test.resp.PageResp;
import com.jepcc.test.service.EbookService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@RestController
@RequestMapping("/ebook")
public class EbookController {
private static final Logger LOG = LoggerFactory.getLogger(EbookController.class);
@Autowired
private EbookService ebookService;
@GetMapping("/list")
public CommonResp list(EbookReq req){
CommonResp resp = new CommonResp();
PageResp<EbookResp> list = ebookService.list(req);
resp.setContent(list);
return resp;
}
@PostMapping("/save")
public CommonResp save(@RequestBody EbookSaveReq req){
LOG.info("----------------------------------------");
LOG.info("req:{}", JSONObject.toJSONString(req));
LOG.info("----------------------------------------");
CommonResp resp = new CommonResp();
ebookService.save(req);
return resp;
}
@DeleteMapping("/delete/{id}")
public CommonResp delete(@PathVariable Long id){
CommonResp resp = new CommonResp();
ebookService.delete(id);
return resp;
}
}
package com.jepcc.test.service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.jepcc.test.mapper.EbookMapper;
import com.jepcc.test.model.Ebook;
import com.jepcc.test.model.EbookExample;
import com.jepcc.test.req.EbookReq;
import com.jepcc.test.req.EbookSaveReq;
import com.jepcc.test.resp.EbookResp;
import com.jepcc.test.resp.PageResp;
import com.jepcc.test.util.CopyUtil;
import com.jepcc.test.util.SnowFlake;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.ObjectUtils;
import java.util.List;
@Service
public class EbookService {
private static final Logger LOG = LoggerFactory.getLogger(EbookService.class);
@Autowired
private EbookMapper ebookMapper;
@Autowired
private SnowFlake snowFlake;
public PageResp<EbookResp> list(EbookReq req){
EbookExample ebookExample = new EbookExample();
EbookExample.Criteria criteria = ebookExample.or();
if(!ObjectUtils.isEmpty(req.getName())){
criteria.andNameLike("%"+req.getName()+"%");
}
PageHelper.startPage(req.getPage(),req.getSize());
List<Ebook> ebookList = ebookMapper.selectByExample(ebookExample);
PageInfo<Ebook> pageinfo = new PageInfo<>(ebookList);
// LOG.info("总条数:{}",pageinfo.getTotal());
// LOG.info("总页数,{}",pageinfo.getPages());
List<EbookResp> list = CopyUtil.copyList(ebookList,EbookResp.class);
PageResp<EbookResp> pageResp = new PageResp<>();
pageResp.setTotal(pageinfo.getTotal());
pageResp.setList(list);
return pageResp;
}
public void save(EbookSaveReq req){
Ebook ebook = CopyUtil.copy(req,Ebook.class);
if(!ObjectUtils.isEmpty(ebook.getId())){
ebookMapper.updateByPrimaryKey(ebook);
}else{
ebook.setId(snowFlake.nextId());
ebookMapper.insert(ebook);
}
}
public void delete(Long id){
ebookMapper.deleteByPrimaryKey(id);
}
}
前台添加 删除电子书 代码
<template>
<a-layout>
<a-layout-content
:style="{ background: '#fff', padding: '24px', margin: 0, minHeight: '280px' }"
>
<p>
<a-button type="primary" size="large" @click="add">新增</a-button>
</p>
<a-table :columns="columns"
:dataSource="ebooks"
:row-key="record=>record.id"
:pagination="pagination"
:loading="loading"
@change="handleTableChange">
<template #cover="{text:cover}">
<img v-if="cover" :src="cover" alt="avatar">
</template>
<template #action="{text,record}">
<a-space>
<a-button type="primary" @click="edit(record)">编辑</a-button>
<a-popconfirm
title="删除后不可恢复,确认删除?"
ok-text="确定"
cancel-text="取消"
@confirm="handleDelete(record)"
>
<a-button type="danger">删除</a-button>
</a-popconfirm>
</a-space>
</template>
</a-table>
</a-layout-content>
</a-layout>
<a-modal
title="电子书表单"
v-model:visible="visible"
:confirm-loading="confirmLoading"
@ok="handleOk"
>
<a-form :model="ebook" :label-col="{span:4}" :wrapper-col="{span:16}">
<a-form-item label="封面">
<a-input v-model:value="ebook.cover" />
</a-form-item>
<a-form-item label="名称">
<a-input v-model:value="ebook.name" />
</a-form-item>
<a-form-item label="分类一">
<a-input v-model:value="ebook.category1Id" />
</a-form-item>
<a-form-item label="分类二">
<a-input v-model:value="ebook.category2Id" />
</a-form-item>
<a-form-item label="描述">
<a-input v-model:value="ebook.description" />
</a-form-item>
</a-form>
</a-modal>
</template>
<script lang="ts">
import { defineComponent,ref,onMounted} from 'vue';
import axios from "axios";
export default defineComponent({
name:"AdminEbook",
setup() {
const ebooks = ref();
const pagination = ref({
current:1,
pageSize:4,
total:0
});
const loading = ref(false);
const columns = [
{
title:"封面",
dataIndex:"cover",
key:"cover",
slots:{customRender:'cover'}
},
{
title:"名称",
key:"name",
dataIndex:"name"
},
{
title:"分类一",
key:"category1Id",
dataIndex:"category1Id"
},
{
title:"分类二",
key:"category2Id",
dataIndex:"category2Id"
},
{
title:"文档数",
key:"docCount",
dataIndex:"docCount"
},
{
title:"阅读数",
key:"viewCount",
dataIndex:"viewCount"
},
{
title:"点赞数",
key:"vouteCount",
dataIndex:"voteCount"
},
{
title:"操作",
key:"action",
dataIndex:"action",
slots:{customRender:'action'}
}
];
const visible = ref(false);
const modalText = ref('test');
const confirmLoading = ref(false);
const ebook= ref({});
const handleQuery = (params:any) => {
loading.value = true;
axios.get("/ebook/list",{params:params}).then(response => {
loading.value = false;
const data = response.data.content;
ebooks.value = data.list;
pagination.value.total = data.total;
pagination.value.current = params.page;
})
};
const handleTableChange = (pagination:any) => {
handleQuery({
page:pagination.current,
size:pagination.pageSize
});
}
const edit = (record:any) => {
visible.value = true;
ebook.value = record;
}
const add = () => {
visible.value = true;
ebook.value = {};
}
const handleDelete = (record:any) => {
axios.delete("ebook/delete/"+record.id).then(response => {
const data = response.data;
if(data.success){
handleQuery({
page:pagination.value.current,
size:pagination.value.pageSize
})
}
})
}
const handleOk = () => {
// modalText.value = 'The modal will be closed after two seconds';
// confirmLoading.value = true;
axios.post("/ebook/save",ebook.value).then(response => {
const data = response.data;
if(data.success){
visible.value = false;
confirmLoading.value = false;
handleQuery({
page:pagination.value.current,
size:pagination.value.pageSize
})
}
})
// setTimeout(() => {
// visible.value = false;
// confirmLoading.value = false;
// }, 2000);
};
onMounted(() => {
handleQuery({
page:1,
size:pagination.value.pageSize
});
})
return {
columns,
ebooks,
loading,
pagination,
handleTableChange,
visible,
modalText,
confirmLoading,
edit,
add,
handleDelete,
handleOk,
ebook
}
}
})
</script>
<style scoped>
img{
width: 48px;
height: 48px;
}
</style>