-
-
- @Controller
- @RequestMapping("/book")
- public class BookController {
-
- @Autowired
- private IBookService bookService;
-
- @RequestMapping("/addBook")
- @ResponseBody
- public JsonResponseBody> addBook(Book book){
- try {
- bookService.insert(book);
- return new JsonResponseBody<>("新增书本成功",true,0,null);
- } catch (Exception e) {
- e.printStackTrace();
- return new JsonResponseBody<>("新增书本失败",false,0,null);
- }
- }
-
- @RequestMapping("/editBook")
- @ResponseBody
- public JsonResponseBody> editBook(Book book){
- try {
- bookService.updateByPrimaryKey(book);
- return new JsonResponseBody<>("编辑书本成功",true,0,null);
- } catch (Exception e) {
- e.printStackTrace();
- return new JsonResponseBody<>("编辑书本失败",false,0,null);
- }
- }
-
- @RequestMapping("/delBook")
- @ResponseBody
- public JsonResponseBody> delBook(Book book){
- try {
- bookService.deleteByPrimaryKey(book.getId());
- return new JsonResponseBody<>("删除书本成功",true,0,null);
- } catch (Exception e) {
- e.printStackTrace();
- return new JsonResponseBody<>("删除书本失败",false,0,null);
- }
- }
-
- @RequestMapping("/queryBookPager")
- @ResponseBody
- public JsonResponseBody
> queryBookPager(Book book, HttpServletRequest req){
- try {
- PageBean pageBean=new PageBean();
- pageBean.setRequest(req);
- List
books = bookService.queryBookPager(book, pageBean); - return new JsonResponseBody<>("OK",true,pageBean.getTotal(),books);
- } catch (Exception e) {
- e.printStackTrace();
- return new JsonResponseBody<>("分页查询书本失败",false,0,null);
- }
- }
-
- @RequestMapping("/queryBookCharts")
- @ResponseBody
- public JsonResponseBody> queryBookCharts(){
- try{
- Map
charts = bookService.queryBookCharts(); - return new JsonResponseBody<>("OK",true,0,charts);
- }catch (Exception e){
- e.printStackTrace();
- return new JsonResponseBody<>("查询统计分析数据失败",false,0,null);
- }
- }
-
- @RequestMapping("/upload")
- @ResponseBody
- public JsonResponseBody> upload(BookFileVo bookFileVo){
- try {
- MultipartFile bookFile = bookFileVo.getBookFile();
- System.out.println(bookFileVo);
- System.out.println(bookFile.getContentType());
- System.out.println(bookFile.getOriginalFilename());
- return new JsonResponseBody<>("上传成功",true,0,null);
- } catch (Exception e) {
- e.printStackTrace();
- return new JsonResponseBody<>("上传失败",false,0,null);
- }
- }
-
- @RequestMapping("/download")
- public void download(HttpServletRequest request, HttpServletResponse response){
- try {
- String relativePath = "uploads/1.jpg";
- String absolutePath = request.getRealPath(relativePath);
- InputStream is = new FileInputStream(new File(absolutePath));
- OutputStream out = response.getOutputStream();
- response.setContentType("application/octet-stream");
- response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("1.jpg", "UTF-8"));
- byte[] by = new byte[1024];
- int len = -1;
- while (-1 != (len = is.read(by))) {
- out.write(by);
- }
- is.close();
- out.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
-
- @RequestMapping("/downloadUrl")
- public void downloadUrl(HttpServletRequest request, HttpServletResponse response){
- String relativePath = "uploads/1.jpg";
- String absolutePath = request.getRealPath(relativePath);
- InputStream is = null;
- OutputStream out = null;
-
- try {
- is = new FileInputStream(new File(absolutePath));
- // 设置Content-Disposition
- response.setHeader("Content-Disposition",
- "attachment;filename=" + URLEncoder.encode("1.jpg", "UTF-8"));
- out = response.getOutputStream();
- IOUtils.copy(is, out);
- response.flushBuffer();
- System.out.println("完成");
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- IOUtils.closeQuietly(is);
- IOUtils.closeQuietly(out);
- }
- }
- }
-
-
-
-
-
-
-
-
-
-
-
-
在项目中的src文件下api中找到action.js进行配置数据访问的地址:
-
- 'BOOKMSG_BOOKINFO_REQ': '/book/queryBookPager', //获取书本信息
- 'BOOK_ADD': '/book/addBook', //新增书本
- 'BOOK_EDIT': '/book/editBook', //修改书本
- 'BOOK_DEL': '/book/delBook', //删除书本
弹出框窗口编写
- "Book" style="padding: 30px;">
-
-
"true" class="demo-form-inline"> -
"书籍名称 : "> -
"bookname" placeholder="书籍名称"> -
-
-
"warning" @click="onSubmit()">查询 -
"warning" icon="el-icon-plus" @click="addBook()">新增 -
-
-
-
"tableData" style="width: 100%"> -
"id" label="书籍ID"> -
"bookname" label="书籍名称"> -
"price" label="书籍价格"> -
"booktype" label="书籍类型"> -
-
"操作"> -
- "scope">
-
"mini" @click="handleEdit(scope.row)">编辑 -
"mini" type="danger" @click="handleDelete(scope.row)">删除 -
-
-
-
- "block" style="padding: 20px;">
-
@size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="page" - background :page-sizes="[10, 20, 30, 40]" :page-size="rows" layout="total, sizes, prev, pager, next, jumper"
- :total="total">
-
-
-
-
"dialogName" :visible.sync="dialogFormVisible" @close="closeBookForm" width="500px"> -
"bookForm"> -
"optiontype == 'update'" label="编号" :label-width="formLabelWidth"> -
"bookForm.id" autocomplete="off" :style="{width: formEleWidth}"> -
-
"书名" :label-width="formLabelWidth"> -
"bookForm.bookname" autocomplete="off" :style="{width: formEleWidth}"> -
-
"价格" :label-width="formLabelWidth"> -
"bookForm.price" autocomplete="off" :style="{width: formEleWidth}"> -
-
"类型" :label-width="formLabelWidth"> -
"bookForm.booktype" placeholder="选择类型" :style="{width:formEleWidth}"> -
"爱情" value="爱情"> -
"都市" value="都市"> -
-
-
- "footer" class="dialog-footer">
-
@click="dialogFormVisible = false">取 消 -
"primary" @click="saveBook()">确 定 -
-
-
-
-
增删改查实现
- export default {
- name: 'BookList',
-
- data() {
-
-
- return {
- bookname: '',
- tableData: [],
- rows: 10,
- total: 0,
- page: 1,
- dialogFormVisible: false,
- formLabelWidth: '40px',
- formEleWidth: '400px',
- dialogName: '新增书本',
- optiontype: 'add',
-
- //定义验证规则
- rules:{
- bookname: [{
- required: true,
- message: '请输入书籍名称',
- trigger: 'blur'
- },
- {
- min: 1,
- max: 10,
- message: '长度在 1 到 10 个字符',
- trigger: 'blur'
- }
- ],
- price: [{
- required: true,
- message: '请输入价格',
- trigger: 'blur'
- }],
- booktype: [{
- required: true,
- message: '请输入书籍类别',
- trigger: 'blur'
- }]
- },
-
- //定义表单对应的model
- bookForm: {
- id: '',
- bookname: '',
- price: null,
- booktype: ''
- }
-
- }
-
-
-
-
-
- },
- methods: {
-
- /* 新增书本 */
- saveBook() {
-
- this.$refs['bookForm'].validate((valid) => {
-
- if (valid) {
-
- var url = this.axios.urls.BOOK_ADD;
- if (this.optiontype == 'update') {
- url = this.axios.urls.BOOK_EDIT;
- }
- console.log(url)
- this.axios.post(url, this.bookForm).then(d => {
- //关闭窗口
- this.closeBookForm();
- this.dialogFormVisible = false;
- this.query({});
- }).catch();
- } else {
- console.log('error submit!!');
- return false;
- }
- });
-
- },
-
- //选择分页
- handleSizeChange(r) {
- //当页大小发生变化
- let params = {
- bookname: this.bookname,
- rows: r,
- page: this.page
- }
- this.query(params);
- },
- //输入分页
- handleCurrentChange(p) {
- //当前页码大小发生变化
- let params = {
- bookname: this.bookname,
- rows: this.rows,
- // 分页
- page: p
- }
-
- this.query(params);
- },
- //查询方法
- query(params) {
- let url = this.axios.urls.BOOKMSG_BOOKINFO_REQ;
- this.axios.get(url, {
- params: params
- }).then(d => {
- this.tableData = d.data.rows;
- this.total = d.data.total;
- }).catch(e => {});
- },
- onSubmit() {
- let params = {
- bookname: this.bookname
- }
- console.log(params)
- this.query(params);
- this.bookname = ''
- },
- //关闭对话框时 清空表单
- closeBookForm() {
- this.bookForm.id = null;
- this.bookForm.bookname = null;
- this.bookForm.booktype = null;
- this.bookForm.price = null;
- },
- addBook() {
- this.dialogName = '新增书本信息';
- this.dialogFormVisible = true;
- this.optiontype = 'add';
- },
- handleEdit(row) {
- this.dialogName = '编辑书本信息';
- this.dialogFormVisible = true;
-
- this.bookForm.id = row.id;
- this.bookForm.bookname = row.bookname;
- this.bookForm.booktype = row.booktype;
- this.bookForm.price = row.price;
- this.optiontype = 'update';
- },
-
-
- //删除书本记录
- handleDelete(row) {
- this.$confirm('此操作将永久删除该文件, 是否继续?', '提示', {
- confirmButtonText: '确定',
- cancelButtonText: '取消',
- type: 'warning'
- }).then(() => {
- var url = this.axios.urls.BOOK_DEL;
- this.axios.post(url, {
- id: row.id
- }).then(r => {
- this.$message({
- type: 'success',
- message: '删除成功!'
- });
- this.query({});
- })
- }).catch(() => {
- this.$message({
- type: 'info',
- message: '已取消删除'
- });
- });
- }
-
- },
- created() {
- this.query({})
- }
-
- }
新增演示:
修改演示:
删除演示:
- //定义验证规则
- rules:{
- bookname: [{
- required: true,
- message: '请输入书籍名称',
- trigger: 'blur'
- },
- {
- min: 1,
- max: 10,
- message: '长度在 1 到 10 个字符',
- trigger: 'blur'
- }
- ],
- price: [{
- required: true,
- message: '请输入价格',
- trigger: 'blur'
- }],
- booktype: [{
- required: true,
- message: '请输入书籍类别',
- trigger: 'blur'
- }]
- },
使用规则
- /* 新增书本 */
- saveBook() {
-
- this.$refs['bookForm'].validate((valid) => {
- if (valid) {
- //默认新增
- var url = this.axios.urls.BOOK_ADD;
- if (this.optiontype == 'update') {
- url = this.axios.urls.BOOK_EDIT;
- }
- console.log(url)
- this.axios.post(url, this.bookForm).then(d => {
- //关闭窗口
- this.closeBookForm();
- this.dialogFormVisible = false;
- this.query({});
- }).catch();
- } else {
- console.log('error submit!!');
- return false;
- }
- });
-
- },
效果演示: