新建一个SpringBoot 项目
导包
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.21</version>
</dependency>
<!-- fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<!--mybatisplus代码生成-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.4.1</version>
</dependency>
<!--模板-->
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger-ui -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
<!-- 引入swagger-bootstrap-ui包 /doc.html-->
<dependency>
<groupId>com.github.xiaoymin</groupId>
<artifactId>swagger-bootstrap-ui</artifactId>
<version>1.9.1</version>
</dependency>
</dependencies>
写配置文件 application.yml
server:
port: 8001
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/db-vue?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
username: root
password: root
thymeleaf:
cache: false
mybatis:
mapper-locations: classpath*:mapper/*.xml #扫描映射文件
type-aliases-package: com.example.springbootvue004.entity #实体类别名
configuration:
map-underscore-to-camel-case: true #驼峰命名规则
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #控制台输出SQL
在把实体类和 mapper,service 都建好
新建ContactController ,写接口
@PostMapping("/findAll")
public JsonData getAllInfo(@RequestBody PageUserJson pageUserJson){
JsonData jsonData = new JsonData();
System.out.println("pageUserJson:"+pageUserJson);
Page<Contact> page = new Page<>(pageUserJson.getPage(),pageUserJson.getLimit());
QueryWrapper<Contact> queryWrapper = new QueryWrapper<>();
String name = pageUserJson.getName();
if(!StringUtil.isEmpty(name)){
queryWrapper.like("name",name);
}
IPage<Contact> paperPageInfo = contactService.page(page,queryWrapper);
if(paperPageInfo.getRecords()!=null){
jsonData.setCode(200);
jsonData.setMsg("成功得到数据!");
}
//设置总条数
jsonData.setCount(paperPageInfo.getTotal());
jsonData.setData(paperPageInfo.getRecords());
return jsonData;
}
工具类
分页工具类
其他 CRUD 的接口
@PostMapping("/insert")
public JsonData insert(@RequestBody Contact contact){
System.out.println(contact);
JsonData jsonData = new JsonData();
boolean insert = contactService.save(contact);
if(insert){
jsonData.setCode(200);
jsonData.setMsg("添加成功!");
}else{
jsonData.setCode(0);
jsonData.setMsg("添加用户失败!");
}
return jsonData;
}
@PostMapping("/deleteContactById/{id}")
public JsonData deleteContactById(@PathVariable("id") Integer id){
System.out.println(id);
JsonData jsonData = new JsonData();
boolean remove = contactService.removeById(id);
if(remove){
jsonData.setCode(200);
jsonData.setMsg("删除成功!");
}else{
jsonData.setCode(0);
jsonData.setMsg("删除用户失败!");
}
return jsonData;
}
@PostMapping("/deleteBatchContact/{ids}")
public JsonData deleteBatchContact(@PathVariable("ids") String ids){
JsonData jsonData = new JsonData();
System.out.println(ids);
String [] split = ids.split(",");
boolean b=false;
for(String id:split){
b = contactService.removeById(Long.parseLong(id));
System.out.println(b);
}
if(b){
jsonData.setCode(200);
jsonData.setMsg("批量删除成功!");
}else{
jsonData.setCode(0);
jsonData.setMsg("批量删除失败!");
}
return jsonData;
}
最后 启动类上要 扫描 mapper 包
二. Vue 前端
<template>
<div>
<!-- 面包屑导航 -->
<el-breadcrumb separator-class="el-icon-arrow-right">
<el-breadcrumb-item :to="{ path: '/Main' }">首页</el-breadcrumb-item>
<el-breadcrumb-item>用户列表</el-breadcrumb-item>
</el-breadcrumb>
<!-- 搜索筛选 -->
<el-form :inline="true" :model="formInline" class="user-search">
<el-form-item label="搜索:">
<el-input size="small" v-model="formInline.name" placeholder="输入名称"></el-input>
</el-form-item>
<el-form-item>
<el-button size="small" type="primary" icon="el-icon-search" @click="search">搜索</el-button>
<el-button size="small" type="primary" icon="el-icon-plus" @click="handleEdit()">添加</el-button>
<el-button class="small" type="warning" size="small" @click="removeBatch()">批量删除</el-button>
</el-form-item>
</el-form>
<!--列表-->
<el-table size="small" :data="listData" highlight-current-row v-loading="loading" border element-loading-text="拼命加载中" style="width: 100%;" ref="multipleTable" @selection-change="handleSelectionChange">
<el-table-column align="center" type="selection" prop="id" width="60" >
</el-table-column>
<el-table-column
label="序号"
width="70px">
<template slot-scope="scope">
{{scope.$index+1}}
</template>
</el-table-column>
<el-table-column sortable prop="id" label="主键" width="60">
</el-table-column>
<el-table-column sortable prop="name" label="姓名" width="110">
</el-table-column>
<el-table-column sortable prop="gender" label="性别" width="60">
</el-table-column>
<el-table-column sortable prop="age" label="年龄" width="80">
</el-table-column>
<el-table-column sortable prop="address" label="地址" width="100">
</el-table-column>
<el-table-column sortable prop="qq" label="qq" width="80">
</el-table-column>
<el-table-column sortable prop="email" label="邮箱" width="120">
</el-table-column>
<el-table-column align="center" label="操作" min-width="160">
<template slot-scope="scope">
<el-button size="mini" @click="handleEdit(scope.$index, scope.row)">编辑</el-button>
<el-button size="mini" type="danger" @click="deleteUser(scope.$index, scope.row)">删除</el-button>
</template>
</el-table-column>
</el-table>
<!-- 分页组件 -->
<Pagination v-bind:child-msg="pageparm" @callFather="callFather"></Pagination>
<!-- 编辑界面 -->
<el-dialog :title="title" :visible.sync="editFormVisible" width="30%" @click="closeDialog">
<el-form label-width="80px" :model="editForm" :rules="rules" ref="editForm">
<el-input size="small" v-model="editForm.id" style="display:none" auto-complete="off"></el-input>
<el-form-item label="姓名" prop="name">
<el-input size="small" v-model="editForm.name" auto-complete="off" placeholder="请输入姓名"></el-input>
</el-form-item>
<el-form-item label="性别" prop="gender">
<el-radio v-model="editForm.gender" label="男">男</el-radio>
<el-radio v-model="editForm.gender" label="女">女</el-radio>
</el-form-item>
<el-form-item label="年龄" prop="age">
<el-input size="small" v-model="editForm.age" auto-complete="off" placeholder="请输入年龄"></el-input>
</el-form-item>
<el-form-item label="地址" prop="address">
<el-input size="small" v-model="editForm.address" auto-complete="off" placeholder="请输入地址"></el-input>
</el-form-item>
<el-form-item label="qq" prop="qq">
<el-input size="small" v-model="editForm.qq" auto-complete="off" placeholder="请输入qq"></el-input>
</el-form-item>
<el-form-item label="Email:" prop="email">
<el-input v-model="editForm.email" auto-complete="off" placeholder="请输入邮箱"></el-input>
</el-form-item>
</el-form>
<div slot="footer" class="dialog-footer">
<el-button size="small" @click="closeDialog">取消</el-button>
<el-button size="small" type="primary" :loading="loading" class="title" @click="submitForm('editForm')">保存</el-button>
</div>
</el-dialog>
</div>
</template>
<script>
import Pagination from '../../components/Pagination'
export default {
name: "ContactList",
data() {
var validateEmail = (rule, value, callback) => {
const mailReg = /^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+/
if (mailReg.test(value)) {
callback()
} else {
callback(new Error('请输入正确的邮箱格式'))
}
}
var checkQQ = (rule, value, callback) => {
if (!value) {
return callback(new Error('qq不能为空!'))
}
// Number.isInteger是es6验证数字是否为整数的方法,实际输入的数字总是识别成字符串
// 所以在前面加了一个+实现隐式转换
if (!Number.isInteger(+value)) {
callback(new Error('请输入数字值'))
}
}
return {
nshow: true, //switch开启
fshow: false, //switch关闭
loading: false, //是显示加载
editFormVisible: false, //控制编辑页面显示与隐藏
logIds:'',
multipleSelection:[],//多选的数据
title: '添加',
editForm: {
id: '',
name: '',
gender:'女',
age:'',
address:'',
qq:'',
email:'',
token: localStorage.getItem('logintoken')
},
// rules表单验证
rules: {
name: [
{ required: true, message: '请输入姓名', trigger: 'blur' }
],
age: [{ required: true, message: '请输入年龄', trigger: 'blur' }],
qq: [{ validator: checkQQ, trigger: 'blur' }],
address: [{ required: true, message: '请输入地址', trigger: 'blur' }],
email: [{required: true, message: '邮箱不能为空', trigger: 'blur'},
{validator: validateEmail, trigger: 'blur'}]
},
//模糊查询数据
formInline: {
page: 1,
limit: 5,
name: '',
token: localStorage.getItem('logintoken')
},
// 删除
seletedata: {
ids: '',
token: localStorage.getItem('logintoken')
},
//用户数据
listData: [],
// 分页参数
pageparm: {
currentPage: 1,
pageSize: 5,
total: 10
}
}
},
// 注册组件
components: {
Pagination
},
/**
* 创建完毕
*/
// activated
created() {
this.getdata(this.formInline)
},
/**
* 里面的方法只有被调用才会执行
*/
methods: {
// 表格加载数据
getdata(parameter) {
console.log(parameter);
this.loading = true;
let url = this.axios.urls.CONTACT_ALL;
this.axios.post(url,parameter).then(
res =>{
console.log(res.data);
console.log(res.data.data);
if(res.data.code == 200){
this.loading = false;
this.listData = res.data.data;
// 分页赋值
console.log(this.formInline.page)
console.log(this.formInline.limit)
this.pageparm.currentPage = this.formInline.page
this.pageparm.pageSize = this.formInline.limit
this.pageparm.total = res.data.count
}
})
.catch(err => {
this.loading = false
this.$message.error('菜单加载失败,请稍后再试!')
});
},
// 分页插件事件
callFather(parm) {
console.log(parm.currentPage)
console.log(parm.pageSize)
this.formInline.page = parm.currentPage;
this.formInline.limit = parm.pageSize;
console.log(this.formInline.page)
console.log(this.formInline.limit)
console.log(this.formInline)
//重新加载数据
this.getdata(this.formInline);
},
// 搜索事件
search() {
this.getdata(this.formInline)
},
//显示编辑界面
handleEdit: function(index, row) {
//显示弹出框
this.editFormVisible = true
if (row != undefined && row != 'undefined') {
this.title = '修改用户'
this.editForm.id = row.id
this.editForm.name = row.name
this.editForm.gender = row.gender
this.editForm.age = row.age
this.editForm.address = row.address
this.editForm.qq = row.qq
this.editForm.email = row.email
} else {
this.title = '添加用户'
this.editForm.id = ''
this.editForm.name = ''
this.editForm.gender ='女'
this.editForm.age = ''
this.editForm.address = ''
this.editForm.qq = ''
this.editForm.email = ''
}
},
// 编辑、增加页面保存方法
submitForm(editData) {
console.log("1111")
console.log(this.editForm)
let url = this.axios.urls.CONTACT_UPDATE;
this.axios.post(url,this.editForm).then(
res =>{
this.editFormVisible = false
this.loading = false
if(res.data.code==200){
//重新加载数据
this.getdata(this.formInline)
this.$message({
type: 'success',
message: '用户保存成功!'
})
}else{
this.$message({
type: 'info',
message: res.data.msg
})
}
})
.catch(err => {
this.editFormVisible = false
this.loading = false
this.$message.error('用户保存失败,请稍后再试!')
})
},
// 删除用户
deleteUser(index, row) {
var _this = this;
_this.$confirm('确定要删除吗?', '信息', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
})
.then(() => {
console.log(row.id)
console.log("2222")
let url = _this.axios.urls.CONTACT_DELETE;
_this.axios.post(url+"/"+row.id).then(
res =>{
if(res.data.code==200){
_this.$message({
type: 'success',
message: '用户已删除!'
});
// 重新加载数据
_this.getdata(_this.formInline);
}else{
_this.$message({
type: 'info',
message: res.data.msg
})
}
})
.catch(err => {
_this.loading = false
_this.$message.error('用户删除失败,请稍后再试!')
})
})
.catch(() => {
this.$message({
type: 'info',
message: '已取消删除'
});
})
},
handleSelectionChange(val) {
this.multipleSelection = val;
},
// 批量删除
removeBatch () {
const length = this.multipleSelection.length;
console.log(this.multipleSelection);
alert(length);
if(length<=0){
this.$message({
type: 'info',
message: "请选择一条数据!"
});
return false;
}
for (let i = 0; i < length; i++) {
this.logIds += this.multipleSelection[i].id+','
}
console.log(this.logIds);
var _this = this;
this.$confirm('确定要批量删除日志信息, 是否继续?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
let url = _this.axios.urls.CONTACT_DELETE_BATCH;
_this.axios.post(url+"/"+_this.logIds).then(res => {
_this.$message({
type: 'info',
message: res.data.msg
});
if(res.data.code==200){
// 重新加载数据
_this.getdata(_this.formInline);
}
})
})
.catch(() => {
_this.$message({
type: 'info',
message: '已取消删除'
})
});
},
// 关闭编辑、增加弹出框
closeDialog() {
this.editFormVisible = false
}
}
}
</script>
<style scoped>
.user-search {
margin-top: 20px;
}
.userRole {
width: 100%;
}
</style>
分页组件 Pagination.vue
/**
* 分页组件
*/
<template>
<el-pagination class="page-box" @size-change="handleSizeChange" @current-change="handleCurrentChange" background :current-page="childMsg.currentPage" :page-sizes="[3, 5, 10, 20]" :page-size="childMsg.pageSize" layout="total, sizes, prev, pager, next, jumper" :total="childMsg.total">
</el-pagination>
</template>
<script>
export default {
name: 'Pagination',
props: ['childMsg'],
data() {
return {
pageparm: {
currentPage: this.childMsg.currentPage,
pageSize: this.childMsg.pageSize
}
}
},
created() {},
methods: {
handleSizeChange(val) {
/**
* 子传父
* 参数1 父元素方法
* 参数2 数据
*/
this.pageparm.pageSize = val
this.$emit('callFather', this.pageparm)
},
handleCurrentChange(val) {
/**
* 子传父
* 参数1 父元素方法
* 参数2 数据
*/
this.pageparm.currentPage = val
this.$emit('callFather', this.pageparm)
}
}
}
</script>
<style>
.page-box {
margin: 10px auto;
}
</style>
因为是前后端分离。就一定会出现跨域问题,需要在后端配置 下
@Configuration
@Component
public class CrosOriginConfigurer implements WebMvcConfigurer {
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/**")
.allowedOrigins("*")
.allowedMethods("GET", "HEAD", "POST", "PUT", "DELETE", "OPTIONS")
.allowCredentials(true)
.maxAge(3600)
.allowedHeaders("*");
}
}
三. 测试