没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
第 1 页 共 29 页
信息管理系统
(SpringBoot+Mybatis+Vue2+ElementUI+POI
实现 Excel 数据的导入导出)
一、页面效果:
二、主要功能:
1、CRUD 的操作
2、批量删除
3、将 Excel 导入到数据库
4、将数据表导出到 Excel 中
三、前端代码:
1、页面代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="../js/index.css">
第 2 页 共 29 页
<script src="../js/vue.js" type="text/javascript"></script>
<script src="../js/elementUI.js" type="text/javascript"></script>
<script src="../js/axios.js" type="text/javascript"></script>
</head>
<body>
<div id="app" style="margin-left: 25px;margin-top: 15px;">
<el-form :model="formData" :rules="rules" ref="formData" label-width="100px">
<el-row>
<el-col :span="6">
<el-form-item label="图书名称" prop="bookName">
<el-input v-model="formData.bookName"></el-input>
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item label="图书作者" prop="bookAuthor">
<el-input v-model="formData.bookAuthor"></el-input>
</el-form-item>
</el-col>
</el-row>
<el-row>
<el-col :span="6">
<el-form-item label="发行日期" prop="bookDate">
<el-input type="date" v-model="formData.bookDate"></el-input>
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item label="图书价格" prop="bookPrice">
<el-input v-model="formData.bookPrice" ></el-input>
</el-form-item>
</el-col>
</el-row>
<el-col>
<el-form-item>
<el-button type="primary" icon="el-icon-plus" size="mini" @click=
"addBook('formData')">增加</el-button>
<el-button type="danger" icon="el-icon-delete" size="mini" @click
="batchDelete">批量删除</el-button>
<el-button icon="el-icon-search" size="mini" @click="searchBook"
>查询</el-button>
<el-button type="success" icon="el-icon-right" size="mini" @click
="importBook">导入 Excel</el-button>
<el-button type="warning" icon="el-icon-back" size="mini" @click=
"exportBook">导出 Excel</el-button>
</el-form-item>
第 3 页 共 29 页
</el-col>
</el-form>
<!--表格-->
<el-table :data="tableData" style="width: 1050px;" ref="multipleTable" @selection-cha
nge="handleSelectionChange" id="out-table">
<el-table-column min-width='140' type="selection"></el-table-column>
<el-table-column prop="bookId" label="图书编号" width="150"> </el-table-column>
<el-table-column prop="bookName" label="图书名称" width="180"> </el-table-column>
<el-table-column prop="bookAuthor" label="图书作者
" width="150"> </el-table-column>
<el-table-column prop="bookDate" label="发行日期" width="150"> </el-table-column>
<el-table-column prop="bookPrice" label="图书价格
" width="150"> </el-table-column>
<el-table-column label="操作" width="210" align="center">
<template slot-scope="scope">
<el-button type="danger" icon="el-icon-delete" size="mini" @click="Delete(
scope.row.bookId)">删除</el-button>
<el-button type="success" icon="el-icon-edit" size="mini" @click="Update(s
cope.row)">修改</el-button>
</template>
</el-table-column>
</el-table>
<!--分页组件-->
<el-pagination class="tabListPage"
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page="currentPage"
:page-sizes="pageSizes"
:page-size="pageCount"
layout="total, sizes, prev, pager, next, jumper"
:total="totalCount"
>
</el-pagination>
<!--修改对话框-->
<el-dialog customClass="customWidth"
:modal="true"
:visible.sync="dialogVisible"
width="25%"
:title="Title"
>
<!--"修改"对话框中的表单-->
<div style="margin-right: 20px;">
第 4 页 共 29 页
<el-form :model="updateData" :rules="rules" ref="updateData" label-width="100px">
<el-row>
<el-col>
<el-form-item label="图书编号" prop="update_bookId">
<el-input v-model="updateData.update_bookId" disabled></el-input>
</el-form-item>
</el-col>
</el-row>
<el-row>
<el-col>
<el-form-item label="图书名称" prop="update_bookName">
<el-input v-model="updateData.update_bookName"></el-input>
</el-form-item>
</el-col>
</el-row>
<el-row>
<el-col>
<el-form-item label="图书作者" prop="update_bookAuthor">
<el-input v-model="updateData.update_bookAuthor"></el-input>
</el-form-item>
</el-col>
</el-row>
<el-row>
<el-col>
<el-form-item label="发行日期" prop="update_bookDate">
<el-input type="date" v-model="updateData.update_bookDate"></el-input>
</el-form-item>
</el-col>
</el-row>
<el-row>
<el-col>
<el-form-item label="图书价格" prop="update_bookPrice">
<el-input v-model="updateData.update_bookPrice"></el-input>
</el-form-item>
</el-col>
</el-row>
</el-form>
</div>
<!-- 底部按钮 -->
<div slot="footer" class="dialog-footer">
<el-button @click="dialogVisible = false">取 消</el-button>
<el-button type="primary" @click="handlerAddOk">确 定</el-button>
</div>
</el-dialog>
第 5 页 共 29 页
<!--导入 Excel 对话框-->
<el-dialog customClass="customWidth"
:modal="true"
:visible.sync="ImportdialogVisible"
width="29%"
:title="ImportTitle"
>
<el-form :model="form">
<el-form-item>
<el-upload class="upload-file"
drag
ref="uploadExcel"
action="http://localhost:8080/elementui/import"
:limit=limitNum
:auto-upload="false"
accept=".xlsx"
:before-upload="beforeUploadFile"
:on-change="fileChange"
:on-exceed="exceedFile"
:on-success="handleSuccess"
:on-error="handleError"
:file-list="fileList"
>
<i class="el-icon-upload"></i>
<div class="el-upload__text">将文件拖到此处,或<em>点击选择 Excel 文件</em></div>
<!-- <div slot="tip" class="el-upload-list__item-name">{{fileName}}</div> -->
</el-upload>
</el-form-item>
<el-form-item>
<div style="margin-left: 120px;">
<el-button @click="ImportdialogVisible = false" size="small">取 消</el-button>
<el-button size="small" type="primary" @click="submitUpload()">立即导入</el-button>
</div>
</el-form-item>
</el-form>
</el-dialog>
</div>
2、JS 代码:
<script>
new Vue({
el:'#app',
data:{
剩余28页未读,继续阅读
资源评论
上庸者-不服周
- 粉丝: 178
- 资源: 15
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功