源码下载地址
后台
前端
- 技术栈
- 前后端目录
- 部分代码
- page1.vue
- application.yml
- mybatis-config.xml
- controller
- 跨域配置
前端
开发工具:WebStorm
开发框架:vue + axios
包管理工具: npm
打包工具:webpack
后端
开发工具:IDEA
开发框架:Springboot + mybatis
打包工具:maven
数据库: MySQL
后端目录
前端目录
application.yml添加 取 消 确 定 搜索 {{ scope.row.isbn }} {{ scope.row.bookName }} {{ scope.row.author }} 编辑 删除
spring:
datasource:
url: jdbc:mysql://localhost:3306/act5?useUnicode=true&characterEncoding=utf-8
username: root
password: root
pagehelper:
helperDialect: mysql
# 分页合理化参数,默认值为false。
# 当该参数设置为 true 时,pageNum<=0 时会查询第一页,
# pageNum>pages(超过总数时),会查询最后一页
reasonable: true
# 支持通过 Mapper 接口参数来传递分页参数
support-methods-arguments: true
mybatis:
config-location: classpath:mybatis-config.xml
server:
port: 8081
mybatis-config.xml
controller
package com.controller;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.mapper.BookMapper;
import com.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
public class BookController {
@Autowired
BookMapper bookMapper;
//分页
@RequestMapping("/books/{page}/{size}")
public PageInfo findBooks(@PathVariable String page, @PathVariable String size){
//当前页总数
PageHelper.startPage(Integer.parseInt(page), Integer.parseInt(size));
List books = bookMapper.findBooks();
PageInfo pageInfo = new PageInfo<>(books);
return pageInfo;
}
@PostMapping("/book/add")
public String addBook(@RequestBody Book book){
try {
bookMapper.addBook(book);
return "success";
}catch (Exception e){
return "error";
}
}
@PostMapping("/book/updateBook")
public String updateBook(@RequestBody Book book){
try {
bookMapper.updateBook(book);
return "success";
}catch (Exception e){
return "error";
}
}
@GetMapping("/book/name/{bookName}")
public PageInfo findBookByBookName( @PathVariable String bookName){
List list = bookMapper.findBookByBookName(bookName);
PageInfo pageInfo = new PageInfo<>(list);
return pageInfo;
}
@GetMapping("/book/author/{author}")
public PageInfo findBookByAuthor( @PathVariable String author){
List list = bookMapper.findBookByAuthor(author);
PageInfo pageInfo = new PageInfo<>(list);
return pageInfo;
}
@PostMapping("/book/deleteBook/{isbn}")
public String deleteBook( @PathVariable String isbn){
try {
System.out.println(isbn);
int i = bookMapper.deleteBook(isbn);
System.out.println(i);
return "success";
}catch (Exception e){
return "error";
}
}
}
跨域配置
package com.config;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class CrosConfig implements WebMvcConfigurer {
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/**")
.allowedOrigins("*")
.allowedMethods("POST", "GET", "PUT", "OPTIONS", "DELETE")
.maxAge(3600)
.allowCredentials(true);
}
}



